Tutorial: AWIN Report Builder
The AWIN report builder app uses the following endpoint to pull data by publisher for a given advertiser:
https://wiki.awin.com/index.php/API_get_reports_aggrbypub
Spend (cost) can be calculated using the following formula:
if confirmed_comm != 0 then use confirmed_comm value
else use pending_comm value
Output schema:
id | (internal usage) row number |
advertiserId | |
advertiserName | |
bonusComm | commission of the bonus transactions |
bonusNo | number of bonus transactions |
bonusValue | value of the bonus transactions |
clicks | |
confirmedComm | commission of the confirmed transactions |
confirmedNo | number of confirmed transactions |
confirmedValue | value of confirmed transactions |
currency | ISO code |
declinedComm | commission of declined transactions |
declinedNo | number of declined transactions |
declinedValue | value of declined transactions |
impressions | |
pendingComm | commissions of the pending transactions |
pendingNo | number of pending transactions |
pendingValue | value of the pending transactions |
publisherId | |
publisherName | |
region | |
tags | publisher tags |
totalComm | commission of all transactions |
totalNo | total number of transactions |
totalValue | value of all transactions |
date |