Search API Connector Documentation

Print

Import AdRoll Data to Google Sheets

In this guide, we’ll walk through how to pull AdRoll data data directly into Google Sheets, using the API Connector add-on for Sheets. The AdRoll API supports authentication via OAuth2, so we’ll be connecting using API Connector’s built-in OAuth2 integration for AdRoll (this is a paid feature, please install API Connector for a free trial or upgrade to access).

CONTENTS

BEFORE YOU BEGIN

Click here to install the API Connector add-on from the Google Marketplace.

PART 1: CONNECT TO THE ADROLL API

If you haven’t connected API Connector to AdRoll before, you’ll first need to initiate the connection as follows:

  1. Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
  2. In the list of available connections, find AdRoll and click Connect.
    adroll-img1
  3. You be asked to authorize the connection. Click Authorize.
    adroll-img2
  4. You’ll then be returned to your Google Sheet, and can verify that your AdRoll connection is active in the Connections screen.
    adroll-img3

PART 2: CREATE YOUR ADROLL API REQUEST URL

For our first request, we’ll get some basic information about your AdRoll account.

  • API root: https://services.adroll.com
  • Endpoint: /api/v1/organization/get


Putting it all together, we get the full API Request URL.

https://services.adroll.com/api/v1/organization/get

PART 3: PULL ADROLL API DATA INTO SHEETS

Now let’s add our URL into API Connector and import AdRoll data into Google Sheets.

  1. In API Connector, click Create, and paste in the Request URL we created above.
    adroll-img4
  2. Under OAuth, choose AdRoll from the dropdown menu.
    adroll-img5
  3. We don’t need any headers so just leave that section as is.
  4. Create a new tab and click ‘Set current’ to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see some information about your organization populate your sheet.
    adroll-img6

PART 4: MORE EXAMPLE API URLS

Now that we’ve got the basic connection down, let’s get some more interesting data. Try the following URLs (one at a time).

  • Get ad performance broken down by ad name
    https://services.adroll.com/api/v1/report/ad?data_format=entity&start_date=01-01-2021&end_date=03-10-2021
    adroll-img7
  • Get summary account performance
    https://services.adroll.com/api/v1/report/ad?data_format=summary&start_date=03-01-2019&end_date=03-10-2019
  • Get ad perfomance broken down by day
    https://services.adroll.com/api/v1/report/ad?data_format=date&start_date=03-01-2019&end_date=03-10-2019
    adroll-img8

To see more API endpoints and example responses, I suggest checking out out the CRUD API documentation located at https://apidocs.nextroll.com/crud-api/reference.html

Previous Import ActiveCampaign Data to Google Sheets
Next Import AfterShip Data to Google Sheets

Leave a Comment

Table of Contents