Salesforce Metric
CRM
Opportunity aging analyses the age distribution of open opportunities in Salesforce by measuring days since creation or days in current stage. It identifies opportunities that have exceeded normal timelines, categorises pipeline into age buckets, and quantifies the proportion of pipeline at risk of being stale or unlikely to close.
SalesforceCRMOpportunity Aging
Opportunity aging analyses the age distribution of open opportunities in Salesforce by measuring days since creation or days in current stage. It identifies opportunities that have exceeded normal timelines, categorises pipeline into age buckets, and quantifies the proportion of pipeline at risk of being stale or unlikely to close.
Why opportunity aging matters for Salesforce users
Stale opportunities are the most common cause of forecast misses and inflated pipeline metrics. Salesforce pipelines accumulate old deals that reps are reluctant to close-lost because it reduces their pipeline coverage. These aged deals sit at full value in the pipeline, creating false confidence in coverage ratios and misleading revenue forecasts. Opportunity aging analysis makes this hidden risk visible and quantifiable.
Aging data also drives sales process improvements. If a significant proportion of opportunities age out in a specific stage, it indicates a structural bottleneck. Perhaps the legal review stage takes too long, or procurement processes in a specific segment create predictable delays. Understanding these patterns enables targeted process fixes rather than generic pipeline cleanup mandates.
Understand and act on opportunity aging with KPI Tree
Sync Salesforce opportunity records with creation dates and stage timestamps into your warehouse. KPI Tree calculates opportunity age, creates distribution buckets, and compares against historical close-time benchmarks to flag at-risk deals.
Add opportunity aging to your metric tree as a pipeline health metric. Assign ownership to sales managers for pipeline hygiene, set alerts when aged pipeline exceeds healthy thresholds, and track aging distributions period-over-period to verify that pipeline cleanup efforts are reducing stale deal accumulation.
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
Deal Stage Progression
CRMMetric Definition
Deal stage progression measures the rate and pattern of opportunity movement through pipeline stages in Salesforce. It tracks forward progression, stage skipping, regression (deals moving backwards), and stagnation (deals stuck in a stage), providing a comprehensive view of how effectively the sales process advances deals toward close.
Pipeline Coverage Ratio
CRMMetric Definition
Pipeline Coverage Ratio = Total Open Pipeline Value / Revenue Target or Quota
Pipeline coverage ratio measures the total value of open pipeline in Salesforce divided by the revenue target or quota for a given period. It indicates whether sufficient pipeline exists to absorb normal loss and slippage rates while still achieving the revenue goal.
Forecast Accuracy
CRMMetric Definition
Forecast Accuracy = (1 - |Forecasted Revenue - Actual Revenue| / Actual Revenue) x 100
Forecast accuracy measures the percentage deviation between revenue forecasts derived from Salesforce pipeline data and actual closed revenue for a given period. It evaluates the reliability of opportunity stage probabilities, close date predictions, and deal value estimates across the sales organisation.
Sales Cycle Length
CRMMetric Definition
Sales Cycle Length = Average(Close Date - Opportunity Created Date)
Sales cycle length measures the average number of days from opportunity creation in Salesforce to a closed-won outcome. It captures the full duration of the active sales process and is a critical input for pipeline velocity, coverage calculations, and revenue forecasting.
All Salesforce metrics
Account Health ScoreActivity Volume per RepMarketing ROIAverage Resolution TimeContact Conversion RateCustomer Acquisition CostCustomer Lifetime ValueDashboard Adoption RateDeal Stage ProgressionForecast AccuracyLead Conversion RateLead Response TimeLead Scoring EffectivenessWin 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.
