Google Campaign Manager 360 Setup guide link
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 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.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. - If the
keyword
dimension is selected, Fivetran syncs report data for the last 31 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
- 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' worth 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 articleslink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration