On This Page
AdRoll is a tool used by marketers to show ads on various Social Media tools, such as, Facebook and Instagram, to people who are likely to click them, using real-time bidding. With AdRoll, marketers can add pricing strategies to setup retargeting, which enables them to remind their customers of products and services after they leave the website without buying, a feature which is not supported by platforms like Google Adwords.
AdRroll uses the concept of Advertisables, or advertiser profiles, that help you manage campaigns for multiple websites in a single AdRoll account. You can toggle between multiple Advertiser profiles and manage access and campaigns for each of these individually.
You can fetch reports related to users’ interaction within AdRoll, such as, reports about campaigns, ad groups, and conversions and replicate these to a database or data warehouse using Hevo Pipelines.
- An active AdRoll account.
Configuring AdRoll as a Source
Perform the following steps to configure AdRoll as the Source in your Pipeline:
Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select AdRoll.
In the Configure your AdRoll Reports Account page, click ADD ADROLL REPORTS ACCOUNT.
Sign in using your AdRoll credentials.
In the Authorize Hevo to Access AdRoll page, click Authorize. This allows Hevo to access your reporting data.
In the Configure your AdRoll Source page, specify the following:
- Pipeline Name: A unique name for your Pipeline.
Report Type: The list of reports whose data you want Hevo to ingest, for the advertisables you select next.
Note: A distinct object is created for each report of every advertisable you select.
Historical Sync Duration: The duration for which the historical data must be ingested.
- Advertisables: The list of advertisables from your AdRoll account whose data you want Hevo to ingest.
- Click TEST & CONTINUE.
- Proceed to configuring the data ingestion and setting up the Destination.
Historical Data: The historical data is ingested from the current day in backward fashion up till the configured historical sync duration, but no earlier than January 1, 2017, as defined by the AdRoll team.
Incremental Data: Once the historical data ingestion is complete, every subsequent run of the Pipeline fetches new and changed data since the previous run.
Data Refresh: Data for all reporting objects is refreshed on a rolling basis to update any conversions attributed to clicks for the past 48 hours, as AdRoll deems data to be finalized post that duration only.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination:
Note: Read Adroll API for the complete list of objects that can be created.
Hevo uses the following data model to ingest data from your AdRoll account:
|Object||Description||Primary Keys to create
|Ad||Advertiser-level, detailed daily report that fetches data for all organisations.||
|Adgroup||Ad group-level, detailed daily report that fetches data for all the target audience-specific ads.||
|Advertisable||Ad-level, daily report that fetches metrics for all creatives that are shown to target audiences.||
|Audience||Audience-level aggregated data.||
|Campaign||Campaign-level, detailed daily report that fetches data for all organisations.||