Google Analytics

Etlworks Integrator can extract data from the Google Analytics API.

Read how to extract data from Google Analytics.

Creating a connection

To work with Google Analytics you will need to create a connection. In the Connections window click the + button and type in google analytics in the search field. Select the Google Analytics connection from the gallery.

Connection parameters

• View ID - a view ID for the web property. It can be seen in Google Analytics Admin.
• Service Account Email - a service account email must be authorized by the web property owner in Google Analytics Admin. Read about Google Service account email. The default is etl-framework@api-project-201080624425.iam.gserviceaccount.com
• Service Account - You can create your own service account in the Google API console, authorize it in Google Analytics Admin and add it to this connection. If nothing is entered in this field the default account, linked to the email etl-framework@api-project-201080624425.iam.gserviceaccount.com will be used.
• 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 a dimension is not on the list - simply type in the dimension name, for example, ga:dimension6 and click Enter. 

  enter the dimension's name exactly as in the dimensions and metrics explorer, including using the 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 a metric is not on the list - simply type in the metric name, for example, ga:metric7 and click Enter. 

  enter the metric's name exactly as in the dimensions and metrics explorer, including usage of the ga: prefix and capitalization.

• Filter - the filters query string parameter restricts the data returned from the request. Example: qa:browser==Firefox. Read more about filters. In Integrator you should not be URL-encoding filters.
• Strip ga: prefix - Google Analytics API returns fields with a qa: prefix. Example: qa:browser, qa:city, etc. If this option is enbaled the prefix will be stripted from the field's name. 
• Timeout - the request timeout in minutes. The default value is 3 minute. If request is talking longer than configured or default value it will be automatically aborted.
• Number of Retries - number of retries if the HTTP call was not successful. The maximum allowed number of retries is 10. The default is 0.
• Delay between retries - delay in milliseconds between retries if the HTTP call was not successful. The maximum allowed delay is 5 minutes (300000 milliseconds). The default is 0.