Follow our setup guide to connect Google Campaign Manager 360 to Fivetran.
Prerequisiteslink
To connect Google Campaign Manager 360 to Fivetran, you need a Google Campaign Manager 360 account.
Setup instructionslink
-
In your connector setup form, enter your chosen destination schema name.
-
Click Authorize to authorize the API and grant Fivetran access to your Google Campaign Manager 360 user profile.
-
Enter your chosen destination table name.
-
Choose your sync mode. If you select Sync Specific Profiles, then select the User Profiles you want to sync via 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. -
Select a Report Type. You can select only one report per connection.
-
Select Dimensions for the
STANDARD
,REACH
andFLOODLIGHT
report types.- The
date
dimension is mandatory for these report types. - The
advertiser
dimension is mandatory for theREACH
report type. - You can enable all
REACH
report dimension combinations using a toggle. If enabled, the date range of the report should be within the last 42 days.
Note: The mandatory dimensions are selected automatically right after the connector has been created.
- The
-
Select Conversion Dimensions, PerInteraction Dimensions and Floodlight Variables for the
PATH_TO_CONVERSION
report type.- The
conversionId
dimension is a mandatoryConversion
Dimensions. - The
interactionNumber
andinteractionTime
are mandatoryPerInteraction
Dimensions
NOTE: The
PATH_TO_CONVERSION
report type is in private preview. If you’d like to enable this feature on your connector, contact our support team. - The
-
Select Metrics
-
For the
FLOODLIGHT
andPATH_TO_CONVERSION
reports, select the Floodlight Configuration IDs. You can select only one Floodlight Configuration ID per account. The IDs are displayed following the formatfloodlightConfigurationId(accountId)
. -
Select how many months of reporting data you’d like to include in your initial sync.
-
Click Save & Test. Fivetran will take it from here and sync your data from your Google Campaign Manager 360 account.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration