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 Looker Studio Report

To create a Looker Studio report using your AdRoll data:
  1. In your PMA hub, go to Reports > Looker Studio.
  2. Click on AdRoll under Create Looker Studio Report. A new window will open with the official Looker Studio application.
  3. Google Looker 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. Backfilling: AdRoll data can be backfilled for up to 2 years. We initially backfill 13 months of data when you first create a report.
  2. 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.

    • Related Articles

    • Amazon Ads Data Connector User Guide

      Amazon Ads is a powerful advertising platform that allows sellers and brands to promote their products on Amazon. This guide will walk you through how to connect Amazon Ads to Power My Analytics, create reports in Looker Studio, and understand key ...

    • eBay Seller Center Data Connector User Guide

      As an eBay seller, you need quick access to your sales data and performance metrics to make informed decisions. This guide will walk you through connecting your eBay Seller Center account to Power My Analytics, enabling you to automate data ...

    • Mailchimp Data Connector User Guide

      Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

    • Quora Ads Data Connector User Guide

      Quora Ads allows marketers to reach a highly engaged audience through targeted advertising on the Quora platform. This guide will walk you through how to connect your Quora Ads data to Power My Analytics and create insightful reports in Looker ...

    • How to Connect to AdRoll

      Connecting AdRoll to Power My Analytics allows you to automatically collect and warehouse your campaign data for seamless reporting across all your marketing channels. This guide walks you through the simple setup and authentication process to ...