How do I connect my Loja Integrada store to Looker Studio using Kondado?

Start by adding Loja Integrada as a data source in your Kondado account and authenticate with your store credentials. Then select Looker Studio as your destination and choose which pipelines you want to replicate, such as Orders, Products, or Customers.

What sales KPIs can I track by visualizing Loja Integrada data in Looker Studio?

You can monitor conversion rates by analyzing Orders alongside Customer Groups, track inventory turnover using Product Stock and Product Prices pipelines, and measure coupon effectiveness by connecting Coupons data with actual sales figures. These metrics help you optimize pricing and promotional strategies for your Brazilian e-commerce operation.

How often does my Loja Integrada data update in Looker Studio?

Kondado lets you configure automated updates on a schedule that fits your business needs, ranging from every 5 minutes for high-volume stores to hourly or daily updates for standard operations. You control the frequency per pipeline, ensuring your Looker Studio dashboards reflect recent activity without manual refreshes.

Can I build a dashboard showing Loja Integrada order status and shipping together?

Yes, combining the Orders, Order Status History, and Shipping Methods pipelines allows you to create comprehensive fulfillment tracking dashboards. You can visualize processing times, identify bottlenecks in specific shipping methods, and monitor order progression from payment confirmation to delivery.

Is there a pre-built template for Loja Integrada in Looker Studio?

Kondado provides the data foundation for you to build custom dashboards tailored to your specific business needs, allowing you to combine any of the 17 available pipelines including Product Variation Grades and Order Invoices. You can design reports that match your unique workflow rather than adapting to generic templates.

How do I share Loja Integrada reports with my marketing team in Looker Studio?

Once your dashboard is built using the replicated data, use Looker Studio's native sharing features to grant view or edit access to team members. Your colleagues will see the same current data from your Loja Integrada store without needing direct access to the source or Kondado account.

Can I analyze Loja Integrada product performance across different variations?

By combining the Products, Product Variation Grades, and Product Stock pipelines in Looker Studio , you can compare sales velocity between size or color options and identify which variations drive the most revenue. This helps optimize your catalog and inventory allocation for complex product lines.

What payment insights can I get from Loja Integrada data in Looker Studio?

Connecting the Payment Methods pipeline with Orders data reveals which payment options your customers prefer, transaction success rates, and how payment choices correlate with order values. This information supports decisions about offering or removing specific payment methods to improve checkout conversion.

Connect Loja Integrada to Looker Studio: Dashboards in Minutes

Get started for free

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

or sign up with your email

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

Visualize Loja Integrada Data in Looker Studio

To visualize your Loja Integrada store data in Looker Studio, start by connecting your account to Kondado and selecting the pipelines you want to analyze, such as Orders, Products, and Customer information. Kondado replicates your e-commerce information on a configurable schedule, making it available through a direct connection to Looker Studio without requiring any technical setup or intermediate databases. Your marketing and operations teams can then build custom dashboards to track sales performance, inventory levels, and customer behavior using familiar drag-and-drop visualization tools that turn raw data into actionable business insights. This approach eliminates manual data exports and ensures your reports always reflect the current state of your online store.

Kondado connects Loja Integrada to Looker Studio via a direct “Via Kondado” connection, allowing business users to replicate 17 data pipelines including Orders, Products, and Customers on schedules ranging from 5 minutes to daily, with no coding or database management required.

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

What You Can Analyze

With Kondado, you can combine Loja Integrada’s Orders and Product Stock pipelines in Looker Studio to identify which items are selling fastest and when to restock inventory before running out during peak sales periods. Analyzing Customer data alongside Order Status History helps you understand purchase patterns and optimize your post-sale communication strategy for better retention and lifetime value. These visualizations enable your team to spot trends in Brazilian e-commerce markets, adjust pricing strategies using Product Prices information, and make data-driven decisions that grow your online store without waiting for technical support or manual spreadsheet updates.

Try out all the features for free for 14 days

Loja Integrada data available in Looker Studio

available pipelines

397

extractable fields

Available integrations

Integration	Description
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.

How to create Loja Integrada dashboards in Looker Studio

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

Connect Loja Integrada to Kondado

Authenticate your Loja Integrada store in Kondado by providing your API credentials, then select the specific pipelines you want to analyze such as Orders, Products, or Customer data.

Select Looker Studio destination

Choose Looker Studio as your visualization tool. Configure how often you want your data to refresh, from every 5 minutes to daily updates based on your business needs.

Build dashboards and set refresh schedule

Create custom reports in Looker Studio using your replicated Loja Integrada data. Set up automated refreshes so your charts and KPIs stay current without manual updates or exports.