In the last post, Who are your Top 20 Revenue Generators, I talked about the 80/20 rule and identifying the top 20% of customers (based on revenue). Revenue is a good starting point and it can help you understand who your biggest customers are. However, it's not the whole story. Profits are equally important, and a lot of people would argue that they are more important. You actually have to look at both to understand which of your customers deliver the highest value.
I was recently working with a client who was quite concerned about losing a high revenue customer. It was keeping him up at night. But, as we started to take a look at the profit generated by that customer, it became very clear that it actually wouldn't be that bad if the customer left. Sure, there would be an emotional loss and it would be tough on the team, but it would be better for the company in the long-run because that customer was costing more to service than they were giving the company in revenue. This happens much more often than people realize and/or acknowledge.
You really need to look at how much a customer brings in (Revenue) and how much of that you can keep (Profit) to understand their true value. Neither alone will do the trick.
The easiest way to get a really good understanding of which customers deliver the highest value and which deliver the least is to plot all of your customers on a 2 x 2 matrix like the one shown here. Each dot represents a customer and the ones in the top right hand quadrant are delivering the highest value (both highest revenue and highest profit).
You can easily create a chart like this once you know how much revenue each customer generates and how much profit you keep from each of those customers. Then, do the following.
Step 1: Use the Top Customer Identifier spreadsheet to track the revenue of each customer. Top Customer Identification.xls
Step 2: Add two additional columns. The first should list the profits generated by each customer and the second should be the % profit for each of those customers. Percent profit is the proportion of the revenue you get to keep after taking into consideration all of the costs needed to get that revenue (% profit = profit/revenue).
Step 3: Plot each customer on the Customer Revenue and Profit Matrix based on the revenue and profit they each represent. Best Customer Matrix.pdf
The customers who end up in the top right hand quadrant deliver the highest value while those in the bottom left hand quadrant deliver the least. Now that you know where each of your customers fits, you can make informed decisions about what to do with the customers in each quadrant.