/uploads/galerie/000234/Startup LTV by Cohort.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 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 Digital Strategy dashboard, you will be able to filter on:

  • CountryClient Country
  • Marketing SourceMarketing Source
  • Filter 1Attribute your want to use as top filter #1
  • Filter 2Attribute your want to use as top filter #2

Other #DataViz in "Digital Strategy" Pack

Home

Digital Strategy Home

Digital Strategy Home
Digital Strategy Home Digital Strategy Home
Get a Home Page for your Digital Strategy dashboard

Cockpit

Start-up Cockpit

Start-up Cockpit
Start-up Cockpit Start-up Cockpit
Get a 360° view of your Start-up performance

Digital Strategy Top KPIs Overview

Digital Strategy Top KPIs Overview
Digital Strategy Top KPIs Overview Digital Strategy Top KPIs Overview
Get a transverse view on your top 6 Digital Strategy KPIs, split by the dimension of your choice

Digital Strategy Top KPIs Evolution

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

Digital Strategy Top Contributors

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

Sales Analytics

Customer Insight

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

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
Instantly know how your LTV evolves across cohorts

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

Digital Strategy KPI Performance

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

GeoAnalytics

Digital Strategy Country Analysis

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

Digital Strategy State/Province Analysis

Digital Strategy State/Province Analysis
Digital Strategy State/Province Analysis Digital Strategy State/Province Analysis
Visualize the performance of any of your Digital Strategy KPIs, at State/Province level

Digital Strategy City Analysis

Digital Strategy City Analysis
Digital Strategy City Analysis Digital Strategy City Analysis
Visualize the performance of any of your Digital Strategy KPIs, at City level

Trends Analytics

Digital Strategy Trends Analysis

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

Distribution Analytics

Digital Strategy Segmentation Analysis

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

Market Share Analysis

Market Share Analysis
Market Share Analysis Market Share Analysis
Visualize the evolution of the Market Share. For any of your KPIs, for any your dimensions.

Other Packs