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 benchmarksChurn 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
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
Connect your existing warehouse where Salesforce data already lands.
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
CRMMetric 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.
Customer Churn Prediction
CRMMetric 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.
Customer Lifetime Value
CRMMetric 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.
Contract Value Analysis
CRMMetric 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.
Explore churn risk analysis across integrations
All Salesforce metrics
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.