What I track in my deal-by-deal forecasting (and what I dropped)

What I track in my deal-by-deal forecasting (and what I dropped)

For the first four years of my sales leadership career, my forecasting spreadsheet looked like a dashboard for a nuclear submarine. I tracked 22 different metrics per deal. I made my reps fill out 14 custom fields in Salesforce before every 1-on-1. The result? A pipeline filled with outdated, fabricated garbage. Reps lied to appease me, and my monthly revenue projections were off by an average of $145,000.

Forecasting isn’t about collecting data points. It is about stress-testing the probability of a transaction. I stripped my tracking down to the raw elements that actually dictate whether a contract gets signed. I deleted the fluff, stopped asking for arbitrary percentages, and focused strictly on the mechanics of the close.

Here is exactly what I track in my deal-by-deal forecast today, and the vanity metrics I forcefully sent to the graveyard.

The Mutual Action Plan Checkpoint

I do not track “close date” unless it is explicitly tied to a Mutual Action Plan (MAP). Asking a rep, “When is this closing?” yields a hopeful guess. Checking the MAP yields a concrete timeline.

If a rep tells me a $65,000 enterprise deal is closing on November 15th, my only tracking metric is whether the prospect has agreed in writing to the specific sequence of events leading to that date. If there is no documented alignment, the deal probability drops to zero in my forecast, regardless of what stage it is in the CRM.

When a rep says, “They verbally agreed to sign next week,” I give them this exact script to validate that claim:

“John, to make sure we hit your target launch date of December 1st, we need the security review finished by the 10th and procurement signed off by the 15th. Is your team aligned to hit those specific milestones, or do we need to adjust the timeline?”

If the prospect dodges the question or offers a weak objection like, “We’ll try to get it done,” the deal is immediately downgraded. I track confirmed milestones, not hopeful estimations.

The Champion’s Political Capital

A champion who likes your product is useless if they have no political capital. I used to track “Champion Status” on a binary Yes/No scale. Now, I track “Executive Exposure.”

I need to know exactly how much influence our main point of contact has over the check-signer. I measure this by tracking whether the champion is willing to introduce us to economic buyers or defend us against competitors internally.

If the prospect stalls on an introduction to the VP of Finance, I tell my reps to use this direct response:

“Sarah, I know you’re championing this, but typically when we see CFOs review a $120,000 unbudgeted line item without prior context, they kill the project entirely. How do we get 10 minutes on his calendar this week to walk him through the ROI model you and I just built?”

If the champion refuses to make the introduction or says “I’ll pitch it to them first,” they aren’t a champion. They are an informational resource. In the forecast, I flag this deal as “Single-Threaded” and deduct 40% from its probability to close.

Identifying the Exact Budget Source

I dropped the standard “Is there budget?” tracking field. Every company has a budget for things they actually care about. Instead, I track the exact origin of the funds.

If a rep submits a $45,000 deal for the forecast, I require them to know exactly whose P&L the money is coming from. Are they pulling from discretionary funds? Are they reallocating Q3 marketing spend? Are they asking for net-new net approval from the CFO?

If the prospect gives a vague “We have the budget,” the rep must clarify using this script:

“Understood. Just so I can align our procurement process with yours, does this $45,000 require formal board approval, or does this sit entirely within your departmental discretionary spend?”

If the rep doesn’t know the exact budget source, it is a pipeline pipe dream, not a forecastable deal. I refuse to track deals where the money is purely hypothetical.

The Legal and Security Black Hole

More deals die in legal and security than in head-to-head competition. I used to track “In Procurement” as a single, massive stage. That was a $250,000 mistake in Q4 of 2021 when three major deals got permanently stuck in redlines.

Now, I track the exact turnaround time of the prospect’s legal team. I require reps to ask the prospect about their internal SLA for contract review during the proposal stage.

“Before we send over the MSA, what is your legal team’s current backlog looking like? If we send this on Monday, are we looking at a 48-hour turnaround or a two-week review cycle?”

In the forecast, I track the specific days a contract has been in legal. If a prospect’s legal team averages a 14-day turnaround and we are on day 15, the deal gets flagged yellow. If we hit day 21 without a redline return, it is pulled entirely from the commit.

Metrics I Completely Dropped

To make room for actionable data, I aggressively purged vanity metrics from our CRM and our weekly forecast reviews.

CRM Stage Probability Percentages: I completely eliminated default stage percentages (e.g., “Stage 3 = 50% probability”). Deals are not coin flips. A deal is either progressing on a mutually agreed timeline or it is stalling out. We forecast on milestone completion, not arbitrary CRM stage math that makes reps feel safe.

Email Open Rates on Proposals: Reps used to say, “They opened the proposal 14 times, they’re definitely signing.” No, they forwarded it to legal, who forwarded it to procurement, who left it open in a browser tab. We stopped tracking proposal engagement completely. We only track direct, written confirmation of next steps.

Competitor Features: I stopped tracking which specific features our competitors were pitching in head-to-head deals. It led to highly reactive selling. If we are playing defense against a feature list, we have already lost control of the buying criteria. Instead, we track our alignment with the executive’s core business problem and ignore the feature war.

Forecasting is an exercise in ruthless truth-telling, not wishful thinking, and by stripping away the noise to track only the friction points that prevent a deal from closing, you can predict your revenue with absolute surgical precision. If you want to build a sales organization that hits target every single month without the end-of-quarter panic, visit mysalescoachnow.com to learn how we train teams to completely dominate their pipeline.