Connect your VTEX store to Metabase without writing code or managing complex infrastructure. Kondado offers a direct connection that lets you replicate your ecommerce data on a configurable schedule, updating every few minutes or daily based on your business needs. Business teams can then explore orders, inventory, and customer information through Metabase’s intuitive interface to make faster, data-driven decisions about promotions, stock levels, and customer behavior patterns across all your sales channels.
Kondado connects VTEX to Metabase using a direct Via Kondado connection with no intermediate databases required, allowing you to visualize 17 different data pipelines including Orders, Stock, and Marketing Data in near-real-time dashboards. With automated updates and 432 available fields covering everything from coupon performance to logistics information, marketing and operations teams gain immediate access to the metrics that drive revenue growth without waiting for technical assistance or complex manual exports.
Once connected, you can combine data from multiple pipelines to answer complex business questions without technical help. The Orders pipeline reveals purchase patterns and revenue trends across all channels, while Marketing Data of Orders shows which campaigns actually convert customers, helping you optimize ad spend effectively. Stock and SKUs pipelines keep inventory levels visible in your dashboards, preventing overselling and stockouts during peak sales seasons. Metabase makes it easy to build shareable reports that keep everyone from warehouse managers to marketing directors aligned on the metrics that matter most for driving profitability.
Try out all the features for free for 14 days
How to create VTEX dashboards in Metabase
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
Connecting VTEX as a data source on Kondado
Add VTEX to your Kondado account by entering your App Key and App Token credentials from your VTEX admin panel. Select specific pipelines like Orders, Stock, or Master Data to start replicating your ecommerce information on your chosen schedule.
2
Selecting Metabase as destination
Choose Metabase as your destination to create a direct connection, or explore alternatives like Power BI and Looker Studio if your team prefers those visualization platforms.
3
Building dashboards and configuring data refresh
Use Metabase's question builder to create charts from your replicated data, then configure automatic refreshes ranging from 5 minutes to daily updates. Share completed dashboards with your team to keep everyone aligned on sales trends and inventory levels without manual reporting.
Try out all the features for free for 14 days
Access VTEX data in Metabase 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 Metabase automatically
How do I connect VTEX to Metabase using Kondado?▼
Start by adding VTEX as a data source in your Kondado account and enter your store credentials. Then select Metabase as your destination and choose which pipelines you want to replicate, such as Orders, Stock, or Coupons. The connection uses our direct Via Kondado method, so you do not need to configure any intermediate databases or technical infrastructure.
What VTEX dashboards can I build in Metabase?▼
You can create operational dashboards tracking order fulfillment, inventory levels by warehouse, and promotional campaign performance. Marketing teams often build reports combining Orders data with Marketing Data of Orders to analyze customer acquisition costs and conversion rates. Operations managers use Stock and Logistics Information pipelines to monitor shipping times and prevent delivery delays.
How often does VTEX data update in Metabase?▼
You choose the update frequency based on your business needs, ranging from every 5 minutes to daily schedules. This configurable schedule ensures your dashboards reflect recent transactions without overwhelming your system with constant updates. You can adjust the timing anytime as your business requirements change during seasonal peaks or sales events.
Which VTEX KPIs should I track in Metabase?▼
Monitor order completion rates using the Orders pipeline, inventory turnover via Stock data, and coupon redemption effectiveness through the Coupons pipeline. Track shipping performance with Logistics Information and compare campaign ROI by analyzing Marketing Data of Orders alongside revenue totals. These metrics help identify bottlenecks in your ecommerce operation and opportunities to increase average order value.
Are there pre-built VTEX report templates available?▼
Yes, we offer ready-made dashboards including the VTEX Power BI Report and VTEX Looker Studio Report for users who prefer those visualization tools. While Metabase dashboards require custom building, you can reference these templates for inspiration on layout and KPI selection. The same data structure applies across all destinations, so insights from our Power BI or Looker Studio templates transfer easily to your Metabase environment.
Can I share VTEX Metabase dashboards with my team?▼
Yes, Metabase allows you to share interactive dashboards via links or email subscriptions with stakeholders across your organization. Team members can view reports without needing Kondado access, though you control permission levels for editing versus viewing. This keeps everyone from customer service to executive leadership aligned on current sales performance and inventory status.
Can I send VTEX data to other tools besides Metabase?▼
Absolutely, you can replicate your VTEX data to multiple destinations simultaneously including Google Sheets, BigQuery, PostgreSQL, MySQL, Excel, Redshift, SQL Server, and Amazon S3. This flexibility lets you use Metabase for executive dashboards while sending raw data to BigQuery for advanced analysis or Google Sheets for operational spreadsheets. Each destination maintains the same update schedule you configured for your primary connection.
'%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)