Google Analytics

Integrator natively supports Google Analytics reporting API.

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

What is a web property?

Web property is a collections of web sites under the same Google Analytics account.

What is a web property View ID?

Web property View ID is a unique id of the particular web site, for example, under Google Analytics account.

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

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

Step 1 - login into Google Analytics console.

Google Analytics Console

Step 2 - select web property.

Web Property

Step 3 - click on a property name drop down on the top of the screen.

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

Google Analytics View ID

Connecting using Google Service account

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

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

Authorizing service account for the web property.

Before Google Analytics connectorcase-studies-connecting-to-google-apis can access the web property, the service account must be authorized.

Open Google Analytics Admin in a web browser and under User Management add permission for service account email.

Authorize 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 default service account (recommended), or create a new service account if needed.
  3. Authorize service account for the web property.

Once 1-3 are completed you can start creating flows which extract data from the Google Analytics.

Step 1 Create Google Analytics Connection.

Google Analytics Connection

When creating a connection, define the following properties:

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

Google Analytics Flows

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

Google Analytics to CSV flows

Step 4 Add mapping and parameters if needed.