The No Log: A Free Tool for Tracking Your First 100 Rejections
Most CRMs are built to track why deals close. Almost none of them track why deals don’t.
In No Startup Left Behind, I wrote about what I call the Rule of 100 No’s: before you worry about winning your first 100 customers, go hear your first 100 no’s, and learn something from every one of them. Each rejection holds a piece of what it will take to win the next deal.
The problem is that almost nobody writes the no’s down. Wins get a full recap. Losses get a dropdown in the CRM, and the most valuable insights in the whole sales process ends up never being recorded.
So I built a free tool for it. The No Log.
→ Download The No Log (free Excel spreadsheet)
How it works
Every time someone tells you no, add a row. Record who said it, which of the 7 Deadly No’s it was, what they said, and your honest read of what they actually meant. A dashboard fills in a 100-square grid as you work toward 100 and shows you which kind of no keeps coming up.
One rule matters more than the rest: not every no should change your offer. A no from someone who was never going to be your customer is noise. A no you keep hearing from the right customers is the signal. That’s why each entry asks whether they were your ideal customer, and why the dashboard only suggests changing your pitch based on the no’s that came from the right people.
It works in Excel and Google Sheets, and it’s yours to keep.
Not sure which no you just heard?
The Knee-Jerker, the Circle Backer, the Info Monster, the Budget King, the Catch Me If You Can, the Ghoster, and the Balloon Popper each sound different, mean different things, and call for a different response. I break down all seven in The 7 Deadly No’s.
If this was useful, subscribe to my newsletter for a new startup lesson every week.
The Rule of 100 No’s and the 7 Deadly No’s come from my work and my book. I built this spreadsheet with help from Claude, an AI assistant.