Customer Lifetime Value Dashboard
A CLTV dashboard that segments the customer base by value and turns that segmentation into marketing and retention decisions.
What it solves
- Splits the base into high, mid and low value customers, with thresholds adjustable from inside the report.
- Connects CLTV to acquisition cost, which is what makes the metric actionable.
- Surfaces cohorts with upselling potential instead of treating the whole base the same.
Customer Lifetime Value answers a question that’s simple to ask and hard to compute: how much is a customer worth across their entire relationship with the company?
The answer changes how budget gets allocated. Without CLTV, acquisition cost is judged against the first purchase. With CLTV, it’s judged against everything that customer will generate, and suddenly campaigns that looked expensive turn out profitable, while others that looked cheap turn out to be losses.
What the dashboard shows
Value segmentation. The base splits into high, mid and low value. The thresholds are report parameters rather than constants baked into the model, so they can be moved to test scenarios without republishing anything.
CLTV against acquisition cost. The relationship between the two metrics is what turns CLTV into a decision tool rather than a reporting number.
Upselling opportunities. Cohorts whose behaviour resembles high-value customers but who haven’t got there yet. That’s the group where a campaign returns the most.
The design decision
The temptation with CLTV is to show one big number and leave it there. This report does the opposite: the number only appears alongside the segment it belongs to and the action it suggests. A dashboard that doesn’t change a decision is decoration.
“Satisfied customers are the best source of advertisement and the most valuable asset a company can have in terms of Customer Lifetime Value.”
Philip Kotler