Search API Connector Documentation

Print

Import Impact Data to Google Sheets

In this guide, we’ll walk through how to import Impact affiliate data directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

Before You Begin

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

Part 1: Get Your Impact API Credentials

  1. Log into Impact
  2. Now navigate to Technical Settings > API Access (or follow this link: https://app.impact.com/secure/mediapartner/accountSettings/mp-wsapi-flow.ihtml)
  3. You'll be presented with an Account SID and Auth Token. Copy these down.
    impact-credentials
  4. One last step: Because the Impact API requires Basic Authentication, we need to encode our authentication info to base 64. You can do this by entering your your credentials in the format account_sid:auth_token into this form (i.e. your account SID, then a colon, and then your auth token).

    The encoding script runs in your browser, and none of your credentials are seen or stored by this site.

     

Part 2: Pull Impact API Data into Sheets

You can create a request using any of the endpoints and parameters described in Impact's API documentation. For this example we'll get a list of available reports. Substitute in your own account SID where it says your_account_SID, and your encoded credentials from above where it says your_encoded_credentials.

  • Application: Custom
  • Method: GET
  • Request URL: https://api.impact.com/Advertisers/your_account_SID/Reports
  • Headers
    • Authorization: Basic your_encoded_credentials

Note the value returned in the Reports.Report.ApiRunUri column, as this is the API URL path used to run each report. For example, if the value reads /Advertisers/I11111111111111/Reports/adv_db_new_mps_groups, pre-pend https://api.impact.com such that the full API request URL is https://api.impact.com//Advertisers/I11111111111111/Reports/adv_db_new_mps_groups

Part 3: API Documentation

Official documentation: https://integrations.impact.com/impact-brand/reference/how-to-structure-requests

Leave a Comment