Lead scoring: ranking enquiries without inventing a formula
Lead scoring decides who gets called first. How to build a score from what you can observe, why most models are too clever, and when scoring is not worth doing at all.
Customer lifetime value is a projection, and projections flatter. Calculated on margin rather than revenue, over a horizon you can defend, it becomes the most useful number in the business — and the most easily abused.
Customer lifetime value is the total profit you expect from a customer across the whole relationship. It answers the question every acquisition decision depends on: how much is it rational to spend to win one? Without it, an advertising budget is a guess, and a discount is either an investment or a loss with no way to tell which.
It is also the number most often inflated, in a way that is rarely deliberate. Three habits do most of the damage: calculating on revenue instead of margin, assuming a lifetime longer than any customer has actually stayed, and ignoring that money arriving in four years is worth less than money arriving now.
Calculate lifetime value on margin, never on revenue. A customer spending 10 000 a year at a 20% margin is worth 2 000 a year to you, not 10 000. Businesses that quote the revenue figure end up spending acquisition budgets against money that belongs to their suppliers, and the error is invisible until the year-end accounts show volume up and profit down.
The number is worth calculating only if it changes a decision, and it changes four. What you can afford to spend on acquisition, which is the pairing with customer acquisition cost. Which channels deserve budget, since a channel bringing cheap customers who leave quickly is worse than an expensive one bringing customers who stay. How much a retention improvement is worth, which is usually more than anyone expects. And which customers deserve unusual effort — the answer is not always the loudest.
Frequency can be bought deliberately. A loyalty program trades a point of margin for repeat visits, and it works when the reward feels reachable rather than aspirational.
Ettex CRM holds the customer records, purchase history and source that any segmented calculation needs, with the sales themselves in Ettex Invoices and the margin figures from Ettex Books. The arithmetic belongs in Ettex Sheets, where the horizon and retention assumptions stay visible instead of being buried in a dashboard.
To be direct: there is no predictive model here, no cohort analysis engine and no automatic lifetime value estimate. That is partly a limitation and partly deliberate — a projected number generated by software gets quoted with a confidence it has not earned, while the same number calculated by hand comes with its assumptions attached.
Average gross margin per purchase, multiplied by purchase frequency, multiplied by expected lifetime — where lifetime is derived from your actual retention and capped at a horizon you can defend, typically three to five years.
Margin, always. Revenue-based figures include money owed to suppliers and lead to acquisition budgets the business cannot afford.
As the reciprocal of your annual churn rate — a 20% annual loss implies a five-year average lifetime — then cap it at a horizon you would defend to somebody sceptical.
Because averages hide the pattern that matters: referred customers usually outlast discounted ones, and a small group typically carries most of the value. The average describes a customer who does not exist.
Lead scoring decides who gets called first. How to build a score from what you can observe, why most models are too clever, and when scoring is not worth doing at all.
An account plan records who decides, what the customer is trying to achieve, and where the relationship is thin. The version that fits on a page and gets updated.
CRM data hygiene fails as a clean-up project and works as a measured routine. The numbers worth tracking, the fields worth enforcing, and why enrichment often makes things worse.