Lucen

Google Ads data reference

Advertising
13 tables
382 columns

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

Tables

gold_google_ads_ad_group_performance

Grain
ad group / day
Use for
Conventional campaigns. Not Performance Max

gold_google_ads_ad_performance

Grain
ad / day
Use for
RSA / conventional ads

gold_google_ads_age_performance

Grain
ad group / age / day
Use for
Age diagnostics. Privacy-limited

gold_google_ads_asset_group_performance

Grain
asset group / day
Use for
Performance Max packages

gold_google_ads_campaign_performance

Grain
campaign / day
Use for
Cross-channel campaign truth

gold_google_ads_conversion_action_performance

Grain
conversion action / day
Use for
Conversion mix. No spend/clicks

gold_google_ads_customer_performance

Grain
account / day
Use for
Account totals

gold_google_ads_device_performance

Grain
account / device / day
Use for
Device mix (account grain)

gold_google_ads_gender_performance

Grain
ad group / gender / day
Use for
Gender diagnostics. Privacy-limited

gold_google_ads_geo_performance

Grain
account / geo / day
Use for
Country / presence. Not campaign targeting

gold_google_ads_keyword_performance

Grain
keyword / day
Use for
Search keyword diagnostics

gold_google_ads_network_performance

Grain
account / network / day
Use for
Search / YouTube / Discover mix

gold_google_ads_search_term_performance

Grain
search term / day
Use for
Exposed queries. Partial

Columns

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

gold_google_ads_ad_group_performance columns

33

gold_google_ads_ad_performance columns

34

gold_google_ads_age_performance columns

32

gold_google_ads_asset_group_performance columns

30

gold_google_ads_campaign_performance columns

39

gold_google_ads_conversion_action_performance columns

27

gold_google_ads_customer_performance columns

22

gold_google_ads_device_performance columns

22

gold_google_ads_gender_performance columns

32

gold_google_ads_geo_performance columns

23

gold_google_ads_keyword_performance columns

33

gold_google_ads_network_performance columns

22

gold_google_ads_search_term_performance columns

33

Typical questions

Prompt to try
Account spend / clicks

gold_google_ads_customer_performance

Prompt to try
Campaign ranking

gold_google_ads_campaign_performance

Prompt to try
Performance Max creatives

gold_google_ads_asset_group_performance

Prompt to try
Age or gender mix

the matching table; never both in one query

Starter queries

sql
SELECT date, account_id, account_name, current_account_status, currency_code
FROM `your-project.your_org_gold.gold_google_ads_customer_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, account_id, account_name, current_account_status, currency_code
FROM `your-project.your_org_gold.gold_google_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, currency_code, time_zone
FROM `your-project.your_org_gold.gold_google_ads_ad_group_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, account_id, account_name, currency_code, time_zone
FROM `your-project.your_org_gold.gold_google_ads_ad_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;

Integration page