Churn rate Comparison analysis

This use case presents a churn rate comparison analysis from last year to this year


This use case presents a churn rate comparison analysis for various client types, gender, and products to help businesses understand their customer retention and attrition patterns. By comparing the churn rate from the last year and this year, the business can identify areas of improvement and implement strategies to increase customer retention.


The objective of this use case is to compare the churn rate of different client types, genders, and products between the last year and this year. The analysis will help the business identify patterns and trends in customer retention and attrition, allowing them to make data-driven decisions to enhance customer satisfaction and loyalty.

Data Source

The data for this use case is provided in the form of a Google Sheet containing the following columns:

There are multiple way de calculate the Churn Rate, on this specific case, we did the following metrics relation:

Churn rate = Clients lost current month / Client beginning of the month

Below is an extract of the data that has been used for this example. You can download the source: Gsheet

In Datama Compare


By conducting a churn rate comparison analysis, businesses can gain valuable insights into customer retention and attrition patterns across various client types, genders, and products. This information can help the business implement targeted strategies to improve customer satisfaction and loyalty, ultimately leading to higher revenue and growth.