How to identify your best and worst customers
Are some of your customers stars, bringing in money, skills and enhancing the reputation to your business? And are others quite frankly duds, bringing you hassle and actually losing you money on each sale?
Simply asking these questions can lead you into making some useful changes to the way you do business - so you do more work for the customers who are better for you.
But sometimes it isn’t obvious who the heroes and villains are. So here’s a 10-step technique that will help you identify them.
Calculating what a given client is worth to you
1. This works most simply in businesses where you have a few clients, but if you’ve got a lot divide them up into meaningful segments that you can find or estimate figures for - e.g. those who buy food and those who don’t, the Monday crowd versus the Saturday crowd or whatever. It’s also more accurate if you do it for a longer time period, so quarterly is better than monthly, but don’t worry if your records don’t go that far back.
2. Next you need to know your own hourly staff costs. In an established business this would be the salaries plus all the costs of making someone productive - office space, equipment and so on. However in a start-up where there’s just you and you are not paying yourself much yet it may be hard to come up with a plausible figure. For this exercise a rough approximation will do. So you could just say £10 or whatever you think is reasonable. We are going to apply the same figure to all clients so it still makes for a fair comparison.
3. Now for each client or segment you are interested in tot up the total hours you spent on them last quarter, and multiply it by your hourly staff time figure. Add in any other significant hard costs like travel or material spent on that client. That will give you the cost of that client.
4. Now check what they brought in last quarter. You can keep things fairly simple. If you invoice in bigger chunks divide it up to give you a quarterly figure. And for segments tot up the quarterly income for the group - gross, without deducting any costs.
5. Subtract the cost of the client you worked out at step 3 from what they brought in. The result is a fair approximation to their relative monetary value to you.
6. Next the important bit - the fiddle factors. We all know some clients are reliable and easy to deal with, while others are a pain. So think of a fair monetary value in pounds per quarter for the joy (add) or pain (subtract), and apply this hassle factor to the value score.
7. We also need to recognise that some clients are valuable for strategic reasons - perhaps referring business to us, allowing us to build up valuable expertise or taking us in the direction we want the business to go. So we need another fiddle factor to recognise this strategic value. Again add an appropriate positive amount in pounds to any client taking you in an exceptionally useful direction, subtract money from clients who lock you into dead-end work you’d rather avoid and leave average clients alone. This gives the overall “value” of the client to you.
8. Now repeat from step 3 to 7 for all the clients or segments you wish to compare.
9. You should end up with a set of numbers, with best clients scoring high and your worst low. Note that because of all the approximations and the inclusion of intangible fiddle factors the number doesn’t represent the actual profit from each client. For that you’d need more real data, which you should eventually accumulate.
Nonetheless, this exercise is legitimate and does tell you something important. The high scorers are bringing in the most value to your business in the broadest sense. The low scorers are more of a drain and repay your efforts less. So if you have uncovered any serious duds or brilliant stars you might want to drop the duds and work more with the stars should the opportunity arise.
10. One final step may make identification of heroes and villains easier. Divide the value figure for each client by the number of hours you worked for them, which you’ve already totted up at step 3. This removes the amount of business you are getting from them from the equation, and gives you more of a pure customer-quality score. The high scorers are the ones you probably want more business with.
Posted on Monday, March 31st, 2008
Under: How-to articles | No Comments »



The production of Working for YOURSELF, written in-house by PRIME, has been partially-funded by the Equal Diversity in Practice project, which is in turn paid for from the European Social Fund.
The Treasury






