Step 1: Get the number of signups in a specific month
Step 2: For these users who signed up in this specific month, calculate how many were active each month after the first month.

Month 0 has all users active by definition. For subscription products, measure how many users are still subscribed.
Step 3: Convert these to percentages of the original users in the cohort.

In google sheets it is easy to make this a separate chart that refers to values in the previous one.
Step 4: Apply steps 1-3 to your other cohorts
You will notice that the retention rate between cohorts generally stays around the same.

It’s hard to increase retention! Now you can apply an average at each column and get a range of where the values level off.
Cohort retention benchmarks to aim for long term:

Consumer free products: 40%
Consumer subscription products: 50%
B2B selling to Small businesses: 60%
B2B selling to Enterprise: 90%
If the dropoff is in the first week or month, then activation and onboarding should be the priority.

If the dropoff is later on, then product work needs to be done to solve a more sticky user problem.
You can follow @JeffChang30.
Tip: mention @twtextapp on a Twitter thread with the keyword “unroll” to get a link to it.

Latest Threads Unrolled:

By continuing to use the site, you are consenting to the use of cookies as explained in our Cookie Policy to improve your experience.