Awin Field Reference
Sample
Sample
https://connectors.windsor.ai/awin?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
Fields
Fields
| ID | Type | Name | Description |
|---|---|---|---|
| adnetwork_conversions | NUMERIC | Ad Network Conversions | The Ad Network Reported Conversions |
| adnetwork_revenue | NUMERIC | Awin Revenue | Awin Revenue |
| advertiser_cost | NUMERIC | Advertiser Cost | Advertiser cost |
| advertiser_cost_currency | TEXT | Advertiser Cost Currency | Advertiser cost currency |
| advertiser_country | TEXT | Advertiser Country | Advertiser country |
| advertiserid | TEXT | Advertiser ID | The Advertiser ID |
| advertisername | TEXT | Advertiser Name | The Advertiser Name |
| amend_reason | TEXT | Amend Reason | Transaction amendment reason |
| amended | TEXT | Amended | Whether the transaction was amended |
| basket_products | TEXT | Basket Products | Basket products |
| bonuscommission | NUMERIC | Bonus Commission | The Commission of Bonus Transactions |
| bonustransactionrevenue | NUMERIC | Bonus Transaction Revenue | The Value of Bonus Transactions |
| bonustransactions | NUMERIC | Bonus Transactions | The Number of Bonus Transactions |
| campaign | TEXT | Campaign | The Name of the Publisher (Duplicate) |
| click_date | DATE | Click Date | Click date |
| click_device | TEXT | Click Device | Click device |
| clicks | NUMERIC | Clicks | The Number of Clicks |
| code | TEXT | Code | Code |
| commission_amount | NUMERIC | Commission Amount | Commission amount |
| commission_currency | TEXT | Commission Currency | Commission currency |
| commission_sharing_publisher_id | TEXT | Commission Sharing Publisher Id | Commission sharing publisher Id |
| commission_status | TEXT | Commission Status | Commission status |
| confirmedcommission | NUMERIC | Confirmed Commission | The Commission of the Confirmed Transactions |
| confirmedtransactionrevenue | NUMERIC | Confirmed Revenue | The Total Value of Confirmed Transactions |
| confirmedtransactions | NUMERIC | Confirmed Transactions | The Total Number of Confirmed Transactions |
| currency | TEXT | Currency | The Currency |
| customer_acquisition | TEXT | Customer Acquisition | Customer acquisition |
| customer_country | TEXT | Customer Country | Customer country |
| date | DATE | Date | The Date |
| decline_reason | TEXT | Decline Reason | Decline reason |
| declinedcommission | NUMERIC | Declined Commission | The Commission of Declined Transactions |
| declinedtransactionrevenue | NUMERIC | Declined Revenue | The Value of Declined Transactions |
| declinedtransactions | NUMERIC | Declined Transactions | The Number of Declined Transactions |
| impressions | NUMERIC | Impressions | The Number of Impressions |
| lapse_time | NUMERIC | Lapse Time | Lapse Time |
| network_fee | NUMERIC | Network Fee | Network fee |
| network_fee_currency | TEXT | Network Fee Currency | Network fee currency |
| old_commission_amount | NUMERIC | Old Commission Amount | Old commission amount |
| old_sale_amount | NUMERIC | Old Sale Amount | Old sale amount |
| order_ref | TEXT | Order Reference | Order reference |
| original_sale_amount | NUMERIC | Original Sale Amount | Original sale amount |
| paid_to_publisher | TEXT | Paid to Publisher | Paid to publisher |
| payment_id | TEXT | Payment Id | Payment Id |
| pendingcommission | NUMERIC | Pending Commission | The Commissions of Pending Transactions |
| pendingtransactionrevenue | NUMERIC | Pending Transaction Revenue | The Value of Pending Transactions |
| pendingtransactions | NUMERIC | Pending Transactions | The Number of Pending Transactions |
| publisher_url | TEXT | Publisher URL | Click device |
| publisherid | TEXT | Publisher ID | The ID of the Publisher |
| publishername | TEXT | Publisher Name | The Name of the Publisher |
| region | TEXT | Region | The Region |
| sale_amount | NUMERIC | Sale Amount | Transaction sale amount |
| sale_currency | TEXT | Sale Currency | Sale currency |
| site_name | TEXT | Site Name | site Name |
| spend | NUMERIC | Transaction Commission | The same as Transaction Commission |
| tags | OBJECT | Publisher Tags | The publisher tags |
| totalcomm | NUMERIC | Transaction Commission (Duplicate) | The Total Commission of all Transactions |
| totalcost | NUMERIC | Total Cost | The same as Transaction Commission |
| tracked_currency | TEXT | Tracked Currency | Tracked currency amount |
| tracked_currency_amount | NUMERIC | Tracked Currency Amount | Tracked currency amount |
| transaction_date | DATE | Transaction Date | Transaction date |
| transaction_device | TEXT | Transaction Device | Transaction device |
| transaction_id | TEXT | Transaction Id | Transaction id |
| transaction_parts_list | TEXT | Transaction Parts List | List of the transaction parts |
| transaction_query_id | TEXT | Transaction Query Id | Transaction query Id |
| transaction_type | TEXT | Transaction Type | Transaction date |
| transaction_url | TEXT | Transaction URL | Transaction URL |
| transactioncommission | NUMERIC | Transaction Commission | The Total Commission of all Transactions |
| transactionrevenue | NUMERIC | Transaction Revenue | The Total Value of all Transactions |
| transactions | NUMERIC | Transactions | The Total Number of Transactions |
| type | TEXT | Type | The Region (duplicate) |
| voucher_code | TEXT | Voucher Code | Code of the voucher used |
| voucher_code_used | TEXT | Voucher Code Used | Whether a voucher code was used |