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;