FinDaS AI

Cohort analysis

What is a customer worth, and how fast does each channel pay back?

Cohort analysis: how many customers each month’s sign-ups keep, what a customer is worth, and how fast each channel repays its acquisition cost, so you know where to spend.

The answer

Payback and lifetime value by channel

Organic pays back in 4 months, referrals in 7 months and paid search in 17 months. Paid social does not pay back within two years: its customers bring back €76 less than they cost to win.

Fastest payback: Organic

4 months

€90 to win a customer, €603 of gross margin back over two years.

No payback: Paid social

−€76

A customer over two years: €540 to win, €464 of gross margin back.

What a customer is worth

€554

Gross margin over a customer's first two years, every channel together. Winning one costs €314 on average.

Per customer won: lifetime value and net are gross margin over 24 months
ChannelCost to winPaying after 12 monthsLifetime valuePaybackNet
Paid search€38063%€54217 months+€162
Paid social€54050%€464Not within 24 months−€76
Referrals€16073%€6677 months+€507
Organic€9067%€6034 months+€513

Run it

Change one channel's cost or churn

€540 to win one paying customer
Starter churn 7.0% a month, 1.4 × the company's average

Growth and Scale move in step; each monthly cohort varies a little around it.

Paid social does not pay back within two years: a customer costs €540 to win and brings back €464 of gross margin over two years.

Net value per customer, by channel

Paid searchPaid socialReferralsOrganicDashed line: break-even.
Across: months after a customer's first payment. Up: gross margin per customer won so far, less what a customer cost to win; above the dashed line, the channel has paid back. The thick line is the channel selected above.
The same data as a table
Net value per customer won, by month after the first payment
MonthPaid searchPaid socialReferralsOrganic
0−€380−€540−€160−€90
1−€357−€517−€137−€67
2−€334−€494−€113−€44
3−€310−€472−€89−€20
4−€287−€451−€65+€3
5−€263−€430−€41+€26
6−€240−€409−€17+€50
7−€216−€389+€8+€74
8−€193−€369+€34+€98
9−€170−€349+€59+€122
10−€147−€329+€86+€147
11−€125−€309+€112+€173
12−€102−€290+€140+€199
13−€78−€271+€167+€225
14−€56−€252+€196+€251
15−€34−€232+€225+€277
16−€11−€214+€256+€302
17+€11−€195+€286+€328
18+€34−€177+€316+€353
19+€55−€160+€346+€379
20+€77−€142+€377+€405
21+€98−€125+€409+€431
22+€120−€108+€440+€458
23+€141−€92+€473+€485
24+€162−€76+€507+€513

The cohorts

Share still paying, by month of sign-up

The latest 18 of 36 monthly cohorts, every channel together
Signed upWon1 mo3 mo6 mo12 mo
Mar 202515697%85%77%63%
Apr 202514296%91%79%65%
May 202515196%83%71%60%
Jun 202516495%85%75%62%
Jul 202514397%86%82%65%
Aug 202513996%87%75%67%
Sep 202514495%83%74%–
Oct 202515395%86%77%–
Nov 202515295%88%80%–
Dec 202515892%82%69%–
Jan 202615996%88%81%–
Feb 202613192%82%73%–
Mar 202613697%85%––
Apr 202614394%82%––
May 202615593%85%––
Jun 202616593%–––
Jul 202615095%–––
Aug 2026148––––
All 36 cohorts5,29895%86%76%62%

Won: customers who paid after the trial. 1, 3, 6 and 12 mo: the share of them still paying that many months after their first payment. A dash: the cohort is not that old yet.

How it works

The customers. A subscription software company with three plans, Starter at €29 a month, Growth at €99 and Scale at €299, after a one-month free trial that 25% of sign-ups convert from. Every customer starts on Starter. 600 trials start each month, from four channels, and each channel’s sign-ups in a month form a cohort: the model follows it month by month as customers pay, move plan, leave, and some come back within a year. The history is 36 monthly cohorts, from September 2023’s sign-ups to August 2026’s, each followed to the end of September 2026.

The four channels, as this demo sets them; the cost and churn are where the controls start
ChannelTrials a monthCost to win a paying customerStarter churn a month
Paid search200€3805.0%
Paid social160€5407.0%
Referrals80€1603.0%
Organic160€904.0%
Every channel6005.0%

Retention. The share of a cohort’s paying customers still paying a given number of months after their first payment. A customer who left and came back counts as paying again.

Lifetime value. The gross margin a customer brings in over their first 24 months of paying: each month’s revenue per customer won, times the 80% gross margin, added up. It is counted on gross margin, not revenue, because the 20% that serving a customer costs is not there to repay acquisition. It is per customer won, so a customer who left counts €0 from then on, and one who moved up counts at the higher price.

Payback. Payback months = acquisition cost ÷ (monthly revenue per customer × gross margin), with the revenue counted on the cohort’s surviving customers: the first month in which the gross margin per customer won adds up to what a customer cost to win. The simple version of the formula holds every customer at €29 a month, as if nobody left. For paid social it gives 24 months; counted on the customers who stay, paid social does not pay back within two years.

Pooling the cohorts. Each month of a channel’s curve pools every cohort old enough to have reached it: month 1 counts all 36 cohorts, month 24 the 13 oldest. The newest cohorts speak only for the first months.

What it does not cover. The cost to win a customer is each channel’s spend over the customers it won: brand spend, and customers who would have come without the channel, are outside it. It is the average customer’s cost, not what the next one would cost on a bigger budget. Margin after 24 months is not counted, and later margin is not discounted.

The same company elsewhere. The revenue forecast demo runs this company’s revenue forward from September 2026 on the same model.

Start here

Want payback by channel on your own customers?

Up to thirty minutes on your billing and marketing data, then a fixed proposal.

Book a free call