New customers in, leavers out, and the level where the two meet. Then three ways to lift it, priced side by side.
Busy at the front door. Quiet at the back one.
How many you win and how many stay. The starting figures are an IT support firm's, so swap in your own.
Ctrl+`
Starting figures · add your own
On average, over the last year.
No contracts? Count a customer as gone once they haven't bought from you in a year. The first box is then the ones who buy once and never come back, and the monthly figure is what a customer spends in a year divided by 12.
That's a lot leaving each year. If your customers only buy every year or two, a year with no order may not mean they've gone. Try counting them gone after two years instead.
Three ways up
Win more
More enquiries, a better close rate, or both. At the same cost each.
A proper start
A call in week two, a check at month two, the set-up done properly.
Look after the rest
A proper check-in every quarter, before they're thinking of leaving.
Customers who stay spending more each year: none, at our starting figures.
Extra services, more seats, yearly price rises they accept. From their fourth month on. It changes the money, never the count.
194
Customers, where the count levels off
88%
Of the way there today
About £87,200 a month at that level. The gap halves about every 42 months.
Where the count standsNearly there
As you areWin moreA proper startLook after the rest
NowYear 1Year 2Year 3Year 4Year 5
Shazza's sent the renewals. Nobody's rung anyone.
As you are, the count reaches about 185 in five years, heading for 194.
Four new customers a month and about 3.6 leaving, so the count levels off at about 194. At 170 you’re 88% of the way there. Cutting yearly leaving from 18% to 12% lifts it most, to about 294, though it gets there slowest (halfway in about 65 months); 25% more new customers reaches about 242 and cutting early leaving from 25% to 12.5% about 225. For each pound spent, a proper start for new customers pays best: about £4.30 back over five years.
Levels off at 194Nearly there
Three ways up, side by side
Over five years, against doing nothing different. Money is what's left after the costs of serving them.
Lever
Levels off at
In five years
Extra kept
Cost
Left over
Most it can cost
As you are
194
185
Win more 25% more a month
242
216
£246,000
£90,000
£156,000
£4,100 a customer won
A proper start 25% to 12.5% gone early
225
205
£156,000
£36,000
£120,000
£650 a new customer
Look after the rest 18% to 12% a year
294
229
£324,000
£115,000
£210,000
£340 a customer a year
Everything runs in your browser. Rough sums on the figures you gave, not a forecast and not financial advice. Before tax, no discounting, five years for the money, and the extra customers cost the same to win as today's. A customer's spend is an average.
Downloads propellr-ceiling-reminder.ics. Opens in Outlook, Google or Apple calendars. No sign-up, no email.
9:00Check the count against the ceiling againpropellrco.com/tools/ceiling
How this works
Think of a bath with the plug out. New customers are the tap, leavers are the drain, and the level settles where the two match. Winning more turns the tap up. Keeping more turns the drain down.
Customers leave at two speeds. Some go in their first three months: a rushed start, a poor fit, a one-off job. The rest leave slowly, a steady share each year. The tool runs both, month by month, for five years.
The level is simple: customers on the books = new customers a month × how many months the average one stays. On our starting figures that's 4 × about 48 months, so about 194.
Each lever is run the same way against doing nothing different. The money is what the extra customers leave after the costs of serving them, minus what the lever costs. Most it can cost is the cost at which that comes out level, so a rough guess at the cost does no harm.
Where it levels off = new customers a month × months the average customer stays Each lever = what the extra customers leave over five years − what the lever costs
Customers on the books once it levels off, for every one new customer a month. Multiply by yours.
Gone in the first three months
5% a year
10% a year
15% a year
20% a year
30% a year
None
237
117
77
57
37
10%
214
106
70
52
34
25%
179
89
58
43
28
40%
143
71
47
35
23
It leaves out price changes, seasons, a big customer going, and the extra ones costing more to win than today's. What one customer leaves you is the question of What can we pay for an enquiry?.
We did one like it
The customers · Advise
A trial visit. Then a membership.
A leisure operator with four venues and 110 staff. People who came to a trial and didn't join got the same messages as people who never came. Following up on who actually turned up gave each group its own next step.