Home > web > Cohort analysis

Cohort analysis

February 16th, 2011

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.

Source: http://disruptivegrowth.wordpress.com/2010/07/12/running-the-numbers-cohorts/

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

Author: Xu Cui Categories: web Tags:
Try Stork, a research tool we developed

Stork is a publication alert app developed by us at Stanford. As a researcher we often forget to follow up important publications - and it's practically impossible to search many keywords or researchers' names everyday. Stork can help us to search everyday and notifies us when there are new publications/grants. How Stork helped me?

About the author:

Xu Cui is a human brain research scientist in Stanford University. He lives in the Bay Area in the United States. He is also the founder of Stork (smart publication alert app), PaperBox and BizGenius.


He was born in He'nan province, China. He received education in Beijing University(BS), University of Tennessee (Knoxville) (MS), Baylor College of Medicine (PhD) and Stanford University (PostDoc). Read more ...
  1. Mark M Whelan
    July 28th, 2014 at 21:52 | #1

    very clear explanation, thank you..