VTEX data reference
E-commerce
1 table
19 columns
Lucen syncs your VTEX data (E-commerce) to your warehouse and models it into the tables below. You connect VTEX by pasting its credentials. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.
Your plan sets how much history the first sync loads, see pricing.
Send VTEX data to
Tables
gold_vtex_orders
- Grain
- order (
account_name,order_id) - Use for
- Order-level revenue and status
Columns
Column names match your warehouse exactly. Descriptions come from dbt.
gold_vtex_orders columns
19
Typical questions
Prompt to try
Order revenue by day
gold_vtex_ordersgroup by order_created_date, same currency
Prompt to try
Order status mix
gold_vtex_orders
Prompt to try
Units sold
gold_vtex_orderstotal_units
Prompt to try
Store sales by platform (UTM)
gold_vtex_ordersgroup by mapped utm_source
Prompt to try
Paid vs organic store sales
gold_vtex_ordersutm_medium, utm_campaign, rules above
Starter queries
sql
SELECT order_created_date, account_name, order_id, creation_date, last_change
FROM `your-project.your_org_gold.gold_vtex_orders`
WHERE order_created_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY order_created_date DESC
LIMIT 100;