How do I use the Transaction Report?

The Transaction report is the most detailed report in the Affiliate Portal. It gives an overview of individual transactions for your selected time period, including fields such as lead date and ID, brand, labels, language, device, user location, transaction type, vertical and your earnings. The Transaction report is updated twice a day.

You can choose to view the report for all transaction types or bookings only by using the drop down menu, as well as filter by integration code (if applicable):

You can also choose to view the report online or click on the Download button to extract the transaction data for different time periods without navigating through the Affiliate Portal every time. 

By doing so, you can keep records of your traffic data for future analysis. We recommend downloading the report on a monthly basis, which may be useful, for instance, if you're planning to compare your Labels performance over a longer period of time.

One of the ways of doing this is by creating an Excel spreadsheet, copying-pasting the generated transaction report table onto the spreadsheet, and saving it on your local server. From there, you can also create Excel PivotTables. Example:

Please refer to the Microsoft Support pages here if you would like to learn more about PivotTables.