You can now calculate a churn rate over time for a company:

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.