Google Analytics 4 Export

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

Features

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 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:

1. In the connector dashboard, go to the Setup tab.
2. Click Edit connection details.
3. In the connector setup form, change the Sync Mode.
4. 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 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 connectors created on or after July 24, 2023.

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