Google Analytics 4 Export

Google Analytics 4 Export is an analytics service to measure traffic and engagement across websites and mobile apps.

Features

Supported deployment models

We support the SaaS Deployment model for the connector.

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:

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:

Switching sync mode

You can change the sync mode for the connection at any time in your Fivetran dashboard from Columns to JSON mode and vice versa.

To change the connection sync mode, do the following:

1. In the connection dashboard, go to the Setup tab.
2. Click Edit connection details.
3. In the connection setup form, change the Sync Mode.
4. Click Save & Test.

Syncing events from intraday tables

We sync data for intraday events.

• You must enable the Streaming export option when configuring your BigQuery Export. To learn more, see GA4's Link a GA4 property to BigQuery documentation.
• We sync intraday tables as they become available throughout the day. Once Google creates the daily table for a given date, it soft deletes the corresponding intraday table. As a result, we can't sync intraday tables for dates that already have a daily table. This applies to both incremental and historical syncs.
• To differentiate intraday events from the end-of-day events, use the is_intraday column in the EVENT table.

To learn more about intraday tables, read GA4's BigQuery Export Documentation.

Schema information

This schema applies to all Google Analytics 4 Export connections created on or after July 24, 2023.

This schema applies to all Google Analytics 4 Export connections created before July 24, 2023.