Customer Churn (SaaS)

High Level Design

Overview

Keeping the customers we already have is usually better and cheaper than trying to find and win new ones. This is why most businesses aim to convert first-time buyers into long-term profitable customers. Customer Churn analysis is a powerful part of the retention efforts, and takes into account the percentage of subscribers to a service who discontinue their subscriptions to that service within a given time period.

Goals

Retain as many customers as possible.

Objectives

Reduce customer churn by 20% from past year.

KPI Architecture

Objectives KPIs Measures Data Source
Reduce customer churn by 20% from past year. Customer Churn Rate Customers Acquisitions Customers base dimension table, Date dimension table and our Transactions fact table
Customers Ceased
Customers Revenue
Demographic Churn Analysis

Data Modeling (Elasticube Design)

Suggested data model for customer churn analysis

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation