Awin Publisher: Most-used fields

The table below gives information about most-used fields that you can import from Awin Publisher. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
Date	Date	The date associated with a transaction or report entry. This can refer to the transaction date (when the sale occurred) or the validation date (when the sale was approved or declined).	dimension
DateTime	DateTime	The complete timestamp, including both date and time, for an event such as a transaction, click, or validation, as recorded by the Awin platform. For example, transactionDate or clickDate fields.	dimension
EndDate	EndDate	The end date for the reporting period or transaction query.	dimension
StartDate	StartDate	The start date for the reporting period or transaction query.	dimension
advertiserCountry	advertiserCountry	The country where the advertiser is based or where the transaction originated.	dimension
advertiserId	advertiserId	The unique identifier for the advertiser.	metric
advertiserName	advertiserName	The name of the advertiser associated with the transaction or report.	dimension
amendDate	amendDate	The date when a transaction was last amended or validated. This field is associated with the Transaction Validation API.	dimension
amendReason	amendReason	The reason provided if a transaction was amended.	dimension
amended	amended	Indicates whether a transaction has been amended.	dimension
amount	amount	The monetary value associated with a transaction, representing either the total sale amount or the commission earned.	metric
basketProducts	basketProducts	A list of products included in the transaction’s basket, available when product-level tracking is enabled.	dimension
bonusComm	bonusComm	The total commission earned from bonus transactions.	metric
bonusNo	bonusNo	The total number of bonus transactions.	metric
campaign	campaign	The name of the campaign associated with the transaction.	dimension
clickDate	clickDate	The date and time when the customer clicked on the tracking link, leading to the transaction.	dimension
clickDevice	clickDevice	The type of device (e.g., desktop, mobile) used by the customer when they clicked on the advertising creative.	dimension
clickRef	clickRef	A custom reference parameter (ClickRef1) passed by the publisher to track clicks and provide additional information for the transaction.	dimension
clickRef2	clickRef2	A secondary custom reference parameter (ClickRef2) passed by the publisher for additional tracking information.	dimension
clicks	clicks	The total number of clicks generated.	metric
commissionAmount	commissionAmount	The amount of commission generated by the transaction.	metric
commissionGroupCode	commissionGroupCode	A unique code identifying a specific commission group.	dimension
commissionGroupId	commissionGroupId	A unique identifier for a commission group.	metric
commissionGroupName	commissionGroupName	The name of the commission group.	dimension
commissionSharingPublisherId	commissionSharingPublisherId	The ID of the publisher involved in commission sharing for this transaction.	dimension
commissionSharingSelectedRatePublisherId	commissionSharingSelectedRatePublisherId	The ID of the publisher whose commission rate was selected for this transaction in a commission sharing scenario.	dimension
commissionStatus	commissionStatus	The current status of the commission, such as pending, approved, or declined.	dimension
confirmedComm	confirmedComm	The total confirmed commission amount.	metric
confirmedNo	confirmedNo	The total number of confirmed or approved transactions.	metric
confirmedValue	confirmedValue	The total value of confirmed or approved transactions.	metric
creativeId	creativeId	The unique identifier for the creative asset used in a campaign.	metric
creativeName	creativeName	The name of the creative used for advertising.	dimension
currency	currency	The ISO currency code for monetary values in the transaction, such as GBP or USD.	dimension
customParameters	customParameters	Additional custom parameters passed with the transaction, allowing for shared information between publishers and advertisers.	dimension
customerCountry	customerCountry	The country of the customer who made the purchase.	dimension
declineReason	declineReason	The reason provided if a transaction was declined.	dimension
declinedComm	declinedComm	The total declined commission amount.	metric
declinedNo	declinedNo	The total number of declined transactions.	metric
declinedValue	declinedValue	The total value of declined transactions.	metric
id	id	The unique identifier for the transaction.	dimension
impressions	impressions	The total number of impressions generated by creative assets.	metric
lapseTime	lapseTime	The conversion time for the transaction, representing the time taken from click to conversion.	metric
orderRef	orderRef	The reference ID for the booking or order, used to share information between publishers and advertisers.	dimension
originalSaleAmount	originalSaleAmount	The original sale amount before any amendments or changes.	dimension
paidToPublisher	paidToPublisher	Indicates whether the commission for the transaction has been paid to the publisher.	dimension
paymentId	paymentId	A unique identifier for the payment associated with a transaction.	metric
pendingComm	pendingComm	The total pending commission amount.	metric
pendingNo	pendingNo	The total number of pending transactions.	metric
pendingValue	pendingValue	The total value of pending transactions.	metric
publisherId	publisherId	The unique identifier for the publisher.	metric
publisherName	publisherName	The name of the publisher associated with the transaction or report.	dimension
publisherUrl	publisherUrl	The URL associated with the publisher or the transaction source.	dimension
region	region	The geographical region for which data is reported, such as AT or US.	dimension
siteName	siteName	The name of the website or site from which the transaction originated.	dimension
totalComm	totalComm	The total commission amount, encompassing all statuses (pending, approved, declined).	metric
totalNo	totalNo	The total number of transactions.	metric
totalValue	totalValue	The total value of all transactions.	metric
trackedCurrencyAmount	trackedCurrencyAmount	The monetary value of a specific tracked part of a transaction, expressed in its corresponding currency. This value is part of a detailed breakdown of the transaction.	dimension
transactionDate	transactionDate	The date and time when the transaction took place. This is the default date type for filtering transactions.	dimension
transactionDevice	transactionDevice	The type of device (e.g., desktop, mobile) used by the customer when the transaction occurred.	dimension
transactionQueryId	transactionQueryId	The identifier for a transaction query.	metric
type	type	The type of transaction, such as Sale, Lead, Bonus, or Mobile App Install.	dimension
url	url	The URL related to the transaction or the publisher.	dimension
validationDate	validationDate	The date when the commission payment for the transaction was validated. This is used when filtering transactions by ‘validation’ dateType.	dimension
voucherCode	voucherCode	The voucher code used in the transaction, if applicable.	dimension
voucherCodeUsed	voucherCodeUsed	Indicates whether a voucher code was used for the transaction.	dimension