Salesforce Metric
Sales
Sales Rep Quota Attainment = Closed Won Amount per Rep in Period / Assigned Quota per Rep in Period x 100
Sales Rep Quota Attainment measures how much of an assigned quota each Salesforce rep has closed within a period, expressed as a percentage. In Salesforce, it is calculated from Closed Won opportunity amounts joined to the quota stored on the Forecasting Quota object or a custom quota field, grouped by Opportunity Owner. It tells you, rep by rep, who is ahead of plan and who is behind.
Full guide: definition, formula, and benchmarksSalesforceSalesSales Rep Quota Attainment
Sales Rep Quota Attainment measures how much of an assigned quota each Salesforce rep has closed within a period, expressed as a percentage. In Salesforce, it is calculated from Closed Won opportunity amounts joined to the quota stored on the Forecasting Quota object or a custom quota field, grouped by Opportunity Owner. It tells you, rep by rep, who is ahead of plan and who is behind.
How to calculate sales rep quota attainment
Why sales rep quota attainment matters for Salesforce users
Pipeline coverage and forecast accuracy both depend on knowing where each rep stands against quota, not just the team total. A healthy team number can hide a few reps carrying the quarter while others fall short, and a blended figure delays the coaching conversations that change the outcome while there is still time to act.
Tracking attainment per rep from Salesforce turns the forecast into something managers can manage. It surfaces reps who need pipeline support early, highlights consistent overperformers worth learning from, and grounds quota setting for the next period in what reps have actually delivered.
Understand and act on sales rep quota attainment with KPI Tree
Sync your Salesforce opportunity, user and quota data into your warehouse and compute Sales Rep Quota Attainment in KPI Tree by dividing Closed Won amount by assigned quota per Opportunity Owner. Place it in a metric tree alongside activity volume per rep and contract value analysis so you can see whether attainment gaps trace back to too little activity or to deal size, rather than treating the number in isolation.
In KPI Tree, assign RACI ownership so each rep is accountable for their own attainment and the sales manager is responsible for the rolled up view, then set a weekly review cadence through the quarter with a deeper read at period close. That keeps the metric tied to a person and a decision instead of sitting in a dashboard nobody owns.
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
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.
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.
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.
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.
Explore sales rep quota attainment 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 Funnel AnalysisSales Pipeline ValueEmpower 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.
