Meta Ads data reference
Lucen syncs your Meta Ads data (Advertising) to your warehouse and models it into the tables below. You connect Meta 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 Meta Ads data to
Tables
gold_meta_ads_account_performance
- Grain
- account / day
- Use for
- Account totals, daily trends, authoritative reach / frequency / unique clicks
gold_meta_ads_action_performance
- Grain
- ad / day / action type / report time
- Use for
- Six fixed attribution views; conversion values and native purchase ROAS. Context spend repeats across action types
gold_meta_ads_ad_performance
- Grain
- account / ad / day
- Use for
- Ad / creative, video, CTA. Gallery grain
gold_meta_ads_adset_performance
- Grain
- account / ad set / day
- Use for
- Ad set billing event and optimization goal
gold_meta_ads_campaign_demographic_performance
Campaign-day Meta Ads delivery and ad-attributed Instagram outcomes broken down by age and gender. Grain: account_id / campaign_id / date / age / gender. Source: campaign-level Ads Insights with age,gender breakdowns, loaded by the dedicated campaign demographic dataset. Keeps the latest extracted row per natural key and joins current account and campaign metadata. Use to compare campaign audience delivery, Instagram profile visits/follows and demographic cost efficiency. Filter by campaign and closed date range. Sum delivery counts/spend only within this independent report; recompute ratios from matching totals. For Instagram costs, include only rows with available result counts in both numerator and denominator and report incomplete coverage. Missing or unsupported Instagram metrics remain NULL; zero results yield NULL costs. Native unknown demographic labels are retained; privacy-suppressed or absent buckets are not inferred. Delivery requests use provider default attribution without explicit windows or unified attribution. Reach, frequency and unique metrics are non-additive across dates/campaigns. Use gold_meta_ads_campaign_performance for unbroken campaign totals and gold_meta_ads_demographic_performance for account demographics. Do not combine overlapping reports as independent facts or allocate account totals/unsegmented action results to demographic buckets. Contains explicit typed reporting columns, not raw action JSON.
gold_meta_ads_campaign_performance
- Grain
- account / campaign / day
- Use for
- Campaign delivery, spend, status, objective
gold_meta_ads_demographic_performance
- Grain
- account / day / age / gender
- Use for
- Audience mix. Row-level reach only
gold_meta_ads_device_performance
- Grain
- ad / day / device
- Use for
- Device delivery
gold_meta_ads_geo_performance
- Grain
- account / day / country / region
- Use for
- Geo mix. Row-level reach only
gold_meta_ads_placement_performance
- Grain
- ad / day / publisher / position
- Use for
- Placement delivery
Columns
Column names match your warehouse exactly. Descriptions come from dbt.
gold_meta_ads_account_performance columns
24
gold_meta_ads_action_performance columns
40
gold_meta_ads_ad_performance columns
34
gold_meta_ads_adset_performance columns
31
gold_meta_ads_campaign_demographic_performance columns
36
gold_meta_ads_campaign_performance columns
32
gold_meta_ads_demographic_performance columns
20
gold_meta_ads_device_performance columns
26
gold_meta_ads_geo_performance columns
20
gold_meta_ads_placement_performance columns
27
Typical questions
How much did we spend / reach this week?
gold_meta_ads_account_performance
Which campaign spent most?
gold_meta_ads_campaign_performance
Which ads / creatives?
gold_meta_ads_ad_performance
Link clicks at 7-day click?
gold_meta_ads_action_performance
Reach by country?
Say native geo-row reach only; account reach is the account table
Starter queries
SELECT date, account_id, account_name, currency, timezone_name
FROM `your-project.your_org_gold.gold_meta_ads_account_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;SELECT date, account_id, account_name, campaign_id, campaign_name
FROM `your-project.your_org_gold.gold_meta_ads_campaign_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;SELECT date, account_id, account_name, campaign_id, campaign_name
FROM `your-project.your_org_gold.gold_meta_ads_adset_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;SELECT date, account_id, account_name, campaign_id, campaign_name
FROM `your-project.your_org_gold.gold_meta_ads_ad_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;