Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Connecting Google AdWords (NEW)

We’re currently doing some private testing on our new Google AdWords integration. Want to be a part of it? Get in touch with us.

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

  1. Verify your permission settings
  2. Authenticate with Google
  3. Select Google AdWords profiles
  4. Define the Replication Frequency
  5. Select reports and columns to replicate

Important!

Before you get started, pause any ad-blocking software you are currently using. Because Google authentication uses pop ups, you may encounter issues if ad blockers aren't disabled during the setup.

Verifying Your Google Analytics Permissions

Before you get started, verify that the user credentials you’ll use to complete the setup has access to the data you want to replicate. Stitch will only be able to see and replicate the data that those credentials have access to.

Authenticating with Google

  1. From the Stitch Dashboard page, click the Add an Integration button.
  2. Click the Google AdWords icon. This will open the Google AdWords credentials page.
  3. 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 data warehouse.

    For example, the name “Stitch Google AdWords” would create a schema called stitch_google_adwords in the data warehouse.
  4. Click the Authorize button.
  5. Next, you’ll be directed to Google to approve Stitch’s access to your Google AdWords data. Note that we will only ever read your data.
  6. Click Allow to continue.

Selecting Google AdWords Profiles

After your credentials are validated, you’ll be prompted to select the Google AdWords profile you want to connect to Stitch.

When finished, click the Continue button.

Defining the Replication Frequency

The Replication Frequency setting determines how often Stitch will attempt to replicate data from Google AdWords. By default this is set to 30 minutes, but you can change the interval to better suit your needs.

You can also update this setting at any time in the Integration Settings page.

When finished, click the Create Integration button.

Selecting Reports and Columns to Replicate

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.

If you want some guidance in selecting reports and columns, check out the Google AdWords Report Types documentation.

Important!
Before you select columns to sync, note the following:

  • Once columns in a table (report) are set to sync, they cannot be changed. Primary Keys for AdWords tables are composite keys partially composed of the columns you select. Since adding or removing columns would change the Primary Key, this configuration can’t be changed once saved. You can learn more about AdWords Primary Keys in the Expected Google AdWords doc.

    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 Expected Google AdWords Data doc.

To sync a table, click the icon next to the Sync Status column. This will open a page containing the columns in the table.

Click the grey circle icon next to the column(s) you want to sync. When a column is set to sync, the icon will turn green:

When you’re finished selecting columns to sync, click the Save and Sync button. You’ll be asked to confirm your column selection. Remember: once the configuration for a report (table) is saved, it can’t be changed!

If you’re certain you have the exact configuration you want, click the Sync Columns button.

Repeat this process for every report (table) you want to replicate to your data warehouse. When you're done, you can sit back and relax while Stitch replicates your AdWords data to your data warehouse.

Related

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!