Learn
You can now calculate a churn rate over time for a company:
month | churn_rate |
---|---|
2017-01-01 | 0.127 |
2017-02-01 | 0.125 |
2017-03-01 | 0.237 |
It looks like our sample company did something in March that doubled the churn rate. They might want to look into that…
In this lesson you learned:
- The churn rate is a percent of subscribers at the beginning of a period that cancel within that period. “Monthly churn” is a typical metric and what was used in the examples.
- How to calculate this metric using SQL for a single month. This used
COUNT()
and conditions to determine the number of subscribers that were active and how many canceled. - A more complex method to track the subscriber churn rate over many months.
Instructions
The complete churn calculation is provided here for you to experiment with.
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.