Skip to main content

Profit Analytics: Customer Churn Prediction - Knowledgebase / Profit Analytics / Profit Analytics Documentation - Cavallo Technical Support

Profit Analytics: Customer Churn Prediction

Authors list

Overview

The Customer Churn module in Profit Analytics uses an AI-driven model to predict the likelihood of repeat customers becoming inactive. The model updates daily, generating "Risk Scores" that help businesses identify at-risk customers and take action to reduce churn.

Risk Scores are displayed in the module's grid, allowing users to filter customers and view insights like:

  • The customer’s impact on the business.

  • Engagement patterns.

  • Comparisons within their class or territory.

This article explains how to use the module and how the model generates predictions.


Customer Churn Widget

  • The Customer Churn widget, located in the customer module, is displayed as a donut chart that provides an overview of the five churn risk categories and the number of customers in each category.

    • Minimal Risk: Customers with a 1-20% chance of churning.
    • Low Risk: Customers with a 21-40% chance of churning.
    • Moderate Risk: Customers with a 41-60% chance of churning.
    • Elevated Risk: Customers with a 61-80% chance of churning.
    • High Risk: Customers with an 81-99% chance of churning.

Key Features of the UI:

  1. Donut Chart:

    • Visual representation of churn data, corresponding to the churn key on the right.
    • Hovering over the chart displays a tooltip with percentage details for each category.
  2. Churn Key:

    • Located on the right side of the screen, it displays each risk category alongside the number of customers assigned to that category.
  3. Explore Churn Prediction Details:

    • A button in the bottom-right corner links to a detailed Churn Prediction page for deeper analytics.

Note: The total number of customers shown in this widget may differ from the total active customers due to a minimum invoice threshold of three to be considered in the churn model.


Customer Churn Details Page

The Customer Churn Details Page provides users with a comprehensive view of their churn risk categories, enabling deeper analysis and insights into which specific customers are at the highest likelihood of churning. This page is designed to support data-driven decision-making by combining visual summaries and granular filtering capabilities. This page supports the following data segmenting tools native to Profit Analytics:

Key Features and Data-Segmenting Tools:

  1. Customer Class Page-Level Filter

    • Apply a global filter at the page level to segment data by customer class (e.g., small business, enterprise, or specific customer groups).
    • Enables users to focus on the most relevant segments for their analysis, ensuring targeted insights.
  2. Quick Filters via Gauges

    • Interact with visual elements like gauges or charts to quickly filter data by churn risk categories (e.g., Minimal, Low, Moderate, Elevated, High Risk).
    • Clicking on a specific gauge dynamically updates the grid and visualizations to display data relevant to the selected category.
  3. Sharing the View with Others

    • Share customized views with team members or stakeholders directly from the interface.
    • Shared views retain applied filters and configurations, ensuring alignment across teams when analyzing churn data.
  4. Grid Filtering

    • Use the data grid to apply detailed filters on individual columns, such as customer name, churn probability, last purchase date, or geographic region.
    • Enables users to drill down into specific subsets of data for precise analysis.
  5. Grid Customization

    • Tailor the grid layout by reordering columns, hiding irrelevant data points, or adding additional fields.
    • Save customized views for repeated use or share them with colleagues.
  6. Exporting to Excel

    • Export the grid data, including filters and customizations, to Excel for offline analysis or reporting purposes.
    • Ensures flexibility in working with the data beyond the Profit Analytics platform.

Churn Risk Gauges

Along the top part of the screen is 5 gauges that represent each indivdual risk score. There are several parts to each of these gauge tiles:

  • Risk category
  • Number of active customers
  • The percentage of the total customers that make up the category
  • The amount of margin currently at risk if those customers were to churn today

These numbers are recalculated daily as part of inference calculations to ensure that all current data is taken into consideration. 

Churn Risk Grid

The default column layout for the churn grid is as follows:

  • Customer Name
  • Customer Number
  • Risk Score
  • ABCD Segement
  • Frequency Score
  • Recency Score
  • Lifetime Sales $
  • Lifetime Sales #
  • Lifetime Marin %
  • Lifetime Margin $

While many columns are shared across the application, the following columns are unique additions specifically designed for the Churn Prediction feature:

Risk Score: Specifies the risk category assigned to each customer. These can range from Minimal Risk to High Risk.

Frequecy Score: Specifies how often a customer can be expected to purchase based on previous purchase patterns. These scrores range from Low to High

Recency Score: Specifies a score of how recently these customers have purchased based on days since last invoice. These scores range from Inactive to Very Recent


Customer Churn Data Calculations

This predictive AI model incorporates numerous factors, but the following details provide an overview of the key calculations and general insights about its structure.

Risk Score Recalculation:  The model is recalculates churn scores daily.

Margin at Risk: This calculation represents the sum of the last 365 days from the most recent invoice. The numbers dynamically update as customers churn or shift between risk categories.

Frequency Score: Represents how often the customer has purchased within the churn period.

Recency Score:  Represents how recently the customer has purchased within the churn period.

Customer Calculation: Customers included in the predictive model must have a minimum of three invoices to ensure accurate predictions of their propensity to make future purchases.

Main Algorithm Components: The churn model has many components, however some of the major factors include the below:

  • Customer RFM scores (Recency, Frequency, Monetary)
  • Customer Invoice Count
  • Customer Sales Totals
  • Customer Margin Totals
  • Customer Days Since Last Invoice

Again many more factors are utilized inside the AI model and are updated alongside the training jobs to ensure an accurate output.

Helpful Unhelpful