Fetching Awin data with the Custom JSON/CSV connector

You can use our Custom JSON/CSV to fetch Awin data into Google Sheets. Do this:

  1. Create an Awin API token at https://ui.awin.com/awin-api
  2. In Google Sheets, select Custom JSON/CSV as the data source, and add this URL into Report configuration: Type URL to get a list of your Awin accounts: https://api.awin.com/accounts?accessToken=XXXXX, where XXXXX is the API token you got in step 1. You should get a list of accounts into the spreadsheet.
  3. With the API token and the account ID, you can make queries to fetch performance data from the Awin API. You can see all the possible queries for advertisers here and for publishers here

    Some examples:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.