# Google Analytics (AdWords) Information note **Google Analytics (AdWords) (v15-10-2015) end of life** This version of Google Analytics (AdWords) reached end of life on **December 4, 2017** and is no longer functioning. [Upgrade to the latest version (v05-12-2017) to continue replicating data.](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-adwords) ## Google Analytics (AdWords) feature snapshot A high-level look at Stitch's Google Analytics (AdWords) (v15-10-2015) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Sunset on December 4, 2017 | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Remove icon

This version of the integration isn't available via the API.


Not available | | **Singer GitHub repository** | Not applicable | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Remove icon

Anchor Scheduling is not supported for this integration. The only available replication scheduling method is the Replication Frequency setting.


Unsupported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Remove icon

Advanced Scheduling is not supported for this integration.


Unsupported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.


Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.


Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Remove icon

Table selection is not supported for this integration. All available table and fields will be automatically selected for replication.


Unsupported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Remove icon

Column selection is not supported for this integration. All available columns in tables set to replicate will be selected.


Unsupported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Remove icon

As this integration doesn't support table or column selection, all available tables and columns are automatically replicated.


Unsupported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Remove icon

This feature is not supported for this version of the integration.


Unsupported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.


Supported | ## Google Analytics (AdWords) replication ### Google Analytics (AdWords) Replication and Attribution Windows Every time Stitch runs a replication job for Google Analytics (AdWords), the last 15 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 15 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 Analytics (AdWords)**. Setting the Replication Frequency to a higher frequency - like 30 minutes - can result in re-replicating recent data and contribute to greater row usage. Selecting a lower frequency can help keep your row count low. ## Google Analytics (AdWords) table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 15-10-2015** of this integration. After the first successful sync of your Google Analytics (AdWords) data, you’ll see two tables in your destination. These tables follow this naming convention: `adwords[GA profile id]_integration version` For example: `adwords123456789_v2`. In this case, the profile ID is `123456789` and the version of the AdWords integration is `2`. In the section below, you’ll find a list of the attributes in these tables, a brief description, and links to Google’s more in-depth documentation. ### Campaign Names and Primary Keys Stitch’s Google Analytics (AdWords) integration uses the campaign name (`campaign`) as part of the Primary Key for both the `adwords` and `campaign` tables. Because of this, **changing campaign names may lead to data discrepancies**. To account for the name change and resolve any data discrepancies, take the following steps: 1. **Delete the affected AdWords data from your destination**. Feel free to delete the data back to the date of the earliest campaign which was renamed. 2. **Re-replicate your AdWords data by [following these instructions](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys#after-the-initial-setup)**, setting the start date back to the date of the earliest campaign which was renamed. This will reset the integration’s Replication Keys and re-replicate all data back to the integration’s defined Start Date. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### adwords The `adwords` table contains daily info about each of your active campaigns and the ads contained within those campaigns. **Note**: Google AdWords data is paginated on a daily basis. This means that a single row in each of the tables pertains to a single day. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | adwordsCampaignId

adGroup

adDestinationUrl

adContent

campaign

date

keyword | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | adwords table schema | **accountId**


DIMENSION | | --- | | **adClicks**


METRIC | | **adContent**


DIMENSION | | **adCost**


METRIC | | **adDestinationUrl**


DIMENSION | | **adGroup**


DIMENSION | | **adwordsCampaignId**


DIMENSION | | **campaign**


DIMENSION | | **date**


DIMENSION | | **impressions**


METRIC | | **keyword**


DIMENSION | | **profileId**


DIMENSION | | **profileName**


DIMENSION | ### campaigns The `campaigns` table contains daily info about your AdWords campaigns. **Note**: Google AdWords data is paginated on a daily basis. This means that a single row in each of the tables pertains to a single day. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | campaign

adwordsCampaignId

date | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | campaigns table schema | **accountId**


DIMENSION | | --- | | **adClicks**


METRIC | | **adCost**


METRIC | | **adwordsCampaignId**


DIMENSION | | **campaign**


DIMENSION | | **date**


DIMENSION | | **impressions**


METRIC | | **profileId**


DIMENSION | | **profileName**


DIMENSION | ## Google Analytics (AdWords) & (not set) Values According to [Google’s documentation](https://support.google.com/analytics/answer/2820717): > `(not set)` is a placeholder name that Analytics uses when it hasn’t received any information for a dimension. In general, if `(not set)` appears in your Google AdWords reports, it means that the property being tracked in the Analytics account is receiving traffic from an AdWords account that isn’t linked to the reporting view. Follow the tips in [the AdWords section of this Google article](https://support.google.com/analytics/answer/2820717) to troubleshoot and resolve the issue.