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

Begin Fivetran configuration

1. In your connector setup form, enter the Destination schema name of your choice.

2. Enter your chosen Destination table name.

3. Click Authorize and log in to your Google account. Click Allow to enable Fivetran access to your Google Campaign Manager 360 user profiles.

4. 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.

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

5. 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

1. Select a Report Type to sync. You can select only one report per connection.

2. 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).
   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).

NOTE: The mandatory dimensions are selected automatically as you select a report type.

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

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home