About Google Analytics
Etlworks 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 URL or web property View ID, and authorize it to use the web property.
Connecting to Google Analytics
A web property is a collection of web sites under the same Google Analytics account.
When configuring a Google Analytics connector, you must specify either a web property URL or a web property View ID.
Web property View ID and Web property URL are mutually exclusive.
Web property URL
The URL of the web property as entered in the Google Analytics console, for example, www.etlworks.com.
Web property View ID
A web property View ID is a unique ID given to a particular web site, for example, etlworks.com, under a Google Analytics account.
You can find your web property View ID under Google Analytics Admin.
Step 1. Log in to the Google Analytics console.
Step 2. Select the 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.
To connect to the Google service using OAuth2 protocol you will need to select OAuth2 as an Authentication type and click Sign in with Google. Read more about OAuth2 authentication with Google Services.
Authentication using Google Service account
To connect to the Google service using the service account select the Service Account as an Authentication type. The service account must be authorized to access the web property.
Open Google Analytics Admin in a web browser. Under User Management, add permission for the service account to use email.
- If you use the default service account (recommended) enter
firstname.lastname@example.org the email address.
- if you use a service account you've created - use the corresponding email address.
Creating a Google Analytics connection
Read how to create a Google Analytics connection.