Dashboards in minutes

Connect Loja Integrada to Looker: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Loja Integrada to Looker

Connect your Loja Integrada store to Looker using Kondado to transform raw sales information into actionable business intelligence. With our direct integration, you can replicate data from your Brazilian ecommerce platform directly into Looker without complex technical setup or intermediate databases. Simply select Loja Integrada as your data source, choose Looker as your destination, and start building visualizations that help you understand customer behavior and sales performance.

17
available pipelines
397
extractable fields
  • No code, no spreadsheets
  • Auto-refreshed data
  • 14-day free trial

Try out all the features for free for 14 days

Kondado provides a direct connection between Loja Integrada and Looker, allowing business teams to access updated ecommerce metrics on a configurable schedule ranging from every 5 minutes to daily updates, with no coding required and no need for manual data exports.

Marketing and operations teams can track key performance indicators, monitor inventory levels, and analyze order trends through automated data replication. Whether you need near-real-time monitoring of daily sales or periodic reports for strategic planning, Kondado keeps your Looker dashboards current with accurate Loja Integrada data. This seamless connection empowers non-technical users to create compelling visualizations that drive smarter inventory decisions and optimize marketing campaigns.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Loja Integrada data available in Looker

Each item below is automatically replicated by Kondado from Loja Integrada into Looker — no schema setup, no manual mapping.

17
available pipelines
397
extractable fields
Auto-refresh

Available integrations

Categories
Includes fields such as id, name, and description, allowing for the organization and hierarchy of products in the store.
Customers
Contains information such as id, name, and email, along with contact details and communication preferences.
Customer Groups
Presents fields such as id, name, and whether it is a default group, facilitating customer segmentation.
Coupons
Includes fields such as id, code, and application conditions, allowing management of discounts and promotions.
Labels
Provides information about labels used to categorize products or customers, facilitating organization.
Shipping Methods
Presents details about available shipping methods, including id, name, and associated costs.
Payment Methods
Includes information about payment methods, such as id, name, and applicable fees for transactions.
Brands
Contains fields such as id, name, and description, allowing for the identification and organization of product brands.
Orders
Includes information such as id, status, and creation date, allowing for tracking and management of orders.
Order Status History
Presents a record of order status changes, including id, status, and date of change.
Order Invoices
Includes fields such as id, creation_date, and total_value, allowing detailed tracking of invoices generated for each order.
Products
Contains information such as id, name, and description, along with data on price and category, essential for managing the product catalog.
Product Stock
Presents fields such as product_id, available_quantity, and reserved_quantity, allowing effective control of the stock for each product.
Product Variation Grades
Includes fields such as product_id, variation_name, and variation_value, facilitating the management of different variations of the same product.
Product Images
Presents fields such as product_id, image_url, and image_description, allowing visual organization and presentation of product images.
Product Prices
Includes fields such as product_id, sale_price, and promotional_price, essential for defining and managing the sale prices of products.
Order Statuses
Presents fields such as id, description, and last_updated, allowing monitoring of the different statuses of orders in processing.

Try out all the features for free for 14 days

Combine your Orders and Product Stock pipelines in Looker to identify bestselling products and optimal restocking times before inventory runs out. By analyzing Customer data alongside Order Status History, you can visualize the complete purchase journey from first visit to delivery, helping you spot bottlenecks in your fulfillment process. These combinations enable you to build custom dashboards that track inventory turnover, conversion rates by category, and customer lifetime value.

Marketing teams can measure promotion effectiveness by analyzing Coupons alongside sales figures, while operations managers monitor shipping performance and pending orders. This unified view of your Loja Integrada store transforms scattered ecommerce information into coherent visual stories that support daily operational decisions and long-term growth strategies.

Try out all the features for free for 14 days

How to create Loja Integrada dashboards in Looker

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Loja Integrada as data source

Add Loja Integrada to your Kondado account by entering your store credentials and selecting the specific pipelines you want to replicate, such as Orders, Products, or Customers.

2
Select Looker as destination

Choose Looker from the destination options and configure your connection settings to establish a direct link. This creates a seamless path for your Loja Integrada data to flow into your business intelligence environment.

3
Build dashboards and configure refresh

Design custom dashboards in Looker that combine multiple Loja Integrada pipelines for comprehensive insights. Then set your preferred update schedule, choosing from intervals between every 5 minutes and daily refreshes to ensure your reports stay current.

Access Loja Integrada data in Looker and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Loja Integrada data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Loja Integrada data in Looker automatically

How do I connect Loja Integrada to Looker using Kondado?
Start by adding Loja Integrada as a data source in your Kondado account and authenticate with your store credentials. Then select Looker as your destination and choose which pipelines you want to replicate, such as Orders, Products, or Customers. The connection uses our direct integration method, so your data flows straight into Looker without requiring any intermediate databases or complex configuration.
What kind of dashboards can I build with Loja Integrada data in Looker?
You can create operational dashboards that monitor daily sales performance, inventory levels across multiple product categories, and order fulfillment status. Marketing teams often build reports tracking coupon redemption rates and customer acquisition costs, while finance teams visualize cash flow from Order Invoices and Payment Methods. Since you have access to 17 different pipelines, you can mix and match data points to create custom views for every department.
How often does the data update in Looker from Loja Integrada?
Kondado lets you configure the update frequency based on your business needs, ranging from every 5 minutes for near-real-time monitoring to hourly or daily updates for periodic reporting. You can set different schedules for different pipelines, updating critical sales data more frequently while refreshing product catalog information less often. This flexibility ensures your Looker dashboards always reflect current information without overwhelming your system with unnecessary updates.
Which KPIs should I track when visualizing Loja Integrada data?
Essential ecommerce metrics include conversion rate by traffic source, average order value trends over time, and inventory turnover rates using the Product Stock pipeline. You should also monitor customer lifetime value through the Customers pipeline and measure shipping efficiency by analyzing Order Status History against Shipping Methods. These indicators help you optimize pricing strategies, identify popular products, and improve the overall shopping experience.
Can I share Looker dashboards with my team using Kondado data?
Yes, once your Loja Integrada data is replicated to Looker, you can leverage Looker's built-in sharing features to distribute dashboards across your organization. Your marketing, operations, and finance teams can access the same current data simultaneously, ensuring everyone works from unified metrics. You can also export specific visualizations or schedule automated report deliveries to stakeholders who prefer email updates.
Do I need technical skills to set up the Loja Integrada to Looker connection?
No coding or technical expertise is required to connect your store to Looker through Kondado. The setup process uses simple point-and-click interfaces where you select your data source and destination from dropdown menus. Business users, marketers, and operations managers can configure the entire pipeline without involving IT departments or writing complex queries.
Can I combine Loja Integrada data with other sources in Looker?
Absolutely, you can blend your ecommerce data with information from Google Sheets, BigQuery, or PostgreSQL within the same Looker environment. This allows you to compare store performance against advertising metrics or customer service data from other platforms. Kondado supports connections to 80+ sources, giving you flexibility to create comprehensive business views that combine Loja Integrada with your entire tech stack.

Try out all the features for free for 14 days