Most pipeline reviews are theater. Thirty minutes of slides, a few defensive comments from reps, zero decisions made. Your forecast doesn’t improve. You don’t catch the slipping deal until it’s too late. Your coverage ratio stays a mystery.
Here’s what changes: a 15-minute framework using Salesforce Pipeline Inspection that actually tells you what’s real. No hypotheticals. No hope-based forecasting. Just the data that matters.
Before You Start: Get Your Environment Right
Pipeline review speed is 80% preparation, 20% analysis. Set this up once, run it every week in under five minutes.
- Open Pipeline Inspection in Salesforce (Setup > Pipeline Inspection). This is your truth engine. If you don’t have it enabled, enable it now.
- Set your date filter: Close date this quarter only. No multi-quarter noise. If it’s Q2, filter April 1 – June 30.
- Apply team or owner filters: Start with one team, then expand. Don’t try to analyze the entire company’s pipeline in 15 minutes — you’ll surface nothing.
- Sort by deal size descending. Largest opportunities first. Your time is finite; your biggest revenue bets come first.
- Have last activity date and close date columns visible. These two fields do 70% of the diagnostic work.
Step 1: Set Your Filters Right
Garbage filters produce garbage insights. Get this wrong and you’ll spend 15 minutes looking at deals that close in six months or belong to a different team entirely.
- Filter by close date. This quarter only. Not “next 90 days.” This quarter. You’re looking for urgency and forecast reality, not pipeline breadth.
- Filter by owner or team. If you’re a VP, pick one team. If you’re a sales ops manager running a full review, segment by Enterprise, Mid-Market, and SMB. Don’t boil the ocean in one pass.
- Sort by deal size descending. Opportunities over $50K first (adjust for your company’s ACV). The big deals move the needle.
- Include all stages from Qualification onward. You want the whole funnel this quarter — this tells you about velocity and stage health, not just what’s about to close.
You now have a clean list of the deals that actually matter for this quarter’s outcome. Proceed.
Step 2: Check Activity Levels
Last activity date is your health signal. A deal with no activity in 14+ days at Qualification or Proposal stage is stalled. It’s not “in the works.” It’s dead weight in your pipeline. A deal with no activity in 7+ days at Negotiation stage is warming up to a slip.
Here’s what healthy looks like by stage:
- Qualification: Activity within 7 days. This is discovery — if the rep isn’t talking to the buyer, you’re not moving.
- Proposal: Activity within 10 days. The deck went out; there should be follow-up motion. Silence here is a bad sign.
- Negotiation: Activity within 5 days. The deal is warm. The rep should be in constant contact.
Scan your list. How many deals have gone 14+ days without a note, call, or email logged? That’s your stall rate. A stall rate above 20% in Proposal or later means your reps aren’t following up. A stall rate above 10% in Qualification means your pipeline is weak at the top.
Document it. Move on.
Step 3: Spot Close Date Slippage
Deals slip. That’s normal. Deals that slip twice in three weeks are signaling something else: the rep doesn’t believe in the close date, or the buyer is slow-walking the deal. Both require intervention.
What to look for:
- A deal that was supposed to close last month but is still in Proposal. That’s a 30+ day slip. The buyer probably isn’t as ready as the rep claimed.
- A deal that’s been in Negotiation for more than 60 days. Either the economics are broken or it’s looping back to Legal for the third time. Either way, it’s stuck.
- A deal with a close date five days away that’s still in Proposal. Not closing. Move the date and reset expectations now.
For each slipped deal, ask the rep one question: “What changed?” Did the buyer’s budget process get delayed? Did a stakeholder leave? The answer tells you if this is a deal problem or a process problem.
Step 4: Flag At-Risk Deals
Risk is a combination signal. Use this matrix:
- High value (top 30% of ACV) + late stage (Proposal or Negotiation) + 14+ days no activity = Immediate call with the rep. This week.
- High value + mid-stage (Qualification) + 21+ days no activity = Manager conversation. The deal may be dead but nobody pulled the plug.
- Any deal over $100K with close date slippage = Review the opportunity record. Talk to the rep. You need to know why.
If you have Einstein Relationship Intelligence or Einstein deal scores enabled, use those as a secondary check. If Einstein scores a deal as at-risk and your activity check agrees, move it to the top of your list. If Einstein scores it high but activity is dead, activity trumps the algorithm — trust what you can see.
Step 5: Build Your Weekly Risk List
You’ve flagged at-risk deals. Now build a working list for this week’s coaching. The list should have 5–10 deals max. If you have 25 at-risk deals, you’re looking at a pipeline problem, not individual deal problems — fix that first.
For each of the 5–10, document:
- Deal name, value, and stage
- Last activity date and days-since
- Close date vs. today
- One-sentence diagnosis: “No buyer motion in 18 days” or “Slipped from April 10 to May 1” or “Stuck in Legal review for 45 days”
- Required action: “Rep needs to call buyer to confirm timeline” or “Manager should facilitate Legal escalation”
Everything else in the pipeline runs without you. This list is the exception — the deals requiring management attention this week.
The 3 Questions Every Pipeline Review Must Answer
After running the steps above, answer these three. If you can’t, your review isn’t done.
1. What’s Actually Going to Close This Quarter?
Filter out deals with 14+ days no activity, deals with slippage, and deals where stage age is unrealistic. What’s left is your real forecast — what you should actually report to your CFO. Most companies overforecast by 20–40% because they count pipeline instead of deals-likely-to-close. You just cut through that noise.
2. Where Do We Need to Intervene Right Now?
Your 5–10 deal list. Schedule the coaching conversations. Hold reps accountable to agreed actions. Follow up next week.
3. What Does Our Coverage Ratio Look Like?
Divide your total open pipeline by your quarterly target. Healthy coverage is 3–4x your target.
Example: Q2 target is $2M, open pipeline is $6M = 3x coverage. Good. At 2x or below, you have a top-of-funnel problem. At 5x or above, either close dates are too conservative or win rates are low. Both need investigation.
SalesQuants Benchmark Cheat Sheet
| Metric | Healthy | Warning Sign |
|---|---|---|
| Pipeline Coverage Ratio | 3–4x quarterly target | <2.5x or >5x |
| Days Since Last Activity | Qualification <7d · Proposal <10d · Negotiation <5d | Any stage >14 days |
| Close Date Changes | 1 slip per deal per quarter | 2+ slips in 3 weeks |
| Stage Age (Enterprise $250K+) | Qualification <45d · Proposal <60d · Negotiation <45d | Qualification >90d · Proposal >90d · Negotiation >60d |
| Activity per Week per Rep | 8–15 logged activities | <5 per week |
What You’ve Accomplished in 15 Minutes
You now have a real forecast (not inflated pipeline), a 5–10 deal intervention list with specific actions, visibility into rep activity levels and deal health, and data to answer CFO questions about forecast confidence. No theater. No slides. Just the decisions that move revenue.
This is the Wednesday installment of the SalesQuants Salesforce Agentic Era series. Read Monday’s article on Agentforce 360 for the full picture on where Salesforce AI is headed. Subscribe to the newsletter to get the Friday Slack + Salesforce workflow guide delivered to your inbox.
