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 Analytics

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

  1. Verify your Google Analytics permissions
  2. Add Google Analytics as a Stitch data source
  3. Define the Replication Frequency
  4. Select a Google Analytics profile to track
  5. Select Metrics and Dimensions

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

To access your Google Analytics data, Stitch requires at least Read & Analyze permissions. Verify that the Google Analytics profile you want to connect has these permissions before continuing.

If the profile you use to connect doesn’t have these permissions (or there’s no data in the account), you’ll receive an error message along the lines of:

“Something went wrong. None of the Google Analytics profiles associated with the credentials you’ve supplied contain data that Stitch can access. Please make sure that the credentials you’ve supplied have appropriate access.”

If you receive this error, check the permissions of your Google Analytics profile and that there’s data in the account before reaching out to support.

Adding Google Analytics as a Stitch Data Source

  1. From the Stitch Dashboard page, click the Add an Integration button.
  2. Click the Google Analytics icon.
  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 Analytics” would create a schema called stitch_google_analytics in the data warehouse.

Defining the Replication Frequency

The Replication Frequency setting determines how often Stitch will attempt to replicate data from Google Analytics. 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.

Replication Frequency & Attribution Windows
While our Google Analytics integration uses Incremental Replication, the last 15 days' worth of data will be replicated every time a replication job runs. This is to account for any updates that may have occurred to existing rows during Google Analytics' 15 day attribution window and includes both updated and not-updated data.

Setting the Replication Frequency to a higher frequency - like 30 minutes - can result in re-replicating recent data and contribute to high row counts. We recommend keeping the 15 day attribution window in mind when setting the Replication Frequency.

When finished, click the Authorize button. This will start the Google authentication process.

Authorizing Stitch & Selecting a Google Analytics Profile

  1. Next, you’ll be directed to Google to approve Stitch’s access to your Google Analytics 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 Analytics profile you want to connect to Stitch.

    Remember: profiles need to have Read & Analyze permissions to be detected by Stitch. If you don’t see the profile you want in this list, we recommend that you double-check the permission settings.
  4. When finished, click the Continue button.

Selecting Metrics & Dimensions

Now that you’ve granted access to Stitch, you can select the specific Metrics and Dimensions you want to replicate to your data warehouse.

Note that Segments and Filters are currently not supported. If you’re interested in these features, please reach out to us.

Important!
Before you get started, note the following:

  • The combination of selected Metrics and Dimensions cannot be changed after you save the integration.
    Because Primary Keys for Google Analytics are composite keys made up of the Dimensions you select, adding or removing anything will change the Primary Keys.
  • You can specify a maximum of seven dimensions in a report.
  • Use the Google AdWords integration to track AdWords data.
    While AdWords Metrics and Dimensions are options listed in the drop-downs, we don’t recommend using the Google Analytics integration to create these reports.

In the Metrics and Dimensions fields, you can search or use the drop-down to explore your options:


Adding Custom Metrics & Dimensions

If you want to add custom Metrics or Dimensions, you need to type out the name exactly in its entirety. If you try to search for it and add a Metric/Dimension that looks like this - ga:customMetricXX - you’ll run into issues.

For example: let’s say you want to add custom metric 10 to the Metric list. To add it, you would type ga:metric10 in the Choose Metrics field like this:

In short, don’t add Metrics or Dimensions that contain XX. These should always be typed out in full and contain a number instead of XX.

Metric/Dimension Compatibility

As you add Metrics and Dimensions, Stitch will check for compatibility and inform you if there are any conflicts. For example: the ga:organicSearches Metric and the ga:goalCompletionLocation Dimension are incompatible. When an incompatible combination is entered into Stitch, you’ll receive an error. The integration cannot be saved until the combo is corrected.

To explore compatible combos, check out Google’s Dimensions & Metrics Explorer. We recommend creating different Google Analytics integrations for different reports to ensure you don’t run into compatibility issues.

Remember: the combination of Metrics/Dimensions you’ve selected can’t be changed after you save! Be sure to double-check your work before proceeding.

When you're finished, click the Save Integration button. 

Now you can sit back and relax while Stitch replicates your Google Analytics 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!