How to use it
- Type in members on day one.
- Type in how many left.
- Add your price a month.
Do it at the end of each month and write the number down. One month can be odd. The trend over three or four months tells you more.
The churn rate formula
Churn rate = members who left ÷ members at the start × 100. With 200 members and 10 gone: 10 ÷ 200 × 100 = 5% a month.
Retention rate = 100% − churn rate. At 5% churn, you keep 95% of members each month.
Average stay = 1 ÷ churn rate. At 5% (0.05), members stay about 20 months on average.
Member lifetime value = price ÷ churn rate. At $49 a month and 5% churn: $49 ÷ 0.05 = $980 per member.
Yearly churn = 1 − (1 − monthly churn) to the power of 12. 5% a month is about 46% a year, not 60%, because each month you lose 5% of a smaller group.
Two kinds of churn
Some members choose to leave. Others leave because their card failed and nobody followed up. The second kind is the easiest to fix, because those members never meant to go. See how to get failed Skool payments back.
For members who do choose to leave, start with how to reduce churn on Skool. To see what your members bring in each month, try the MRR calculator.