How to download your Transactions report
To download your Transactions Report, follow these simple steps:
In the platform navigate to the Reports > Performance > Transactions.
Select the desired date range or apply other filters to specify the period or type of transactions you want to review.
Click the Options button on the left side and select Export as CSV or Export for Excel.
Understanding the data in your Transactions report download
Below is an explanation of the key data fields you’ll find in your Transactions report spreadsheet to help you understand the information provided.
id: Awin’s unique identifier for the transaction or record.
publisher_id: Identifier of the partner involved in the transaction.
sale_amount: Total sale amount of the transaction.
commission: Earnings or fee partners earn from the transaction.
date: Date when the transaction occurred.
commission_status: Current status of the commission (e.g. pending = 0, approved = 1, declined = 2).
validation_date: Date when the transaction was validated (e.g. pending, approved, declined).
extra: The advertiser’s unique order reference related to the transaction.
type: Type of the transaction (e.g. Sale, Lead or TQ).
site_name: Name of the partner who drove the transaction.
URL: Website URL linked to the partner.
decline_reason: Reason why a transaction was declined.
referer: Partner source URL or referrer that led to the transaction.
clickThroughTime: Time when user initially clicked on the affiliate link.
voucher_code: Code used to get a discount or promotion.
mins_between_click_trans: Time elapsed between the click and the transaction.
amended: Indicates if the transaction details were modified.
amend_reason: Reason for any amendments made to the transaction.
old_sale_amount: Previous sale amount before amendment.
old_commission: Previous commission amount before amendment.
different_currency: Indicates if the transaction involved a currency different from the default.
ip: IP address associated with the transaction or click.
click_ref: Custom tracking references added to affiliate links that help track additional data.
click_device: Device used to perform the click (e.g. mobile, desktop).
transaction_device: Device used to complete the transaction.
publisher_url: URL of the partner’s website or platform.
transaction_parts: Identifies which commission group(s) the transaction relates to.
country_by_ip: Country determined based on the IP address.
custom_parameters: Any custom parameters attached to the transaction.
paid_to_publisher: If commission associated to the transaction has been paid to the partner.
invoice_id: Awin internal identifier for the invoice related to the transaction.
transaction_query_id: ID related to a transaction query.
commission_sharing_publisher_id: ID of the partner sharing the commission.
commission_sharing_publisher: Name or identifier of the co-partner sharing the commission.
partner_commission: Showing the commission allocated to the commission sharing partner.
commission_sharing_transaction_id: Transaction ID related to commission sharing.
iphash: Hashed version of the IP address for privacy.
commission_sharing_selected_rate_publisher_id: Publisher ID for the selected commission rate in sharing.
products: List of products involved in the transaction.
campaign: Campaign name associated with the transaction.
tracked_parts: Identifies which commission group(s) the transaction relates to.
customer_acquisition: Indicates if the transaction contributed to a new or returning customer.
network_fee: Tracking fee charged by Awin for processing the transaction.
service_partner_advertiser_cost: Showing the commission allocated to the commission sharing service partner.
Understanding rounding in your transactions
When you download your Transactions report, you may notice that the sum of your commission group amounts differs slightly from the sale_amount. This is expected behavior, not an error.
It can occur in two scenarios:
Currency conversion - When a transaction is processed in a currency different from your account’s default, conversion introduces small residual amounts due to precision handling.
Tax deductions - When tax is applied and deducted, rounding to two decimal places across each commission group can produce minor differences in the totals.
In both cases, partner commission is always calculated on the original, non-rounded values. Any small difference between sale_amount and the sum of commission group amounts is an artifact of precision reconciliation and doesn’t indicate any commission loss.
Example
Due to currency conversion or tax deduction, transaction amounts can carry multiple decimal places internally, for example:
Before rounding:
totalSaleAmount: 12.1563457854
commissionGroups:
BOOKS: 2.5654587125
HATS: 5.9854263578
SHOES: 3.6054607151
At this stage, the commission group amounts sum precisely to the total sale amount. This is also the point at which partner commission is calculated.
After rounding to 2 decimal places:
totalSaleAmount: 12.16
commissionGroups:
BOOKS: 2.57
HATS: 5.99
SHOES: 3.61
The rounded commission group amounts now total 12.17, which differs from the rounded
totalSaleAmountby 0.01. This small difference is expected and doesn’t indicate any commission loss.