Google Analytics 4 Export
Google Analytics 4 Export is an analytics service to measure traffic and engagement across websites and mobile apps.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
History mode | ||
Custom data | check | event_param and user_property data supports both the Column sync mode and the JSON sync mode as per our Sync Mode Options documentation |
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | check | |
Fivetran data models | ||
Private networking | ||
Authorization via API | check |
Setup guide
Follow our step-by-step Google Analytics 4 Export setup guide to connect Google Analytics 4 Export with your destination using Fivetran connectors.
Sync overview
Sync mode options
Sync mode determines how Fivetran delivers your Google Analytics 4 Export event parameters and user properties data into the destination. There are two sync modes - Columns and JSON.
Columns mode
This is the default sync mode. In the Columns mode, we unwrap event params and user properties into individual columns in the EVENT
table.
For example, if the event data in the source is:
{
"event_params": [
{
"key": "campaign",
"value": {
"string_value": "organic"
}
},
{
"key": "entrances",
"value": {
"int_value": "1"
}
}
],
"user_properties": [
{
"key": "user_type",
"value": {
"string_value": "new"
}
},
{
"key": "device_type",
"value": {
"string_value": "mobile"
}
}
]
}
The corresponding columns in the destination EVENT
table would be:
param_campaign | param_entrances | user_property_user_type | user_property_device_type |
---|---|---|---|
organic | 1 | new | mobile |
JSON mode
In the JSON mode, we sync event parameters and user properties as JSON columns to the EVENT
table.
For example, if the event data in the source is:
{
"event_params": [
{
"key": "campaign",
"value": {
"string_value": "organic"
}
},
{
"key": "entrances",
"value": {
"int_value": "1"
}
}
],
"user_properties": [
{
"key": "user_type",
"value": {
"string_value": "new"
}
},
{
"key": "device_type",
"value": {
"string_value": "mobile"
}
}
]
}
The corresponding columns in the destination EVENT
table would be:
params | user_properties |
---|---|
{"campaign":"google","entrances":"1"} | {"user_type":"new","device_type":"mobile"} |
Switching sync mode
You can change the sync mode for the connector at any time in your Fivetran dashboard from Columns to JSON mode and vice versa.
IMPORTANT: We automatically perform a full re-sync of the connector when you change the sync mode.
To change the connector sync mode, do the following:
- In the connector dashboard, go to the Setup tab.
- Click Edit connection details.
- In the connector setup form, change the Sync Mode.
- Click Save & Test.
Syncing events from intraday tables
We sync data for intraday events.
- We sync events from intraday tables throughout the day. Whereas, we sync daily tables at the end of the day.
- To differentiate the intraday events from the end-of-day events, you can filter the
is_intraday
column in theEVENT
table.
To learn more about intraday tables, read GA4's BigQuery Export Documentation
Schema information
This schema applies to all Google Analytics 4 Export connectors created on or after July 24, 2023.
To zoom, open the ERD in a new window.This schema applies to all Google Analytics 4 Export connectors created before July 24, 2023.
To zoom, open the ERD in a new window.