AdRoll Data Connector User Guide

AdRoll Data Connector User Guide

Info
This guide provides comprehensive instructions for setting up and utilizing the AdRoll data source in Power My Analytics. AdRoll is a powerful advertising platform specializing in retargeting, cross-channel advertising, dynamic ads, email marketing, and campaign automation. By integrating AdRoll with PMA, you can streamline your marketing data collection and analysis, saving time and improving your reporting capabilities.

Prerequisites

Before you begin, ensure you have:
  1. An active AdRoll account
  2. Administrator or General User role in your AdRoll account
  3. A Power My Analytics account

Adding AdRoll as a Data Source

  1. Log in to your Power My Analytics hub.
  2. Navigate to the Sources section in the main menu.
  3. Click on + Add new source.
  4. Select AdRoll from the list of available data sources. You will be prompted to sign in to your AdRoll account.
  5. Authorize Power My Analytics to access your AdRoll account.
Once connected, AdRoll will appear in your list of active data sources.

Creating a Data Studio Report

To create a Data Studio report using your AdRoll data:
  1. In your PMA hub, go to Reports > Data Studio.
  2. Click on AdRoll under Create Data Studio Report. A new window will open with the official Data Studio application.
  3. Google Data Studio Configuration:
    1. Step 1:
      1. Rename "Untitled Data Source" to a unique name (e.g., "AdRoll - Your Organization Name")
      2. Select your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked if you want to use the PMA demo template
      4. Click Next   
    2. Step 2:
      1. User Account: Select your AdRoll account for real data or choose "Sample Account" for sample data
      2. Click Next  
    3. Step 3:
      1. Choose "Advertisables" and "Currency" for your reports
      2. Optional: Allow "Advertisables" modification in reports
      3. Click Connect in the top right corner   
    4. Step 4:
      1. Click Create Report in the top right corner
For a quick start, use our pre-built AdRoll demo template.

Key Features and Reports

AdRoll data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports.
  • Key Performance Metrics: Impressions, Clicks, CTR, CPC, Cost
  • Campaign Metrics: Impressions, Clicks, CTR, CPC, Cost
  • Ad Metrics: Impressions, Clicks, CTR, CPC, Cost
  • Ad Placement Metrics: Spend, Impressions, CPM, Clicks, CTR
For a complete list of available fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see Understanding Cached and Live Data Requests.
  2. Backfilling: We backfill 24 months of data when you first connect your AdRoll account as a data source.
  3. Data Refresh Time: AdRoll data in Power My Analytics is updated daily at midnight in your local time zone.

Unavailable Data

  1. Custom fields
  2. Realtime data

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the AdRoll connector.