dashboard page template for tableau on Sales Sales Effectiveness Sales (expert) Customer Lifetime Value & Churn Rate data visualization dataviz

 

Presentation

This dashboard page shows the Customer Lifetime Value (CLV or LTV) as well as the Customer Churn Rate (and Retention Rate). 

Definition of Churn Rate

The Churn Rate is the share of Customers who left from one year to another.

The Churn Rate for Year "N" is computed as follows:

([Customers with at least "N+1" years since first sales date, having generated revenues in Year "N"]

Minus

[Customers with at least "N+1" years since first sales date, having generated revenues in Year "N+1"])

Divided by

[Customers with at least "N+1" years since first sales date, having generated revenues in Year "N"]

More details on "Customer Churn Rate" here.

 

Definition of Customer Lifetime Value

The Customer Lifetime Value is a prediction of all the value (margin or revenues) you will derive from the entire relationship with a customer.

The Customer Lifetime Value for Year "N" is computed as follows:

[Customer Lifetime Value Year "N-1"]

Plus

([Revenues in Year "N" for Customers with at least "N" years since first sales date]

Divided by

[Customers with at least "N" years since first sales date])

More details on "Customer Lifetime Value" here.

 

Dashboard page

You can visualize the LTV at the end of first 5 years of customer lifetime, starting first sales date.

This page is composed of four sections:

  • Client Lifetime Value - LTV
  • Client Churn Rate Evolution
  • CLTV Evolution
  • CLTV by Cohort

 

Client Lifetime Value - LTV

This table shows one row per cohort, i.e. per year of first sale by customer.

Concretely, the line '2015' shows the Lifetime of all customers having bought something for the first time in 2015.

The second column, called 'Number of Customers' shows the total number of customers having done their first purchase in the related year (cohort).

Then for each of the first 5 years of customer lifetime, you can see two KPIs:

  • Lifetime Value
  • Churn rate

 

Client Churn Rate Evolution

This DataViz shows the evolution of Customer Churn Rate for first  five years of Customer Lifetime.

 

CLTV Evolution

This DataViz shows the evolution of Customer Lifetime Value for first  five years of Customer Lifetime.

 

CLTV by Cohort

This DataViz shows the Customer Lifetime Value by Cohort. 

There is one line for each first five years of Customer Lifetime.

An ascending line would show your ability to develop your Customer Lifetime Value across cohorts.

 

Filter your data

This data visualization comes with four top filters:

In your Sales (expert) dashboard, you will be able to filter on:

  • CustomerName of the customer
  • Sales GroupThe way you regroup sales: business line, product category…

Other DataViz in "Sales (expert)" Pack

Home

Sales (expert) Home

Sales (expert) Home
Sales (expert) Home Sales (expert) Home
Get a Home Page for your Sales (expert) dashboard

Cockpit

Sales (expert) Cockpit

Sales (expert) Cockpit
Sales (expert) Cockpit Sales (expert) Cockpit
Clear picture on your Sales performance: What are our Sales results? What is our Profitability? Which Sales Groups generate the most sales? Who are our top Customers?

Sales (expert) Top Performers

Sales (expert) Top Performers
Sales (expert) Top Performers Sales (expert) Top Performers
Get an instant understanding of your top Sales (expert) performers: current, mid and long term performance

Top 4 KPIs Trends (MTD/YTD)

Top 4 KPIs Trends (MTD/YTD)
Top 4 KPIs Trends (MTD/YTD) Top 4 KPIs Trends (MTD/YTD)
Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Sales Analytics

Product Performance

Product Performance
Product Performance Product Performance
Analyze your Sales and Profitability Performance at Product level of detail: What are our best selling products? What does our Product base look like?

Customer Insight

Customer Insight
Customer Insight Customer Insight
Better understand your customer base (Customer Acquisition, Customer Profitability): How many active customers do we have? What about our ability to acquire news customers? Who are our top customers? What does our customer base look like?

Sales Advanced Analytics

RFM Analysis (Recency-Frequency-Monetary)

RFM Analysis (Recency-Frequency-Monetary)
RFM Analysis (Recency-Frequency-Monetary) RFM Analysis (Recency-Frequency-Monetary)
The RFM Analysis creates an actionable segmentation of your customer base: How is our customer base segmented? What are the recommended marketing actions to address each customer segment?

RFM Customer Base

RFM Customer Base
RFM Customer Base RFM Customer Base
Overview of your customer base by RFM Segment: Which customers constitute each of our RFM segments?

RFM Segment Detail

RFM Segment Detail
RFM Segment Detail RFM Segment Detail
Detailed analysis of each RFM Segment: Which customers belong to this RFM segment?

Customer Lifetime Value & Churn Rate

Customer Lifetime Value & Churn Rate
Customer Lifetime Value & Churn Rate Customer Lifetime Value & Churn Rate
Predict of the revenues and profit attributed to the entire future relationship with a customer. Customer lifetime value can also be defined as the monetary value of a customer relationship. Measure your (in)ability to retain customers (Churn Rate & Retention Rate).

Price Volume Mix Analysis / Sales Bridge

Price Volume Mix Analysis / Sales Bridge
Price Volume Mix Analysis / Sales Bridge Price Volume Mix Analysis / Sales Bridge
Price Volume Mix variance analysis enhances standard variance analyses by decomposing how volume or pricing changes of our product assortment contributed to the difference in performance between the Actual and Reference values

Behavioral Analytics

Sales (expert) Adhoc Analysis

Sales (expert) Adhoc Analysis
Sales (expert) Adhoc Analysis Sales (expert) Adhoc Analysis
Perform simple ad-hoc analysis on your Sales (expert) data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

Other Dashboard Templates