Google Analytics 4 Export link
Google Analytics 4 Export is an analytics service to measure traffic and engagement across websites and mobile apps.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | check | The 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 level |
Column hashing | check | |
Re-sync | check | Connector level, but not recommended because it takes a long time |
History | ||
API configurable | check | API configuration |
Priority-first sync | check | All tables |
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Google Analytics 4 Export setup guide to connect Google Analytics 4 Export with your destination using Fivetran connectors.
Sync overviewlink
Sync mode optionslink
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 modelink
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 modelink
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 modelink
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 tableslink
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 informationlink
This schema applies to all Google Analytics 4 Export connectors created before July 24, 2023.
To zoom, open the ERD in a new window.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.