dashboard page template for tableau on Sales e-Commerce Online Sales & Marketing LTV Evolution data visualization dataviz

 

Presentation

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

This dashboard page is composed of two sections:

  • LTV by Cohort
  • Cumulated Turnover/Margin by Cohort

 

For both sections, you can select whether you want to see the LTV based on Total Revenues or Total Margin.

 

LTV by Cohort

This DataViz shows the evolution of the Customer Lifetime Value by Cohort.

There is one row per cohort (year of client registration).

For each cohort, you can see the evolution of LTV across lifetime years.

 

Cumulated Turnover/Margin by Cohort

This DataViz shows a detailed analysis of your cohorts (at month or quarter level) and see how your LTV evolves.

There is one line per LTV period. A selector at the top right allows you to switch from LTV at month level to LTV at year level.

 

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