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 google.com, 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.
Step 2 - select 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.
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.
- If you use default service account (recommended) enter
email@example.com email address.
- if you use service account created by you - use corresponding email address.
Creating Google Analytics flows
Important: before you start creating flows you must:
- Get a web property View ID.
- Use default service account (recommended), or create a new service account if needed.
- 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.
When creating a connection, define the following properties:
- Vied ID - a view ID of the web property.
- Service Account Email - service account email.
- Service Account -
important:keep it blank if you use default service account. Otherwise, copy and paste content of the json file downloaded in a step 8, when you created a new service account.
- Start Date - A start date for the request, formatted as YYYY-MM-DD, or as a relative date (e.g., today, yesterday, or NdaysAgo where N is a positive integer).
- End Date - An end date for the request, formatted as YYYY-MM-DD, or as a relative date (e.g., today, yesterday, or NdaysAgo where N is a positive integer).
- Dimensions - Google Analytics dimensions to be included in the report. You can include multiple dimensions in the request. Read more about the dimensions here. If dimension is not in a list - simply type in dimension name, for example
Note:enter dimension's name exactly as in the dimensions and metrics explorer, including
ga:prefix and capitalization.
- Metrics - Google Analytics metrics to be included in the report. You can include multiple metrics in the request. Read more about the metrics here. If metric is not in a list - simply type in metric name, for example
Note:enter metric's name exactly as in the dimensions and metrics explorer, including
ga:prefix and capitalization.
Step 2 Start creating a flow by opening Flow Builder window, clicking the
+ button and typing in
Google Analytics in the search box:
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.