KPI Tree

Salesforce Metric

CRM

Customer Lifetime Value = Average Revenue per Customer per Year x Gross Margin % x Average Customer Lifespan

Customer lifetime value (CLV) estimates the total net revenue a customer will generate over their entire relationship with your business. Using Salesforce opportunity history, renewal data, expansion revenue, and churn patterns, CLV quantifies the long-term return on each customer acquisition and retention investment.

Full guide: definition, formula, and benchmarks

Customer Lifetime Value

Customer lifetime value (CLV) estimates the total net revenue a customer will generate over their entire relationship with your business. Using Salesforce opportunity history, renewal data, expansion revenue, and churn patterns, CLV quantifies the long-term return on each customer acquisition and retention investment.

How to calculate customer lifetime value

Customer Lifetime Value = Average Revenue per Customer per Year x Gross Margin % x Average Customer Lifespan

Why customer lifetime value matters for Salesforce users

CLV is the metric that connects acquisition, retention, and expansion into a single strategic number. Salesforce captures the full revenue history of each customer: initial deal value, renewals, upsells, cross-sells, and downgrades. This longitudinal data enables CLV calculations grounded in actual customer behaviour rather than theoretical models, producing forecasts that the finance team can trust.

CLV segmented by acquisition source, initial deal size, product mix, and industry reveals which customer types generate the most long-term value. This insight transforms ideal customer profile definitions from qualitative descriptions into quantitative benchmarks. When the sales team knows that customers from referrals have 2.5 times the CLV of customers from paid campaigns, they prioritise referral-generated leads with conviction rather than intuition.

Understand and act on customer lifetime value with KPI Tree

Sync Salesforce opportunity history, renewal records, and revenue data into your warehouse. KPI Tree calculates CLV using actual revenue patterns, churn rates, and expansion velocity, segmented by every available dimension.

Position CLV as a strategic metric in your metric tree with CAC, churn rate, and expansion revenue as contributing nodes. Assign ownership to the executive team, set alerts for CLV trend changes, and compare CLV by acquisition cohort to track whether customer quality is improving with go-to-market changes.

Get started with your Salesforce data

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Salesforce data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Related Salesforce metrics

Customer Acquisition Cost

CRM

Metric Definition

Customer Acquisition Cost = Total Sales & Marketing Spend / Number of New Customers Won

Customer acquisition cost (CAC) measures the total sales and marketing investment required to win a new customer. Using Salesforce opportunity data, campaign costs, and activity records, CAC quantifies acquisition efficiency and determines the breakeven point for each new customer relationship.

View metric

Account Health Score

CRM

Metric Definition

Account health score is a composite metric that evaluates the overall strength of a customer relationship using Salesforce data. It combines activity recency, opportunity pipeline status, support ticket trends, product adoption signals, and engagement frequency to produce a single score indicating whether an account is thriving, stable, or at risk.

View metric

Revenue by Product Line

CRM

Metric Definition

Revenue by product line breaks down closed-won revenue in Salesforce by the products and product families included in opportunities. It tracks which products generate the most revenue, how product mix is shifting over time, and which product combinations appear most frequently in winning deals.

View metric

Win Rate

CRM

Metric Definition

Opportunity Win Rate = (Closed-Won Opportunities / Total Closed Opportunities) x 100

Opportunity win rate measures the percentage of closed opportunities in Salesforce that result in a won outcome. It is the definitive measure of sales effectiveness, capturing the combined impact of qualification, competitive positioning, pricing, negotiation, and execution across the entire pipeline.

View metric

Empower your team to understand and act on Salesforce data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business