Hi @paulag, very interesting follow-up to the Q2 report! While the new registration counts continue to decrease over time, the churn rate seems to follow this trend - which is not too bad if I understood it correctly?! I must admit, I was also a bit puzzled if the churn rate can be negative. Given your definition, it makes sense if previously inactive accounts are reactivated. Do you have insights how the churn rate is calculated for the other social networks? They must have the same effects somehow. But what I'm unsure about: does it make sense to add new accounts unconditionally to the churn or should only those be included that are actually "active"? I've seen definitions of the churn rate as (active_users_at_the_beginning - active_users_at_the_end) / active_users_at_the_beginning. I think this could treat inactive new accounts more accurately?
Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post, click here.
Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]
hay @crokkon and thanks for the review and feedback.
I did use (active_users_at_the_beginning - active_users_at_the_end) / active_users_at_the_beginning to calculate the churn
"Churn = Number of Active users at the beginning of the period + New registrations – Number of Active users at the end of the period.
Churn rate can be calculated using
Churn rate = Churn / Number of Active users at the beginning of the period."
The problem with the weekly and negative churn is down to steemit inc not creating accounts at the same pace each week. the variance on the week to week is to much to make sense really.
Thank you for your review, @crokkon!
So far this week you've reviewed 3 contributions. Keep up the good work!