Google Campaign Manager 360 Setup guide

Follow our setup guide to connect Google Campaign Manager 360 to Fivetran.

Prerequisites

To connect Google Campaign Manager 360 to Fivetran, you need a Google Campaign Manager 360 account.

Setup instructions

Connections created after Aug 11, 2025

Begin Fivetran configuration

In your connection setup form, enter the Destination schema name of your choice.
Click Authorize and log in to your Google account. Click Allow to enable Fivetran access to your Google Campaign Manager 360 user profiles.
Choose your sync mode:
- Select Sync All Profiles to sync all profiles.
- Select Sync Specific Profiles, to sync specific profiles only. Under User Profiles, select at least one profile you want to sync using Fivetran.
  If you choose to sync more than one profile associated with the same Campaign Manager account, you may find nearly duplicate records in the synced data. You can use the profile_id column that stores profile identity values to distinguish between these records.
In the Historical Sync Time Frame drop-down, select how many months' worth of reporting data you'd like to include in your initial sync.

(Optional) Add report

Enter a Destination table. It must be unique within this connection and must comply with Fivetran's naming conventions. Give the table a name you will find easy to identify with the report in the future. When you want to enable or disable a particular report once it is set up, you can do so by selecting its table in the connection's Schema tab.
Select a Report Type to sync. You can select multiple reports per connection.
Configure the report. Options vary depending on the report type:
Configure STANDARD report
1. Select Dimensions. A timeline granularity dimension (date, week, or month) is mandatory for the STANDARD report type.
2. Select Metrics.
Configure REACH report
1. Set the Dimension Combination toggle to On to enable all REACH report dimension combinations. If enabled, the date range of the report should be within the last 42 days.
2. Select Dimensions. A timeline granularity (date, week, or month) and advertiser dimensions are mandatory for the REACH report type.
3. Select Metrics.
Configure FLOODLIGHT report
1. Select Dimensions. A timeline granularity dimension (date, week, or month) is mandatory for the FLOODLIGHT report type.
2. Select Metrics.
3. Select the Floodlight Configuration IDs. You can select only one Floodlight Configuration ID per account. The IDs are displayed following the format floodlightConfigurationId(accountId). We sync report data for selected Floodlight Configuration IDs.
Configure PATH_TO_CONVERSION report
1. Select Conversion Dimensions. The conversionId dimension is mandatory for the PATH_TO_CONVERSION report type.
2. Select Per Interaction Dimensions. The interactionNumber and interactionTime are mandatory per interaction dimensions.
3. Select Floodlight Variables.
4. Select Metrics.
5. Select the Floodlight Configuration IDs. You can select only one Floodlight Configuration ID per account. The IDs are displayed following the format floodlightConfigurationId(accountId). We sync report data for the selected Floodlight Configuration IDs.

If the keyword dimension is selected, Fivetran syncs report data for the last 31 days.

Finish Fivetran configuration

Click Save & Test. Fivetran will take it from here and sync your data from your Google Campaign Manager 360 account.

Connections created before Aug 11, 2025

Begin Fivetran configuration

In your connection setup form, enter the Destination schema name of your choice.
Enter your chosen Destination table name.
Click Authorize and log in to your Google account. Click Allow to enable Fivetran access to your Google Campaign Manager 360 user profiles.
Choose your sync mode:
- Select Sync All Profiles to sync all profiles.
- Select Sync Specific Profiles, to sync specific profiles only. Under User Profiles, select at least one profile you want to sync using Fivetran.
If you choose to sync more than one profile associated with the same Campaign Manager account, you may find nearly duplicate records in the synced data. You can use the profile_id column that stores profile identity values to distinguish between these records.
In the Historical Sync Time Frame drop-down, select how many months' worth of reporting data you'd like to include in your initial sync.

Configure report

Select a Report Type to sync. You can select only one report per connection.
Configure the report. Options vary depending on the report type:
Configure STANDARD report
1. Select Dimensions. A timeline granularity dimension (date, week, or month) is mandatory for the STANDARD report type.
2. Select Metrics.
Configure REACH report
1. Set the Dimension Combination toggle to On to enable all REACH report dimension combinations. If enabled, the date range of the report should be within the last 42 days.
2. Select Dimensions. A timeline granularity (date, week, or month) and advertiser dimensions are mandatory for the REACH report type.
3. Select Metrics.
Configure FLOODLIGHT report
1. Select Dimensions. A timeline granularity dimension (date, week, or month) is mandatory for the FLOODLIGHT report type.
2. Select Metrics.
3. Select the Floodlight Configuration IDs. You can select several Floodlight Configuration IDs per account. We display these IDs following the format floodlightConfigurationId(accountId).
Configure PATH_TO_CONVERSION report
1. Select Conversion Dimensions. The conversionId dimension is mandatory for the PATH_TO_CONVERSION report type.
2. Select Per Interaction Dimensions. The interactionNumber and interactionTime are mandatory per interaction dimensions.
3. Select Floodlight Variables.
4. Select Metrics.
5. Select the Floodlight Configuration IDs. You can select several Floodlight Configuration IDs per account. We display these IDs following the format floodlightConfigurationId(accountId).