Although I cannot give you my spreadsheet, which is extremely proprietary and customized, I will suggest that you keep track of the following, on a month-to-month basis, per vendor:
– Total clicks
– Total revenue
– Calculated revenue/click
This latter derivative will help crystallize who you should focus on advertising more.
Additionally, total revenue and itemized costs need to be kept. Obviously, total profit is total rev – total cost.