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.
Date Dimension
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).
DateTime Dimension
Represents the date and time associated with an event or record, such as the transaction date or validation date, used for defining reporting periods.
advertiserCountry Dimension
The country where the advertiser is located or for which the advertiser's performance data is reported. This field can be used for filtering reports by region.
advertiserId Metric
The unique identifier for the advertiser.
advertiserName Dimension
The name of the advertiser associated with the transaction or report.
amendDate Dimension
The date and time when the transaction was last amended.
amendReason Dimension
The reason provided for why a transaction was amended.
amended Dimension
Indicates whether the transaction has been amended (true/false).
amount Metric
The monetary value associated with the transaction, often representing the sale amount or a part of it before commission calculations.
basketProducts Dimension
A list of products included in the transaction, available if Product Level Tracking is enabled and shared by the advertiser. Each product includes details like ID, name, unit price, quantity, SKU, commission group, and category.
campaign Dimension
The name of the campaign through which the transaction was generated.
clickDate Dimension
The date and time when the user clicked on the tracking link, leading to the transaction.
clickDevice Dimension
The device (e.g., 'Windows', 'iOS', 'Android') used by the customer when clicking the tracking link.
clickRef Dimension
A custom reference value passed by the publisher in the tracking link, used for internal tracking and reporting.
clickRef2 Dimension
A second custom reference value passed by the publisher in the tracking link, used for additional internal tracking.
clicks Metric
The total number of clicks generated.
commissionAmount Metric
The total commission amount earned for the transaction, including the currency.
commissionGroupCode Dimension
The unique code identifying the commission group that applies to a specific part of the transaction.
commissionGroupId Dimension
The unique ID of the commission group that applies to a specific part of the transaction.
commissionGroupName Dimension
The name of the commission group that applies to a specific part of the transaction, providing additional context to the group code.
commissionSharingPublisherId Dimension
The ID of the publisher involved in commission sharing for this transaction.
commissionSharingSelectedRatePublisherId Dimension
The ID of the publisher for whom the commission sharing rate was selected for this transaction.
commissionStatus Dimension
The current status of the commission (e.g., 'pending', 'approved', 'declined', 'deleted').
confirmedComm Metric
The total confirmed commission amount.
confirmedNo Metric
The total number of confirmed or approved transactions.
confirmedValue Metric
The total value of confirmed or approved transactions.
currency Dimension
The ISO currency code for monetary values in the transaction, such as GBP or USD.
customParameters Dimension
Additional custom parameters passed by the advertiser for the transaction, available if shared with the publisher.
customerCountry Dimension
The geographical region or country associated with the customer's activity, used to filter performance reports by specific markets.
declineReason Dimension
The reason provided for why a transaction was declined.
declinedComm Metric
The total declined commission amount.
declinedNo Metric
The total number of declined transactions.
declinedValue Metric
The total value of declined transactions.
id Metric
The unique identifier for the transaction.
impressions Metric
The total number of impressions generated by creative assets.
lapseTime Metric
The conversion time in seconds, representing the duration between the click and the transaction.
orderRef Dimension
A unique reference number for the order or transaction from the advertiser's system.
originalSaleAmount Metric
The original sale amount of the transaction before any amendments or adjustments.
paidToPublisher Dimension
Indicates whether the commission for this transaction has been paid to the publisher (true/false).
paymentId Dimension
The identifier for the payment associated with this transaction's commission.
pendingComm Metric
The total pending commission amount.
pendingNo Metric
The total number of pending transactions.
pendingValue Metric
The total value of pending transactions.
publisherId Metric
The unique identifier for the publisher.
publisherName Dimension
The name of the publisher associated with the transaction or report.
publisherUrl Dimension
The URL on the publisher's website where the click originated.
region Dimension
The geographical region for which data is reported, such as AT or US.
siteName Dimension
The name of the publisher's site where the transaction was tracked.
totalComm Metric
The total commission amount, encompassing all statuses (pending, approved, declined).
totalNo Metric
The total number of transactions.
totalValue Metric
The total value of all transactions.
trackedCurrencyAmount Dimension
The monetary value of a tracked part of the transaction, including its currency.
transactionDate Dimension
The date and time when the transaction was completed.
transactionDevice Dimension
The device (e.g., 'Windows', 'iOS', 'Android') used by the customer when completing the transaction.
transactionQueryId Metric
An identifier used for querying or retrieving transaction data.
type Dimension
The type of transaction, such as 'Commission group transaction'.
url Dimension
The URL of the publisher that generated the transaction.
validationDate Dimension
The date and time when the transaction was validated.
voucherCode Dimension
The specific voucher code used by the customer for the transaction.
voucherCodeUsed Dimension
Indicates whether a voucher code was used for the transaction (true/false).