How to build a cohort retention report

A cohort retention report is the clearest way to see whether your product is getting stickier over time. By grouping customers by when they joined and following each group, you separate improvement from noise.

The magic is in comparing cohorts. If newer cohorts retain better than older ones, your onboarding and product are improving; if they retain worse, something is degrading even as top-line grows.

Short answer

Build a cohort retention report by grouping customers into cohorts by their start month, then tracking what share of each cohort's revenue (or customers) remains in each following month. Plot the retention curves to see whether newer cohorts retain better than older ones and where revenue stabilizes or keeps declining.

Step by step

  1. Define cohorts by start period

    Group customers by the month or quarter they first paid. Each cohort is followed as a fixed group over its lifetime.

  2. Choose revenue or logo retention

    Track either the share of customers retained or the share of revenue retained. Revenue cohorts capture expansion and can exceed 100 percent; logo cohorts show pure survival.

  3. Measure retention each period

    For each cohort, compute what percentage remains in month 1, 2, 3, and so on after start. Lay these out as a grid, cohorts down, periods across.

  4. Plot and compare the curves

    Graph each cohort's retention curve. A curve that flattens means you have found a sticky base; one that keeps declining means customers never stabilize. Compare newer to older cohorts for the trend.

How to read the curves

A healthy retention curve drops in the early periods, then flattens as the committed core remains. The flattening point and level tell you your true long-term retention. A curve that never flattens signals a product that does not retain.

Revenue cohorts can curve upward above 100 percent when expansion outpaces churn, the visual signature of net revenue retention above 100 percent. That upward curve is the best sign in SaaS.

How Ardovo handles it

Ardovo builds cohort retention grids and curves from live billing automatically, in both revenue and logo terms. Rook compares newer cohorts to older ones and flags when retention is degrading, so you catch a slipping onboarding before it hits the P and L.

Frequently asked questions

What is a cohort retention report?

A view that groups customers by their start period and tracks how much of each cohort's revenue or customer count remains over time. It reveals whether retention is improving and where revenue stabilizes.

Should I use revenue or logo cohorts?

Both are useful. Logo cohorts show pure customer survival; revenue cohorts capture expansion and can rise above 100 percent when upsell beats churn. Revenue cohorts best reflect the economics of the base.

What does a good retention curve look like?

It declines in the early periods, then flattens as the committed core remains, ideally at a high level. Revenue cohorts that curve upward past 100 percent are the strongest sign, reflecting net revenue retention above 100 percent.

Keep reading

Get started with Rally or browse all pages.