Salesforce Metric
Sales
Stage Conversion Rate = Opportunities Advancing to Next Stage / Opportunities Entering Stage x 100
Sales Funnel Analysis measures how opportunities progress through each stage of your Salesforce pipeline, from the first qualified opportunity to closed won. It quantifies the conversion rate between adjacent stages in the Opportunity object, the volume of deals resting at each stage, and the time those deals spend before advancing. In Salesforce terms, it reads the StageName field and its history to show exactly where the funnel narrows.
Full guide: definition, formula, and benchmarksSalesforceSalesSales Funnel Analysis
Sales Funnel Analysis measures how opportunities progress through each stage of your Salesforce pipeline, from the first qualified opportunity to closed won. It quantifies the conversion rate between adjacent stages in the Opportunity object, the volume of deals resting at each stage, and the time those deals spend before advancing. In Salesforce terms, it reads the StageName field and its history to show exactly where the funnel narrows.
How to calculate sales funnel analysis
Why sales funnel analysis matters for Salesforce users
A Salesforce pipeline can look healthy in aggregate while hiding a single stage where most deals quietly die. Sales Funnel Analysis breaks the pipeline into its constituent stages so leaders can see whether the problem is poor qualification, weak proposals, or slow legal review, rather than guessing from a single close rate.
It also makes forecasting far more honest. When you know the historic conversion rate out of each stage, you can weight open opportunities by where they actually sit, instead of trusting the optimistic close dates reps enter by hand. That turns the Salesforce funnel into a predictive tool rather than a snapshot.
Understand and act on sales funnel analysis with KPI Tree
Sync your Salesforce Opportunity and OpportunityHistory data into your warehouse and compute the funnel in KPI Tree, deriving stage entry and exit counts from StageName transitions. Place the result in a metric tree so each stage conversion rate sits beneath pipeline value and feeds into related metrics like contact conversion rate and contract value analysis, making it clear which stage movements drive revenue.
Assign RACI ownership so the sales operations lead is accountable for funnel definitions while regional sales managers are responsible for the stages they run. Set a weekly review cadence in KPI Tree to catch stage-level slippage early, with a deeper monthly review to spot structural trends in conversion and stage duration.
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
Contact Conversion Rate
CRMMetric Definition
Contact Conversion Rate = (Contacts with Opportunities / Total Qualified Contacts) x 100
Contact conversion rate measures the percentage of contacts in Salesforce that become associated with an opportunity. It evaluates the effectiveness of lead qualification, nurturing, and sales development at converting the contact database into active pipeline.
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.
Activity Volume per Rep
CRMMetric Definition
Activity Volume per Rep = Total Logged Activities / Number of Active Reps
Activity volume per rep measures the total number of logged activities (calls, emails, meetings, tasks) per sales representative in Salesforce over a defined period. It quantifies the effort each rep invests in customer-facing and pipeline-building activities and serves as a baseline for evaluating activity efficiency.
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 sales funnel analysis across integrations
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 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 AnalysisAccount Growth RateActivity Based AnalysisAverage Deal SizeCampaign Attribution AnalysisCampaign ROICase Resolution TimeChurn Risk AnalysisContact Engagement ScoreCustomer Segmentation AnalysisLead Source AnalysisMonthly Recurring RevenueOpportunity Stage AnalysisPipeline VelocityProduct Performance AnalysisQuote To Close RateSales Pipeline ValueSales Rep Quota AttainmentEmpower 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.
