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 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 Google Analytics connector can access a web property, the service account must be authorized.

Open the Google Analytics Admin in a web browser and 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 a 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.