Google Analytics

This document describes the Dataworkz connector configuration required to access Google Analytics. Dataworkz requires one of the following OAuth setup before proceeding with the configuration

1. OAuth

2. Service Account Outh

OAuth

You need to authorize Dataworkz to access your Google Analytics data

Service Account

In order to setup service accountOAuth follow the Setup Service Account instructions. Ensure that service account that has been created has access to the Google Analytics property.

After this goto “APIs & Services” -> “Enabled APIs & services” and enable the following.

1. Google Analytics Data API

2. Google Analytics Admin API

Create Connector for Google Analytics 4

1. Login to Dataworkz Application

2. Goto Configuration -> SaaS Applications -> Google Analytics

3. Click the + icon to add a new configuration

1. Enter name for the configuration in the above screen

2. Select the authentication option for your account (OAuth / Service Account OAuth)

OAuth

1. This requires using Google OAuth to authorize Dataworkz to access Google Analytics

2. Select the workspace & collection

3. Click Save

Service Account OAuth

1. Enter the Client ID

2. Enter the Client email ID

3. Select the certification option & type

4. Enter the Private Key ID

5. Enter the Private Key

6. Test the connection

7. If successful select the workspace & collection

8. Click Save

Newly created connector would show up in the list of Google Analytics configurations

Add Configuration

Click the newly created connector and then click + icon to add configuration for Google Analytics

1. Provide name for the dataset comprising the analytics data

2. Select the account

3. Select the property

4. Select dimensions (maximum 9). Note that date dimension is mandatory

5. Select metrics to be collected

6. Select either a date range or “all historical records”

7. Enable/disable recurring job

8. Click Add

This would complete the Dataworkz configuration for Google Analytics