Kondado provides a direct connection between VTEX and Redash, allowing business teams to replicate ecommerce data on a configurable schedule. You simply select VTEX as your data source and Redash as your destination, then choose which pipelines to activate. Within minutes, your orders, inventory, and marketing data become available as visual charts and dashboards in Redash, enabling data-driven decisions without technical complexity.
The platform handles all data preparation automatically, so marketing and operations teams can focus on analyzing performance rather than managing technical infrastructure. Whether you need near-real-time inventory updates or daily sales summaries, Kondado keeps your Redash dashboards current with automated refreshes tailored to your business needs.
Kondado offers 17 ready-to-use VTEX pipelines including Orders, Stock, and Marketing Data, replicating 432 fields directly into Redash on update frequencies ranging from 5 minutes to daily, with no intermediate databases or coding required.
Combining VTEX data with Redash visualization capabilities opens powerful analytical opportunities for ecommerce businesses. The Orders pipeline provides detailed transaction information including status and total value, while the Marketing Data of Orders pipeline reveals which campaigns drive actual sales through affiliate and UTM tracking. Meanwhile, the Stock pipeline keeps warehouse quantities visible, helping operations teams prevent overselling and optimize fulfillment. By visualizing these interconnected datasets together, managers can identify top-performing products, monitor shipping timelines from the Shipping Data of Orders pipeline, and adjust promotional strategies based on real coupon usage from the Coupons pipeline, all within intuitive Redash dashboards that update on your preferred schedule.
Try out all the features for free for 14 days
How to create VTEX dashboards in Redash
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
Connect VTEX as Your Data Source
Add VTEX to your Kondado account by entering your store credentials and authentication details. Select the specific pipelines you want to replicate, such as Orders, Stock, or Marketing Data, to define which ecommerce data will be available for visualization.
2
Choose Redash as Destination
Select Redash from the available destinations to establish where your VTEX data will be sent. Kondado automatically prepares your data structure so it appears correctly formatted within Redash, ready for immediate chart and dashboard creation.
3
Configure Refresh and Visualize
Set your preferred update schedule ranging from 5 minutes to daily, then start building dashboards using the replicated VTEX data. Create visualizations tracking sales performance, inventory levels, and marketing campaigns that stay current automatically without manual intervention.
Try out all the features for free for 14 days
Access VTEX data in Redash 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 Redash automatically
How do I connect my VTEX store to Redash using Kondado?▼
Start by adding VTEX as a data source in your Kondado account and enter your VTEX credentials. Then select Redash as your destination, choose the specific pipelines you want to replicate, and configure your preferred update schedule. Kondado handles the technical setup automatically, so your data flows directly into Redash without requiring any coding or database configuration.
What VTEX dashboards can I build in Redash?▼
You can create comprehensive dashboards tracking sales performance, inventory levels, promotional campaign effectiveness, and shipping logistics. Combine data from the Orders, Stock, and Marketing Data of Orders pipelines to visualize conversion rates, best-selling SKUs, and campaign ROI. Many users also build operational dashboards monitoring order status flows and warehouse stock alerts to streamline fulfillment processes.
How often does VTEX data update in Redash?▼
Kondado allows you to configure update frequencies ranging from every 5 minutes to daily, depending on your business requirements. High-velocity operations often choose 15-minute intervals for inventory and order tracking, while strategic marketing reports may refresh daily. You can adjust these schedules anytime to match your analytics needs without disrupting existing dashboards.
Which ecommerce KPIs should I track in Redash with VTEX data?▼
Focus on metrics like order conversion rates, average order value from the Orders: Totals pipeline, and inventory turnover using the Stock pipeline. Marketing teams should monitor UTM campaign performance and affiliate attribution through the Marketing Data of Orders pipeline. Operations managers benefit from tracking shipping estimated dates and invoice statuses to optimize delivery timelines and customer satisfaction.
Are there pre-built VTEX dashboard templates available?▼
Yes, Kondado provides ready-made reports including the VTEX Power BI Report and VTEX Looker Studio Report for users who prefer those visualization tools. While these templates are optimized for Power BI and Looker Studio, the underlying VTEX data structure supports easy dashboard creation in Redash using the same replicated pipelines and field mappings.
Can I share Redash dashboards with my team using VTEX data?▼
Absolutely, once your VTEX data is visualized in Redash, you can share dashboards with stakeholders across marketing, operations, and executive teams. Redash supports scheduled email reports and embedded sharing options, ensuring everyone accesses the same current data. Your team members can view insights without needing direct access to your VTEX admin panel or Kondado account.
What specific VTEX data can I visualize in Redash?▼
Kondado offers 17 distinct pipelines covering every aspect of your ecommerce operation, including Orders, Order Items, Coupons, Promotions, SKUs: Prices, and Payments. You can visualize individual product performance, promotional campaign usage, shipping logistics, and customer transaction details. This comprehensive coverage enables deep analysis of sales trends, inventory management, and marketing attribution within your Redash environment.
'%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)