AdRoll
AdRoll is a prospecting and re-targeting platform. It allows users to place ads, monitor performance, and run campaigns.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step AdRoll setup guide to connect AdRoll with your destination using Fivetran connectors.
Sync overview
Rollback sync
A rollback sync is a sync that automatically runs once a day. Rollback syncs capture the changes that happen outside the incremental sync time frame. The rollback window for our AdRoll connector is two days.
Schema information
Tables and fields
Fivetran generates one table for each selected report. The fields you select during the connector setup constitute the columns in the table.
The following are the mandatory fields for the different types of reports:
eidis a mandatory field for all the reports other than theCONVERSIONSreport.campaignis a mandatory field for theALL_ADGROUPSandALL_AUDIENCESreports.audienceEIDis a mandatory field for theCONVERSIONSreport.
Available reports
The following are the types of reports available:
ALL_ADVERTISABLES- This is an organization level report. Use this report to fetch all the Advertisables in an organization.ALL_CAMPAIGNS- This is a user level report. Use this report to fetch all the Campaigns visible to the selected advertisable(s).ALL_ADS- This is a user level report. Use this report to fetch all the Advertisements visible to the selected advertisable(s).ALL_ADGROUPS- This is a user level report. Use this report to fetch all the Adgroups visible to the selected advertisable(s).ALL_AUDIENCE- This is a user level report. Use this report to fetch all the Audience data for all the ads visible to the selected advertisable(s).ALL_ADS- This is a user level report. Use this report to fetch all the Advertisements visible to the selected advertisable(s).CONVERSIONS- This is a user level report. Use this report to fetch all the Conversions for all the Campaigns, Adgroups, and Ads visible to the selected advertisable(s).
Syncing multiple reports
It's only possible to include one report per connector. To sync multiple reports, you must create a new connector for each report.
Reporting delay
We fetch 48 hours old data from AdRoll. As per AdRoll documentation data is not considered finalized until after 48 hours of the current UTC day. Refer to AdRoll's FAQ for details.