How do I set up the VTEX connection to Data Studio using Kondado?

In Kondado, select VTEX as your data source and authenticate your store credentials. Choose Looker Studio as your destination, select the pipelines you need such as Orders or Stock, and your data will begin replicating immediately without requiring technical configuration or database setup.

What dashboards can I build with VTEX data in Data Studio?

You can build comprehensive ecommerce dashboards tracking sales performance, inventory levels, and marketing attribution. Common visualizations include order status monitoring, warehouse stock distribution, coupon redemption rates, and shipping timeline analysis to optimize operations and marketing spend.

How often does VTEX data update in my Data Studio reports?

You configure the refresh schedule based on your business needs, with options ranging from every 5 minutes to daily updates. This ensures your Looker Studio reports reflect recent transactions and inventory changes without manual data exports.

Which KPIs should I track using VTEX pipelines in Data Studio?

Track essential metrics including conversion rates by marketing campaign, inventory turnover by warehouse, average order value, shipping performance against estimated dates, and coupon effectiveness. The Marketing Data of Orders and Orders pipelines provide the fields needed to calculate these performance indicators.

Are there pre-built report templates available for VTEX and Data Studio?

Yes, Kondado offers ready-made report templates including the VTEX Looker Studio Report and VTEX Power BI Report. These templates provide pre-configured visualizations for common ecommerce metrics, allowing you to generate insights immediately after connecting your data.

Can I share VTEX dashboards with my team in Data Studio?

Once published, your Data Studio reports can be shared with unlimited team members directly through Google's sharing features. Marketing teams, operations managers, and executives can view current dashboards simultaneously without needing Kondado accounts or access to your VTEX admin panel.

Do I need a database to store VTEX data before visualizing in Data Studio?

No, Kondado connects VTEX directly to Looker Studio using the "Via Kondado" connection method. You do not need to set up intermediate databases, storage systems, or technical infrastructure to visualize your ecommerce data.

Can I combine VTEX data with other sources in Data Studio?

Yes, you can blend VTEX data with other business sources available in Kondado such as Google Sheets for budget data or advertising platforms. This allows you to create unified dashboards that correlate sales performance with external marketing spend or operational costs.

Connect VTEX to Data 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 VTEX Data in Data Studio Reports

Connecting your VTEX store to Data Studio allows you to transform complex ecommerce data into clear visual reports that drive business decisions. With Kondado, you replicate data from your VTEX account directly to Looker Studio without technical setup or intermediate databases. Simply select VTEX as your data source, choose your preferred pipelines, and start building dashboards in minutes. Your reports refresh automatically on your chosen schedule, keeping insights current without manual exports. Business teams can track sales performance, inventory levels, and marketing campaign effectiveness through intuitive visualizations.

Kondado provides a direct connection between VTEX and Data Studio, offering 17 pre-configured pipelines with 432 fields including Orders, Stock, Coupons, and Marketing Data, enabling automated report updates on a configurable schedule without coding or database management.

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

Combining VTEX data in Data Studio unlocks powerful ecommerce analytics for business teams without technical complexity. By blending the Orders pipeline with Marketing Data of Orders, you can analyze which campaigns drive actual sales and calculate precise return on advertising spend. The Stock pipeline helps operations teams monitor inventory levels across warehouses to prevent stockouts, while Order Details provides customer service insights through communication tracking. These combined datasets enable you to identify purchasing trends, optimize promotional strategies, and make inventory decisions based on current business metrics rather than guesswork. Marketing teams can track coupon performance using the Coupons pipeline to refine discount strategies.

Try out all the features for free for 14 days

VTEX data available in Data Studio

available pipelines

432

extractable fields

Available integrations

Integration	Description
Coupons	Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.
Stock	Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.
Master Data	Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.
Orders	Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.
Shipping Data of Orders	Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.
Marketing Data of Orders	Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.
Order Details	Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.
Logistics Information of Orders	Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.
Order Items	Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.
Payments: Order Transactions	Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.
Orders: Fees and Benefits	Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.
Orders: Totals	Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.
Products	Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.
Promotions	Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.
SKUs	Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.
SKUs: Kits	Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.
SKUs: Prices	Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.

Coupons

Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.

Stock

Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.

Master Data

Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.

Orders

Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.

Shipping Data of Orders

Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.

Marketing Data of Orders

Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.

Order Details

Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.

Logistics Information of Orders

Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.

Order Items

Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.

Payments: Order Transactions

Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.

Orders: Fees and Benefits

Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.

Orders: Totals

Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.

Products

Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.

Promotions

Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.

SKUs

Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.

SKUs: Kits

Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.

SKUs: Prices

Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.

See all available data →

Try out all the features for free for 14 days

Discover our VTEX report in Data Studio

How to create VTEX dashboards in Data Studio

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

Connect VTEX to Kondado

Log into Kondado and select VTEX from the available data sources, then enter your store credentials to establish the connection. Choose the specific pipelines you need, such as Orders, Stock, or Marketing Data, to begin replicating your ecommerce information.

Choose Data Studio Destination

Select Looker Studio as your visualization destination and configure how often you want your data to refresh, from every 5 minutes to daily schedules. Kondado will automatically structure your VTEX data for immediate use in dashboard creation without requiring database configuration.

Build Dashboards and Schedule Updates

Access your replicated data directly in Looker Studio to create visual reports tracking sales, inventory, and marketing performance. Set your preferred refresh frequency to keep reports updated automatically, ensuring your team always has current insights for decision-making.