Lucen

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;

Integration page