Lucen

MercadoLibre Commerce data reference

E-commerce
9 tables
234 columns

Lucen syncs your MercadoLibre Commerce data (E-commerce) to your warehouse and models it into the tables below. You connect MercadoLibre Commerce with one OAuth sign-in. 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 MercadoLibre Commerce data to

Tables

gold_mercadolibre_cancellations

Grain
cancellation
Use for
Cancelled orders

gold_mercadolibre_financial_events_daily

Engineering diagnostic model published only into the explicit per-run audit schema; excluded from regular Mercado Libre gold builds. Financial movement audit by date, seller/site, currency, event/category/subtype, attribution, scope, reconciliation, and eligibility. Includes unattributed and control contributions; not a cash/settlement ledger or immutable event history. Refunds are cumulative order snapshots placed on the latest payment/cancellation date. Net is an eligible event subtotal without order-level availability masking; use gold_mercadolibre_sales_daily for commercial net.

gold_mercadolibre_items

Grain
item
Use for
Item catalog

gold_mercadolibre_order_geography

Grain
order
Use for
Order geo grain

gold_mercadolibre_orders_status_by_region_daily

Grain
status / region / day
Use for
Status geo

gold_mercadolibre_orders_status_daily

Grain
status / day
Use for
Order counts by status

gold_mercadolibre_pack_split_lineage

Grain
pack / order
Use for
Split-pack lineage

gold_mercadolibre_sales_by_region_daily

Grain
seller / currency / region / day
Use for
Commercial measures and provider net by geography

gold_mercadolibre_sales_daily

Grain
seller / currency / product variation / status / day
Use for
Commercial measures and provider net, including net-only adjustments

Columns

Column names match your warehouse exactly. Descriptions come from dbt.

gold_mercadolibre_cancellations columns

26

gold_mercadolibre_financial_events_daily columns

23

gold_mercadolibre_items columns

16

gold_mercadolibre_order_geography columns

31

gold_mercadolibre_orders_status_by_region_daily columns

24

gold_mercadolibre_orders_status_daily columns

20

gold_mercadolibre_pack_split_lineage columns

27

gold_mercadolibre_sales_by_region_daily columns

34

gold_mercadolibre_sales_daily columns

33

Typical questions

Prompt to try
Daily sales

gold_mercadolibre_sales_daily

Prompt to try
Ads spend

gold_mercadolibre_ads_campaign_performance

Prompt to try
Cancellations

gold_mercadolibre_cancellations

Starter queries

sql
SELECT date, seller_id, seller_nickname, site_id, context_channel
FROM `your-project.your_org_gold.gold_mercadolibre_sales_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, seller_id, seller_nickname, site_id, context_channel
FROM `your-project.your_org_gold.gold_mercadolibre_sales_by_region_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, seller_id, seller_nickname, site_id, context_channel
FROM `your-project.your_org_gold.gold_mercadolibre_orders_status_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, seller_id, seller_nickname, site_id, context_channel
FROM `your-project.your_org_gold.gold_mercadolibre_orders_status_by_region_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;

Integration page