How to replicate Google Analytics to your data warehouse

Google Analytics is the most popular data source among Stitch users. Want to get started replicating GA data to your data warehouse? Let's walk through the process step by step. If you're not already using Stitch, sign up now, follow along, and start replicating Google Analytics to BigQuery, Amazon Redshift, Snowflake, or another data warehouse in less than 15 minutes.

Add Google Analytics as a Stitch data source

To add a Google Analytics integration, sign in to Stitch, then click the Add Integration button. On the next screen, scroll down and click the Google Analytics icon to configure the integration.

GA-ss-1-1

First, enter a name for the integration, which will be used to create the schema in your destination.

Next, the Sync Historical Data setting defines how far back Stitch should go to get data. By default Stitch replicates 30 days of data, but you can unclick the checkbox to specify any date you like.

Finally, Replication Frequency defines when and how often to replicate the data. The default is every six hours. If you want to customize the schedule, you can specify both an Anchor Time and Replication Frequency.

Now click the Authorize button. You should be prompted to log in to your Google account to approve Stitch's access; click Allow to continue. If you don't get the prompt, temporarily pause any pop-up or ad blockers you're using, because Google authentication uses pop-ups.

GA-ss-2

Next you'll be prompted to select the Google Analytics profile you want to connect to Stitch. The profile creating the integration must have Read & Analyze permissions; if you don't see the profile you want in the list, double-check the permission settings. You can turn to our documentation for more information.

GA-ss-3

Select Metrics and Dimensions to replicate

After you grant Stitch access to your Google Analytics profile, select the Metrics and Dimensions you want to replicate to your destination. Google allows only certain Metric/Dimension combinations, but you don't have to know all the nuances to set up your integration. Stitch does the compatibility checking for you, and will display a notification if you try to replicate an invalid combination.

GA-ss-4
When you're finished, click Save Integration.

And ... go!

That's all it takes to replicate Google Analytics data to any destination. Give it a try – you have nothing to lose, because Stitch gives you free row replication for the first seven days of a new integration. Go on and test Google Analytics integration, or any of the more than 80 data sources we support.

Image credit: Roger Marks