Google analytics data api
Prerequisites
- JSON credentials for the service account that has access to Google Analytics. For more details check instructions
- OAuth 2.0 credentials for the service account that has access to Google Analytics
- Property ID
Setting up the Google analytics data api connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Credentials | Yes | Credentials for the service Refer to the documentation in the form while using the connector Authenticate via Google (Oauth)Service Account Key Authentication | |
| 2 | Property ID | Yes | A Google Analytics GA4 property identifier whose events are tracked. Specified in the URL path and not the body | |
| 3 | Start Date | Yes | The start date from which to replicate report data in the format YYYY-MM-DD. Data generated before this date will not be included in the report. | |
| 4 | Custom Reports | No | A JSON array describing the custom reports you want to sync from Google Analytics. See the docs for more information about the exact format you can use to fill out this field. | |
| 5 | Data request time increment in days | No | 30 60 90 120 200 364 | The time increment used by the connector when requesting data from the Google Analytics API. More information is available in the the docs. The bigger this value is, the faster the sync will be, but the more likely that sampling will be applied to your data, potentially causing inaccuracies in the returned results. We recommend setting this to 1 unless you have a hard requirement to make the sync faster at the expense of accuracy. The minimum allowed value for this field is 1, and the maximum is 364. |
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.