How To Compare Your Sales Quota With Performance in Salesforce

This guide provides practical advice on comparing sales funnel coverage with sales quotas in Salesforce.

It summarises key ideas from the full best practice article and explains how to combine sales targets, pipeline value, weighted pipeline, and expected revenue to determine whether there is enough high-quality funnel to achieve monthly, quarterly, and annual targets.

---

Why This Matters

Knowing the total value of your sales funnel is not enough to determine whether you will hit quota. A pipeline can look large while containing too many early-stage or low-quality opportunities that are unlikely to close within the required period. Comparing your funnel with quota using weighted pipeline and expected revenue gives sales managers a much clearer view of whether targets are realistically achievable.

---

Key Insights

• Compare pipeline directly with quota: Create sales target records for each salesperson and time period so that funnel value can be measured against the relevant sales quota.
• Automatically link opportunities to targets: Opportunities should be associated with the appropriate target based on factors such as Opportunity Owner and Close Date. If the Close Date changes, the opportunity should move to the corresponding target period.
• Use expected revenue as a key metric: Combine Closed Won revenue with the weighted value of open opportunities to estimate likely revenue. This provides a more meaningful view of target attainment than total pipeline value alone.
• Consider the shape of the funnel: Pipeline stage matters. A large amount of early-stage pipeline due to close this month may provide little confidence, while the same pipeline composition for a target several months away may be appropriate.
• Combine target reporting with pipeline quality management: Expected Revenue is only as reliable as the opportunities and probabilities behind it. Use pipeline quality metrics to identify and remove deals that are inflating the funnel.

---

How To Apply This

1. Create sales target records.
   Set up a target for each salesperson and reporting period. Monthly targets are useful for detailed performance management, but the approach can also support quarterly or other reporting periods.
2. Link opportunities to the appropriate target.
   Associate opportunities with the relevant salesperson and target period using the Opportunity Owner and Close Date. Ensure opportunities automatically move to the correct target when their Close Date changes.
3. Track four core funnel metrics.
   Monitor:
   • Won Amount: Revenue from Closed Won opportunities.
   • Funnel Amount: Total value of open opportunities.
   • Weighted Sales Funnel: Pipeline value adjusted for opportunity probability.
   • Expected Revenue: Won Amount plus Weighted Sales Funnel.
4. Compare Expected Revenue with quota.
   Use Expected Revenue to determine whether the salesperson, team, or company is likely to achieve its target. A shortfall indicates that additional pipeline or improved conversion is required.
5. Check the funnel shape and quality.
   Review the opportunity stages behind the target. For example, if the average sales cycle is 90 days, a large amount of Prospecting-stage pipeline due to close this month should be treated cautiously.
6. Review and remove poor-quality opportunities.
   Use additional Salesforce reports and pipeline quality metrics to identify deals that have slipped repeatedly, remained unchanged for too long, or otherwise have little chance of closing. Removing these opportunities gives you a more realistic view of future revenue.

---

Read The Full Article

For a deeper dive, including examples and detailed guidance, read the full blog:

How To Compare Your Sales Funnel With Quota In Salesforce

---

Related Guidance

• How To Measure Sales Pipeline Coverage With Confidence
• The Myth About 3x Pipeline Coverage—and What to Do Instead
• The Best Way to Track Sales Targets in Salesforce
• Master Your Pipeline Coverage with the Sales Manager Dashboard

---

Request Further Support

If you’re still having some trouble, we’re more than happy to help. Let us know what you’re struggling with using the form below, and we’ll be in touch as soon as possible.