Customer lifetime value, without the spreadsheet

Most small businesses know exactly what a sale is worth and have no idea what a customer is worth. Customer lifetime value is the number that closes that gap, and you can work yours out on paper in about twenty minutes.

Here is the whole idea in one line. Customer lifetime value is the profit one customer brings you across the entire time they keep buying, minus what it costs you to look after them. One figure, covering every order they will ever place.

It matters because most of your spending decisions sit downstream of it. What you can afford to pay for a new customer. Whether a discount to keep an unhappy one is generous or reckless. Whether answering the phone faster is worth hiring for. Get your customer lifetime value roughly right and those arguments settle themselves.

What customer lifetime value actually means

You will see it written as CLV, and sometimes LTV. Same thing. Both describe the total worth of one customer relationship, averaged across your customer base rather than measured person by person.

The part people get wrong is the word value. Plenty of guides use revenue, because revenue is the easiest thing to pull out of a dashboard. Revenue tells you what customers hand over. It says nothing about what you keep. A $4,000 customer at a 15% margin is worth less to you than a $900 customer at 70%, and a revenue-based figure hides that completely.

So here is the working definition for a small business: gross profit from one customer, across their whole run with you.

The customer lifetime value formula, in three numbers

Skip the customer lifetime value formulas with decay rates and discount factors in them. Those exist for companies with a data team. Yours needs three numbers, multiplied together.

Average order value × orders per year × years they stay

That gives you revenue. Turn it into customer lifetime value by taking your margin off and subtracting what it costs to serve them. Both of those get their own section below.

What they spend per order

Total revenue for the last twelve months divided by the number of orders or invoices in the same twelve months. Not the number of customers. The number of transactions.

How often they come back

Total orders in twelve months divided by the number of separate customers who bought during those months. If 180 jobs came from 60 people, that is 3 orders per customer per year.

How long they stay

This one is harder, because it is a fact about the future, and it swings customer lifetime value more than the other two inputs do. If you know your yearly retention rate there is a shortcut: average lifespan is roughly 1 divided by your churn rate. Keep 70% of customers each year and you are losing 30%, so 1 ÷ 0.3 gives about 3.3 years. No retention figure yet? Use the age of your business and treat the answer as a floor rather than a forecast.

A worked example, run twice

Two businesses, one customer lifetime value formula, opposite conclusions.

A home cleaning business. The average visit invoices at $120. Customers book monthly, so 12 visits a year. They stay about three years. That is $120 × 12 × 3, or $4,320 of revenue. Wages and supplies eat roughly 60% of it, leaving about $1,730 of gross profit. Take off the admin cost of scheduling, rescheduling and the odd redo, call it $200 across the three years, and customer lifetime value lands near $1,500.

An online shop selling homeware. Average order $45. People buy three times a year. They stick around two years. That is $270 of revenue, and at a 50% product margin, $135 of gross profit. Shipping, returns and card fees take another $35 or so. Customer lifetime value is about $100.

Same arithmetic, and the two owners should behave completely differently. The cleaning business can spend $300 to win a customer and still be well ahead. The shop cannot spend $60 without losing money on the first two years of the relationship. Anyone giving both of them the same advice about ad budgets is guessing.

Where to find the numbers without an analytics team

This is the step the big customer lifetime value guides leave out. They hand you a formula and never say where the inputs live. For a small business, they are already sitting in something you pay for.

• Stripe or PayPal. The payments dashboard gives you total volume and the count of successful charges for any date range. Divide one by the other and you have average order value.
• Shopify, Square or another till system. The reports section usually works out average order value for you, and often returning customer rate as well.
• QuickBooks or Xero. Run a sales-by-customer report for the last twelve months. That one export gives you revenue, invoice count and unique customers together.
• A spreadsheet. Perfectly fine. Two columns, customer name and invoice total, one year of rows. Everything above falls out of a pivot table in ten minutes.

Do it by hand once before you buy any tool that offers to do it for you. The exercise teaches you more than the tool will, and you only need to repeat it a couple of times a year.

Subtract what it costs to serve them

Cost to serve is the piece that quietly drags customer lifetime value down, and serving a customer costs money long after the sale. Card fees, refunds and redos, the software you run, and the hours you spend answering questions.

The hours are the part nobody counts. Try it. If the average customer emails you six times a year and each one takes ten minutes to sort out, that is an hour a year. At a loaded cost of $25 an hour, that is $25 a year, or $75 across a three-year relationship. Against $1,730 of gross profit it is roughly 4%. Small, but it is 4% you could keep, and it grows in a straight line as you get busier.

The fix is rarely to answer faster. It is usually to turn those six emails into two, by writing down the answers to the other four so customers can find them without you. That is why a help center is a profit decision as much as a service one.

What to change once you know your customer lifetime value

Set a ceiling on what you pay for a customer

A common rule of thumb is to want customer lifetime value of at least three times what you paid to get them. With a $1,500 customer that leaves room up to about $500. With a $100 customer, about $33. It is a rule of thumb rather than a law, and if cash is tight you also want that money back inside twelve months.

Decide what a save is worth

When somebody threatens to leave, you now know what letting them go costs. A month free to keep a $1,500 customer is an easy yes. The same offer to keep a $100 customer is not. Our guide on how to reduce customer churn covers which saves are worth making and which ones just delay the exit.

Put the support money where people leave

Customer lifetime value goes up when customers stay longer, and customers mostly leave because something went wrong and nobody dealt with it. Harvard Business Review has cited estimates that winning a new customer costs five to twenty-five times what keeping an existing one costs. Treat that range as a direction rather than a precise figure, because it swings hard by industry. The direction is the useful part.

When customer lifetime value lies to you

• You are under two years old. You cannot measure a lifespan longer than your own history. Use what you have, label it a floor, redo it in six months.
• You have forty customers. One big account drags the average somewhere silly. Look at the median as well, or rerun it with the top and bottom 10% taken out.
• Your business is seasonal. Always use a full twelve months. Three months of a garden center's year tells you nothing about the other nine.
• You sell one big thing once. Roofers, wedding photographers, movers. For you, lifetime value is mostly referral value, so count the customers each happy customer sends instead.

None of that makes customer lifetime value useless. It makes it a range instead of a single point, which is all you needed from it anyway.

Where SupportifyGPT fits

We make support software, so read this bit knowing that.

Cost to serve is the half of customer lifetime value you control most directly, and your support bill decides whether that half stays predictable. A lot of help desks now charge per resolution, so the more questions your customers ask, the more you pay, and the cost of serving them moves every month. We priced out how per-resolution pricing behaves at small volumes, and it is rarely kind to a growing business.

SupportifyGPT is a flat bill instead. Starter is $15 a month for one seat, Growth is $39 for up to three, Enterprise is $79 for up to ten. Every feature sits on every plan, including the cheapest one: shared inbox, ticketing, live chat, a published help center and the support bot. Our flat monthly plans carry no per-answer fees and no ticket overages, so cost to serve is one line you divide by your customer count.

The support bot is worth explaining plainly, because it is the piece that turns six emails into two. Hand-written rules search your own help articles and pull out the likely ones. A model then reads those articles and answers in its own words, using only what you have written. If the answer is not in there, it says so and hands the customer to you. And when it drafts a new help article from a solved ticket, that draft waits for your approval before any customer sees it.

All of it runs on a free 14-day trial. For more on the growth side of this, our small-business growth posts cover retention and referrals in more depth.