MercadoLibre Commerce data reference
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
Daily sales
gold_mercadolibre_sales_daily
Ads spend
gold_mercadolibre_ads_campaign_performance
Cancellations
gold_mercadolibre_cancellations
Starter queries
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;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;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;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;