From Wiki

Publisher Transactions Report

The Transactions Report is designed to provide you with a complete overview of all transactions that you have generated.

This powerful report has several filter options so you can look at all your transactions in a number of ways, be it by status (pending, approved, declined) or even by the type of transaction (such as bonuses, tracked transactions and transaction queries). You can refine your data by the date the transaction occurred, or by the date it was validated. You can also use the filter options to export data on specific Advertisers. And of course there is a search if you’re looking for a certain transaction (such as one specific order reference).

Understanding the various ‘Transaction Status’ options

Pending

These are tracked transactions that have not yet been reviewed (i.e. validated) by the Advertiser. You can find the estimated validation period within the Advertiser Directory if you want to better understand when it’s likely that these transactions will be reviewed. Pending transactions are not considered to be ‘owed’ to you until they have been approved.

Approved & Declined

This option will show you all tracked transactions, bonuses, tenancies, CPC payments and transaction queries which have already been validated as either Approved or Declined. Selecting this option will show you all transactions, both those that you have already been paid, and those that are yet to be paid to you. To read more details on the payment cycle please see here: http://wiki.awin.com/index.php/Affiliate_Window_Payment_details

Approved

This option will show you all tracked transactions, bonuses, tenancies, CPC payments and transaction queries which have been validated as Approved. Selecting this option will show you all transactions, both those that you have already been paid, and those that are yet to be paid to you. To read more details on the payment cycle please see here: http://wiki.awin.com/index.php/Affiliate_Window_Payment_details

Declined

This option will show you all tracked transactions and transaction queries which have been validated as Declined. When you hover over these transactions or export them, you will be able to see the reason why these transactions were declined.

Bonus

This option will show you all transactions that have been manually added to your account and will include bonuses, tenancies and CPC payments.

Some common ways to use this report:

“I want to see all transactions that were manually inserted (such as bonuses and tenancies)”

Use the ‘from’ and ‘to’ filters to select the date range of interest Select ‘Bonus’. Generate report.

“I want to see a history of which transactions were paid and when”

Set 'Payment Status' filter to 'Paid to Publisher'. If you export the report you can see the payment id which you can match up with the payment history.

You can also use the 'Search for' and 'In' filters to search for transactions included in a specific Publisher payment.

“I want to see which transactions will be included in my next payment”

Set 'Payment Status' filter to 'Cleared - Waiting for AW to pay Publisher'

“I want to see which sales were cross device transactions”

In the interface there a is a specific icon for Cross Device. This icon shows multiple devices and on hover will say 'Cross Device'.

There is also a column when you export your CSV or Excel report called ‘device_name’. This will show either the device type or cross device.

“I want to see all transactions that were declined”

Use the ‘from’ and ‘to’ filters to select the date range of interest Select ‘Declined’. Generate report.

“I want to see the which transactions used a voucher code”

Use the ‘from’ and ‘to’ filters to select the date range of interest. Select ‘Transaction Status’ as ‘All’. Generate report. You can now export the report. Within this export there's a column called voucher_code_used

“I want work out the time difference between the click and the sale”

Use the ‘from’ and ‘to’ filters to select the date range of interest. Select ‘Transaction Status’ as ‘All’. Generate report.

You can view this in the interface under 'Time between click-trans' or export the data and view the ‘lapse_time’ column. The data is presented in minutes.