Sales Follow-Up Tracker: The Six Mistakes That Let Deals Go Quiet

Almost nobody loses a deal in a meeting. They lose it in the eleven days after one, while intending to send a follow-up email.

The frustrating part is that this is not a selling problem. Every one of the failures below is a record-keeping failure with a dollar figure attached, and each one is visible the moment a sheet holds a dated next action against every open deal.

The figures here come from one worked pipeline — 22 open deals worth $392,150 — that sits under the client CRM and pipeline guide. Six mistakes, in the order they cost money.

1. Treating Overdue and Stalled as the Same List

They are different failures and they want opposite responses.

Overdue is a next action whose date has passed. You decided what to do and did not do it. In the worked pipeline: eight overdue actions holding $80,450, the worst of them nine days late on a $9,250 deal. The fix is mechanical — make the call.

Stalled is a deal nothing has happened on in longer than your threshold, whatever stage it claims to be in. Seven deals, $61,100, the largest being $17,600 untouched for 29 days. Nobody is late on it, because nobody scheduled anything. The fix is not mechanical: the conversation itself has gone cold and repeating the last message will not restart it.

Merge these into one “needs attention” list and the $17,600 sits behind six calls that are technically more urgent and worth less.

The distinction also exposes the most expensive illusion in any pipeline: stalled is not a stage. A deal can sit in “Negotiating” for a month, look perfect on every stage-based report, and be dead. Only a days-since-contact column catches that.

2. Leaving the Next Action Blank

A deal with no scheduled next action cannot be late. It is invisible to the overdue report, invisible to the stalled report if it was touched recently, and it will keep looking healthy until the quarter ends.

In the worked pipeline there are two of them, worth $22,550 — about 13% of the weighted forecast, sitting in a blind spot.

This is why a next-action count belongs on the dashboard as a number in its own right, not as a filter someone remembers to apply. Zero is the only acceptable value. Every open deal has a next thing, even if the next thing is “decide whether this is still real.”

3. Writing a Next Action You Cannot Do

“Follow up” is not a next action. Neither is “check in.”

A next action has a verb, a person and a channel: call Dave about the March start date. The test is whether you could do it at 7:40am without re-reading the thread. If you have to open the email chain to work out what you meant, the task will be postponed, and postponed tasks are how eight actions end up nine days late.

The same applies to the date. “Next week” is not a date. A specific Tuesday is.

4. Using One Follow-Up Interval For Everything

A fresh inbound lead and a quote sitting with a buyer decay at completely different speeds. One rule for both means you are either pestering people at the top or losing quotes at the bottom.

Intervals worth setting once, by stage:

Quoted deserves the tightest interval of the lot, which surprises people. A quote has a shelf life — in the worked business the average quote is decided in 15 days, and nine are currently waiting. Anything sitting past about double the average is a no that has not been said out loud, and it should move to a decision-forcing message rather than a fourth polite check-in.

5. Setting a Stall Threshold Out of Thin Air

Fourteen days is a common threshold because it sounds tidy, not because it fits anyone in particular.

Set it against your own cycle: roughly a third of your average days-to-close. In the worked business, deals close in 50.9 days on average — fastest 13, slowest 69 — so a 14-to-21-day silence genuinely is unusual and worth flagging. In a business closing in 12 days, 14 days of silence means the deal is long gone. In one closing in 200, it means nothing at all.

The spread matters as much as the average. When the slowest normal win takes 69 days, a deal at 90 days is not “nearly there” — it is outside the range of everything that has ever worked, and it should be re-qualified rather than chased.

6. Forgetting the People Who Already Paid You

The cheapest pipeline in any business is the client list. They have bought, the trust exists, and the acquisition cost was paid long ago.

In the worked business, five past clients worth $100,250 of prior revenue have had no contact in the dormancy window — more than half the entire weighted forecast, sitting in a list nobody runs because past clients are not leads and therefore appear on no pipeline report.

One dormant-client view, sorted by lifetime value, and one message a quarter. It is the highest-return twenty minutes in the whole system and it exists purely because the sheet keeps a last-contact date on clients as well as on open deals.

The Weekly Twenty Minutes

Three lists, in this order — descending order of how close the money is:

1. Overdue, worst first. Do the thing or change the date, and be honest about which.
2. Stalled, biggest first. Not another nudge: a different approach, or a decision to mark it lost with a reason.
3. No next action. Give each one a verb, a person and a date, or close it.

In the worked pipeline that is $80,450, then $61,100, then $22,550. Twenty minutes, once a week, against $164,000 of deals that would otherwise drift — and the reason it takes twenty minutes rather than an afternoon is that the sheet built all three lists on its own from dates you were already typing.

Related: how to calculate a weighted pipeline forecast, and win/loss analysis for the deals that do get away.

Featured on ReadySheetGo

Client CRM, Sales Pipeline & Lead Tracker — $16.99

Thirteen linked tabs and 7,217 formulas, pre-filled with the 46-lead business used above.

The Follow-Ups tab counts down to every next action and then counts up past it, building three separate lists on its own: overdue worst-first, stalled biggest-first against a threshold you set, and a standing count of open deals with no next action at all. The Clients tab adds the fourth — a dormant list of people who already paid you once, ranked by lifetime value. Quotes runs an expiry clock and an average days-to-decision.

Alongside them: Pipeline and Forecast with weighted values and rolling 30/60/90-day windows, Win-Loss ranking loss reasons by revenue, Source ROI returning a true cost per win, plus Leads, Activity, Dashboard, Settings and Lists. Row checks catch a deal with no owner and a lost deal with no reason.

Works in Excel and Google Sheets. No macros, no add-ons.

Get the Client CRM, Sales Pipeline & Lead Tracker →