Lucen

MercadoLibre Ads data reference

Advertising
3 tables
171 columns

Lucen syncs your MercadoLibre Ads data (Advertising) to your warehouse and models it into the tables below. You connect MercadoLibre Ads 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 Ads data to

Tables

gold_mercadolibre_ads_ad_group_items

Grain
ad group / item
Use for
Items in an ad group

gold_mercadolibre_ads_ad_group_performance

Grain
ad group / day
Use for
Ad group delivery

gold_mercadolibre_ads_campaign_performance

Grain
campaign / day
Use for
Product Ads campaigns

Columns

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

gold_mercadolibre_ads_ad_group_items columns

16

gold_mercadolibre_ads_ad_group_performance columns

79

gold_mercadolibre_ads_campaign_performance columns

76

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, campaign_id, impressions, clicks, cost
FROM `your-project.your_org_gold.gold_mercadolibre_ads_campaign_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, ad_group_id, ad_group_thumbnail_url, ad_group_permalink, ad_group_metadata_fetched_at
FROM `your-project.your_org_gold.gold_mercadolibre_ads_ad_group_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT seller_id, connection_id, advertiser_id, site_id, ad_group_id
FROM `your-project.your_org_gold.gold_mercadolibre_ads_ad_group_items`
LIMIT 100;

Integration page