AdRoll Data Connector User Guide

AdRoll Data Connector User Guide

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




  1. 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 + New Data Source.
  4. Select AdRoll from the list of available data sources. You will be prompted to sign in to your AdRoll account.
  5. 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.


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • 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 ...

      • GA4 Data Connector User Guide

        Google Analytics 4 (GA4) is a powerful web analytics platform that provides valuable insights into your website and app performance. This guide will walk you through the process of connecting GA4 to Power My Analytics, creating reports in Looker ...

      • 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 ...