Google Ads (Adwords) | Stitch Documentation

Google Ads (AdWords) (v1) deprecation

This integration is deprecated. A newer version of the Google Ads integration, using the Google Ads API is available. For more information, refer to the Google Ads integration documentation.

Google Ads (AdWords) extraction is supported by Stitch
This integration is powered by Singer's Google Ads (AdWords) tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Support.

Google Ads (AdWords) integration summary

Stitch’s Google Ads (AdWords) integration replicates data using the Google AdWords API (v201809). Refer to the Schema section for a list of objects available for replication.

Note: To use the AdWords API, an Ads account must be connected to a My Client Center (MCC) account.

Google Ads (AdWords) feature snapshot

A high-level look at Stitch's Google Ads (AdWords) (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Deprecated on April 6, 2022	Supported by	[Stitch] (https://community.qlik.com/t5/Support/ct-p/qlikSupport)
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-adwords
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Unsupported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Google Ads (AdWords)

Google Ads (AdWords) setup requirements

To set up Google Ads (AdWords) in Stitch, you need:

To pause any ad-blocking software. Ad blockers can interfere with pop-ups, which are used in Google authorization and may prevent authorization from successfully completing.
Access to the Google Ads (AdWords) data you want to replicate. Before beginning, verify that the user creating the integration has access to the reports you want to replicate.
To connect your Ads account to a My Client Center (MCC) account. This will ensure your account has access to the AdWords API, thereby allowing Stitch to query for and extract data.

An MCC account is an Ads account type that enables you to manage several Ads accounts under a single login. Think of manager accounts as trees: they can branch out to individual accounts or even other manager accounts. Read more about MCC accounts here.

By default, regular advertiser accounts - that is, individual Ads accounts - don’t have access to the AdWords API. To gain access, they must be linked to an MCC account. If you don’t have an MCC account, create one using these instructions and then link it to your Ads account by following these steps.

Step 1: Add Google Ads (AdWords) as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Google Ads (AdWords) icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Google Ads AdWords” would create a schema called stitch_google_ads_adwords in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Google Ads (AdWords) integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Google Ads (AdWords)’s default setting of 30 days. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Google Ads (AdWords) integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch & Select Google Ads (AdWords) Profiles

Selecting Google Ads profiles.

Next, you’ll be prompted to log into your Google account and to approve Stitch’s access to your Google Ads data. Note: We will only ever read your data.
Click Authorize to continue.
After your credentials are validated, you’ll be prompted to select the Google Ads (AdWords) profiles you want to connect to Stitch.

If you don’t see the profile(s) you want to connect, verify that you have completed the setup requirements.
When selecting profiles, keep the following in mind:
- You can select up to 400 profiles per Google Ads integration. If you need to replicate data from more than 400 profiles, you should create additional Google Ads (AdWords) integrations in your Stitch account.
- Selecting a subprofile will also select the parent, or top-level profile. If you de-select the top-level profile, you will be unable to select any subprofiles.
- If multiple profiles are selected, data for all the selected profiles will map to the same table in your destination. For example: If two profiles are selected and the accounts table is tracked, account data for both profiles will be replicated into the accounts table. This is applicable to every table selected in the next step.
When finished selecting profiles, click Continue.

Step 5: Set objects to replicate

Column selection and Google compatibility rules

Because of Google’s compatibility rules, some columns (metrics and segments) can’t be tracked together. As you select columns to track, incompatible fields will automatically be greyed out.

You can create additional Google Ads (AdWords) integrations if you need to track incompatible columns. The resulting table names will still be the same (ex: account_performance_report) but the data will reside in different schemas in your data warehouse.

Initial and historical replication jobs

After you finish setting up Google Ads (AdWords), its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Google Ads (AdWords) replication

There are two types of tables in Stitch’s Google Ads (AdWords) integration: Core Object and Report.

Core Object tables contain foundational data that’s useful for analysis. These are the following tables:
- account
- ad_groups
- ads
- campaigns
These tables are replicated using Full Table Replication.
Report tables are the various Google Ads (AdWords) reports. The replication process for these tables is a bit unlike that of other tables:
- Extraction: Data is extracted using a Conversion Window. A Conversion Window is a period of time after a customer clicks an ad that a conversion (ex: a purchase) is recorded in Google Ads (AdWords).
Stitch currently uses a Conversion Window of 30 days.

This means that data from the past 30 days will be replicated during every replication job.
- Loading: Data is loaded into your data warehouse using Append-Only Replication.

For Report tables, this means that:

Due to the Conversion Window, a high Replication Frequency may not be necessary. Because Stitch will replicate data from the past 30 days during every replication job, recent data will be re-replicated and count towards your row quota.

To reduce your row usage and replicating redundant data, consider setting the integration to replicate less frequently. For example: every 12 or 24 hours.
Querying for the latest data in Report tables will require a different strategy than you might usually use. Stitch will add a column named _sdc_report_datetime to Report tables to help you identify the most recent records in a table. See the Query for the Latest Data section for more info and a sample query.

Each part of the replication process for Report tables is explained below.

Report tables: Data extraction and conversion windows

Every time Stitch runs a replication job for Google Ads (AdWords), the last 30 days’ worth of data will be replicated for any Report tables currently being tracked.

Stitch replicates data in this way to account for updates made during the Conversion Window.

Historical and full re-replications
Ongoing replications

For historical and full re-replications of Google Ads (AdWords) data, Stitch will query for and extract data newer than or equal to the date defined in the Start Date field in the Integration Settings page.

The Start Date, in conjunction with the Conversion Window, defines the minimum date Stitch should query for when extracting historical data. This is calculated as:

Start Date - Conversion Window = Minimum Extraction Date

Example

During the initial set up, the Start Date field is set to July 3, 2017, or 2017-07-03 00:00:00.

To account for the Conversion Window, Stitch would calculate the Minimum Extraction Date value as: 2017-07-03 00:00:00 - 30 days = 2017-06-03 00:00:00

If you were to write a SQL query using this date for the ad_performance_report table, it might look like this:

  SELECT *
    FROM google_ads_adwords.ad_performance_report
   WHERE day >= '2017-06-03 00:00:00'   /* Min. Extraction Date */
ORDER BY day

For ongoing replication jobs, Stitch will query for and extract data using the last saved maximum value in the table’s Replication Key column and the Conversion Window for the table.

Note: This applies to every replication job that takes place after the historical replication job.

Example

The last maximum saved Replication Key value for the ad_performance_report table is 2017-10-01 00:00:00.

To account for the Conversion Window of 30 days, we’d subtract this from the last maximum saved Replication Key value:

2017-10-01 00:00:00 - 30 days = 2017-09-01 00:00:00

In this case, Stitch would query for and extract data that is newer than or equal to 2017-09-01 00:00:00 and older than or equal to 2017-10-01 00:00:00.

If this were a SQL query, it might look like this:

  SELECT *
    FROM ad_performance_report
   WHERE day >= '2017-09-01 00:00:00'
                              /* max Replication Key value - Conversion Window */
     AND day <= '2017-10-01 00:00:00'
                              /* max Replication Key value from previous job */
ORDER BY day

Report tables: Data loading and Append-Only Replication

When Stitch loads the extracted data for Report tables into your destination, it will do so using Append-Only Replication. This is a type of Incremental Replication where existing rows aren’t updated, but appended to the end of the table.

Additionally, the number of rows loaded into the table during each replication job is dependent on the combination of unique values in the dimension columns you track. See the Column Selection and Statistic Aggregation section for more info and examples.

Example

Let’s say these columns are tracking in the ad_performance_report table:

campaignId (dimension) - This is the ID associated with a campaign. In this example, there are two campaigns: 929007494 and 929599581
device (dimension) - The device type. There are two values for this example: Computer and Tablet
impressions (metric) - The total number of impressions.

Every time Stitch replicates and loads data, a row for each unique combination of the dimension columns will be appended to the end of the table:

_sdc_report_datetime	day	_sdc_customer_id	campaignId	device	impressions
2017-10-01 17:48:26.791	2017-09-10 00:00:00	1585293495	929007494	Computer	61
2017-10-01 17:48:26.791	2017-09-10 00:00:00	1585293495	929007494	Tablet	15
2017-10-01 17:48:26.791	2017-09-10 00:00:00	1585293495	929599581	Computer	37
2017-10-01 17:48:26.791	2017-09-10 00:00:00	1585293495	929599581	Tablet	9

Report tables: Query for the latest data

You may need to alter this query

The query below is meant to act as a foundation for writing your own. Depending on your SQL syntax and the dimensions contained in a given table, you may need to alter this query for your own usage.

When querying your Google Ads (AdWords) data, you’ll want to include the Dimensions you’re analyzing in the partition. For example: If you’re analyzing campaigns over time, you’d include columns like campaignId and date.

If you want only the most recently replicated data for any Google Ads (AdWords) Report table, you can use the sample query below to account for the Append-Only Replication Stitch uses.

This query uses two columns - which are automatically included for every Report table - to return the latest data:

day - The day that the record pertains to.
_sdc_report_datetime - The starting time of the Stitch job that extracted the record.

SELECT *
  FROM (
        SELECT *,
        RANK() OVER (PARTITION BY day, customerid
                     ORDER BY _sdc_report_datetime DESC)
        FROM ad_performance_report
        ORDER BY day ASC
       ) AS latest
 WHERE latest.rank = 1

In this query:

A subquery first uses a window function to create a ‘window’ of data for each day,
The values of the _sdc_report_datetime column are ranked within each window partition, and
Then, in the outer query, only the rows with _sdc_report_datetime values ranked as 1 - which is equal to the maximum timestamp - are returned.

Google Ads (AdWords) table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

This is the latest version of the Google Ads (AdWords) integration.

Report tables: Values for money fields

When conducting analyses on Report tables, you might notice that values in money fields - like a cost field, for example - look higher than usual. This is because Google Ads’ API sends Stitch money data in micro currency units. Micro amounts always refer to your account’s local currency.

For example: The value of $2.25USD will be recorded as 2250000. To represent this value as 2.25 in a report, divide by one million: 2250000 / 1000000 = 2.25.

Report tables: Column selection and statistic aggregation

The dimension columns selected for replication in Report tables can impact how performance statistics are aggregated. Additionally, this can also affect the number of rows replicated and loaded into your destination.

For example: if day, _sdc_customer_id, campaignId, device, and impressions were selected, the impressions column would contain the total number of impressions for the device type for that date:

day	_sdc_customer_id	campaignId	device	impressions
2018-01-05 00:00:00	1585293495	240531207	DESKTOP	4
2018-01-05 00:00:00	1585293495	240531207	HIGH_END_MOBILE	3
2018-01-05 00:00:00	1585293495	240531207	TABLET	3
2018-01-05 00:00:00	1585293495	240531207	UNKNOWN	1

If the adNetworkType1 column were also selected, a row for every unique combination of device and adNetworkType1 would be created and impressions would be aggregated accordingly:

day	_sdc_customer_id	campaignId	device	adNetworkType1	impressions
2018-01-05 00:00:00	1585293495	240531207	DESKTOP	YOUTUBE_SEARCH	3
2018-01-05 00:00:00	1585293495	240531207	HIGH_END_MOBILE	YOUTUBE_SEARCH	1
2018-01-05 00:00:00	1585293495	240531207	TABLET	YOUTUBE_SEARCH	0
2018-01-05 00:00:00	1585293495	240531207	UNKNOWN	YOUTUBE_SEARCH	0
2018-01-05 00:00:00	1585293495	240531207	DESKTOP	SEARCH	1
2018-01-05 00:00:00	1585293495	240531207	HIGH_END_MOBILE	SEARCH	2
2018-01-05 00:00:00	1585293495	240531207	TABLET	SEARCH	3
2018-01-05 00:00:00	1585293495	240531207	UNKNOWN	SEARCH	1

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

account_performance_report

The account_performance_report table contains all statistics aggregated by default at the account level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

account_performance_report table foreign keys

Join account_performance_report with	on
accounts	account_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	account_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	account_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	account_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	account_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	account_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	account_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	account_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	account_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	account_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	account_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	account_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	account_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	account_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	account_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	account_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	account_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	account_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

account_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

accounts

The accounts table contains high-level info about the Google AdWords account(s) you’ve connected to Stitch.

This is a Core Object table.

Replication Method

Full Table

Primary Key

customerId

Useful links

Google Ads (AdWords) documentation

accounts schema on GitHub

accounts table foreign keys

Join accounts with	on
account_performance_report	accounts.customerId = account_performance_report._sdc_customer_id
ad_performance_report	accounts.customerId = ad_performance_report._sdc_customer_id
adgroup_performance_report	accounts.customerId = adgroup_performance_report._sdc_customer_id
age_range_performance_report	accounts.customerId = age_range_performance_report._sdc_customer_id
audience_performance_report	accounts.customerId = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	accounts.customerId = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	accounts.customerId = campaign_performance_report._sdc_customer_id
click_performance_report	accounts.customerId = click_performance_report._sdc_customer_id
criteria_performance_report	accounts.customerId = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	accounts.customerId = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	accounts.customerId = display_topics_performance_report._sdc_customer_id
final_url_report	accounts.customerId = final_url_report._sdc_customer_id
gender_performance_report	accounts.customerId = gender_performance_report._sdc_customer_id
geo_performance_report	accounts.customerId = geo_performance_report._sdc_customer_id
keywordless_query_report	accounts.customerId = keywordless_query_report._sdc_customer_id
keywords_performance_report	accounts.customerId = keywords_performance_report._sdc_customer_id
search_query_performance_report	accounts.customerId = search_query_performance_report._sdc_customer_id
video_performance_report	accounts.customerId = video_performance_report._sdc_customer_id

accounts table schema

canManageClients

BOOLEAN

currencyCode

STRING

customerId

INTEGER

dateTimeZone

STRING

name

STRING

testAccount

BOOLEAN

ad_groups

The ad_groups table contains detailed info about your ad groups.

This is a Core Object table.

Replication Method

Full Table

Primary Key

Useful links

Google Ads (AdWords) documentation

ad_groups schema on GitHub

ad_groups table foreign keys

Join ad_groups with	on
ads	ad_groups.id = ads.adGroupId ad_groups.baseAdGroupId = ads.baseAdGroupId ad_groups.baseCampaignId = ads.baseCampaignId
campaigns	ad_groups.baseCampaignId = campaigns.baseCampaignId ad_groups.campaignId = campaigns.id ad_groups.labels.id = campaigns.labels.id

Join ad_groups with

ads

ad_groups.id = ads.adGroupId

ad_groups.baseAdGroupId = ads.baseAdGroupId

ad_groups.baseCampaignId = ads.baseCampaignId

campaigns

ad_groups.baseCampaignId = campaigns.baseCampaignId

ad_groups.campaignId = campaigns.id

ad_groups.labels.id = campaigns.labels.id

ad_groups table schema

adGroupType

STRING

baseAdGroupId

INTEGER

baseCampaignId

INTEGER

biddingStrategyConfiguration

OBJECT

Click to expand biddingStrategyConfiguration

bids

ARRAY

Click to expand bids

Bids.Type

STRING

bid

OBJECT

Click to expand bid

ComparableValue.Type

STRING

microAmount

INTEGER

bidSource

STRING

campaignId

INTEGER

campaignName

STRING

INTEGER

labels

ARRAY

Click to expand labels

Label.Type

STRING

attribute

OBJECT

Click to expand attribute

LabelAttribute.Type

STRING

backgroundColor

STRING

INTEGER

name

STRING

status

STRING

name

STRING

settings

ARRAY

Click to expand settings

Setting.Type

STRING

details

ARRAY

Click to expand details

criterionTypeGroup

STRING

targetAll

INTEGER

optIn

INTEGER

status

STRING

urlCustomParameters

OBJECT

Click to expand urlCustomParameters

doReplace

BOOLEAN

parameters

ARRAY

Click to expand parameters

isRemove

BOOLEAN

key

STRING

value

STRING

ad_performance_report

The ad_performance_report table contains all statistics aggregated at the ad level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

ad_performance_report table foreign keys

Join ad_performance_report with	on
account_performance_report	ad_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	ad_performance_report._sdc_customer_id = accounts.customerId
adgroup_performance_report	ad_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	ad_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	ad_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	ad_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	ad_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	ad_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	ad_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	ad_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	ad_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	ad_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	ad_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	ad_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	ad_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	ad_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	ad_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	ad_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

ad_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

adgroup_performance_report

The ad_performance_report table contains all statistics aggregated at the ad group level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

adgroup_performance_report table foreign keys

Join adgroup_performance_report with	on
account_performance_report	adgroup_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	adgroup_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	adgroup_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
age_range_performance_report	adgroup_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	adgroup_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	adgroup_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	adgroup_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	adgroup_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	adgroup_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	adgroup_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	adgroup_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	adgroup_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	adgroup_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	adgroup_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	adgroup_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	adgroup_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	adgroup_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	adgroup_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

adgroup_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

The ads table contains comprehensive info about ads in ad groups in your Google AdWords account.

This is a Core Object table.

Replication Method

Full Table

Primary Key

adGroupId

Useful links

Google Ads (AdWords) documentation

ads schema on GitHub

ads table foreign keys

Join ads with	on
ad_groups	ads.adGroupId = ad_groups.id ads.baseAdGroupId = ad_groups.baseAdGroupId ads.baseCampaignId = ad_groups.baseCampaignId
campaigns	ads.baseCampaignId = campaigns.baseCampaignId

Join ads with

ad_groups

ads.adGroupId = ad_groups.id

ads.baseAdGroupId = ad_groups.baseAdGroupId

ads.baseCampaignId = ad_groups.baseCampaignId

campaigns

ads.baseCampaignId = campaigns.baseCampaignId

ads table schema

adGroupId

INTEGER

baseAdGroupId

INTEGER

baseCampaignId

INTEGER

policySummary

OBJECT

Click to expand policySummary

combinedApprovalStatus

STRING

denormalizedStatus

STRING

policyTopicEntries

ARRAY

Click to expand policyTopicEntries

policyTopicEntryType

STRING

policyTopicEvidences

ARRAY

Click to expand policyTopicEvidences

evidenceTextList

ARRAY

policyTopicEvidenceType

STRING

policyTopicHelpCenterUrl

STRING

policyTopicId

STRING

policyTopicName

STRING

reviewState

STRING

status

STRING

trademarkDisapproved

BOOLEAN

age_range_performance_report

The age_range_performance_report table contains all Display Network and YouTube Network statistics aggregated by age range.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

age_range_performance_report table foreign keys

Join age_range_performance_report with	on
account_performance_report	age_range_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	age_range_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	age_range_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	age_range_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
audience_performance_report	age_range_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	age_range_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	age_range_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	age_range_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	age_range_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	age_range_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	age_range_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	age_range_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	age_range_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	age_range_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	age_range_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	age_range_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	age_range_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	age_range_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

age_range_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

audience_performance_report

The audience_performance_report table contains performance data from interests and remarketing lists for Display Network and YouTube Network ads, and remarketing lists for search ads (RLSA), aggregated at the audience level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

audience_performance_report table foreign keys

Join audience_performance_report with	on
account_performance_report	audience_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	audience_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	audience_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	audience_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	audience_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
call_metrics_call_details_report	audience_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	audience_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	audience_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	audience_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	audience_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	audience_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	audience_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	audience_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	audience_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	audience_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	audience_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	audience_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	audience_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

audience_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

call_metrics_call_details_report

The call_metrics_call_details_report table contains data for call tracking of call-only ads or call extensions.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

call_metrics_call_details_report table foreign keys

Join call_metrics_call_details_report with	on
account_performance_report	call_metrics_call_details_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	call_metrics_call_details_report._sdc_customer_id = accounts.customerId
ad_performance_report	call_metrics_call_details_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	call_metrics_call_details_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	call_metrics_call_details_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	call_metrics_call_details_report._sdc_customer_id = audience_performance_report._sdc_customer_id
campaign_performance_report	call_metrics_call_details_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	call_metrics_call_details_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	call_metrics_call_details_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	call_metrics_call_details_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	call_metrics_call_details_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	call_metrics_call_details_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	call_metrics_call_details_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	call_metrics_call_details_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	call_metrics_call_details_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	call_metrics_call_details_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	call_metrics_call_details_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	call_metrics_call_details_report._sdc_customer_id = video_performance_report._sdc_customer_id

call_metrics_call_details_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

campaign_performance_report

The campaign_performance_report table contains all statistics aggregated by default at the campaign level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

campaign_performance_report table foreign keys

Join campaign_performance_report with	on
account_performance_report	campaign_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	campaign_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	campaign_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	campaign_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	campaign_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	campaign_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	campaign_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
click_performance_report	campaign_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	campaign_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	campaign_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	campaign_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	campaign_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	campaign_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	campaign_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	campaign_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	campaign_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	campaign_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	campaign_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

campaign_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

campaigns

The campaigns table contains detailed info about your Google AdWords campaigns.

This is a Core Object table.

Replication Method

Full Table

Primary Key

Useful links

Google Ads (AdWords) documentation

campaigns schema on GitHub

campaigns table foreign keys

Join campaigns with	on
ads	campaigns.baseCampaignId = ads.baseCampaignId
ad_groups	campaigns.baseCampaignId = ad_groups.baseCampaignId campaigns.id = ad_groups.campaignId campaigns.labels.id = ad_groups.labels.id

Join campaigns with

ads

campaigns.baseCampaignId = ads.baseCampaignId

ad_groups

campaigns.baseCampaignId = ad_groups.baseCampaignId

campaigns.id = ad_groups.campaignId

campaigns.labels.id = ad_groups.labels.id

campaigns table schema

adServingOptimizationStatus

STRING

advertisingChannelType

STRING

baseCampaignId

INTEGER

budgetId

INTEGER

campaignTrialType

STRING

conversionOptimizerEligibility

OBJECT

Click to expand conversionOptimizerEligibility

eligible

INTEGER

endDate

DATE-TIME

frequencyCap

OBJECT

Click to expand frequencyCap

impressions

INTEGER

timeUnit

STRING

INTEGER

labels

ARRAY

Click to expand labels

Label.Type

STRING

attribute

OBJECT

Click to expand attribute

LabelAttribute.Type

STRING

backgroundColor

STRING

description

STRING

INTEGER

name

STRING

status

STRING

name

STRING

networkSetting

OBJECT

Click to expand networkSetting

targetGoogleSearch

INTEGER

servingStatus

STRING

settings

ARRAY

Click to expand settings

Setting.Type

STRING

details

ARRAY

Click to expand details

criterionTypeGroup

STRING

targetAll

BOOLEAN

domainName

STRING

languageCode

STRING

negativeGeoTargetType

STRING

positiveGeoTargetType

STRING

startDate

DATE-TIME

status

STRING

urlCustomParameters

OBJECT

Click to expand urlCustomParameters

doReplace

BOOLEAN

parameters

ARRAY

Click to expand parameters

isRemove

BOOLEAN

key

STRING

value

STRING

click_performance_report

The click_performance_report table contains statistics aggregated at each click level, and includes both valid and invalid clicks.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

click_performance_report table foreign keys

Join click_performance_report with	on
account_performance_report	click_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	click_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	click_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	click_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	click_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	click_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	click_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	click_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
criteria_performance_report	click_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	click_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	click_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	click_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	click_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	click_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	click_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	click_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	click_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	click_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

click_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

criteria_performance_report

The criteria_performance_report table contains statistics aggregated at the ad group criteria level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

criteria_performance_report table foreign keys

Join criteria_performance_report with	on
account_performance_report	criteria_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	criteria_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	criteria_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	criteria_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	criteria_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	criteria_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	criteria_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	criteria_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	criteria_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
display_keyword_performance_report	criteria_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	criteria_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	criteria_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	criteria_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	criteria_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	criteria_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	criteria_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	criteria_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	criteria_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

criteria_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

display_keyword_performance_report

The display_keyword_performance_report table contains all Display Network and YouTube Network statistics aggregated at the keyword level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

display_keyword_performance_report table foreign keys

Join display_keyword_performance_report with	on
account_performance_report	display_keyword_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	display_keyword_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	display_keyword_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	display_keyword_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	display_keyword_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	display_keyword_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	display_keyword_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	display_keyword_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	display_keyword_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	display_keyword_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_topics_performance_report	display_keyword_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	display_keyword_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	display_keyword_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	display_keyword_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	display_keyword_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	display_keyword_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	display_keyword_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	display_keyword_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

display_keyword_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

display_topics_performance_report

The display_topics_performance_report table contains all Display Network and YouTube Network statistics aggregated at the topic level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

display_topics_performance_report table foreign keys

Join display_topics_performance_report with	on
account_performance_report	display_topics_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	display_topics_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	display_topics_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	display_topics_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	display_topics_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	display_topics_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	display_topics_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	display_topics_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	display_topics_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	display_topics_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	display_topics_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
final_url_report	display_topics_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	display_topics_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	display_topics_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	display_topics_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	display_topics_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	display_topics_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	display_topics_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

display_topics_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

final_url_report

The final_url_report table contains all statistics aggregated at the final URL level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

final_url_report table foreign keys

Join final_url_report with	on
account_performance_report	final_url_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	final_url_report._sdc_customer_id = accounts.customerId
ad_performance_report	final_url_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	final_url_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	final_url_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	final_url_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	final_url_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	final_url_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	final_url_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	final_url_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	final_url_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	final_url_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
gender_performance_report	final_url_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	final_url_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	final_url_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	final_url_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	final_url_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	final_url_report._sdc_customer_id = video_performance_report._sdc_customer_id

final_url_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

gender_performance_report

The gender_performance_report table contains all statistics aggregated by gender.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

gender_performance_report table foreign keys

Join gender_performance_report with	on
account_performance_report	gender_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	gender_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	gender_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	gender_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	gender_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	gender_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	gender_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	gender_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	gender_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	gender_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	gender_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	gender_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	gender_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
geo_performance_report	gender_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	gender_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	gender_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	gender_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	gender_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

gender_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

geo_performance_report

The geo_performance_report table contains all statistics aggregated at the country/territory level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

geo_performance_report table foreign keys

Join geo_performance_report with	on
account_performance_report	geo_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	geo_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	geo_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	geo_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	geo_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	geo_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	geo_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	geo_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	geo_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	geo_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	geo_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	geo_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	geo_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	geo_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
keywordless_query_report	geo_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	geo_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	geo_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	geo_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

geo_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

keywordless_query_report

The keywordless_query_report includes keywordless ads (dynamic search ads) statistics based on search terms.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

keywordless_query_report table foreign keys

Join keywordless_query_report with	on
account_performance_report	keywordless_query_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	keywordless_query_report._sdc_customer_id = accounts.customerId
ad_performance_report	keywordless_query_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	keywordless_query_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	keywordless_query_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	keywordless_query_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	keywordless_query_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	keywordless_query_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	keywordless_query_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	keywordless_query_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	keywordless_query_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	keywordless_query_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	keywordless_query_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	keywordless_query_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	keywordless_query_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywords_performance_report	keywordless_query_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	keywordless_query_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	keywordless_query_report._sdc_customer_id = video_performance_report._sdc_customer_id

keywordless_query_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

keywords_performance_report

The keywords_performance_report table contains all statistics aggregated at the keyword level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

keywords_performance_report table foreign keys

Join keywords_performance_report with	on
account_performance_report	keywords_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	keywords_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	keywords_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	keywords_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	keywords_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	keywords_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	keywords_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	keywords_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	keywords_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	keywords_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	keywords_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	keywords_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	keywords_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	keywords_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	keywords_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	keywords_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
search_query_performance_report	keywords_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id
video_performance_report	keywords_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

keywords_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

search_query_performance_report

The search_query_performance_report table contains all statistics aggregated at the search term level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

search_query_performance_report table foreign keys

Join search_query_performance_report with	on
account_performance_report	search_query_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	search_query_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	search_query_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	search_query_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	search_query_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	search_query_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	search_query_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	search_query_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	search_query_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	search_query_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	search_query_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	search_query_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	search_query_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	search_query_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	search_query_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	search_query_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	search_query_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
video_performance_report	search_query_performance_report._sdc_customer_id = video_performance_report._sdc_customer_id

search_query_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

video_performance_report

The video_performance_report table contains statistics for your account’s upgraded AdWords for Video campaigns.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Primary Key	__sdc_primary_key
Replication Key	day
Useful links	Google Ads (AdWords) documentation

video_performance_report table foreign keys

Join video_performance_report with	on
account_performance_report	video_performance_report._sdc_customer_id = account_performance_report._sdc_customer_id
accounts	video_performance_report._sdc_customer_id = accounts.customerId
ad_performance_report	video_performance_report._sdc_customer_id = ad_performance_report._sdc_customer_id
adgroup_performance_report	video_performance_report._sdc_customer_id = adgroup_performance_report._sdc_customer_id
age_range_performance_report	video_performance_report._sdc_customer_id = age_range_performance_report._sdc_customer_id
audience_performance_report	video_performance_report._sdc_customer_id = audience_performance_report._sdc_customer_id
call_metrics_call_details_report	video_performance_report._sdc_customer_id = call_metrics_call_details_report._sdc_customer_id
campaign_performance_report	video_performance_report._sdc_customer_id = campaign_performance_report._sdc_customer_id
click_performance_report	video_performance_report._sdc_customer_id = click_performance_report._sdc_customer_id
criteria_performance_report	video_performance_report._sdc_customer_id = criteria_performance_report._sdc_customer_id
display_keyword_performance_report	video_performance_report._sdc_customer_id = display_keyword_performance_report._sdc_customer_id
display_topics_performance_report	video_performance_report._sdc_customer_id = display_topics_performance_report._sdc_customer_id
final_url_report	video_performance_report._sdc_customer_id = final_url_report._sdc_customer_id
gender_performance_report	video_performance_report._sdc_customer_id = gender_performance_report._sdc_customer_id
geo_performance_report	video_performance_report._sdc_customer_id = geo_performance_report._sdc_customer_id
keywordless_query_report	video_performance_report._sdc_customer_id = keywordless_query_report._sdc_customer_id
keywords_performance_report	video_performance_report._sdc_customer_id = keywords_performance_report._sdc_customer_id
search_query_performance_report	video_performance_report._sdc_customer_id = search_query_performance_report._sdc_customer_id

video_performance_report table schema

day

DATE-TIME

_sdc_customer_id

INTEGER

__sdc_primary_key

STRING

_sdc_report_datetime

DATE-TIME

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues