Affiliate Commission Reporting System

Clive Stone

System Requirements

The client was receiving leads from a growing number of affiliates. The affiliates were paid based on commission using an agreed conversion percentage or/and per lead value. The commission value also varied per affiliate, lead code and month. An affiliate reporting system was required to replace a lengthy manual process of calculating commission and invoicing via an array of Excel spreadsheets. The reporting system would need to allow affiliates to login to the system and see accurate, upto date lead and invoicing reports. The client also needed to incorporate a manually updated invoicing spreadsheet relating to the incoming leads that convert. Other functionality was required such as the ability for specific affiliates to enter leads manually, part-payment functionality and overall management reports.

Solution Provided

An SQL Server database was used to import and clean incoming lead data. Detailed, searchable lead and financial statement reports were created and made visible to affiliates logging in. Affiliates were given the ability to update their details and also view other useful market information which the client updated via an admin area. The admin area also contained the following functionality:

  • Affiliate summary report (an extremely flexible report allowing a wide variety of seaches over all affiliate data)
  • An overall management report, showing various totals and percentages
  • An easy to manage table for tracking and invoicing converted clients
  • A page for managing individual affiliate details
  • A quick way to manage commission values with rolling ability and block updates
  • Various downloads of lead data to Excel for further inspection

Skills Used

  • Project Management
  • SQL Server
  • SQL Server Agent
  • ASP.Net
  • VB.Net
  • Ajax Control Toolkit

Affiliate Reporting Software

Fair Web Solutions has developed a number of bespoke affiliate reporting systems for clients with functionality ranging from commission reporting and reconcilliation to link tracking and conversion tracking. If you are a network or a supplier, we may be able to help you use the power of affiliate reporting to manage your affiliate relationships and streamline your affiliate conversion accordingly.