Our AdRoll integration is currently in Open Beta. As such, the info in this article may change.
Release Status | Open Beta | Availability | Free |
Status Page | AdRoll Status Page | Default Historical Sync | 1 year |
Whitelist Tables/Columns | Unsupported/Unsupported | Default Replication Frequency | 30 minutes |
Full Table Endpoints | 5 | Incremental Endpoints | 1 |
Destination Incompatibilities | None |
Connecting AdRoll
Connecting your AdRoll data to Stitch is a four-step process:
- Create an AdRoll user for Stitch
- Add AdRoll as a Stitch data source
- Define the Historical Sync
- Define the Replication Frequency
Creating an AdRoll User for Stitch
While you can use your own credentials to connect AdRoll to Stitch, we recommend creating a separate user for us. This will make it easier for you to manage users and audit events in your AdRoll account.
We require a General User role - which is the default - to be able to replicate your AdRoll data. Note that Stitch does not need billing access. If you need help creating an AdRoll user, you can find instructions here in AdRoll’s support docs.
Add AdRoll as a Stitch Data Source
- On the Stitch Dashboard page, click the Add an Integration button.
-
Click the AdRoll icon.
-
Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.
For example, the name “Stitch AdRoll” would create a schema called
stitch_adroll
in the data warehouse. This schema is where all the tables for this integration will be stored. - Enter the email address and username for the Stitch AdRoll user.
Defining the Historical Sync
The Sync Historical Data setting will define the starting date for your AdRoll integration. This means that data equal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to sync data beyond AdRoll’s default setting of 1 year. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.
Define the Replication Frequency
The Replication Frequency controls how often Stitch will attempt to replicate data from your AdRoll integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.
Before setting the Replication Frequency, note that:
- The more often AdRoll is set to replicate, the higher the number of replicated rows.
-
The number of rows in the source may not equal the number of rows replicated by Stitch. Tables that use Full Table Replication will result in a higher number of replicated rows.
- If you’re using a data warehouses that doesn’t natively support nested structures, you’ll see a higher number of replicated rows due to the de-nesting Stitch performs.
To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes. For tips on reducing your row count, check out the Reducing Your Row Count section of our Billing Guide.
After selecting a Replication Frequency, click Save Integration.
AdRoll’s Intial Sync
After you finish setting up AdRoll, you might see its Sync Status show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial sync for the integration. This may take some time to complete.
AdRoll Schema
Stitch's AdRoll integration includes these tables:
adroll_ad_groups
Replication Method: Full Table
Primary Key: eid
Contains Nested Structures?:
Yes
adroll_ad_groups
table contains info about the adgroups contained within the campaigns of your AdRoll account.adroll_ad_groups & Nested Structures
This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a *
adroll_ad_groups Attributes
While we try to include everything AdRoll has here, this may not be a full list of attributes. Refer to AdRoll's documentation for a full list and description of each attribute.
Adgroup ID (
eid
)Ad info
*
ad_optimization
campaign
created_date
flight_timezone
name
Segment info
*
space_optimization
status
type
updated_date
adroll_ad_reports
Replication Method: Incremental
Primary Key: eid
Contains Nested Structures?:
No
adroll_ad_reports
table contains ad-level reporting data.Each row in this table contains totals for the ad, by date.
adroll_ad_reports Attributes
While we try to include everything AdRoll has here, this may not be a full list of attributes. Refer to AdRoll's documentation for a full list and description of each attribute.
Ad ID (
eid
)ad
ad_size
adjusted_click_through_ratio
adjusted_cpa
adjusted_cpa_usd
adjusted_ctc
adjusted_total_conversion_rate
adjusted_total_conversions
adjusted_view_through_ratio
adjusted_vtc
advertiser
click_cpa
click_cpa_usd
click_through_conversions
click_through_ratio
clicks
cost
cost_usd
cpa
cpa_usd
cpc
cpc_usd
cpm
cpm_usd
created_date
ctr
date
height
impressions
paid_impressions
prospects
status
total_conversion_rate
total_conversions
type
view_through_conversions
view_through_ratio
width
adroll_ads
Replication Method: Full Table
Primary Key: eid
Contains Nested Structures?:
Yes
adroll_ads
table contains about the ads, or creatives, associated with the advertisables in your account.adroll_ads & Nested Structures
This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a *
adroll_ads Attributes
While we try to include everything AdRoll has here, this may not be a full list of attributes. Refer to AdRoll's documentation for a full list and description of each attribute.
Ad ID (
eid
)ad_format
ad_format_id
ad_format_name
Ad Group info
*
advertisable
call_to_action
created_date
destination_url
has_edits
has_future_campaigns
has_pending_edits
height
inventory_type
is_active
is_fb_dynamic
is_outlined
name
original_ad
outline_color
src
status
type
updated_date
valid_clicktag
width
adroll_advertisables
Replication Method: Full Table
Primary Key: eid
Contains Nested Structures?:
No
adroll_advertisables
table contains about the advertisables (typically the parent object for a brand) in your AdRoll account.adroll_advertisables Attributes
While we try to include everything AdRoll has here, this may not be a full list of attributes. Refer to AdRoll's documentation for a full list and description of each attribute.
Advertisable ID (
id
)is_active
name
organization
status
url
product_name
click_through_conversion_window
view_through_conversion_window
created_date
updated_date
attached_users
*
blacklisted_sites
enable_customer_multi_dur_segs
is_coop_approved
is_publisher
cm_networks
iab1_category_id
iab1_category_name
iab2_category_id
iab2_category_iname
zvelo_category_id
zvelo_category_name
approval_state
has_privacy_policy
ops
optimizer
saleser
liquidads
adroll_campaigns
Replication Method: Full Table
Primary Key: eid
Contains Nested Structures?:
Yes
adroll_campaigns
table contains about the advertising campaigns in your account.adroll_campaigns & Nested Structures
This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a *
adroll_campaigns Attributes
While we try to include everything AdRoll has here, this may not be a full list of attributes. Refer to AdRoll's documentation for a full list and description of each attribute.
Campaign ID (
eid
)adgroups
*
advertisable
budget
ui_budget_daily
created_date
cpc
cpm
end_date
is_active
is_facebook
is_fbx_newsfeed
is_retargeting
is_fb_wca
is_apple
max_cpm
name
promotion
pricing_strategies
start_date
status
updated_date
is_coop
is_pubgraph
spend_limit_until
created_date
updated_date
adroll_segments
Replication Method: Full Table
Primary Key: eid
Contains Nested Structures?:
No
adroll_segments
table contains about segments, or the lists of users that visit your site.adroll_segments Attributes
While we try to include everything AdRoll has here, this may not be a full list of attributes. Refer to AdRoll's documentation for a full list and description of each attribute.
Segment ID (
eid
)display_name
name
type
match_method
pattern
threshold
duration
conversion_value
group
mobile
Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, please reach out to us.