Google Analytics 360 Setup Guide Sunset

Follow our setup guide to connect Google Analytics 360 to Fivetran.

Prerequisites

To connect your Google Analytics 360 account to Fivetran, you need:

• A Google Analytics 360 account.
• A Google Cloud Platform role with sufficient permissions to provision IAM roles for BigQuery access and Storage Object creation (such as Project Owner or Project IAM Admin roles).

Setup instructions

Find Fivetran email

In your connector setup form, make a note of the unique auto-generated email address at the bottom of the setup form (for example, g-generated-account@fivetran-production.iam.gserviceaccount.com). You will need this email to configure your source system to sync with Fivetran.

NOTE: The auto-generated email is tied to your account. If you close and re-open the setup form, the email will remain the same. You may wish to keep the tab open in the background while you configure your source for convenience.

Configure BigQuery export for GA360

Follow Google's step-by-step instructions to configure BigQuery export for Google Analytics 360.

Get your BigQuery Project ID and Dataset ID

1. Go to your projects list in your Google Cloud Console.

2. Find the Project ID of the project you created when you configured BigQuery export for GA360 in Configure BigQuery export for GA360. Make a note of the Project ID. You will need it to configure Fivetran.

   

3. Under the project, find the dataset you created. Make a note of the Dataset ID. You will need it to configure Fivetran.

Grant permissions to Fivetran

1. Navigate to your Google Cloud Platform project principals list.

2. Select + GRANT ACCESS to create a new user. The Add principals form will appear.

   

3. In the New principals field, enter the auto-generated email address you copied from your connector setup form.

   

4. Select roles for the Fivetran account. The minimum roles that Fivetran needs to function are BigQuery User, BigQuery Job User, and BigQuery Data Viewer. You must assign the Fivetran account all three roles. These roles provide permissions to:

   • Run, enumerate, and cancel our own jobs (updates).
   • Enumerate all datasets and tables within a project.

   These permissions are required for Fivetran to access Google Analytics 360 tables and create the jobs necessary to query the BigQuery tables. Use a separate project for datasets that you do not want Fivetran to be able to query.

5. Click Save.

Set up a Google Cloud Platform Bucket

You need to host a Google Cloud Platform Bucket for Fivetran to use temporarily as a staging environment while we perform your syncs. The benefit is faster sync times for large data sets, which are common in Google Analytics 360 connectors. This bucket must be in the same Google Cloud Project as your Google Analytics 360 export destination.

1. Navigate to the Google Cloud Console Storage browser.
2. On storage browser screen, select Create a Bucket.
3. Name and configure your bucket.
4. Make a note of your bucket name. You will need it to fill in your connector setup form.
5. After you create your bucket, grant Fivetran access to the bucket through the Permissions tab in the bucket details.
6. Enter the auto-generated email address you copied from the Fivetran setup form as a new member and assign it the "Storage Object Admin" role. Then click Save.

Finish Fivetran configuration

1. In the connector setup form, enter your chosen Destination schema name.
2. Enter the Project ID and Dataset ID that you found in the Get your BigQuery Project ID and Dataset ID step.
3. In the Bucket Name field, enter the name of the bucket you set up in the Set up a Google Cloud Platform Bucket step.
4. Click Save & Test. Fivetran will take it from here and sync your Google Analytics 360 data.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home