Google Analytics 4
Connect Google Analytics 4 to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.
Connect Google Analytics 4
- Open the catalogue. In the console, go to Data · Connections and press New connection.
- Choose Google Analytics 4. It is listed under marketing and analytics; you can also search for it by name.
- Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
- Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
- Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.
Configuration fields
What the connection form asks for. Required fields are marked; the rest are optional.
| Field | Type | Required | Description |
|---|---|---|---|
| Credentials | one of 2 options | No | Credentials for the service. |
| Property IDs | array | Yes | A list of your Property IDs. The Property ID is a unique number assigned to each property in Google Analytics, found in your GA4 property URL. This ID allows the connector to track the specific events associated with your property. |
| One Stream per Report | boolean | No | When enabled, each report produces one stream containing data from all configured properties, distinguished by the property_id field. These streams take a Consolidated suffix (for example, devicesConsolidated) and replace the per-property streams. Default false. |
| Start Date | string | No | 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. Not applied to custom Cohort reports. |
| End Date | string | No | The end date from which to replicate report data in the format YYYY-MM-DD. Data generated after this date will not be included in the report. Not applied to custom Cohort reports. When no date is provided or the date is in the future, the date from today is used. |
| Custom Reports | array | No | You can add your Custom Analytics report by creating one. |
| Data Request Interval (Days) | integer | No | The interval in days for each data request made to the Google Analytics API. A larger value speeds up data sync, but increases the chance of data sampling, which may result in inaccuracies. We recommend a value of 1 to minimize sampling, unless speed is an absolute priority over accuracy. Acceptable values range from 1 to 364. Does not apply to custom Cohort reports. Default 1. |
| Lookback window (Days) | integer | No | Since attribution changes after the event date, and Google Analytics has a data processing latency, we should specify how many days in the past we should refresh the data in every run. So if you set it at 5 days, in every sync it will fetch the last bookmark date minus 5 days. Default 2. |
| Keep Empty Rows | boolean | No | If false, each row with all metrics equal to 0 will not be returned. If true, these rows will be returned if they are not separately removed by a filter. Default false. |
Convert conversions:* Metrics to Float |
boolean | No | Enables conversion of conversions:* event metrics from integers to floats. This is beneficial for preventing data rounding when the API returns float values for any conversions:* fields. Default false. |
| Subscription Plan/Tier | string | No | Quota tier of the Google Analytics 4 properties being queried. Determines the per-property rate-limit policy applied locally once the tier-aware rate-limit budget is activated. Select "Analytics 360 Property" only if all configured property IDs belong to an Analytics 360 subscription. See https://developers.google.com/analytics/devguides/reporting/data/v1/quotas. One of Standard Property, Analytics 360 Property. Default Standard Property. |
Credentials
Credentials for the service.
Choose one of the following. Each asks for its own fields.
Authenticate via Google (Oauth)
| Field | Type | Required | Description |
|---|---|---|---|
| Client ID | string | Yes | The Client ID of your Google Analytics developer application. |
| Client Secret | string, secret | Yes | The Client Secret of your Google Analytics developer application. |
| Refresh Token | string, secret | Yes | The token for obtaining a new access token. |
| Access Token | string, secret | No | Access Token for making authenticated requests. |
Service Account Key Authentication
| Field | Type | Required | Description |
|---|---|---|---|
| Service Account JSON Key | string, secret | Yes | The JSON key linked to the service account used for authorization. |
Related
Something unclear or out of date? Tell us, and we will fix the page.