Google Analytics 4 Setup Guide
Follow our setup guide to connect Google Analytics 4 to Fivetran.
Prerequisites
To connect Google Analytics 4 to Fivetran, you need a Google user account with permissions to access Google Analytics accounts with Google Analytics 4 properties you'd like to sync.
IMPORTANT: You must use a Google Analytics 4 property.
Setup instructions
Begin Fivetran configuration
- In the connector setup form, enter your chosen Destination schema name.
- Click Authorize with Google and log in to your Google Analytics account. Click Continue and then Allow to enable Fivetran access to your Google account.
- In the Historical Sync Time Frame drop-down menu, select how many months' worth of reporting data you'd like to include in your initial sync.
- Choose your Accounts sync mode:
- Select Sync All Accounts to automatically sync all accounts you have access to.
- Select Sync Specific Accounts to sync specific accounts only. Use the + Accounts link to add accounts and properties you'd like to sync.
(Optional) Add Custom report
Click + Custom report.
Enter a Report name. It must be unique within this connector and must comply with Fivetran's naming conventions.
NOTE: Give the table a name you will find easy to identify with the report in the future. When you want to enable or disable the sync for a particular report once it is set up, you will do so by selecting its table in the connector's Schema tab.
(optional) Select a time aggregation for the report.
NOTE: Each aggregation option requires the corresponding date dimension to be selected in the report dimensions:
- date for Daily
- yearWeek or isoYearIsoWeek for Weekly
- yearMonth for Monthly
- year or isoYear for Yearly
(Optional) Set the Show Advanced Options toggle to ON if you want to customize reports by the selected parameters.
(Optional) To filter the Custom report by dimension, do the following:
- In the Filter type field, select whether to filter by including or excluding records.
- In the Filter field name field, enter the exact name of the dimension that you want to filter on.
- In the Filter value field, enter the dimension value. Records with the specified dimension value will be included if you select Include records or excluded if you select Exclude records.
IMPORTANT: Filtering is only enabled when all filter parameters are specified.
(Optional) In the Rollback window field, enter a value between 2 and 90 (default value is 30) days.
NOTE: To learn more, read our Google Analytics 4 Rollback Sync documentation.
Click Next.
Select the Report template name to automatically populate dimensions and metrics with pre-defined values.
To customize the set of fields populated from the selected template, do either of the following:
- Start typing the dimension's or metric's name in the search field to find it by name, and select it by checking the box.
- Select the category name on the left panel to see the relevant dimensions and metrics for that category displayed on the right, and select them by checking the box.
IMPORTANT: See the Google Analytics 4 API documentation to learn about the specific dimensions and metrics that are supported.
Click Save.
TIP: Repeat the steps above if you want to add another Custom report.
(Optional) Once you have finished adding custom reports, click Validate custom reports. The test verifies the reports' settings.
Finish Fivetran configuration
Click Save & Test. Fivetran will take it from here and sync your data from your Google Analytics account.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration