Follow our setup guide to connect Google Campaign Manager 360 to Fivetran.
To connect Google Campaign Manager 360 to Fivetran, you need a Google Campaign Manager 360 account.
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_idcolumn 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
datedimension is mandatory for these report types.
advertiserdimension is mandatory for the
- You can enable all
REACHreport 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.
Select Conversion Dimensions, PerInteraction Dimensions and Floodlight Variables for the
conversionIddimension is a mandatory
PATH_TO_CONVERSIONreport type is in private preview. If you’d like to enable this feature on your connector, contact our support team.
PATH_TO_CONVERSIONreports, select the Floodlight Configuration IDs. You can select only one Floodlight Configuration ID per account. The IDs are displayed following the format
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.