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

IDTypeNameDescription
adnetwork_conversionsNUMERICAd Network ConversionsThe Ad Network Reported Conversions
adnetwork_revenueNUMERICAwin RevenueAwin Revenue
advertiser_costNUMERICAdvertiser CostAdvertiser cost
advertiser_cost_currencyTEXTAdvertiser Cost CurrencyAdvertiser cost currency
advertiser_countryTEXTAdvertiser CountryAdvertiser country
advertiseridTEXTAdvertiser IDThe Advertiser ID
advertisernameTEXTAdvertiser NameThe Advertiser Name
amend_reasonTEXTAmend ReasonTransaction amendment reason
amendedTEXTAmendedWhether the transaction was amended
basket_productsTEXTBasket ProductsBasket products
bonuscommissionNUMERICBonus CommissionThe Commission of Bonus Transactions
bonustransactionrevenueNUMERICBonus Transaction RevenueThe Value of Bonus Transactions
bonustransactionsNUMERICBonus TransactionsThe Number of Bonus Transactions
campaignTEXTCampaignThe Name of the Publisher (Duplicate)
click_dateDATEClick DateClick date
click_deviceTEXTClick DeviceClick device
clicksNUMERICClicksThe Number of Clicks
codeTEXTCodeCode
commission_amountNUMERICCommission AmountCommission amount
commission_currencyTEXTCommission CurrencyCommission currency
commission_sharing_publisher_idTEXTCommission Sharing Publisher IdCommission sharing publisher Id
commission_statusTEXTCommission StatusCommission status
confirmedcommissionNUMERICConfirmed CommissionThe Commission of the Confirmed Transactions
confirmedtransactionrevenueNUMERICConfirmed RevenueThe Total Value of Confirmed Transactions
confirmedtransactionsNUMERICConfirmed TransactionsThe Total Number of Confirmed Transactions
currencyTEXTCurrencyThe Currency
customer_acquisitionTEXTCustomer AcquisitionCustomer acquisition
customer_countryTEXTCustomer CountryCustomer country
dateDATEDateThe Date
decline_reasonTEXTDecline ReasonDecline reason
declinedcommissionNUMERICDeclined CommissionThe Commission of Declined Transactions
declinedtransactionrevenueNUMERICDeclined RevenueThe Value of Declined Transactions
declinedtransactionsNUMERICDeclined TransactionsThe Number of Declined Transactions
impressionsNUMERICImpressionsThe Number of Impressions
lapse_timeNUMERICLapse TimeLapse Time
network_feeNUMERICNetwork FeeNetwork fee
network_fee_currencyTEXTNetwork Fee CurrencyNetwork fee currency
old_commission_amountNUMERICOld Commission AmountOld commission amount
old_sale_amountNUMERICOld Sale AmountOld sale amount
order_refTEXTOrder ReferenceOrder reference
original_sale_amountNUMERICOriginal Sale AmountOriginal sale amount
TEXTPaid to PublisherPaid to publisher
payment_idTEXTPayment IdPayment Id
pendingcommissionNUMERICPending CommissionThe Commissions of Pending Transactions
pendingtransactionrevenueNUMERICPending Transaction RevenueThe Value of Pending Transactions
pendingtransactionsNUMERICPending TransactionsThe Number of Pending Transactions
publisher_urlTEXTPublisher URLClick device
publisheridTEXTPublisher IDThe ID of the Publisher
publishernameTEXTPublisher NameThe Name of the Publisher
regionTEXTRegionThe Region
sale_amountNUMERICSale AmountTransaction sale amount
sale_currencyTEXTSale CurrencySale currency
site_nameTEXTSite Namesite Name
spendNUMERICTransaction CommissionThe same as Transaction Commission
tagsOBJECTPublisher TagsThe publisher tags
totalcommNUMERICTransaction Commission (Duplicate)The Total Commission of all Transactions
totalcostNUMERICTotal CostThe same as Transaction Commission
tracked_currencyTEXTTracked CurrencyTracked currency amount
tracked_currency_amountNUMERICTracked Currency AmountTracked currency amount
transaction_dateDATETransaction DateTransaction date
transaction_deviceTEXTTransaction DeviceTransaction device
transaction_idTEXTTransaction IdTransaction id
transaction_parts_listTEXTTransaction Parts ListList of the transaction parts
transaction_query_idTEXTTransaction Query IdTransaction query Id
transaction_typeTEXTTransaction TypeTransaction date
transaction_urlTEXTTransaction URLTransaction URL
transactioncommissionNUMERICTransaction CommissionThe Total Commission of all Transactions
transactionrevenueNUMERICTransaction RevenueThe Total Value of all Transactions
transactionsNUMERICTransactionsThe Total Number of Transactions
typeTEXTTypeThe Region (duplicate)
voucher_codeTEXTVoucher CodeCode of the voucher used
voucher_code_usedTEXTVoucher Code UsedWhether a voucher code was used