Follow our setup guide to connect Campaign Manager to Fivetran.
To connect Campaign Manager to Fivetran, you need a Campaign Manager account.
In your connector setup form, enter your chosen destination schema name.
Click Authorize to authorize the API and grant Fivetran access to your Campaign Manager user profile.
Enter your chosen destination table name.
Choose your sync mode. If you select Sync Specific Accounts, then select the User Profiles you want to sync via Fivetran.
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 Campaign Manager account.