- Blended metrics mix your best old customers with your newest ones — repeat rate can look stable for months while every new cohort is worse than the last.
- Three splits do most of the work: acquisition month (health trend), first product (which SKU creates loyalists), acquisition channel (who sends buyers vs tourists).
- The action isn't reporting — it's re-pricing acquisition: two channels with identical CPAs can deserve completely different budgets once cohort quality is priced in.
A brand's blended repeat rate held at 31% for three straight quarters — stability everyone read as health. The cohort view told the real story: customers acquired 18 months ago repeated at 45% and were slowly aging out, while last quarter's cohort was repeating at 19%. The blend averaged a strong past against a weak present. By the time the blended number finally moved, the damage was six months deep.
What a cohort actually is (fifteen seconds)
A cohort is every customer who did a thing in the same window — usually "first order in June." You then follow that group forward: how many bought again by day 30/60/90, what their cumulative contribution looks like. Nobody enters or leaves the group, which is exactly why it can't lie the way an average can.
View 1 — by acquisition month: is the machine improving?
| Cohort | Buyers | Repeat by day 90 | Contribution/buyer by day 90 |
|---|---|---|---|
| February | 1,140 | 27% | ₹492 |
| March | 1,380 | 24% | ₹455 |
| April | 1,905 | 20% | ₹410 |
| May | 2,450 | 16% | ₹360 |
Read the diagonal: volume doubling while day-90 quality drops a third. This is the signature of scaling into weaker audiences — each incremental rupee buys a worse customer. Blended dashboards celebrate this exact chart ("record new customers!"). The cohort view prices it: May's buyers are worth ~27% less each, so May's real CAC ceiling should have been ~27% lower. Was it?
View 2 — by first product: which SKU creates loyalists?
From a real audit: buyers whose first order was the mango product repeated at roughly twice the rate of buyers who entered on honey. Same store, same ads budget — one entry product creates customers, the other creates transactions. The implications cascade: hero the loyalist-maker in prospecting creatives, gate the tourist product behind bundles, and judge campaigns by which product's buyers they recruit, not just how many.
View 3 — by channel: who sends buyers vs tourists?
| Channel | CPA | 90-day repeat | 90-day contribution | Verdict |
|---|---|---|---|---|
| Meta prospecting | ₹1,100 | 24% | ₹520 | Real customers — defend it |
| Google brand | ₹350 | 38% | ₹640 | Great cohort, but see incrementality — many were coming anyway |
| Discount-code influencer | ₹700 | 9% | ₹310 | Cheap tourists — the CPA is a trap |
The middle column is the one platforms will never show you, because order two happens outside their window and off their properties. Two channels at identical CPA can deserve opposite budget decisions — cohort quality is the missing price tag.
Reading a cohort triangle without a data team
- Down a column (same age, successive cohorts): the machine's health trend. Down-and-worsening = the February–May table above.
- Along a row (one cohort aging): where repeat flattens — that's your realistic LTV horizon, not the aspirational one.
- The two traps: judging young cohorts too early (give them 60–90 days), and celebrating a great month that was really one viral spike of tourist buyers.