Decide on which formula to use and calculate the amount of customers canceling their subscription/product over a period of time

## Understand the two components for calculating churn

The first component of churn is “number of churned customers” => the absolute number of customers that, during the timeframe, no longer pay for your solution

The second component of churn is “total number of customers” => the absolute number of customers that, during the timeframe, are still paying for your solution

## Determine which formula for churn to use based on business needs and intricacies

The base formula for churn is the number of churned customers / total number of customers but there are many different possible variations:

• Simple: number of churned customers / total number of customers per 1st/31st of the month
• Simple Average: number of churned customers / total number of customers per midpoint of the month
• Expanded Average: number of churned customers / average customer count between days 1 and 30(31)

## Create a spreadsheet to calculate your churn over time and create months as columns and rows for each your formula metrics.

Example:

Source: provided by author

## Fill in the relevant numbers for your different metrics

Based on your churn rate formula chosen, fill in the spreadsheet and use cell linking to have it automatically fill values for you (to avoid making typing errors or calculation mistakes).