A founder asks for lifetime value at 90 days, 180 days, a year, and all time. Someone runs a report, four numbers come back, and the room nods. Often all four are wrong, and even the right ones answer the wrong question.

The report that looks like cohort LTV and isn’t

I’ve seen the same mistake on more than one client account. A store’s reporting tool is asked for “90-day, 180-day, 365-day and lifetime LTV.” What comes back is four calendar windows stacked back from today: revenue from customers active in the last 90 days, the last 180, and so on. Customer counts rise as the windows get longer.

That’s the tell. In a real cohort table, the count should fall as you require more age: fewer customers have had 365 days since their first order than have had 90. If the counts go up, you’re looking at windows, not cohorts, and the averages mix new customers with old ones.

The fix is to rebuild from a customer export that has each customer’s first-order date, order count and lifetime spend. Group by first-order month. Then you can see the real curves. Appendix A has the fields.

The number under the average

Once the data is clean, split customers by how many orders they’ve placed. On most DTC brands, the shape is the same: a large majority ordered once, and a minority of repeat buyers carries a disproportionate share of revenue.

Made-up numbers, typical shape. The average customer here is worth $150. Nobody is worth $150. The one-timers averaged about $74; the repeat buyers about $328.

Manage the one-and-done rate. The average is a blend of two different businesses.

Why this is an offer problem

The one-and-done rate is partly a retention problem, which The Second Order covers. It’s also an acquisition problem, because the first offer chose who is in that 70%. A first offer that brings buyers who were never going to return raises the rate no matter how good your flows are. The door table from the last chapter tells you which first products feed it.

It’s also the clearest way to price the second offer. Every one-time buyer you turn into a two-time buyer is worth roughly the difference between the two groups’ averages, before margin. That turns “improve retention” into a number per customer, and it tells you how much a second offer can afford to give away (chapter 15).

Two motions, not one

From my work: the same split usually shows a second fact. Revenue among repeat buyers is lopsided too. A small top slice of customers, often around a tenth, carries a large share of all revenue, and the very top few hundred people can matter more than whole acquisition months. That produces two retention motions with different economics, and they shouldn’t share a calendar, a creative team or a scorecard.

1. The one-timer motionMany customers, low value each, most of them never coming back on their own. The job is the first repeat: a reason, a default, a well-timed second offer, a winback that leads with what changed (chapter 18). Measured on the share who cross from one order to two, against a holdout.
2. The top-customer motionFew customers, high value each, most of them already loyal. The job is to keep them: service, recognition, first access, no discounts (chapter 17). Measured on how many of the top slice you lose each quarter, which should be close to none.

Mixing them is how brands end up sending their best customers the winback code meant for people who left. It’s also how the one-timer motion gets starved: the top customers produce most of the revenue, so they get most of the attention, and the largest group in the file gets a monthly newsletter.

The first offer feeds one of these motions more than the other. A first offer that brings collectors feeds the top; a first offer that brings deal-seekers feeds the one-timers. Knowing which one your offer feeds is what lets the retention team plan for the customers acquisition is actually sending them.

Run your numbers

Do this

• Check whether your LTV report is cohorts or windows: do the customer counts rise or fall as the window lengthens?
• Run the calculator on a clean export and put the one-and-done rate on the same page as your ROAS target. They’re the two numbers the first offer moves.