A sales team I worked with tracked its deals in two places: their inboxes and their heads. Nobody could see the whole pipeline. Nothing connected the marketing to the sales. If two people called the same customer in the same week, there was nothing that would have told them.
It is a very human way to run a sales team. It is also a very leaky one.
What is my take on losing leads?
My view: the problem is almost never the people. A team that loses leads is usually working inside a process that has no place to put a lead. Buying a CRM before you have agreed what happens to an enquiry is how you end up with an expensive inbox. I would fix the process on paper first, then choose the tool. That is my opinion from the work I have done, not a rule, and the audit below will show you how big your own problem is.
Where do leads actually go missing?
Almost never in one dramatic moment. They leak out in small, forgivable ways:
- The enquiry lands in a shared inbox and everyone assumes someone else replied.
- A WhatsApp message arrives on one person's phone, and that person goes on holiday.
- A form sends an email that lands in spam, or does not send at all.
- A deal is reassigned and the new owner never sees it.
- A follow-up was promised and lived only in someone's memory.
If you recognise two of these, you do not have a motivation problem. You have a system problem.
What does a CRM change?
A CRM (customer relationship management system) is a shared list of every lead, who owns it and what happens next. That is all. It is less exciting than the name suggests, and the boringness is the point.
The version I built for that team has invite-only logins, three roles, a board that shows every deal as a card moving across stages, customer profiles, notifications and branded emails. Permissions are enforced in the database itself, so a consultant only ever sees their own leads, even if they type a web address directly. If you want to know how that works, Supabase explains row level security well.
I also linked it to the website, so every enquiry lands as a tagged deal automatically instead of a message someone has to copy across.
What was the bug that said nothing was wrong?
This is my favourite kind of failure, because it is silent.
The CRM was meant to email people when a lead arrived. It looked like it worked. No error appeared anywhere. The emails simply never sent.
The cause was a quirk of how this kind of software runs. Parts of it run as short-lived "serverless functions" that start when needed and shut down as soon as they decide they are finished. Here the function was shutting down before the email code had a chance to run. The system was not failing. It was leaving the room before the sentence ended. You can read how these functions work in Vercel's documentation.
I fixed it by keeping the function alive until the email had really gone out. Then I added the lesson to my own checklist: "no error message" does not mean "it worked". Send yourself a real one and look in the inbox. Email services such as Resend can tell you a message was accepted for sending, which is a different statement from "the recipient has it", so check both.
A second bug made reassigned leads half-invisible. The fix there was not only to repair it but to make checking for it a standing rule for every new page I build. If a mistake can happen once, it can happen on page twelve.
How do I check whether my own leads are leaking?
Run this small audit. It takes about an hour and it is humbling.
- List every place a lead can arrive: website forms, email, phone, WhatsApp, social messages, walk-ins.
- For each, write who sees it and where it gets written down. If the second answer is "nowhere", that is a leak.
- Submit a test enquiry through every form and watch what happens. Check spam. Check it arrived at all.
- Ask your team what happened to the last five leads. If the answers differ, you do not have a shared picture.
- Count the time. How long between an enquiry arriving and a human replying? Write the number down.
You do not need to buy anything to do this. You need a notepad and a willingness to be told off by your own process.
Do I need a CRM, or can a spreadsheet do it?
For one person with a handful of leads, a spreadsheet is fine. It starts to strain when more than one person touches the same lead, when follow-ups matter, or when you want to know where leads come from. The honest test is: if the person who manages the sheet disappeared for a week, would anything break? If yes, you have outgrown it.
What should I do first?
Do the audit above. Then fix the biggest leak, not all of them. The first goal is that every enquiry has a home and an owner. Everything else, the pretty boards and the automations, comes after.
The full story of this build is Case 002 in the case files. I also have a live demo of the CRM with fictional data. If your leads are living in inboxes, you are welcome to book a call and bring the mess.
Frequently asked questions
What is the difference between a CRM and a spreadsheet?
A spreadsheet stores information. A CRM also assigns owners, sends reminders and shows you the whole pipeline at once, and several people can work in it safely at the same time.
Will my team actually use it?
Only if it is built around how they really work. I gathered requirements from the people who would use it and built a click-through prototype first, so they could react before any real code existed.
Can leads from my website go into a CRM automatically?
Yes. A form can create a deal directly. That removes the copy-and-paste step, where many leads get lost.
How do I know the notification emails are really sending?
Test them with a real submission and check the inbox, including spam. Never trust the absence of an error message.
