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;