Connect VTEX to Looker Studio: 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
Looker Studio

Visualize VTEX Data in Looker Studio

Kondado makes it simple to visualize your VTEX store data in Looker Studio without any technical setup or coding required. You can replicate orders, inventory, and marketing data directly into interactive dashboards that update on a configurable schedule you control, choosing intervals from every 5 minutes to daily updates. Business teams gain immediate visibility into sales performance, stock levels, and campaign effectiveness through automated reporting that keeps everyone aligned on key metrics and business opportunities.

Kondado connects VTEX to Looker Studio using a direct “Via Kondado” connection, eliminating the need for intermediate databases or complex configurations while allowing users to set update frequencies from every 5 minutes to daily.

With this direct connection, marketing teams track affiliate performance continuously, operations monitor shipping logistics across warehouses, and executives view consolidated revenue metrics all in one visual interface. The platform handles the data replication automatically, so you focus on making strategic decisions rather than managing technical infrastructure or manual data exports.

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 Looker Studio reveals powerful insights across your ecommerce operation. By visualizing the Orders pipeline alongside Marketing Data of Orders, you identify which affiliate campaigns and UTM sources drive actual sales to calculate true return on ad spend. The Stock pipeline helps prevent overselling by displaying inventory positions across warehouses, while Coupons data reveals promotion performance and customer redemption patterns. These combined views enable marketing teams to optimize spend, operations to manage fulfillment proactively, and managers to spot revenue trends through visual charts that update automatically on your chosen schedule.

Try out all the features for free for 14 days

VTEX data available in Looker Studio

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

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

1
Add VTEX as Data Source

Log into Kondado and add VTEX as a data source by providing your store credentials, then choose which pipelines to replicate such as Orders, Stock, or Marketing Data.

2
Select Looker Studio Destination

Choose Looker Studio as your visualization destination to establish a direct connection that requires no intermediate databases or complex technical setup.

3
Build Dashboards and Configure Refresh

Create visualizations in Looker Studio using your VTEX data and set automated updates to run on your preferred schedule, from every 5 minutes to daily refreshes.

Access VTEX data in Looker 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!

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 Looker Studio automatically

How do I connect VTEX to Looker Studio using Kondado?
Start by adding VTEX as a data source in your Kondado account and enter your store credentials. Then select Looker Studio as your destination and choose the specific pipelines you want to replicate, such as Orders or Stock data. The connection uses a direct "Via Kondado" method that requires no intermediate databases or technical configuration.
What VTEX dashboards can I build in Looker Studio?
You can create comprehensive ecommerce dashboards showing sales trends from the Orders pipeline, inventory levels via Stock data, and campaign performance using Marketing Data of Orders. Many users build executive summaries combining revenue metrics with shipping logistics to monitor fulfillment efficiency alongside financial results.
How often does VTEX data update in Looker Studio?
You control the update frequency and can configure automated refreshes to run every 5 minutes, 15 minutes, hourly, or daily depending on your business needs. This configurable schedule ensures your dashboards display current information without manual exports or data refreshes.
Can I share VTEX reports with my team in Looker Studio?
Yes, once your data is flowing to Looker Studio, you can share interactive reports with marketing teams, operations managers, or executives through standard Looker Studio sharing features. Team members view live data based on the refresh schedule you configured, ensuring everyone works with the same current metrics.
Are there pre-built VTEX dashboard templates available?
Kondado offers ready-made report templates including the VTEX Looker Studio Report and VTEX Power BI Report, which provide immediate visualizations for common ecommerce metrics. These templates include pre-configured charts for orders, inventory, and marketing performance that you can customize to match your specific business requirements.
What key metrics should I track from VTEX in Looker Studio?
Focus on combining Orders data with Marketing Data of Orders to track conversion rates by campaign and affiliate performance. Monitor Stock levels to prevent inventory shortages, and use Coupons data to measure promotion effectiveness and customer acquisition costs through visual KPI cards and trend lines.

Try out all the features for free for 14 days