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 |