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