Salesforce Metric
Sales
Source Conversion Rate = Converted Leads from Source / Total Leads from Source x 100; Source Pipeline Value = Sum of Opportunity Amount by LeadSource
Lead Source Analysis breaks down Salesforce leads and converted opportunities by the value held in the LeadSource field, so the team can see how each channel performs across volume, conversion, and revenue. In Salesforce, every Lead and Opportunity carries a source, which lets you compare inbound, outbound, events, referrals, and paid channels on a like for like basis. The analysis turns that single field into a ranking of which sources actually generate qualified pipeline and won deals.
Full guide: definition, formula, and benchmarksSalesforceSalesLead Source Analysis
Lead Source Analysis breaks down Salesforce leads and converted opportunities by the value held in the LeadSource field, so the team can see how each channel performs across volume, conversion, and revenue. In Salesforce, every Lead and Opportunity carries a source, which lets you compare inbound, outbound, events, referrals, and paid channels on a like for like basis. The analysis turns that single field into a ranking of which sources actually generate qualified pipeline and won deals.
How to calculate lead source analysis
Why lead source analysis matters for Salesforce users
Most teams have a rough sense of which channels they like, but Salesforce holds the evidence to settle it. Without this analysis budget tends to follow lead volume, which rewards cheap channels that produce leads that never convert and starves the sources that quietly drive revenue.
Reading sources through to closed won, rather than stopping at raw lead counts, tells you where to put marketing and sales effort next quarter. It also exposes data hygiene gaps, since a large block of blank or unknown LeadSource values is itself a signal that attribution at the top of the funnel needs fixing.
Understand and act on lead source analysis with KPI Tree
Sync your Salesforce Lead and Opportunity objects into your warehouse and compute Lead Source Analysis in KPI Tree, segmenting by LeadSource and following each source through to conversion and won revenue. Place it in a metric tree alongside contact conversion rate and customer acquisition cost so you can see how source quality flows into the cost and yield of new business.
Assign RACI ownership so a marketing operations or revenue operations lead is accountable for the numbers and the underlying field hygiene, with sales leadership consulted. Set a monthly review cadence in KPI Tree to reallocate spend and keep source data clean as channels shift.
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.
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.
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 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.
Explore lead source 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 AnalysisMonthly Recurring RevenueOpportunity Stage AnalysisPipeline VelocityProduct Performance AnalysisQuote To Close RateSales Funnel AnalysisSales 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.
