Cohort Analysis in Tableau: User Retention Given Only Created and Last Seen Dates

Data

Cohort Analysis in Tableau: User Retention Given Only Created and Last Seen Dates

by Javod Khalaj
//

Cohorts have been the go-to analysis for user retention for a while now, and Tableau has a great article on how to go about creating different types of cohorts. However, when our data set is limited, we may have to create some workarounds.

An Example

The data set I’m working with is for an online service. It only tracks the day a customer signed up and the most recent date they’ve used the service.

If you do not have historical data for a customer’s login, cohort analysis can be tricky. However, given a customer’s sign up date and the most recent date they’ve used the service, we can mock up a cohort of user retention.

There is a big weakness to the following analysis: We simply don’t know if a user has been active in previous months from their most recent login. Therefore, for this report, we will define a user active for every month up to (and including) their last login.

For example: A user who signed up in January 2015 and last logged in on April 2015 would be considered an active user in both February 2015 and March 2015.

Our Workaround

We want to make sure that this distinction/limitation is clear and understood by the report consumer.

  1. The first thing we’re going to do is drag out our customer’s last login date (the date they joined) and change it to a Continuous Month.
  2. The next step is to create a reverse running sum. Essentially we’re going to count every record starting from the last time a user logged in to the date they were created. Create a new calculated field and enter the following equation:TOTAL(SUM([Number of Records])) – RUNNING_SUM(SUM([Number of Records])) + ZN(SUM([Number of Records]))

  3. Drag this new calculated field out to the Rows shelf:
  4. Now we want to split this line by the month a user was created. We drag our created date into the Color button on the Marks card, and change it to Month Continuous but set to be treated as Discrete:

     

  5. Now, in our Marks card, let’s change our visualization to Area. I’m using an area chart in order to get the total usage over time as well as to have an understanding of what percentage of that total belongs to a specific cohort.

Below I’ve added some filters to remove null values (which, in our case, are users who have never logged in) and to only display the last eight months of data.

This chart represents user retention starting from the month the customer signed up and counts how many continue to use the service as time goes by, broken down by the cohort month the customer signed up.

More About the Author

Javod Khalaj

Experience Architect
Cohort Analysis in Tableau: User Retention Given Only Created and Last Seen Dates Cohorts have been the go-to analysis for user retention for a while now, and Tableau has a great article on how to go about creating ...
Use DreamObjects to Backup Your MySQL Database (PHP Script) DreamObjects is DreamHost’s public cloud storage offering. It’s analogous to Amazon’s S3 offering, but slightly cheaper. The nice thing ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!