Connect VTEX to Redash: Dashboards in Minutes

Get started for free

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

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

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

VTEX
Redash

Visualize VTEX Data in Redash with Automated Pipelines

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.

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 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

VTEX data available in Redash

17
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.

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.

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!

Visualize VTEX data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

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.

Try out all the features for free for 14 days