Learn
Calculating Churn
Calculating Churn Review

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.

Folder Icon

Sign up to start coding

Already have an account?