A simple pipeline board for freelance web designers

A pipeline board for freelance web designers does not need to be complicated to earn its keep. Most freelancers who prospect for themselves start with nothing more than intention: a rough memory of who they emailed last week, a vague sense of who replied, and no record at all of who they meant to chase and never did. That gap is where a lot of outbound effort quietly leaks away, not in the writing of the emails but in losing track of what happened after they were sent.

Why a mental list stops working

At five prospects a week, memory is fine. You can hold a joiner in Batley and a beauty salon in the next town over in your head without much effort. At twenty a week, which is roughly what it takes to keep a steady flow of replies coming in, memory starts dropping things. You forget which of two plumbers you already followed up with. You send a second email to someone who replied three days ago asking for a quote, because the reply got buried under other work. You never follow up with a genuinely promising prospect at all, because nothing told you it was due. None of this is a discipline problem. It is what happens when the number of things to track exceeds what a person can hold in their head while also doing the actual work.

The stages a simple pipeline actually needs

A pipeline board for a freelancer does not need the dozen stages a sales team might use. Something close to this covers almost every case:

• Found: a prospect worth emailing, not yet contacted
• First email sent: waiting to hear back
• Opened or clicked: some engagement, no reply yet
• Replied: a conversation has actually started
• Quoted: a price is out, waiting on a decision
• Won, lost, or gone quiet: the outcome, whatever it turned out to be

The point of keeping it this short is that you can glance at the board and know what to do next without reading notes. A prospect sitting in “first email sent” for more than a week needs a follow-up. One sitting in “quoted” for two weeks needs a different kind of nudge. Add more stages than that and the board starts needing its own maintenance, which is exactly the kind of overhead a solo freelancer does not have time for.

What to record against each prospect

Keep it to one row per prospect and a small, fixed set of fields: business name and trade, the specific issue you are pitching around (a slow site, no mobile version, a dead contact form), the date of the first email, the date of the last touch, and what the next action is. Resist the urge to add a field for everything you might one day want to know. A pipeline with thirty columns is a pipeline nobody keeps updated after the first fortnight, and a board that is not kept updated is worse than no board at all, because it gives you false confidence that you know where things stand.

Spreadsheets work until they don't

A spreadsheet is a perfectly reasonable place to start. It is fine for a handful of prospects, and it costs nothing. The trouble starts as the list grows past thirty or forty rows: sorting by stage, filtering out the ones already lost, and spotting who is overdue for a follow-up all take manual effort every single time you open the file. That friction is small on any one day and adds up over months into a sheet that gets checked less and less often, right up until a genuinely good prospect goes cold because nobody noticed they were due a nudge.

Timing follow-ups off the board, not from memory

The main job a pipeline does is tell you who is due a follow-up today, which is a question memory answers badly and a dated field answers instantly. The timing and content of that follow-up is its own subject, covered in the follow-up email after no response, but none of that advice matters if the board never surfaces who needs one. A prospect who replied and went quiet after a quote is a different kind of follow-up to one who never opened the first email at all, and the board should make that distinction obvious at a glance rather than something you have to reconstruct from memory.

Keeping the board honest

It is tempting to track everything a modern inbox can measure: every open, every click, every re-open days later. Most of that detail is noise rather than signal, for reasons covered in what open and click tracking actually tells you. A pipeline board works best when it reflects real stages a prospect has moved through, not every twitch of engagement data, otherwise you end up staring at numbers instead of deciding who to email next.

When it stops being a one-person job

A spreadsheet-based board holds up for a solo freelancer working through a steady stream of local prospects. It starts to strain once you are tracking outreach across several towns or trades at once, or once a second person joins and both of you need to see the same board without overwriting each other's updates. Building it by hand works, but it takes real discipline to keep the sheet current every time a prospect replies or a follow-up goes out. Patchscout puts every business you find, audit and email onto a pipeline board automatically, tracking opens, clicks and replies against each one, so you can see who is actually due a follow-up rather than scrolling a spreadsheet to work it out. The three free searches at app.patchscout.co.uk/signup are enough to see a real pipeline build itself against a trade and town you already know.