Windsor brings all your Awin data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
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 | COUNTRY | 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 | COUNTRY | Customer Country | Customer country |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
| date | DATE | Date | The Date |
| day_of_month | TEXT | Day of month | Day of the month |
| 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 |
| month | TEXT | Month | Number of the month |
| 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 | REGION | 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 |
| source | TEXT | Source | The name of the Windsor connector returning the row |
| spend | NUMERIC | Transaction Commission | The same as Transaction Commission |
| tags | OBJECT | Publisher Tags | The publisher tags |
| today | DATE | Today | Today's date |
| 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 | ID of the transaction | 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 |
| week | TEXT | Week | Week (Sun-Sat). |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). |
| year | TEXT | Year | Year |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |