---
title: "Understanding the data fields in the Transactions report"
slug: "understanding-the-data-fields-in-the-transactions-report"
updated: 2026-03-09T14:42:01Z
published: 2026-03-09T14:42:01Z
canonical: "help.awin.com/understanding-the-data-fields-in-the-transactions-report"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.awin.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Understanding the data fields in the Transactions report

## How to download your Transactions report

To download your **Transactions Report**, follow these simple steps:

1. In the platform navigate to the **Reports > Performance > Transactions**.
2. Select the desired date range or apply other filters to specify the period or type of transactions you want to review.
3. 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.