Google Analytics 360 To Amazon Redshift, Spectrum Or Athena: Avoid Risky Integration Legwork With Our Immediate, Friendly And Modern Solution
The following describes the steps and inputs needed to configure a Google Analytics 360 to a destination data warehouse located at Amazon. Currently we support delivery of data to Amazon Redshift, Amazon Athena or Redshift Spectrum.
Not only is the process simple, but the data we pull from Google Analytics 360 is the most comprehensive integration to Amazon cloud services currently available. Our data definition document details exactly what we are loading into your Amazon data warehouse.
Lets get started!
Getting Started: Prerequisites
The guide assumes you have an Openbridge account and have setup a data warehouse location. Once you are ready we will show you how easy it is to load your Google Analytics 360 data to a destination warehouse.
Step 1: Visit the Data Pipeline — Batch Product Page
The first step is to visit our Google Analytics 360 product page. If you don’t have an Openbridge account, you will need to create one. It takes about 20 seconds to set one up!
Select the “Order” button to continue
Step 2: Setup Authorization
The next step is either (A) using an existing authorized account or (B) creating a new one (see below).
This authorization allow us to connect to your Google Analytics 360 account on BigQuery. Before you go through this step make sure your user has the correct authorization to the GA 360 data in BigQuery before proceeding:
With authorization complete, select your account and continue.
Step 3: Configuration
Provide your connection a label (A). This helps you identify this particular integration in the future.
Next, select (B) the project that holds your GA 360 data. Please note that we will list all available projects even if some do not have GA 360 data resident within them. If you select the wrong one, simply edit the selection as needed.
After selecting your project we will display the datasets associated with the Project (see below).
Typically the GA 360 data will be resident in a dataset called “ga_sessions*”. This is the one you will most likely want to select. However, if you have a custom GA 360 dataset name, select the one that contains your GA data.
Lastly, select the target data warehouse under “storage group” (see below). In the example below the only data warehouse listed in Redshift. You may have multiple warehouses registered in our system. We will route the GA 360 data to the warehouse you select here.
Once you select “PAY AND LAUNCH” you are done! Congrats, your Google Analytics 360 data will now be delivered to Redshift, Redshift Spectrum or Athena.
References
Looking for a manual way to process GA 360 to Redshift? Check out our open source tool:
Here are a few other GA articles we have written:
Did we miss anything? Feel free to leave a comment, we always want to hear how other companies solve data access challenges.
Get started with Openbridge by signing up for a simple, no cost account. If you have any questions about using Google Analytics 360, we are here to help. Reach out to hello@openbridge.com.
