Adroll walkthrough

AdRoll is a comprehensive digital marketing platform designed to empower businesses of all sizes to effectively manage their online advertising campaigns.

Connecting AdRoll to your destination

Integrate AdRoll with your destination in Data Integration by following these steps.

AdRoll reports overview

The following table lists AdRoll reports and their corresponding API endpoints. Some links redirect you to NextRoll's documentation, the parent company of AdRoll, while others provide direct access to the API endpoints.

Report Name	Endpoint
Report Ads	GET https://services.adroll.com/api/v1/organization/get_advertisables
Report Campaigns	POST https://services.adroll.com/reporting/api/v1/query
Audience Advertisers	GET https://services.adroll.com/api/v1/organization/get_advertisables
Audience Segment	POST https://services.adroll.com/reporting/api/v1/query
Attribution Advertisables	GET https://services.adroll.com/api/v1/organization/get_advertisables
Attribution Campaigns	POST https://services.adroll.com/reporting/api/v1/query
Delivery Campaigns	GET https://services.adroll.com/reporting/api/v1/query
Prospecting Campaigns	POST https://services.adroll.com/reporting/api/v1/query
Audience User Attribute Names	GET https://services.adroll.com/api/v1/organization/get_advertisables

To learn more, refer to the NextRoll’s API documentation.

Time-dependent reports

Most AdRoll reports are time-dependent, except for the Advertisers report. For time-dependent reports, you can specify the following time options:

1. Date range:
   • Pulls data within a specific start and end date, including the end date.
   • You must select a start date.
   • Leave the end date empty to pull data up to the current time of the river's run.
   • Set a timezone offset to adjust the dates accordingly.
   • Use the Last Days Back For Each Run feature to extend the start date by a specific number of days.

For example: The river runs with a date range between 01/03/2020 and 30/03/2020.

2. Predefined date:
   • Day: Yesterday.
   • Week: From Monday to Sunday (Week to date, Previous week, Previous week to date).
   • Month: Month to date, Previous month, Previous month to date.
   • Year: Year to date.

Flattening AdRoll output in Snowflake

In certain reports, like the Attribution Campaigns report, the date field is output in a JSON structure. You can flatten this data using Snowflake SQL.

Below is an example query:

SELECT 
    value:assist_revenue::INTEGER AS assist_revenue,
    value:assists::INTEGER AS assists,
    value:click_revenue::INTEGER AS click_revenue,
    value:click_throughs::INTEGER AS click_throughs,
    value:date::STRING AS date,
    value:precise_assists::INTEGER AS precise_assists,
    value:precise_click_throughs::INTEGER AS precise_click_throughs,
    value:precise_view_throughs::INTEGER AS precise_view_throughs,
    value:view_revenue::FLOAT AS view_revenue,
    value:view_throughs::INTEGER
FROM 
    "SCHEMA1"."PUBLIC"."ADROLL_JSON_DATA", 
 LATERAL FLATTEN(input => parse_json(date));