Google Analytics

Integrator supports extracting data from the Google Analytics Reporting API.

When configuring a Google Analytics connector, you must point it to a particular web site, as defined by the web property View ID, and authorize it to use this with the web property.

What is a web property?

A web property is a collection of web sites under the same Google Analytics account.

What is a web property View ID?

A web property View ID is a unique ID given to a particular web site, for example, under a Google Analytics account.

When configuring a Google Analytics connector, you must specify a web property View ID.

You can find your web property View ID under Google Analytics Admin.

Step 1. Log in to the Google Analytics console.

Google Analytics Console

Step 2. Select the web property.

Web Property

Step 3. Click on the property name dropdown list at the top of the screen.

Look for a number on the left, below the property name. This is your web property View ID.

Google Analytics View ID

Connecting using a Google Service account

You need a service account in order to access the Google Analytics API.

Read more about using a Google Service account to connect to the Google APIs.

Authorizing a service account for a web property

Before a Google Analytics connector can access the web property, the service account must be authorized.

Open Google Analytics Admin in a web browser. Under User Management, add permission for the service account to use email.

Authorize a service account for Google Analytics

Creating Google Analytics flows

Important: before you start creating flows, you must:

  1. Get a web property View ID.
  2. Use the default service account (recommended), or create a new service account, if necessary.
  3. Authorize the service account to use the web property.

Once Steps 1 to 3, are completed you can start creating flows which can extract data from Google Analytics.

Step 1 Create a Google Analytics Connection.

Google Analytics Connection

When creating a connection, define the following properties:

Step 2 Start creating a flow by opening the Flow Builder window, clicking the + button and typing Google Analytics into the search box:

Google Analytics Flows

Step 3 Continue by defining a transformation(s) where the source (FROM) is the Google Analytics Connection created in Step 1, and the destination (TO) is either a file, database or a web service.

Google Analytics to CSV flows

Step 4 Add mapping and parameters, if needed.