KPI Tree

Salesforce Metric

Revenue

Churn Risk Analysis = Weighted Sum of Risk Signals (declining activity, open cases, stalled renewals, falling account health) / Maximum Possible Risk Score x 100

Churn Risk Analysis scores how likely each Salesforce account is to cancel or fail to renew, based on signals already held in your CRM. It combines account engagement, open support cases, declining activity volume and stalled renewal opportunities into a single risk view per customer. In a Salesforce context, it turns standard objects such as Account, Opportunity, Case and Activity into an early warning system rather than a static record.

Full guide: definition, formula, and benchmarks
SalesforceRevenue

Churn Risk Analysis

Churn Risk Analysis scores how likely each Salesforce account is to cancel or fail to renew, based on signals already held in your CRM. It combines account engagement, open support cases, declining activity volume and stalled renewal opportunities into a single risk view per customer. In a Salesforce context, it turns standard objects such as Account, Opportunity, Case and Activity into an early warning system rather than a static record.

How to calculate churn risk analysis

Churn Risk Analysis = Weighted Sum of Risk Signals (declining activity, open cases, stalled renewals, falling account health) / Maximum Possible Risk Score x 100

Why churn risk analysis matters for Salesforce users

Renewal revenue is far cheaper to keep than new revenue is to win, yet churn often only becomes visible once a customer has already decided to leave. Salesforce holds the signals that predict it - drops in logged activity, a spike in open cases, renewal opportunities that stop progressing - but those signals sit in separate objects and rarely surface as one number.

Bringing them together lets revenue and customer success teams rank accounts by risk and intervene while there is still time. It moves the conversation from reactive firefighting at renewal to proactive outreach weeks or months earlier, which is where retention is actually won.

Understand and act on churn risk analysis with KPI Tree

Sync your Salesforce Account, Opportunity, Case and Activity data into your warehouse and compute Churn Risk Analysis in KPI Tree. Place it in a metric tree alongside account health score and customer churn prediction so you can see which underlying signals are driving each at-risk account rather than just the headline score.

Assign RACI ownership so a named customer success lead is accountable for the metric and the play that follows a high-risk flag, and set a weekly review cadence ahead of renewal cycles. KPI Tree keeps the score, the owners and the follow-up tasks in one place so a rising risk signal turns into action, not just a dashboard tile.

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

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

Customer Churn Prediction

CRM

Metric Definition

Customer churn prediction uses Salesforce activity, support case, engagement, and renewal data to calculate a probability score indicating how likely each customer is to churn. It combines declining engagement frequency, increasing support escalations, contract approaching renewal without expansion signals, and reduced product usage into a composite risk score.

View metric

Customer Lifetime Value

CRM

Metric Definition

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.

View metric

Contract Value Analysis

CRM

Metric Definition

Contract value analysis examines the distribution and trends of contract values across Salesforce opportunities and contracts. It segments total contract value (TCV) and annual contract value (ACV) by customer segment, product mix, contract term length, and sales rep to identify pricing patterns, discount behaviours, and deal structuring trends that influence long-term revenue.

View metric

Explore churn risk analysis across integrations

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