AdRoll Setup Guide

Follow our setup guide to connect AdRoll to Fivetran.

Prerequisites

To connect AdRoll to Fivetran, you need an AdRoll account with Admin privileges.

Enter your chosen Destination schema name in the connector setup form.
Enter your chosen Destination table name.
Click Authorize. This will redirect your browser to the AdRoll authorization page.

In AdRoll's authorization page, click Authorize. This will redirect your browser back to the connector setup form.

authorize

In the connector setup form, choose the sync mode: Sync All Advertisables or Sync Specific Advertisables. If you choose Sync Specific Advertisables, select the advertisables you'd like to sync.
Select the Report Type.
Select Sync Mode for user level reports.
ALL_ADVERTISABLES is an organization level report and not a user level report.
Select the Dimensions.
Select the Metrics.
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 AdRoll.