What is cohort analysis in simple terms?
Cohort analysis groups users who share an entry point, such as the month they signed up or the first action they took, and tracks that fixed group forward through time. Instead of looking at a single blended average that mixes new and mature users, you watch how a specific group behaves at month one, month two, month three, and beyond. The output is usually a triangle chart where each row is a cohort and each column is the age of that cohort. The pattern across the rows and columns is the picture of how the business actually retains, expands, or leaks.
Why is cohort analysis important for SaaS?
SaaS businesses depend on recurring revenue, and recurring revenue depends on retention. Blended retention numbers in a growing SaaS company look fine right up until acquisition slows, at which point the underlying decay becomes visible and the plan unwinds. Cohort analysis exposes the decay the day it begins by separating this quarter from last quarter and tracking each separately. It is also the only honest way to measure product changes, onboarding improvements, and channel quality, because each lives in its own cohort and compounds forward.
What are the three main types of cohorts?
The three primary cohort types are retention cohorts, acquisition cohorts, and behavioral cohorts. Retention cohorts group users by the period they signed up, usually weekly or monthly, and track survival over time. Acquisition cohorts group users by the channel or campaign that brought them in. Behavioral cohorts group users by a shared early action, such as inviting a teammate or hitting an activation event. Each type isolates a different variable: time, source, and behavior. Most teams run at least two of the three in parallel because they answer different questions about the same base.
How do you read a cohort retention curve?
A healthy cohort retention curve drops quickly in the first few weeks as unactivated users leave, flattens as the sticky core settles in, and holds steady at a stable floor over the long term. The height of that flat floor is the asset you own. In the strongest businesses the curve eventually bends upward because expansion inside the cohort outruns churn, producing a smile shape. Comparing cohorts to each other diagonally, same age across different signup months, reveals whether each new cohort is retaining better or worse than the one before it.
How do you set up cohort analysis?
Setup requires three things: a clean definition of the cohort entry event, a stable user identity that persists across sessions, and timestamped activity records for each user. Once those are in place, any analytics or CRM tool can pivot the records into the standard cohort triangle, with signup period on the rows and age on the columns. The important work is not the chart; it is the plumbing. Define the entry event precisely, fix the identity before you grow, and log every activity that counts as an active user. The pivot is the easy part.
What is the difference between a cohort and a segment?
A segment is a static slice of users defined by shared attributes, such as all customers on the Pro plan or all accounts in healthcare. A cohort is a group defined by a shared entry point in time or behavior, and the group is tracked forward from that moment. A segment is a who. A cohort is a who and a when. Many analyses combine the two: compare the retention cohort for Pro plan signups in January against the Pro plan cohort in April. The segmentation lets you compare apples to apples, and the cohort gives you the forward motion.
Can cohort analysis be done in a spreadsheet?
Yes, cohort analysis started in spreadsheets and still works there for small datasets. The requirement is one row per user with a signup date, and columns for whether that user was active in each subsequent period. A pivot table can turn those columns into the standard triangle chart. The reason modern businesses move off spreadsheets is not that the math gets harder; it is that the data refresh gets painful. A CRM or analytics tool that pivots live records produces the same chart automatically every week, which is the point.
How does a CRM support cohort analysis?
A CRM is the system of record for signups, activity, pipeline, and revenue, which are exactly the inputs cohort analysis needs. A CRM built for the full revenue motion carries the signup date on the account, logs activity to the timeline, tracks the subscription state and plan changes, and can pivot those records into retention and revenue cohort charts without a separate BI tool. Cohort regressions can even fire workflows that open tasks for the owning team, turning the analysis into an operating input instead of a quarterly review slide.