dashboard page template for tableau on Sales e-Commerce Online Sales & Marketing 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. 

 

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 registration, having generated revenues in Year "N"]

Minus

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

Divided by

[Customers with at least "N+1" years since registration, 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 registration]

Divided by

[Customers with at least "N" years since registration])

More details on "Customer Lifetime Value" here.

 

Dashboard page

You can visualize the LTV and the Churn Rate at the end of first 5 years of customer lifetime, starting client registration date.

This page is composed of four sections:

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

 

Client Lifetime Value - LTV

This table shows one row per cohort, i.e. per year of registration date 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 'Registered Clients' shows the total number of customers having done their first purchase in the related year (cohort).

The third column, called 'Conversion Rate' shows the percentage of registered clients having done at least one purchase since their registration.

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

  • LTV at 1 year:
    • Lifetime Value: Average Total Revenues per customer at the end of the first year of lifetime (= Total Revenues on first 12 months of lifetime, divided by the number of customers having at least 12 months of lifetime)
  • LTV at 2 years:
    • Churn Rate: Share of lost customers from 1st year of lifetime
    • Lifetime Value: Average Total Revenues per customer at the end of the second year of lifetime (= Total Revenues on first 24 months of lifetime, divided by the number of customers having at least 24 months of lifetime)
  • LTV at 3 years:
    • Churn Rate: Share of lost customers from 2nd year of lifetime
    • Lifetime Value: Average Total Revenues per customer at the end of the third year of lifetime (= Total Revenues on first 36 months of lifetime, divided by the number of customers having at least 36 months of lifetime)
  • LTV at 4 years:
    • Churn Rate: Share of lost customers from 3rd year of lifetime
    • Lifetime Value: Average Total Revenues per customer at the end of the fourth year of lifetime (= Total Revenues on first 48 months of lifetime, divided by the number of customers having at least 48 months of lifetime)
  • LTV at 5 years:
    • Churn Rate: Share of lost customers from 4th year of lifetime
    • Lifetime Value: Average Total Revenues per customer at the end of the fifth year of lifetime (= Total Revenues on first 60 months of lifetime, divided by the number of customers having at least 60 months of lifetime)

 

Client Churn Rate Evolution

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

 

LTV Evolution

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

 

LTV 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 Online Sales & Marketing dashboard, you will be able to filter on:

  • Marketing SourceMarketing Source

Other DataViz in "Online Sales & Marketing" Pack

Home

Online Sales & Marketing Home

Online Sales & Marketing Home
Online Sales & Marketing Home Online Sales & Marketing Home
Get a Home Page for your Online Sales & Marketing dashboard

Cockpit

eCommerce Sales Cockpit

eCommerce Sales Cockpit
eCommerce Sales Cockpit eCommerce Sales Cockpit
Get a clear picture on your eCommerce performance (sales and marketing efficiency): What are our Revenues? Which Products generate the most revenues? What is the performance of our marketing investments? What are our top Marketing Sources?

Online Sales & Marketing Top KPIs Breakdown

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

Online Sales & Marketing Top KPIs Trends

Online Sales & Marketing Top KPIs Trends
Online Sales & Marketing Top KPIs Trends Online Sales & Marketing Top KPIs Trends
Visualize how your Online Sales & Marketing KPIs are evolving (Month-to-Date, Year-to-Date)

Campaign Performance

Marketing Profitability

Marketing Profitability
Marketing Profitability Marketing Profitability
Visualize the efficiency of your marketing investments

Sales Analytics

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?

Client Acquisition

Client Acquisition
Client Acquisition Client Acquisition
Visualize the evolution of your new registered clients

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.

LTV Evolution

LTV Evolution
LTV Evolution LTV Evolution
Analysis of your customer TLV - Lifetime Value by cohort (= year of customer registration on your portal)

Active Customers Evolution by Cohort

Active Customers Evolution by Cohort
Active Customers Evolution by Cohort Active Customers Evolution by Cohort
Visualize the evolution of active customers across lifetime, split by cohort

Behavioral Analytics

Online Sales & Marketing Adhoc Analysis

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

Other Dashboard Templates