Affiliate Management - Reports

Affiliate Reports/Tools

The affiliate system has a number of useful reports and tools located at:

Main Menu → Advanced → Affiliate Management


Click on the Reports tab at the Overview Screen (shown below).

Both Reports and Tools options will be listed on this screen

Reports

The first section contains the high level reports that are available to the affiliate manager as described below.

Report NameDescription
All AffiliatesThis report shows all the affiliates on the UltraCart account. It provides the affiliate ID, name, email address, affiliate type, unique clicks, items sold, and total commissions for a given time period. It will include affiliates that you previously disabled.  
Commission AnalysisThis report provides the transaction level details for all the commissions generated for a given sales period including affiliate, order id, buyer, item details, etc.
Click Summary

This report provides the total number of customer clicks through affiliate links per day for a given sales period.

 Retention of raw affiliate click log data (raw click history) is only retained for 365 days.

Payment SummaryThis report provides a history of the payments that you have recorded as being paid to your affiliates. 
Sales SummaryThis report provides the number of sales generated by all the affiliates and the gross sales amount for each day of a given sales period.
Traffic Summary

This report analysis the traffic that individual affiliates are generating to provide an executive level view of revenue generation by affiliate.

This report is currently considered ALPHA.

Tools

The Affiliate Manager's tools are described in the 2nd section.

ToolDescription
Broadcast EmailAllows the affiliate manager to send a broadcast email to all the affiliates on the UltraCart account.
Fraud ReviewScans orders associated with affiliates for potential fraud.  The most common fraud this tool will find is customers signing up as affiliates to reduce the amount they pay for a product.
Process PaymentsThis tool allows merchants to process payments to their affiliates via check or PayPal MassPay.
Export PaymentsSimilar to the process payments tool, this tool allows you to export the payment information (to send to a check writing service for example) and mark all the payments as completed.
Export AffiliatesExports the Affiliate ID and Email address for all affiliates in a spreadsheet format.

FAQ

Question: We are running reports for an affiliate for a single day. When we compare the "Completed Orders" and then compare it to the "Sub-Id" report, we are seeing a large discrepancy between the two reports (2 vs. 30) What accounts for the discrepancy? 

Answer: The "Completed Orders" report provides the details only for orders that occurred on that day, whereas the "Sub-Id" report shows the outcome of the clicks that occurred on that day. The reason for the difference between the two reports is that customers often click a link initiating a checkout, but then don't end up purchasing that day, but they end up coming back and completing their purchase a short period after the initial click through (usually 1-2 days later). The Sub-Id" report reflect that behavior.