AdvancedLesson 22 of 305 min read

CAC, Lifetime Value and Payback

Work out what a customer costs to win, what they bring over time, and how long it takes to pay back, with a worked example that follows a cohort of 100 customers month by month.

In this lesson you will

  • Compute CAC for each channel
  • Estimate lifetime margin per customer
  • Find payback in orders and months
  • Read a cohort of customers over time

About 26 minutes

A profitable order is not a profitable customer

Noor’s Facebook advert wins a customer for 20 pounds. Her average order leaves 8.10 pounds of margin. By the maths of lesson 7 she is losing money on each order. But some of those customers will buy again, and again. Is the advert a mistake or an investment? The answer needs three ideas that every growing business uses: customer acquisition cost, lifetime value and payback.

Three numbers

  • CAC. What you spend to win one new customer: spend divided by new customers.
  • Lifetime value. What a customer brings over the time you care about. The safest version counts margin, not revenue, because only margin pays your bills.
  • Payback. How long, or how many orders, it takes for a customer’s margin to cover what it cost to win them.

The program below uses made-up numbers for three channels. The average order is 18 pounds with a 45 per cent margin, and the typical customer places three orders. It works out each channel’s CAC, the lifetime margin divided by CAC, and the number of orders needed to pay back. After that, it follows a group of 100 new customers through six months of repeat buying, to find the month in which their margin covers a 12 pound cost.

# MADE-UP numbers, in pounds
spend = {"newsletter": (30.0, 14), "instagram": (60.0, 20), "facebook": (240.0, 12)}   # spend, new customers
aov, margin_rate, orders_per_customer = 18.0, 0.45, 3.0
margin_order = aov * margin_rate
ltv = margin_order * orders_per_customer
print("margin per order:", round(margin_order, 2))
print("lifetime margin per customer:", round(ltv, 2))
for ch, (sp, cust) in spend.items():
    cac = sp / cust
    print(f"{ch}:")
    print(f"  cost to win a customer {cac:.2f}")
    print(f"  lifetime margin / cost {ltv / cac:.1f}")
    print(f"  orders to pay back {cac / margin_order:.1f}")

# cohort of 100 customers: orders in each month after joining
orders = [100, 38, 22, 14, 10, 8]
cac = 12.0
cum = 0.0
payback = None
for m, n in enumerate(orders):
    cum += n * margin_order / 100
    if payback is None and cum >= cac:
        payback = m
print("margin per customer after 6 months:", round(cum, 2))
print("paid back in month:", payback, "(0 = first)")
print("customers still buying in month 5:", orders[-1], "of 100")
margin per order: 8.1
lifetime margin per customer: 24.3
newsletter:
  cost to win a customer 2.14
  lifetime margin / cost 11.3
  orders to pay back 0.3
instagram:
  cost to win a customer 3.00
  lifetime margin / cost 8.1
  orders to pay back 0.4
facebook:
  cost to win a customer 20.00
  lifetime margin / cost 1.2
  orders to pay back 2.5
margin per customer after 6 months: 15.55
paid back in month: 2 (0 = first)
customers still buying in month 5: 8 of 100

Each order leaves 8.1 pounds, so the lifetime margin per customer is 24.3 pounds. Look at the ratio of lifetime margin to the cost of winning a customer. The newsletter gets 11.3 and Instagram 8.1, which is excellent. Facebook, at 20.00 pounds a customer, gets only 1.2. It needs 2.5 orders to pay back, so it breaks even only if the customer comes back, which most of them do not. In the cohort, buying drops quickly: only 8 of the 100 customers are still buying in month 5. The group’s margin reaches 12 pounds in month 2, counting the first month as 0, and after six months it is 15.55 pounds per customer. That is the lesson: repeat buying, not the first order, is what makes paid acquisition pay, and you should measure it for real instead of assuming it.

Rules of thumb, and their limits

  • You will hear that lifetime value should be several times the cost to win a customer. Use such rules as a rough guide, not a law: the right ratio depends on your margins, your cash and how sure you are of repeat buying.
  • Cash matters. A slow payback ties up money you may need now.
  • Use cohorts, groups who joined in the same month, so that a good recent month does not hide a decline.
  • Count real margin: product cost, delivery, fees and returns.
  1. Work out margin per order, including every cost.
  2. Find repeat-buying rates from real cohorts, even if they are small.
  3. Compute CAC for each channel from spend and new customers.
  4. Compare lifetime margin and payback, and decide what you can afford.
  5. Review quarterly, because rates change.
Common mistake: assuming loyalty

Using a hopeful repeat rate to justify a loss-making advert. If you assume that customers will return three times, any advert looks fine. Use your own numbers, and be careful with small samples.

Small shops, small samples

All figures are made up. A small shop may have only a few customers in a cohort, so treat the result as a hint, and keep learning from each new month.

Take your own average margin per order and average orders per customer. Work out your lifetime margin, and the most you could pay to win a customer and still break even.

Practice for this lesson

Check what you learned

Five quick questions. Pick an answer and you will see straight away whether it is right and why.

What is CAC?

  1. Cost per click
  2. Spend to win one new customer
  3. Cost per post
  4. A profit measure

Customer acquisition cost is spend divided by new customers.

Why count margin, not revenue, in lifetime value?

  1. Margin is bigger
  2. Revenue is banned
  3. Only margin pays your bills
  4. It is simpler

Revenue includes costs you already paid.

What made Facebook look weak in the sample?

  1. Lifetime margin was only a little above cost
  2. It had no clicks
  3. It was free
  4. It had no customers

Its ratio was around 1.2.

What does a cohort show?

  1. One order
  2. A single channel
  3. How a group joining together behaves over time
  4. Total visits

Cohorts follow groups who started at the same time.

What makes paid acquisition pay in the sample?

  1. Repeat buying
  2. More clicks
  3. Bigger images
  4. Longer ads

The first order did not cover the cost; later ones did.

Summary

  • CAC is spend divided by new customers.
  • Lifetime value should count margin, not revenue.
  • Payback shows how long a customer takes to cover their cost.
  • Use cohorts and your own repeat-buying data.

Next lesson

Lesson 23 covers marketing automation and lead scoring.

Questions

What is a good LTV to CAC ratio?

Rules of thumb exist, but the right ratio depends on your margins, cash and confidence in repeat buying. Use your own data.

How do I measure repeat buying with few customers?

Follow each month's new customers for as long as you can, and treat the figures as hints until you have more.

Are the numbers real?

No. They are made-up sample numbers in pounds to show the method.

Progress is saved in this browser.