Retention Curves with Mixpanel and Google Sheets
Product retention is often measured using cohort reports with tools such as Amplitude, Google Analytics, iTunes Connect Analytics, or Mixpanel.
Most of the time, these cohort reports come in tabular form. My experience is those reports can be confusing. An alternative visualization is a retention curve.
Amplitude and Google Analytics provide retention curves for acquisition and behavioral cohorts "out of the box". If we're using Mixpanel, we can export data to Google Sheets and generate a retention curve there.
Setting up the curve
Sign into Mixpanel. Click "Retention" in the left sidebar. Click "First Time" at the top of the page. For "Show me people who did", select an activation event such as "Signed Up".
For "Then came back and did", select a North Star metric (the activity where users are getting authentic value from the product). Choose "Day", "Week", or "Month" based on the expected frequency of that event.
Click the "CSV" download button in the bottom right. Go to Google Sheets. Create a new spreadsheet. Click "File > Import > Upload". Select the file. Select "Replace spreadsheet".
Select all the data. Click "Insert > Chart". Click "Chart types", "Switch rows / columns", and the curvy "Line" chart type (for style). Click "Customization" to edit the title.
Select each time series, and pick a shade of color in the same column, making the oldest time series the lightest shade.
The goal of this shading to create a relationship between the series. Darker is more recent ("fresh paint") and lighter is older ("faded").
Analyzing FormKeep's curves
In every product's activation funnel, the curves will flatten out.
A product with improving retention will have darker-colored lines (more recent cohorts) flatten sooner, for longer, and for a higher absolute amount, than lighter-colored lines (older cohorts).
FormKeep's curves are experiencing a sharp drop-off in the first two weeks. The people who do activate, stay activated for months, though. So, the growth team should work on better activation to set users up for success.
This isn't super surprising. FormKeep is a "free to sign up" product that require some set up (HTML to be added to a site) to activate.
Analyzing Upcase's curves
Let's compare the retention curves of another real product, Upcase, an online training community for programmers.
The initial drop-off in usage is shallower than FormKeep's. Where FormKeep's cohorts are closer to 10% active in weeks one and two, Upcase's cohorts are more like 30-40% active in weeks one and two.
There is a trend of older cohorts stopping use of the product 3-4 weeks after subscribing, and recent cohorts sticking around a bit longer, closer to 6 weeks. This is good news, and validates a recent focus on content production.
Unlike FormKeep, Upcase is "pay to sign up", so we'd intuitively expect more motivated users, especially in the first month.
Time to segment
These charts give us a scorecard, but also some clues about where to dig for more data. For example, maybe Intercom communication to users should be adjusted around weeks 1-2.
It's also a reminder that the more properties we send to Mixpanel for our activation event, the more information we have on different segments, which could give us other clues about who is and isn't getting value. Click "+ Segment" in Mixpanel and choose an important property to segment by, such as user acquisition channel:
Each segment can have its own retention curve.