Proven Founder

Cohorts for Beginners: How to Read Retention by Signup Month

· by Proven Founder

Short answer: A cohort table tracks how many users from each signup month stay active over time. By pulling signup and activity data into a spreadsheet, you can create a simple matrix that shows the number of active users in each month after signup. The first column lists signup months; subsequent columns show activity for those cohorts in later months.

Key takeaways

What a Cohort Table Looks Like

A cohort table shows how many people signed up in each month and how many of them remain active each month after that. It lets you see retention over time without mixing new and old customers.

The first column lists signup months. Each row below that column contains the active count for the cohort in successive months. The top row, after the signup month column, shows the first month of activity, the next cell the second month, and so on. The diagonal across the table follows a cohort as it ages.

Pulling the Data into a Sheet

Export your signup logs and active user counts to CSV and open them in a spreadsheet. Keep the data tidy: one row per record, dates in a consistent format, and a column that marks whether the user was active in a given month.

Create a column that groups signups by month. In a new sheet, list each signup month once. Then use a COUNTIF or a pivot table to tally how many users from that month appear as active in each subsequent month. Copy the formulas across so that the table fills automatically.

Filling in the Numbers

Write the count of new users for each signup month in the first column. In the second column, paste the number of those users who were active in their first month. Continue filling rightward for the second month, third month, and so forth.

To get the active counts, filter the raw data for users from the signup month, then count how many rows contain an active flag for each later month. Many spreadsheet programs offer a simple SUMIFS that matches two criteria: the signup month and the month of activity.

Reading the Drop-Off Curve

The diagonal of the table follows a cohort as it ages. Each cell on that diagonal shows how many users from the original signup month are still active after a specific number of months. A steady decline on the diagonal points to a natural drop in early interest.

After the first few months, the decline usually slows. If the drop keeps going at the same pace for a long stretch, the cohort is losing momentum. If the rate levels off, the remaining users are likely to stick around.

The One Pattern That Matters

The key signal is a plateau that appears after the early dip. When retention stops falling sharply and stays roughly constant for several months, it shows that the product keeps a core of users engaged. That plateau is a good sign for growth.

Track the plateau each month and compare new cohorts to see if it shifts. If it drops again, investigate what changed. If it stays steady or rises, celebrate the effort and focus on scaling the same experience to new users.

Questions people ask

What does the first column in a cohort table represent?

The first column lists the month in which each group of users signed up. It anchors the table, letting you follow that group month-by-month without mixing in new signups that appear later.

How do I know if my retention is healthy?

Look for a drop in the first month that levels off after a few months. If the number of users stays flat or rises for at least two or three months after the initial dip, it usually means the product keeps people interested. If it keeps falling, you may need to adjust.

Do I need special software to create a cohort table?

A simple spreadsheet is enough. Use built-in functions like COUNTIF, SUMIFS, or a pivot table. No advanced tools or external services are required. You just need clean data and a few formulas.

How often should I update my cohort table?

Update it when you have a new month of data. A monthly update keeps the pattern current and lets you spot changes quickly. If you have a lot of churn, you may choose to review it more often, but the table is most useful when it reflects the latest month.

A Proven Founder page shows activity read from a founder's own tools, and the method page explains what it can and cannot prove. /verified

This post was written by an AI model for Proven Founder and checked by automated rules before it was published: no statistics, no quotes, no claims about what any company said. If something is wrong, write to hello@provenfounder.com and it will be fixed or removed. Plain-text version.