Edit on GitHub
AdRoll link
AdRoll is a prospecting and re-targeting platform. It allows users to place ads, monitor performance, and run campaigns.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | check | Reporting tables |
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step AdRoll setup guide to connect AdRoll with your destination using Fivetran connectors.
Schema informationlink
Tables and fieldslink
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:
eid
is a mandatory field for all the reports other than theCONVERSIONS
report.campaign
is a mandatory field for theALL_ADGROUPS
andALL_AUDIENCES
reports.audienceEID
is a mandatory field for theCONVERSIONS
report.
Available reportslink
The followings are different types of reports available for the connector:
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).
Reporting delaylink
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.