Awin Publisher: Most-used fields

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).

Represents the date and time associated with an event or record, such as the transaction date or validation date, used for defining reporting periods.

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.

The unique identifier for the advertiser.

The name of the advertiser associated with the transaction or report.

The date and time when the transaction was last amended.

The reason provided for why a transaction was amended.

Indicates whether the transaction has been amended (true/false).

The monetary value associated with the transaction, often representing the sale amount or a part of it before commission calculations.

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.

The name of the campaign through which the transaction was generated.

The date and time when the user clicked on the tracking link, leading to the transaction.

The device (e.g., 'Windows', 'iOS', 'Android') used by the customer when clicking the tracking link.

A custom reference value passed by the publisher in the tracking link, used for internal tracking and reporting.

A second custom reference value passed by the publisher in the tracking link, used for additional internal tracking.

The total number of clicks generated.

The total commission amount earned for the transaction, including the currency.

The unique code identifying the commission group that applies to a specific part of the transaction.

The unique ID of the commission group that applies to a specific part of the transaction.

The name of the commission group that applies to a specific part of the transaction, providing additional context to the group code.

The ID of the publisher involved in commission sharing for this transaction.

The ID of the publisher for whom the commission sharing rate was selected for this transaction.

The current status of the commission (e.g., 'pending', 'approved', 'declined', 'deleted').

The total confirmed commission amount.

The total number of confirmed or approved transactions.

The total value of confirmed or approved transactions.

The ISO currency code for monetary values in the transaction, such as GBP or USD.

Additional custom parameters passed by the advertiser for the transaction, available if shared with the publisher.

The geographical region or country associated with the customer's activity, used to filter performance reports by specific markets.

The reason provided for why a transaction was declined.

The total declined commission amount.

The total number of declined transactions.

The total value of declined transactions.

The unique identifier for the transaction.

The total number of impressions generated by creative assets.

The conversion time in seconds, representing the duration between the click and the transaction.

A unique reference number for the order or transaction from the advertiser's system.

The original sale amount of the transaction before any amendments or adjustments.

Indicates whether the commission for this transaction has been paid to the publisher (true/false).

The identifier for the payment associated with this transaction's commission.

The total pending commission amount.

The total number of pending transactions.

The total value of pending transactions.

The unique identifier for the publisher.

The name of the publisher associated with the transaction or report.

The URL on the publisher's website where the click originated.

The geographical region for which data is reported, such as AT or US.

The name of the publisher's site where the transaction was tracked.

The total commission amount, encompassing all statuses (pending, approved, declined).

The total number of transactions.

The total value of all transactions.

The monetary value of a tracked part of the transaction, including its currency.

The date and time when the transaction was completed.

The device (e.g., 'Windows', 'iOS', 'Android') used by the customer when completing the transaction.

An identifier used for querying or retrieving transaction data.

The type of transaction, such as 'Commission group transaction'.

The URL of the publisher that generated the transaction.

The date and time when the transaction was validated.

The specific voucher code used by the customer for the transaction.

Indicates whether a voucher code was used for the transaction (true/false).