Release Status Released Supported By Stitch
Availability Free Status Page Google AdWords Status Page
Default Historical Sync 30 days Default Replication Frequency 24 hours
Whitelisting Tables and columns Destination Incompatibilities None

Connecting Google AdWords

Google AdWords Setup requirements

To set up Google 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 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 AdWords 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 AdWords account type that enables you to manage several AdWords 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 AdWords 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 AdWords account by following these steps.

Step 1: Add Google AdWords as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Google AdWords icon.

  4. 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 AdWords” would create a schema called stitch_google_adwords in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the Historical Sync

The Sync Historical Data setting will define the starting date for your Google AdWords integration. This means that:

  • For tables using Incremental Replication, data equal to or newer than this date will be replicated to your data warehouse.
  • For tables using Full Table Replication, all data - including records that are older, 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 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

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.

Stitch offers two methods of creating a replication schedule:

  • Replication Frequency: This method requires selecting the interval you want replication to run for the integration. Start times of replication jobs are based on the start time and duration of the previous job. Refer to the Replication Frequency documentation for more information and examples.
  • Anchor scheduling: Based on the Replication Frequency, or interval, you select, this method “anchors” the start times of this integration’s replication jobs to a time you select to create a predictable schedule. Anchor scheduling is a combination of the Anchor Time and Replication Frequency settings, which must both be defined to use this method. Additionally, note that:

    • A Replication Frequency of at least one hour is required to use anchor scheduling.
    • An initial replication job may not begin immediately after saving the integration, depending on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

To help prevent overages, 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 AdWords Profiles

Selecting Google AdWords profiles.

  1. Next, you’ll be prompted to log into your Google account and to approve Stitch’s access to your Google AdWords data. Note: We will only ever read your data.
  2. Click Authorize to continue.
  3. After your credentials are validated, you’ll be prompted to select the Google AdWords profile(s) 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.

  4. When selecting profiles, keep the following in mind:

    • You can select up to 400 profiles per Google AdWords integration. If you need to replicate data from more than 400 profiles, you should create additional Google 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.
  5. When finished selecting profiles, click Continue.

Step 5: Set tables to replicate

To complete the setup, you’ll need to select tables you want to replicate to your data warehouse.

Check out the Schema section to learn more about the available tables in Google AdWords and how they replicate.

  1. In the list of tables that displays - or in the Tables to Replicate tab, if you skipped this step during setup - locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.

  3. Repeat this process for all the tables you want to replicate.
  4. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Note: If you change these settings while a replication job is still in progress, they will not be used until the next job starts.

Initial and historical replication jobs

After you finish setting up Google 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.

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.


Google AdWords Replication

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

  • Core Object tables contain foundational data that’s useful for analysis. These are the accounts, ad_groups, ads, and campaigns tables. These tables are replicated using Full Table Replication.

  • Report tables are the various Google 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 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:

  1. 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 help prevent overages or unnecessary re-replication, consider setting the integration to sync less frequently. For example: every 12 or 24 hours.

  2. 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 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.

For historical and full re-replications of Google 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, will define 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_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 setting.

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

If you want only the most recently replicated data for any Google 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:

  1. A subquery first uses a window function to create a ‘window’ of data for each day,
  2. The values of the _sdc_report_datetime column are ranked within each window partition, and
  3. 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 AdWords table schemas

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 AdWords’ 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

account_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


Replication Method: Full Table Documentation: Official Docs
Primary Key : customerId

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

This is a Core Object table.

customerId
INTEGER

The ID of the AdWords account that the record belongs to.

canManageClients
BOOLEAN

Indicates if the AdWords account can manage clients.

currencyCode
STRING

The currency code used by the AdWords account.

dateTimeZone
STRING

The local timezone used by the AdWords account.

name
STRING

The name used by the manager to refer to the client.

testAccount
BOOLEAN

Indicates if the managed customer’s account is a test account.


Replication Method: Full Table Documentation: Official Docs
Primary Key : id

The ad_groups table contains detailed info about your ad groups.

This is a Core Object table.

id
INTEGER

The ID of the ad group.

adGroupType
STRING

The type of the ad group.

baseAdGroupId
INTEGER

The ID of the base ad group from which the draft/trial ad group was created. This field will be NULL if the ad group was created in the draft or trial and has no corresponding base ad group.

baseCampaignId
INTEGER

The ID of the base campaign from which the draft/trial ad group was created.

biddingStrategyConfiguration__bidSource
STRING

Indicates where the bidding strategy is associated i.e. campaign, ad group, or ad group criterion.

biddingStrategyConfiguration__BidsType
STRING

The type of bidding strategy to be attached.

biddingStrategyConfiguration__bids

If your destination doesn't natively support nested data, this data may be denested into a subtable named ad_groups__biddingStrategyConfiguration__bids. Refer to the Singer schema for details on possible attributes.

campaignId
INTEGER

The ID of the campaign associated with the ad group.

campaignName
STRING

The name of the campaign associated with the ad group.

customerId
INTEGER

The ID of the AdWords account that the record belongs to.

labels

Details about the labels applied to the ad.

If your destination doesn't natively support nested data, this data may be denested into a subtable named ad_groups__labels. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_id
INTEGER

The ID of the ad group.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
INTEGER

The ID of the label applied to the ad.

name
STRING

The name of the label applied to the ad.

status
STRING

The status of the label applied to the ad.

attribute__backgroundColor
STRING

The background color of the label in RGB format.

name
STRING

The name of the ad group.

status
STRING

The status of the ad group.

settings

Details about the settings defined for the ad group.

If your destination doesn't natively support nested data, this data may be denested into a subtable named ad_groups__settings. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_id
INTEGER

The ID of the ad group.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

optIn
INTEGER

Indicates the Opt In setting for the Display Campaign Optimizer.

Setting.Type
STRING

Indicates that this instance is a subtype of Setting.

details

Contains details about the settings applied to the ad group, including the target and criterion group settings.

If your destination doesn't natively support nested data, this data may be denested into a subtable named ad_groups__settings__details. Refer to the Singer schema for details on possible attributes.


ad_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


adgroup_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


Replication Method: Full Table Documentation: Official Docs
Primary Key : adGroupId

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

This is a Core Object table.

adGroupId
INTEGER

The ID of the ad group containing the ad.

adGroupAdDisapprovalReasons

The list of disapproval reasons applicable to the ad.

If your destination doesn't natively support nested data, this data may be denested into a subtable named ads__adGroupAdDisapprovalReasons. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_adGroupId
INTEGER

The ID of the ad group containing the ad.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The list of disapproval reasons.

adGroupCreativeApprovalStatus
STRING

The approval status of the ad.

baseAdGroupId
INTEGER

The ID of the base ad group from which the draft/trial ad was created.

baseCampaignId
INTEGER

The ID of the base campaign from which the draft/trial ad was created.

customerId
INTEGER

The ID of the AdWords account that the record belongs to.

policySummary__combinedApprovalStatus
STRING

The approval status that combines review state and status.

policySummary__reviewState
STRING

Indicates the progress in the review process.

policySummary__denormalizedStatus
STRING

The overall review status based on the policy topic entries.

policySummary__policyTopicEntries

Summary of policy findings for the ad.

If your destination doesn't natively support nested data, this data may be denested into a subtable named ads__policySummary__policyTopicEntries. Refer to the Singer schema for details on possible attributes.

status
STRING

The status of the ad.

trademarks

The trademarked items that were found in the ad.

If your destination doesn't natively support nested data, this data may be denested into a subtable named ads__trademarks. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_adGroupId
INTEGER

The ID of the ad group containing the ad.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The trademarked items that were found in the ad.

trademarkDisapproved
INTEGER

Indicates if the ad isn’t serving because it doesn’t meet trademark policy.


age_range_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


audience_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


call_metrics_call_details_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


campaign_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


Replication Method: Full Table Documentation: Official Docs
Primary Key : id

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

This is a Core Object table.

id
INTEGER

The ID of the campaign.

adServingOptimizationStatus
STRING

The campaign’s ad serving optimization status.

advertisingChannelType
STRING

The primary serving target for ads within the campaign.

baseCampaignId
INTEGER

The ID of the base campaign of the draft or trial campaign.

conversionOptimizerEligibility__eligible
INTEGER

Indicates if the campaign is eligible to enter Conversion Optimizer.

campaignTrialType
STRING

Indicates the campaign type.

customerId
INTEGER

The ID of the AdWords account that the record belongs to.

endDate
DATE-TIME

The date the campaign ends.

frequencyCap__impressions
INTEGER

The maximum number of impressions allowed during the time range by this cap.

frequencyCap__timeUnit
STRING

The unit of time the cap is defined at.

labels

Labels attached to the campaign.

If your destination doesn't natively support nested data, this data may be denested into a subtable named campaigns__labels. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_id
INTEGER

The ID of the campaign.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
INTEGER

The ID of the label applied to the campaign.

name
STRING

The name of the label applied to the campaign.

status
STRING

The status of the label applied to the campaign.

Label.Type
STRING

Indicates that this instance is a subtype of Label.

attribute__backgroundColor
STRING

The background color of the label in RGB format.

attribute__LabelAttribute.Type
STRING

Indicates that this instance is a subtype of LabelAttribute.

attribute__description
STRING

The description of the label.

name
STRING

The name of the campaign.

networkSetting__targetGoogleSearch
INTEGER

Indicates if ads in the campaign will be served with Google.com search results.

settings__languageCode
STRING

The language code that indicates what language the domain’s content is in. For example: en signifies English.

settings__negativeGeoTargetType
STRING

The negative geotargeting setting used for the campaign.

settings__Setting.Type
STRING

Indicates that this instance is a subtype of Setting.

settings__positiveGeoTargetType
STRING

The positive geotargeting setting used for the campaign.

settings__domainName
STRING

The domain name that the setting represents. For example: google.com

startDate
DATE-TIME

The date the campaign starts.

status
STRING

The status of the campaign.


click_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


criteria_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


display_keyword_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


display_topics_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


final_url_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


gender_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


geo_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


keywordless_query_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


keywords_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


search_query_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.


video_performance_report

Replication Method: Append-Only (Incremental) Replication Key : day
Primary Key : _sdc_primary_key Documentation: Official Docs

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.

_sdc_primary_key
STRING

Applicable only if Stitch doesn’t detect a Primary Key in the source table. Stitch will use this column to de-dupe data.

day
DATE-TIME

The day the record pertains to.

_sdc_customer_id
INTEGER

The ID of the AdWords account that the record belongs to.

_sdc_report_datetime
DATE-TIME

The start time of the Stitch replication job that replicated this record.

Custom Fields

Columns (attributes/segments/metrics) selected by you. For descriptions of available columns, see Google’s documentation.



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.