Skip to main content
Solved

Best way to measure users who have never churned?


hi all! am looking for some help - I am trying to use Amplitude to create a chart of users who have had >1 active event for every month they have been on a platform. Users all sign up in different months, however, which is making this tricky. The workaround I was trying was to create cohorts for each month, and then use the segmentation graph to graph for each monthly cohort, the number of users who have had an event every month. I'm hitting a limit on the number of cohorts I can show here, and this feels way too manual. does anyone have a tip on a better way to use Amplitude to calculate users who have been active every month and have never missed a month? Thank you!

Best answer by Saish Redkar

Hi @Aliza Rosen 

If you have access to derived properties feature, you can start with the following approach and create a “month number” derived property. Once you have that property created, you can anchor your cohort creation as mentioned in there along with your initial joining event for the users.

Let me know if this works out.

View original
Did this topic help you find an answer to your question?

2 replies

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1380 replies
  • Answer
  • June 27, 2023

Hi @Aliza Rosen 

If you have access to derived properties feature, you can start with the following approach and create a “month number” derived property. Once you have that property created, you can anchor your cohort creation as mentioned in there along with your initial joining event for the users.

Let me know if this works out.


Esther Trapadoux
Community Manager
Forum|alt.badge.img+9

@Aliza Rosen great question. We just hosted a Retention Models workshop with @timothy-permutable and he touched on this topic (and maybe a few ways to get closer to what you’re trying to solve for). Here’s the recording and will share out the follow up recap post to make it easier to consume.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings