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.
For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.
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.
|Default Pipeline Frequency||Minimum Pipeline Frequency||Maximum Pipeline Frequency||Custom Frequency Range (Hrs)|
|1 Hr||1 Hr||48 Hrs||1-48|
Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.
Historical Data: The historical data is ingested using the Recent Data First approach 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 updated data for the reports.
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.||
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|Sep-05-2022||NA||Updated section, Data Replication to reorganize the content for better understanding and coherence.|
|Oct-25-2021||NA||Added the Pipeline frequency information in the Data Replication section.|
|Jul-26-2021||NA||Added a note in the Overview section about Hevo providing a fully-managed Google BigQuery Destination for Pipelines created with this Source.|