Salesforce Metric
CRM
Case Resolution Time = Average(Case Close Date - Case Created Date)
Case resolution time measures the average elapsed time from case creation to case closure in Salesforce Service Cloud. It evaluates support team efficiency and customer experience by tracking how quickly issues are addressed, segmented by case priority, type, product, and support agent.
Full guide: definition, formula, and benchmarksSalesforceCRMAverage Resolution Time
Case resolution time measures the average elapsed time from case creation to case closure in Salesforce Service Cloud. It evaluates support team efficiency and customer experience by tracking how quickly issues are addressed, segmented by case priority, type, product, and support agent.
How to calculate average resolution time
Why average resolution time matters for Salesforce users
Resolution time directly impacts customer satisfaction, retention, and expansion likelihood. Customers waiting days for issue resolution are significantly more likely to churn than those who receive prompt support. Salesforce Service Cloud captures comprehensive case lifecycle data, but many teams only track average resolution time without examining the distribution, which can hide a long tail of severely delayed cases.
Resolution time analysis also reveals operational bottlenecks. Cases that involve escalation, cross-team collaboration, or engineering involvement take predictably longer. Understanding these patterns helps support leadership staff appropriately, set realistic SLAs by case type, and identify process improvements that would reduce the most common delays rather than optimising already-efficient case types.
Understand and act on average resolution time with KPI Tree
Land Salesforce case records with creation, update, and closure timestamps in your warehouse via ETL. KPI Tree calculates resolution times by priority, type, product, agent, and escalation status.
Add case resolution time to your metric tree as a customer experience metric feeding into account health and churn risk. Assign ownership to support team leads, set SLA-based alerts for cases exceeding target resolution times, and track resolution time trends period-over-period to measure the impact of process improvements and staffing changes.
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 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.
User Adoption Rate
CRMMetric Definition
User Adoption Rate = (Active Users in Period / Total Licensed Users) x 100
User adoption rate measures the percentage of licensed Salesforce users who actively log in and perform meaningful actions (creating records, updating opportunities, logging activities, running reports) within a defined period. It evaluates whether the Salesforce investment is being utilised by the intended user base.
Customer Acquisition Cost
CRMMetric 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.
Explore average resolution time across integrations
All Salesforce metrics
Account Health ScoreActivity Volume per RepMarketing ROIContact Conversion RateCustomer Acquisition CostCustomer Lifetime ValueDashboard Adoption RateDeal Stage ProgressionForecast AccuracyLead Conversion RateLead Response TimeLead Scoring EffectivenessOpportunity AgingWin RatePipeline Coverage RatioSales Pipeline VelocityQuota AttainmentReport Usage AnalysisRevenue by Product LineSales Cycle LengthSales Rep Performance AnalysisTerritory Performance AnalysisUser Adoption RateWin/Loss AnalysisContract Value AnalysisCustomer Churn PredictionCustomer Renewal RateDeal Stage Conversion AnalysisDeal VelocityEmail Engagement AnalysisLead Source AttributionMarketing Qualified Lead RatePipeline ValueSales Velocity AnalysisUpsell Cross-sell AnalysisEmpower 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.
