5 Replies Latest reply on Sep 3, 2015 1:35 PM by nbussard

Canned "Cohort Analysis" Report?

neilmussett Jul 3, 2014 8:29 AM

Reading Eric Ries article on "Vanity Metrics vs. Actionable Metrics" got me inspired to create a "Cohort Analysis" report for our installation of Jive.

The idea is to group your users according to when they joined (week or month), then track a percentage of users still active within that group (defined as "having logged in in the past X days"). This tracks how "Sticky" Jive is within your organization.

It was not too difficult, and it led to some very meaningful insights (e.g. Jive is hard to learn, and it takes about 33 weeks for people to make a place for Jive in their daily work lives). Seems like this kind of report would be a very compact way for group owners to manage their metrics.

Ted Hopton's post touched on the issue: Actionable Analytics Presentation JW2010

PS. The mechanics:

Every week (or month), produce a report that lists each user, along with the creation date, the last logged in date, and any demographics that you want use to break down the numbers.
Group users by the week (or month) they joined Jive
Calculate a percentage of users in that grouping that are still active. This is your "retention rate" (and the converse is your "churn rate")

Re: Canned "Cohort Analysis" Report?

RyanSe Jul 17, 2014 8:08 AM (in response to neilmussett)

Yep. I've done something very similar to this on our support site to get a feeling for how much of a retention rate we have and to baseline any changes/improvements we make to the experience.

Internally we don't really have much need for it since folks don't visit either from a) attrition (they've left) or b) they aren't in the intended audience.

Good stuff though.

Ryan
1 person found this helpful
Like (1)

Actions
- Re: Canned "Cohort Analysis" Report?
  
  neilmussett Jul 17, 2014 8:36 AM (in response to RyanSe)
  
  When you say that they aren't in the intended audience, are you saying that you have a very specific targeted audience for Jive? We are trying to promote Jive in our own company as something that should be "bigger than email", so we are trying to cast a pretty wide net.
  
  Like (0)
  
  Actions
  - Re: Canned "Cohort Analysis" Report?
    
    RyanSe Jul 17, 2014 1:06 PM (in response to neilmussett)
    
    Correct. T-Community (our internal community) is intended for front line employees like our call center and store employees plus the staff that support them. Other groups such as Engineering, IT, HR, etc are not in scope for us at this time.
    
    We primarily do this to keep the results super clean for this audience (T-Community is their primary resource for news/content/etc to support customers and other audiences tend to clutter things up).
    
    Like (1)
    
    Actions
Re: Canned "Cohort Analysis" Report?

neilmussett Jan 2, 2015 6:58 AM (in response to neilmussett)

Bump!
Like (0)

Actions
Re: Canned "Cohort Analysis" Report?

nbussard Sep 3, 2015 1:35 PM (in response to neilmussett)

HI Neil,
I'm wondering if you're still using this report and whether you've been able to take any actions to move the numbers.
Like (0)

Actions

Go to original post