/uploads/galerie/000183/Sales - Customer Lifetime Value.png

 

Presentation

This dashboard page shows the Customer Lifetime Value (CLV or LTV)as well as the Customer Churn 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 dashboard, you will be able to filter on:

  • CustomerName of the customer
  • CountryThe country to which the sale is associated: it can be the country of the sales organization or the country of the customer
  • Product Group / Business LineThe way you regroup sales: business line, product category…

Other #DataViz in "Sales" Pack

Home

Sales Home

Sales Home
Sales Home Sales Home
Get a Home Page for your Sales dashboard

Cockpit

Sales Cockpit

Sales Cockpit
Sales Cockpit Sales Cockpit
Get a 360° view of your Sales performance

Sales Top KPIs Breakdown

Sales Top KPIs Breakdown
Sales Top KPIs Breakdown Sales Top KPIs Breakdown
Get a transverse view on your top 6 Sales KPIs, split by the dimension of your choice

Sales Top KPIs Evolution

Sales Top KPIs Evolution
Sales Top KPIs Evolution Sales Top KPIs Evolution
Visualize how your Sales KPIs are evolving (Month-to-Date, Year-to-Date)

Sales Top Contributors

Sales Top Contributors
Sales Top Contributors Sales Top Contributors
Instant overview of your Sales top 4 KPIs split by the dimension you selected.

Sales Analytics

Item Performance

Item Performance
Item Performance Item Performance
Better understand your Sales Performance from an Item point of view: Top items, Evolution of catalog depth...

Customer Insight

Customer Insight
Customer Insight Customer Insight
Get instant insight on your customers: Top customers, Evolution...

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.

Behavioral Analytics

Sales KPI Performance

Sales KPI Performance
Sales KPI Performance Sales KPI Performance
Visualize the overall performance of any of your Sales KPIs: what is the performance, how does this performance evolve, who contributes to this performance

GeoAnalytics

Sales Country Analysis

Sales Country Analysis
Sales Country Analysis Sales Country Analysis
Visualize the performance of any of your Sales KPIs, at Country level

Trends Analytics

Sales Trends Analysis

Sales Trends Analysis
Sales Trends Analysis Sales Trends Analysis
Visualize the evolution of any of your Sales KPIs: Trends, Performance & Year over Year

Distribution Analytics

Sales Segmentation Analysis

Sales Segmentation Analysis
Sales Segmentation Analysis Sales Segmentation Analysis
Visualize the value of any of your Sales KPIs, split by the dimension you selected (market share analysis)

Sales Pareto Analysis

Sales Pareto Analysis
Sales Pareto Analysis Sales Pareto Analysis
Perform a Pareto Analysis on any of your Sales KPIs: the 80/20 rule.

Other Packs