Connecting your Google Analytics data to Stitch a five-step process:
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.
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.
stitch_google_analyticsin the data warehouse.
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.
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.
Before you get started, note the following:
In the Metrics and Dimensions fields, you can search or use the drop-down to explore your options:
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
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.