Use this when: The quarter is starting (or mid-quarter) and you need to know what's real, what's at risk, and where to focus. Also use this when close rates drop, deal velocity slows, or you suspect the gap between how you think your sales process works and how it actually works has grown.
You're done when: Every deal in the pipeline has a status (advance, at risk, or kill), you've identified the one constraint limiting revenue, and you've listened to what your sales process actually sounds like from the outside.
The Sequence
1. Secret-shop your own process
Before you look at any numbers, experience your sales process as a prospect would. Call your own company (or have someone do it). Submit a form on your website. Reply to one of your outbound sequences. Go through the entire buyer journey.
You will be horrified by what you hear. Your team will skip steps from the script. The follow-up will come 3 days late. The demo will run 20 minutes when it should be 5. You have a beautiful mental model of how your sales process works. It's a lie. Secret-shopping shows you reality.
Do this with a checklist:
-
Did they qualify you?
-
Did they follow the on-call SOP?
-
Did they book a next meeting (BAMFAM)?
-
How long until the follow-up arrived?
-
What was the tone? Peer-to-peer or obsequious?
-
Deliverable: A secret-shop report with specific observations and gaps between your SOP and actual behavior.
-
Common mistake: Telling your team you're going to secret-shop them. The point is to see reality, not a performance.
2. Pull the funnel metrics
Export your pipeline data and calculate each conversion rate in the funnel:
- Leads → Contacted (outreach rate)
- Contacted → Discovery scheduled (schedule rate)
- Discovery scheduled → Discovery completed (show rate)
- Discovery completed → Proposal sent (offer rate)
- Proposal sent → Closed Won (close rate)
- Average deal size
- Average time in each stage
- Total pipeline value vs. quota
The constraint is usually not where you think it is. Most founders fixate on close rate, but a 20% improvement in show rate has exactly the same revenue impact. Find the stage with the biggest drop-off. That's your constraint.
Two additional views will sharpen your diagnosis. First, build a pipeline waterfall: compare your pipeline at the start of the quarter to today, and break the change into four buckets — new opportunities added, value changes on existing deals, close-date slippage (deals that pushed to next quarter), and wins/losses. This shows you whether your pipeline is growing, shrinking, or just churning. A pipeline that looks the same size quarter over quarter can mask a problem if you're constantly adding new deals to replace ones that slipped or died. Second, calculate cohorted win rates: group opportunities by the month they were created and track what percentage closed won, lost, or are still open. This reveals patterns that aggregate win rates hide — like a batch of deals from a specific campaign that are all stuck, or a month where win rates cratered because of a pricing change.
- Deliverable: A funnel report showing conversion rates between every stage, plus a pipeline waterfall and cohorted win rates, with the top constraint highlighted.
- Common mistake: Only looking at top-line close rate. A 40% close rate can mask a 30% show rate problem that's silently killing half your pipeline.
3. Grade every deal
Go through every active deal in the pipeline and assign a status:
- Green (advance): Has a next step, a decision-maker engaged, and a timeline. This deal is moving.
- Yellow (at risk): Missing one of the above. Needs a specific action this week or it dies.
- Red (kill): No next step, no response in 14+ days, or the prospect doesn't have budget/authority/need. Remove it from the pipeline. Dead deals inflate your forecast and distort your planning.
Be ruthless. A fat pipeline of yellow and red deals is worse than a skinny pipeline of green ones. You can't fix what you won't acknowledge.
- Deliverable: Every deal tagged green, yellow, or red, with a specific next action for every yellow deal.
- Common mistake: Keeping dead deals in the pipeline because removing them makes the number look bad. The number is already bad. You're just hiding it.
4. Identify the constraint
From the funnel data and deal grades, identify the single biggest constraint on revenue. It's usually one of:
- Volume: Not enough leads entering the top of the funnel
- Conversion: A specific stage has an abnormally low conversion rate
- Velocity: Deals are taking too long in a particular stage
- Offer/packaging: The product or pricing isn't compelling enough (prospects like the call but don't buy)
- People: The same problem keeps recurring under the same person quarter after quarter
If the same problem has recurred multiple quarters in a row in the same department under the same person, it might not be a "what" issue. It might be a "who" issue.
- Deliverable: One sentence: "The constraint is ___. The fix is ___."
- Common mistake: Trying to fix everything at once. Pick the one constraint with the highest leverage and fix that. Then move to the next one.
5. Listen to game tape
Pull 3-5 recorded calls from the quarter — a mix of won deals, lost deals, and deals that stalled. Listen to each one with three questions:
- What went right on this call?
- What went wrong?
- What would we do differently next time?
Do this as a team if you have one. A 30-minute daily game tape review is the single highest-ROI training activity in sales. You'll catch patterns no dashboard reveals: reps who monologue, discovery questions that produce dead air, pitches that run 10 minutes instead of 3.
- Deliverable: A list of 3-5 specific coaching actions based on call recordings.
- Common mistake: Only listening to won deals. The lost and stalled calls are where the lessons are.
6. Set the next quarter's targets
Based on the review, set targets for the next quarter (or the remainder of the current one):
- Pipeline coverage: 3x your revenue target in qualified pipeline
- Conversion targets for each funnel stage (focus on improving the constraint stage by 10-20%)
- Individual quotas if you have a team
- One process change to address the top constraint
Commit to a cadence: weekly 30-minute pipeline check-ins (deal-by-deal), monthly metric reviews (funnel analysis), quarterly full reviews (this sequence).
- Deliverable: A one-page plan with targets, the constraint fix, and the review cadence.
- Common mistake: Setting aggressive targets without addressing the constraint. If the problem is show rate, adding more leads doesn't help. Fix the show rate first, then scale volume.
Template
Example
A B2B SaaS startup doing $80K/month reviewed their pipeline at mid-quarter. The secret shop revealed that their SDR skipped the qualification step entirely and jumped straight to booking a demo — which explained why 40% of demos were with people who had no budget. Funnel analysis confirmed: show rate was fine (72%), but close rate after demo was 12%, well below the 25% target. The constraint wasn't the closer's skill — it was unqualified demos. They graded 34 active deals: 8 green, 11 yellow, 15 red. Killing the 15 red deals dropped the pipeline from "$420K" to "$190K" — which felt painful but was the truth. The fix: add a 10-minute qualification call between "interested" and "demo scheduled," with three gate questions about budget, timeline, and decision process. Within 6 weeks, demos dropped by 30% but close rate climbed to 28%. Revenue went up, not down, because every demo was now with a real buyer.
Written with ❤️ by a human (still)