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.