Cohort Analysis for SaaS Marketers

Most marketing teams find out a channel was bad about nine months too late. The spend looked efficient, the leads converted, the pipeline closed, and then the renewals did not happen. Cohort analysis is how you see that coming in month four instead of month fourteen. It is also the single analytics skill that gets skipped in almost every marketing career path, which is why so many budget decisions still rest on cost per lead.

What a cohort actually is, and the three kinds that matter

A cohort is a group of customers who share a starting condition and are then measured over identical time windows. That last part does the work. Comparing January’s customers at month six against June’s customers at month one tells you nothing, which is exactly the error a blended churn number makes.

Three cohort types answer three different questions, and mixing them up is the usual reason a cohort deck lands badly in a leadership meeting.

Acquisition date cohorts are the default in every billing tool. They are useful and slightly boring. If March 2026 signups retain better at month six than March 2025 signups did at month six, something in the product or onboarding improved. That is a real finding, and it belongs to product more than to marketing.

Channel cohorts are the ones marketers should be building and almost never are. Behaviour cohorts sit in the product analytics tool and matter most for lifecycle messaging, which is where the SaaS metrics and analytics work overlaps with campaign design.

How to read a retention curve without fooling yourself

A retention curve plots the share of a cohort still active or still paying at each month of age. What you are looking for is not the starting number. It is the point where the curve stops falling.

That flattening point is the whole argument. A curve that flattens at 55 percent in month seven means you have a durable base of 55 percent, and lifetime value is a real quantity you can calculate. A curve still sloping downward at month eighteen means there is no durable base yet, and every LTV figure in your board deck is an extrapolation of a line that has not stopped moving.

Two practical rules. First, always plot logo retention and revenue retention on the same chart. In B2B they diverge fast, and the gap is the expansion story that the NRR expansion levers playbook is built around. Second, never average curves across plan tiers. A self serve tier bleeding out at month three and an enterprise tier holding flat at 94 percent produce a blended curve that describes no actual customer.

Cohorting CAC by month catches rising acquisition cost early

Blended CAC hides the trend that matters. Calculate CAC per monthly acquisition cohort instead: total sales and marketing spend attributed to that month, divided by new customers acquired in that month. Then plot twelve of those in a row.

What you usually see is a slow upward drift as the cheapest demand gets exhausted, punctuated by a step change when a channel saturates. Catching the step change in the month it happens is worth more than any quarterly review. If your paid search CAC moved from $4,100 to $5,600 across four cohorts while conversion rates held steady, the auction got more expensive and your payback math needs redoing before the next budget cycle, not after.

Pair the CAC cohort with the revenue cohort and you get payback by cohort, which is the number that should gate spend increases. Our marketing budget calculator handles the arithmetic if you want to stress test what a CAC drift of 20 percent does to a plan, and the sales and marketing spend benchmarks give you something to compare against by ARR band.

The cheap channel that turns out to be the expensive one

Here is the pattern that makes this whole exercise worth the effort. Two channels, same quarter, same product.

Channel	CAC	Month 12 logo retention	Month 12 net revenue retention	Effective 12 month CAC per retained dollar
Paid social, broad targeting	$2,800	41%	58%	Poor
Organic search, BOFU pages	$4,300	72%	104%	Strong
Partner referral	$3,100	78%	118%	Strongest
Review sites, paid placement	$5,900	64%	91%	Acceptable

The paid social cohort is 35 percent cheaper to acquire and generates 46 points less net revenue retention twelve months in. On a first order CAC view it is the best channel in the account. On a cohort view it is the worst, and scaling it would have made the business worse while every dashboard said otherwise.

Why does this happen? Broad paid targeting reaches people with a vague problem, and vague problems do not survive a renewal conversation. BOFU search reaches people already comparing vendors, which is a stronger buying signal and a better fit filter. This is the same logic that makes comparison and alternatives pages convert well, and it is why channel quality belongs in the same conversation as channel cost.

We doubled the cheapest channel for two quarters and our net revenue retention fell six points. Nothing in the acquisition dashboard warned us.

My position: judge channels on month 6 and month 12 cohort revenue retention before you scale, and treat first order CAC as a sanity check rather than a verdict. If you only have six months of data, use month 6 and be honest that it is provisional.

The minimum data and tooling to run this properly

You need less than people think. Three fields get you started: an account id, a cohort assignment date, and a monthly revenue row per account. Add a channel field and you have channel cohorts.

Where teams get stuck is the join. Billing data lives in Stripe or the billing system. Channel data lives in the CRM or an ad platform. Behavioural data lives in Amplitude or Mixpanel. Nobody owns the key that ties them together, which is why a marketing tracking plan matters more than the choice of analytics tool.

Start with the spreadsheet. Genuinely. A single quarter of channel cohorts in a spreadsheet has changed more budget decisions than most warehouse projects, and it tells you whether the warehouse project is worth funding. If you are choosing between product analytics tools for the behavioural side, our Mixpanel vs Amplitude comparison covers where each one wins on cohort building specifically.

For the channel attribution field itself, decide early if you are using platform reported source, a first touch CRM field, or a self reported “how did you hear about us” question. They disagree, often by a lot. The B2B SaaS attribution tools roundup covers the tradeoffs, but the short version is that self reported data is better than most marketers expect and worse than finance wants.

What cohort analysis costs you, and where it misleads

The honest tradeoff: this takes time you currently spend on campaigns, and it produces answers slowly. A twelve month cohort takes twelve months. There is no shortcut, and any vendor promising one is selling a model, not a measurement.

Three failure modes worth naming.

• Small cohorts produce noise. Under roughly 30 accounts in a cohort, a single churned enterprise logo swings the whole line. Group quarterly instead of monthly at low volume.
• Mix shift fakes improvement. If your enterprise share grew, blended cohorts improve without anything actually getting better. Always segment before you celebrate.
• Cohort tables invite cherry picking. Somebody will find the one good row. Agree in advance which cell you are judging on.

Cohort work also has a reporting cost. Most executives have never read a triangle table and will read the wrong cell. Convert to curves for the board deck and keep the table for the working session. A standing view in your marketing dashboard with two lines, month 6 and month 12 revenue retention by channel, does more than a full triangle nobody opens.

What to do this week

Pull a CRM export with account id, first paid date, acquisition channel and monthly revenue for the last eighteen months. Build one triangle in a spreadsheet, grey out the incomplete cells, and split it by channel. Then check the month 6 column against the CAC for each channel and see whether your cheapest channel is actually your cheapest channel.

If the answer surprises you, run the same view with the NRR and churn calculator to size what a five point retention difference is worth in annual revenue. That number is usually what gets the warehouse project funded.