The fourth eBook in the Sales and Leads category. Most small businesses either run their entire customer list out of memory and a chaotic inbox, or they buy expensive customer list software they never log into. This eBook is the calm middle path: a small system, the right size for a business of one to ten people, that you will still be using in twelve months.
Members ebook·7 chapters· 35 minute read
Chapter 1
Why a Customer List System Matters
The four questions a working system answers in under a minute, the cost of not having one and what good looks like in a small business of one to ten people.
Most small businesses run their customer relationships from memory and an inbox. It works for the first year, when the customer base is small and the owner remembers everyone by name. It stops working somewhere between the hundredth and the three hundredth contact, depending on how good your memory is and how busy you get. By the time you notice it has stopped working, you have already lost ground - customers who would have bought again if you had got in touch, dormant clients who quietly went elsewhere because nobody followed up, prospects who slipped through the cracks because you were sure you had emailed them last week and you had not.
A working customer list system stops that. It is not glamorous and it does not need to be. It is one list, in one place, kept up to date once a week, with the right columns to answer the four questions every owner needs to answer about the people who pay them. This chapter is about what good looks like, what it costs not to have it and how to recognise the signs that it is time to put one in place.
By the end of the chapter you should have a clear sense of whether you are at the stage where this matters, the four questions a system has to answer and a sketch of the simplest version that would suit your business.
The full chapter sets out the four questions, walks through three small businesses at different stages and gives you the test for whether you have outgrown the inbox-only approach.
The four questions
A working system answers four questions in under a minute. Who has bought from us in the last twelve months, what did they spend and when did they last buy. Who is in the middle of buying right now and what stage are they at. Who showed interest in the last six months without buying and is worth a gentle follow-up. When did we last speak to each of them, by any channel. If you can answer all four in under a minute from one place, you have a system. If you cannot, you do not, regardless of how nice the inbox or how big the spreadsheet.
The reason these four questions matter is that they connect directly to revenue. The first one tells you who to nurture for repeat business. The second one tells you what cash is in the pipeline this month. The third one tells you who to recover. The fourth one tells you whether anyone is being neglected. A business that can answer those four questions weekly will outgrow a business that cannot, even if the second business has a better product.
What good looks like in a one-person business
Imagine a freelance copywriter. Twenty active clients in the last year, eight live conversations in progress, perhaps two hundred contacts in total when you count past clients and warm leads. A working system here is one spreadsheet with five tabs - active clients, current opportunities, dormant contacts, suppliers, archive. Each tab has the same set of columns: name, business, contact details, last contact date, next action, notes. The whole thing fits on a laptop screen, takes ten minutes a week to update and answers the four questions instantly. No software needed, no monthly fee, no learning curve.
What good looks like in a five-person business
A small studio of five people, four hundred clients, fifty live opportunities, three people sharing customer-facing work. A spreadsheet starts to creak here, less because of the volume and more because three people cannot reliably edit it at the same time without losing changes. This is where lightweight customer list software earns its keep - the same shape as the spreadsheet, but with each contact on its own page, multiple people editing without conflict and reminders that fire on the right person's phone. The system is still small, still simple, still updated weekly. It is just hosted somewhere designed for shared use.
Signs you have outgrown the inbox
You forgot to follow up someone you meant to last month
Two people in the business contacted the same client twice
You cannot say your top ten customers by spend last year
Looking up the last quote you sent takes more than two minutes
Holiday cover means asking three colleagues for context on each client
The cost of not having one
The cost is rarely a single dramatic loss. It is many small ones. A repeat sale that did not happen because nobody got in touch. A referral that went elsewhere because the customer thought you had stopped trading. A new business win that took a month longer than it should have because the prospect's notes were lost. A new hire who took six weeks to get up to speed because there was no list to hand them. None of these show up in any one month's accounts, but together they amount to ten to twenty percent of revenue in most small businesses we have measured, year after year. A modest weekly habit recovers most of that.
The signs it is time to put one in place
Some signs to watch for. You forgot to follow up someone you meant to follow up last month. Two people in the business contacted the same client twice in a week. You cannot say your top ten customers by spend last year without checking the bank statement. The last time you tried to email past customers about something, you spent a morning copying addresses out of old invoices. Any one of these is fine. Two or three together is the moment to set up the system in the next chapter.
What to do this week
Spend twenty minutes trying to answer the four questions for your business with whatever you have today. Note where you got stuck, what was missing and how long it took. That note becomes the brief for the spreadsheet or software you set up in chapter two.
We covered, in the previous eBook Lead Capture and Follow-Up, what happens to interest in the first three weeks. This eBook is what happens to those people, and to your existing customers, in the months and years after that. The next chapter Spreadsheet vs Customer List Software is the choice that shapes everything after it. Recurring principle: keep existing customers close.
The rest of this chapter walks through the practical steps, the templates and the checklists you need to put it into action. It includes worked examples, copy frameworks and the small decisions that make the difference between a plan that sits in a drive and one that gets used.
Inside you'll find a step-by-step playbook, a downloadable template, a checklist you can run this week and a short list of common mistakes to avoid before you start.
The full action plan, broken into weekly steps.
Ready-to-use scripts, templates and checklists.
Worked examples for different sized businesses.
Common mistakes and how to avoid them.
Members-only chapter
Become a member to read the full chapter
Members get the complete chapter, the step-by-step plan, the templates and the checklists. Cancel anytime.
