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.
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.
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
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.
2
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.
3
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.
Try out all the features for free for 14 days
Access VTEX data in Data Studio 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!
Answers about visualizing VTEX data in Data Studio automatically
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.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)