Advertising
Google Ads schema
SightShark syncs Google Ads into a data warehouse you own. It creates 3 tables holding 35 fields, refreshed daily. Campaign, ad group and keyword performance from the Google Ads API.
3 tables / 35 fields / Provisional
Provisional
The table names below follow this site’s naming convention rather than a production sync, and the field names follow the documented Google Ads schema. Confirm both against your own dataset before you rely on them.
Tables and fields
Every table this connector creates. Field lists come from the production sync where we publish it, and otherwise from the documented schema, marked on the table.
google_ads_campaign_performance
12 fields
- account_id
- account_name
- campaign_id
- campaign_name
- campaign_status
- channel_type
- date
- spend
- impressions
- clicks
- conversions
- conversion_value
google_ads_keyword_performance
7 fields
- keyword
- match_type
- date
- spend
- impressions
- clicks
- conversions
google_ads_ad_group_performance
16 fields, documented schema
- date_day
- account_name
- account_id
- currency_code
- campaign_name
- campaign_id
- ad_group_name
- ad_group_id
- ad_group_status
- ad_group_type
- spend
- clicks
- impressions
- conversions
- conversions_value
- view_through_conversions
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Every ad platform names the same number differently and reports it in its own currency and its own time zone. Put two of them in one report without reconciling that and the totals disagree.
Questions people ask
What tables does SightShark create from Google Ads?
3 tables, including google_ads_campaign_performance, google_ads_keyword_performance, google_ads_ad_group_performance. google_ads_campaign_performance is one row per campaign, per day. Every one is listed on this page, with its fields.
Which Google Ads fields can I get?
The 35 fields on this page, table by table. Lists marked documented schema follow the published schema for Google Ads, and your own warehouse may carry a few more or fewer.
How often does Google Ads data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Google Ads data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Google Ads and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 5 min read
How to report AI Max campaigns to clients.
When Google picks the query, the headline and the page, the report has to show what it picked.
Read it - 6 min read
Budget pacing: the formula, and the report.
Spend against plan, while there is still time to do something about it.
Read it - 5 min read
How often marketing data should refresh.
Almost always daily. Here is why more often is usually worse, not better.
Read it
Get started
Want Google Ads in your own warehouse?
A call with someone who can answer the schema questions.