Cohort-based LTV tracking: let customer value set your CAC limit

Average LTV tells you how good your old customers were, not what your new customers are worth. Cohort tracking shows what each acquisition month really returns, and therefore what you can afford to pay.

Cohort-based LTV tracking means grouping customers by the month of their first purchase and following how much revenue each group adds in the months after. It sounds like bookkeeping, but it produces one of the most strategic numbers in your business: your cohort curves determine what a new customer is really worth, and therefore the maximum you can afford to pay to acquire one.

What exactly is cohort-based LTV tracking?

A cohort is simply the group of customers who bought from you for the first time in the same month. The January cohort, the February cohort, and so on. For each cohort you track cumulative revenue per customer: what the first order was worth, what has been added after one month, after three, after six. Stack those lines and you see two things you will not find anywhere else: how quickly a customer builds up value, and whether your new customers are getting better or worse than your old ones.

That second point is where it gets really interesting. Growth changes your customer base. New channels, new markets, new offers: every cohort reflects the acquisition of its moment. A brand that scales up and sees its cohorts weaken knows something is off in the inflow long before it shows up in the totals.

Why is average LTV misleading?

Most founders know their LTV as a single number: total revenue divided by total customers. That number blends the loyal customer from your early years with the customer who came in through a discount code last week. It says something about your past, but nothing about the question that matters today: what is the customer worth that I am acquiring with ads this month?

Base your bids on average LTV and you are structurally making one of two mistakes. Either you overestimate your new customers, because the average is inflated by years of loyalty that new cohorts may never reach, and you overpay per acquisition. Or you underestimate them, because recent cohorts repeat faster than the old ones did, and you leave growth on the table by bidding too cautiously.

Basing your CAC limit on average LTV is steering by the rearview mirror.

How do you set up cohort tracking?

You do not need a data team or an expensive dashboard. The minimum setup runs on an order export and a spreadsheet, and for most brands that is more than enough to steer on for the first years.

• Export all orders with customer ID, order date and order value from your shop or order platform.
• Determine each customer's first purchase date: that month is their cohort.
• Group all revenue per cohort and per month since first purchase, and make the amounts cumulative.
• Divide by the number of customers in the cohort, so you see cumulative revenue per customer over time.
• Refresh the overview monthly and put the newest cohort next to the previous ones every time.

One important detail: switch from revenue to margin as soon as you use the numbers for bidding decisions. Revenue LTV flatters the ego, but your ads are paid out of gross margin. Subtract product and fulfilment costs per cohort and you have the number you can actually steer on.

How do cohorts set your CAC limit?

Two numbers from your cohort curves together define your maximum CAC. First the build-up: how much margin a customer generates cumulatively after one, three and six months. Second your payback period: how long you can and want to wait for a customer to pay back their acquisition cost. That last one is a cash flow decision. A brand with healthy reserves can bid on six-month value, while a brand that needs to reinvest every euro immediately has to stay closer to the first order.

The outcome changes how you look at your paid social account. A campaign that looks mediocre on first-order ROAS can be comfortably profitable once you count the cohort's repeat value. And the reverse: a campaign that rakes in cheap first orders from customers who never return is worse than it looks. You stop steering on today's dashboard and start steering on the cohort's curve.

Cohorts also expose the effect of promotions. Customers who came in through a heavy discount often show a different curve in the months after than customers who paid full price. Only when you put those groups side by side do you see whether a promotion built real customer value or just scored a cheap first order that pollutes your averages.

Conclusion

Cohort-based LTV tracking takes an afternoon to set up and changes every bidding decision you make afterwards. You know what a new customer is really worth, how fast that value builds, and therefore how much you can pay while your competitor is still staring at first-order ROAS. Translating customer value into daily media buying decisions is exactly how we run paid social for brands: bidding on what a customer is worth, not on what the dashboard shows today. Curious how much room your CAC limit really has? Book a call and we will gladly take a look with you.