KPI Tree

Salesforce Metric

CRM

Win/loss analysis systematically examines closed opportunities in Salesforce to identify patterns that differentiate won and lost deals. It analyses loss reasons, competitive presence, deal characteristics, sales process adherence, and buyer behaviour to surface actionable insights for improving future win rates.

Win/Loss Analysis

Win/loss analysis systematically examines closed opportunities in Salesforce to identify patterns that differentiate won and lost deals. It analyses loss reasons, competitive presence, deal characteristics, sales process adherence, and buyer behaviour to surface actionable insights for improving future win rates.

Why win/loss analysis matters for Salesforce users

Every lost deal contains intelligence about competitive positioning, pricing effectiveness, and sales process gaps. Salesforce captures loss reasons, competitor fields, and the full history of deal progression, but most teams record a loss reason and move on without systematic analysis. Win/loss analysis transforms this data into strategic intelligence by identifying which loss reasons cluster, which competitors win most frequently, and what deal characteristics predict wins versus losses.

This analysis also reveals process-driven wins and losses. Deals where the sales process was followed completely (all stages progressed, required activities completed, stakeholders mapped) may close at significantly higher rates than deals where process steps were skipped. Quantifying this relationship creates a compelling, data-driven case for process adherence that is more persuasive than mandate-based enforcement.

Understand and act on win/loss analysis with KPI Tree

Sync Salesforce closed opportunity data with loss reasons, competitor fields, and stage history into your warehouse. KPI Tree analyses win and loss patterns across every dimension, surfacing the factors that most strongly differentiate outcomes.

Build a win/loss analysis branch in your metric tree breaking down outcomes by reason, competitor, segment, deal size, and process adherence. Assign ownership to sales leadership for competitive intelligence and enablement for process improvement, set alerts for emerging loss patterns, and track win/loss trends period-over-period to measure whether strategic interventions are shifting outcomes.

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

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

Deal Stage Progression

CRM

Metric 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.

View metric

Forecast Accuracy

CRM

Metric 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.

View metric

Pipeline Coverage Ratio

CRM

Metric 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.

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