Release Status Closed Beta Availability Free
Status Page Google Adwords Status Page Default Historical Sync 30 days
Whitelist Tables/Columns Supported/Supported Default Replication Frequency 30 minutes
Full Table Endpoints 0 Incremental Endpoints 40
Destination Incompatibilities None

Connecting Google Adwords

Connecting your Google AdWords data to Stitch is a five-step process:

  1. Add Google AdWords as a Stitch data source
  2. Authorize Stitch & select Google AdWords profiles
  3. Define the Historical Sync
  4. Define the Replication Frequency
  5. Sync reports and columns

Prerequisites

Before you get started, you should verify that:

  1. The user creating the integration has access to the data you want to replicate. Stitch will only be able to see and replicate the data that that user has access to.

  2. All ad-blocking software you are currently using is paused. Because Google authentication uses pop ups, you may encounter issues if ad blockers aren’t disabled during the setup.

Add Google Adwords as a Stitch Data Source

  1. On the Stitch Dashboard page, click the Add an Integration button.
  2. Click the Google Adwords icon.

  3. Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch Google Adwords” would create a schema called stitch_google-adwords-new in the data warehouse. This schema is where all the tables for this integration will be stored.

Defining the Historical Sync

The Sync Historical Data setting will define the starting date for your Google 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 sync data beyond Google Adwords’s default setting of 30 days. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.

Define the Replication Frequency

The Replication Frequency controls how often Stitch will attempt to replicate data from your Google Adwords integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.

Before setting the Replication Frequency, note that:

  • The more often Google Adwords is set to replicate, the higher the number of replicated rows.
  • The number of rows in the source may not equal the number of rows replicated by Stitch. Tables that use Full Table Replication will result in a higher number of replicated rows.

  • Some or all of the tables in Google Adwords have an attribution window. This means that during every replication job, the past days’ worth of data will be replicated. See the Replication section below for more details.

  • If you’re using a data warehouses that doesn’t natively support nested structures, you’ll see a higher number of replicated rows due to the de-nesting Stitch performs.

To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes. For tips on reducing your row count, check out the Reducing Your Row Count section of our Billing Guide.

After selecting a Replication Frequency, click Save Integration.

Authorizing Stitch & 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 that we will only ever read your data.
  2. Click Allow to continue.
  3. After your credentials are validated, you’ll be prompted to select the Google AdWords profile you want to connect to Stitch:

    Selecting Google AdWords profiles.

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

    • You can select up to 400 profiles per Google AdWords integration. If you need to sync 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 sync any subprofiles.
  5. When finished selecting profiles, click Continue.

Syncing Reports & Columns

After the integration is saved, Stitch will direct you to the Integration Details page for the Google AdWords integration. The last step is to select the reports and columns you want to replicate.

About Google AdWords Report Replication

Before you select columns in a report to sync, note the following:

  • Once columns in a table (report) are set to sync, they cannot be changed after saving. Primary Keys for Google AdWords tables are composite keys partially composed of the columns you select. Adding or removing columns would change the Primary Key, which Stitch uses to prevent duplication of data.

    In the event that you want to add or remove columns, we recommend creating a new Google AdWords integration.

  • Some tables are synced by default and can’t be deselected. These are the accounts, ad_groups, ads, and campaigns tables.

    You can find more info about these tables in the Schema section.

Selecting Reports & Columns to Sync

  1. To sync a table, click the checkbox next to the table’s name. A green checkmark means the table is set to sync. This will open a page containing the columns in that table.

  2. In this page, select the columns you want to sync by clicking the circle icon next to the Column Name column. A green circle means the column is set to sync.

  3. Repeat this process for all the columns in the table you want to sync.

  4. When finished selecting columns for the table, click the Save and Sync button.

  5. When prompted, confirm your selection by clicking Sync Columns. Remember: once the configuration for a table is saved, it can’t be changed.

  6. Repeat this process for every table you want to replicate to your data warehouse.

Google Adwords’s Intial Sync

After you finish setting up Google Adwords, you might see its Sync Status 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 sync for the integration. This may take some time to complete.


Replicating Google Adwords Data

Every time Stitch runs a replication job for Google Adwords, the last days’ worth of data will be replicated.

This is applicable to all tables in the integration.

Stitch replicates data in this way to account for updates made to existing records within the default attribution window of days, thus ensuring you won’t make decisions based on stale (or false) data. As a result, you may see a higher number of replicated rows than what’s being generated in Google Adwords.

Setting the Replication Frequency to a higher frequency - like 30 minutes - can result in re-replicating recent data and contribute to high row counts. Syncing fewer tables or selecting a lower frequency can help prevent overages.


Google Adwords Schema

There are two types of tables in Stitch’s Google AdWords integration: default and Reports.

  • Default tables (and all the columns they contain) are set to sync by default and can’t be unsynced. These tables contain foundational data that’s useful for analysis. The default tables are the accounts, ad_groups, ads, and campaigns tables.

  • Report tables are the AdWords reports and can be individually selected for syncing. You can select individual columns for syncing, but once the table configuration has been saved, it can’t be changed.

Report Table Primary Keys

Primary Keys for Report tables are composite keys made up of the individual columns you set to sync AND a few columns automatically selected by Stitch. This will ensure that each row is uniquely identifiable.

The columns automatically selected by Stitch are noted in the Primary Key section for each Report table below.

Report Table Schemas

The schemas for Report tables are composed of the following:

  • The columns Stitch selects as part of a composite Primary Key,
  • date and customerid columns (which are explained in each Report table section), and
  • The individual columns you set to sync

Because the Primary Keys are a composite partially made up of the columns you select to sync, columns can’t be added or removed after the table’s configuration is saved. Doing so would change the table’s Primary Key and cause issues with replication.

Included Tables

Note that these tables won't automatically be created in your data warehouse. You must set them to sync in the Integration Details page first.

Stitch's Google Adwords integration includes these tables:


accounts

Replication Method: Incremental
Primary Key: customerid
Contains Nested Structures?: No

The accounts table contains high-level info about the Google AdWords account you’ve connected to Stitch. This is a default table and cannot be unsynced.

Table Info & Attributes

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

accounts Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes.

  • customerid

  • canmanageclients

  • companyname

  • currencycode

  • datetmiezone

  • name

  • testaccount

ad_groups

Replication Method: Incremental
Primary Key: id
Contains Nested Structures?: No

The ad_groups table contains detailed info about your ad groups. This is a default table and cannot be unsynced.

Table Info & Attributes

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

ad_groups Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • Ad Group ID (id)

  • baseadgroupid

  • basecampaignid

  • biddingstrategyconfiguration__biddingscheme__biddingschemetype

  • biddingstrategyconfiguration__bidddingscheme__enhancedcpcenabled

  • biddingstrategyconfiguration__biddingstrategysource

  • biddingstrategyconfiguration__biddingstrategytype

  • biddingstrategyconfiguration__bids__bid__comparablevaluetype

  • biddingstrategyconfiguration__bids__bid__microamount

  • biddingstrategyconfiguration__bids__bidstype

  • biddingstrategyconfiguration__bids__cpcbidsource

  • biddingstrategyconfiguration__bids__cpmbidsource

  • campaignid

  • campaignname

  • customerid

  • labels__attribute__backgroundcolor

  • labels__attribute__labelattributetype

  • labels__id

  • labels__labeltype

  • labels__name

  • labels__status

  • name

  • settings__details__criteriontypegroup

  • settings__details__targetall

  • settings__optin

  • settings__settingtype

  • status

ads

Replication Method: Incremental
Primary Key: id:adgroupid
Contains Nested Structures?: No

The ads table contains comprehensive info about ads in ad groups in your Google AdWords account. This is a default table and cannot be unsynced.

Table Info & Attributes

Our Google AdWords integration pulls data from a variety of endpoints to create this table:

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

ads Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes.

  • Ad ID (id)

  • adgroupid

  • adtype

  • approvalstatus

  • baseadgroupid

  • basecampaignid

  • customerid

  • description1

  • description2

  • disapprovalreasons

  • displayurl

  • finalurls

  • headline

  • image__dimensions__key

  • image__dimensions__value__height

  • image__dimensions__value__width

  • image__filesize

  • image__mediatype

  • image__mimetype

  • image__referenceid

  • image__type

  • image__urls__key

  • image__urls__value

  • name

  • status

  • templateelements__fields__fieldmedia__dimensions__key

  • templateelements__fields__fieldmedia__dimensions__value__height

  • templateelements__fields__fieldmedia__dimensions__value__width

  • templateelements__fields__fieldmedia__mediaaid

  • templateelements__fields__fieldmedia__mediatype

  • templateelements__fields__fieldmedia__mimetype

  • templateelements__fields__fieldmedia__referenceid

  • templateelements__fields__fieldmedia__sourceurl

  • templateelements__fields__fieldmedia__type

  • templateelements__fields__fieldmedia__urls__key

  • templateelements__fields__fieldmedia__urls__value

  • templateelements__fields__fieldtext

  • templateelements__fields__name

  • templateelements__fields__type

  • templateelements__uniquename

  • templateid

  • trackingurltemplate

  • trademarkdisapproved

  • trademarks

  • type

  • urls

campaigns

Replication Method: Incremental
Primary Key: id
Contains Nested Structures?: No

The campaigns table contains detailed info about your Google AdWords campaigns. This is a default table and cannot be unsynced.

Table Info & Attributes

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

campaigns Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • Campaign ID (id)

  • advertisingchanneltype

  • basecampaignid

  • biddingstrategyconfiguration__biddingscheme__bidcelling__comparablevaluetype

  • biddingstrategyconfiguration__biddingscheme__bidcelling__microamount

  • biddingstrategyconfiguration__biddingscheme__biddingschemetype

  • biddingstrategyconfiguration__bidddingscheme__enhancedcpcenabled

  • biddingstrategyconfiguration__biddingstrategytype

  • budget__amount__comparablevaluetype

  • budget__amount__microamount

  • budget__budgetid

  • budget__deliverymethod

  • budget__isexplicitlyshared

  • budget__name

  • budget__referencecount

  • budget__status

  • campaigntrialtype

  • conversionoptimizereligibility__eligible

  • conversionoptimizereligibility__rejectionreasons

  • customerid

  • enddate

  • frequencycap__impressions

  • frequencycap__level

  • frequencycap__timeunit

  • labels__attribute__backgroundcolor

  • labels__attribute__labelattributetype

  • labels__id

  • labels__labeltype

  • labels__name

  • labels__status

  • name

  • networksetting__targetcontentnetwork

  • networksetting__targetgooglesearch

  • networksetting__targetpartnersearchnetwork

  • networksetting__targetsearchnetwork

  • servingstatus

  • settings__domainname

  • settings__languagecode

  • settings__negativegeotargettype

  • settings__positivegeotargettype

  • settings__settingtype

  • startdate

  • status

account_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AccountDescriptiveName
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

account_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • accountdescriptivename

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

adgroup_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId
Contains Nested Structures?: No

The adgroup_performance_report table contains includes all statistics aggregated by default at the ad group level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

adgroup_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

ad_customizers_feed_item_report

Replication Method: Incremental
Primary Key: Columns You Select : FeedItemId
Contains Nested Structures?: No

The ad_customizers_feed_item_report table contains statistics for feed items used in Ad Customizers. Statistics are aggregated at the feed item level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

ad_customizers_feed_item_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • feeditemid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

ad_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : Id
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

ad_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

age_range_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The age_range_performance_report table contains all Display Network and YouTube Network statistics aggregated by age range. It also includes automatic audience performance.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

age_range_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

audience_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

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.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

audience_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

automatic_placements_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Domain
Contains Nested Structures?: No

The automatic_placements_performance_report table contains all statistics aggregated at the placement level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

automatic_placements_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

bid_goal_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The bid_goal_performance_report table contains statistics for your portfolio bid strategies. Standard strategies will not appear in this report's output.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

bid_goal_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

budget_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : BudgetId
Contains Nested Structures?: No

The budget_performance_report table contains all statistics aggregated by default at the budget level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

budget_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • budgetid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

campaign_ad_schedule_target_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The campaign_ad_schedule_target_report table contains performance summary info about campaigns by AdSchedule criteria.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

campaign_ad_schedule_target_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

campaign_location_target_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The campaign_location_target_report table contains performance summary info about campaigns by location-based CampaignCriterion.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

campaign_location_target_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

campaign_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : CampaignId
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

campaign_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • campaignid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

click_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : GclId
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

click_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • gclid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

creative_conversion_report

Replication Method: Incremental
Primary Key: Columns You Select : ConversionTrackerId
Contains Nested Structures?: No

The creative_conversion_report table contains info about free clicks, or interactions that take place before a clickthrough for certain ads, product extensions, and location extensions. For example: interactions like 'Get directions.' In the AdWords web interface, this is called the Free Clicks Report.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

creative_conversion_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • conversiontrackerid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

criteria_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : Id
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

criteria_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

destination_url_report

Replication Method: Incremental
Primary Key: Columns You Select : EffectiveDestinationUrl
Contains Nested Structures?: No

The destination_url_report table contains all statistics aggregated at the destination URL level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

destination_url_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • effectivedestinationurl

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

display_keyword_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : Id
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

display_keyword_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

display_topics_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

display_topics_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

final_url_report

Replication Method: Incremental
Primary Key: Columns You Select : EffectiveFinalUrl
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

final_url_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • effectivefinalurl

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

gender_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The gender_performance_report table contains statistics aggregated by gender. It also includes automatic audience performance.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

gender_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

geo_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

geo_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

keywordless_category_report

Replication Method: Incremental
Primary Key: Columns You Select : Category0 : Category1 : Category2
Contains Nested Structures?: No

The keywordless_category_report table contains keywordless ads (dynamic search ads) statistics aggregated by category.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

keywordless_category_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • category0

  • category1

  • category2

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

keywordless_query_report

Replication Method: Incremental
Primary Key: Columns You Select : CriterionId
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

keywordless_query_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • criterionid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

keywords_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : Id
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

keywords_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : CampaignId : KeywordId
Contains Nested Structures?: No

The paid_organic_query_report table contains a holistic view of your search stats across ads and organic listings at the query level. This lets you analyze strengths and gaps in your overall search presence, and gives insight into how your paid and organic search listings work together to connect your business with people searching on Google.

Table Info & Attributes

parental_status_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The parental_status_performance_report table contains statistics aggregated at the parental status level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

parental_status_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

placeholder_feed_item_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : AdId : FeedId : FeedItemId
Contains Nested Structures?: No

The placeholder_feed_item_report table contains all statistics at the feed-item level (e.g., a single sitelink).

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

placeholder_feed_item_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • adid

  • feedid

  • feeditemid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

placeholder_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : ExtensionPlaceholderCreativeId
Contains Nested Structures?: No

The placeholder_report table contains statistics for feed-based ad extensions, one row per placeholder type.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

placeholder_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • extensionplaceholdercreativeid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

placement_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The placement_performance_report table contains all statistics aggregated at the placement level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

placement_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

product_partition_report

Replication Method: Incremental
Primary Key: Columns You Select : Id
Contains Nested Structures?: No

The product_partition_report table contains shopping campaign statistics aggregated at the product partition (Id field) level. Note that results will always reflect the current set of product partitions.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

product_partition_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

search_query_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Query
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

search_query_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • query

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

shopping_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : OfferId
Contains Nested Structures?: No

The shopping_performance_report table contains shopping campaign statistics aggregated at the product (OfferId field) level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

shopping_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • offerid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

top_content_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : Id
Contains Nested Structures?: No

The top_content_performance_report table contains statistics for top content bid modifier criteria.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

top_content_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • id

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

url_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : Url : CriteriaParameters
Contains Nested Structures?: No

The url_performance_report table contains all statistics aggregated at the URL and criterion level.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

url_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • url

  • criteriaparameters

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

user_ad_distance_report

Replication Method: Incremental
Primary Key: Columns You Select : CampaignId : DistanceBucket
Contains Nested Structures?: No

The user_ad_distance_report table contains statistics aggregated by the user's distance from your location extensions.

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

user_ad_distance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • campaignid

  • distancebucket

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.

video_performance_report

Replication Method: Incremental
Primary Key: Columns You Select : AdGroupId : CampaignId : CreativeId : VideoChannelId : VideoId
Contains Nested Structures?: No

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

Table Info & Attributes

Default Columns

In addition to the specific columns you select, this table will also contain these columns:

  • date: This column indicates the day that the row corresponds to. Data is accounted for on a daily basis, meaning a single date will correspond to a single row in the table.
  • customerid: This column contains the ID of the AdWords account that the row belongs to. This column can be used to segment data in a table by account.

Replication & Attribution Windows

Every time a replication job runs for Google Adwords, the past days' worth of data will be replicated for this table. As a result, you may see a higher number of replicated rows than what's being generated in Google Adwords.

Stitch replicates data in this way to account for updates made to existing records within Google Adwords's default attribution window, thus ensuring you won't make decisions based on stale (or false) data.

video_performance_report Attributes

While we try to include everything Google Adwords has here, this may not be a full list of attributes. Refer to Google Adwords's documentation for a full list and description of each attribute.

  • adgroupid

  • campaignid

  • creativeid

  • videochannelid

  • videoid

  • date

  • customerid

  • Columns selected by you - refer to Google’s documentation (linked above) for a list of possible attributes.



Questions? Feedback?

Did this article help? If you have questions or feedback, please reach out to us.