Cohort analysis

28 sec read

Cohort analysis is a good metric on how users engage to an application. To do this, you:

  1. Break the users into cohorts according to when they register (bin size usually a month)
  2. Count the number of users in each cohort who login in over time
  3. Plot it

What you can get:

  1. the number of users currently using the program (read the height of period 5)
  2. retention rate over time
  3. growth rate

EverNote ECO Phil Libin used this analysis to attract investors.


How to make the cohort analysis plot?

It’s actually simple. Use Excel. Prepare a table where each row is one cohort over time, and each column is a time point. Then click “insert” and “Stacked Area”.

cohort plot using Excel
cohort plot using Excel

Subscribe to my blog
Don't want to miss new papers in your field? Check out Stork we developed:

Record screen and convert to GIF

Stork has an update and we need to send an email to our users. In the email we wish to show a super short...
Xu Cui
43 sec read

Google Password Checkup, find which password is compromised

It’s not uncommon you hear news about data breaches of some big internet companies. If you happen to you use their services, your username/password...
Xu Cui
22 sec read

One Reply to “Cohort analysis”

Leave a Reply

Your email address will not be published. Required fields are marked *