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.