Lucen

Meta Ads data reference

Advertising
10 tables
290 columns

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

Prompt to try
How much did we spend / reach this week?

gold_meta_ads_account_performance

Prompt to try
Which campaign spent most?

gold_meta_ads_campaign_performance

Prompt to try
Which ads / creatives?

gold_meta_ads_ad_performance

Prompt to try
Link clicks at 7-day click?

gold_meta_ads_action_performance

Prompt to try
Reach by country?

Say native geo-row reach only; account reach is the account table

Starter queries

sql
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;
sql
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;
sql
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;
sql
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;

Integration page