IntermediateLesson 12 of 305 min read

A Client Pipeline You Can Manage

Keep a simple pipeline of leads by stage and last contact date, find follow-ups due, weight the pipeline by stage and turn last quarter's counts into conversion rates.

In this lesson you will

  • Set up a pipeline with stages
  • Find follow-ups that are due
  • Weight a pipeline honestly
  • Turn counts into conversion rates

About 24 minutes

Dev has leads in four places and forgets two

Dev now has leads in an email folder, on sticky notes and in a notebook. Last week a bakery wrote back asking for a quote, and the reply sat unread for six days. By then the bakery had hired someone else. A pipeline is a simple list of every possible client and where each one is in the process. It sounds grand, but a spreadsheet will do. Its job is to make sure that no lead is forgotten, and to show you what to do each morning.

The stages

  • New. Someone you plan to contact.
  • Contacted. You have sent a message.
  • Proposal. They have replied and you have sent a quote.
  • Won. They said yes.
  • Lost. They said no, or stopped replying. Keep the note about why.

For each lead, record the name, the stage, the date of the last contact and the possible fee. That is only four columns. The date is the key one. Without it you cannot tell a lead that is waiting from a lead that has gone cold.

Let a program do the daily check

The program below holds eight made-up leads and a check date of Monday 23 November 2026. It counts leads per stage, picks out the ones that need a follow-up, which here means anything in ‘contacted’ or ‘proposal’ with no contact for at least seven days, and adds up a weighted pipeline. That is the possible fees multiplied by a chance for each stage, 10 per cent for contacted and 40 per cent for proposal, both made up. Finally it turns last quarter’s counts into stage-by-stage rates.

from datetime import date

today = date(2026, 11, 23)
# MADE-UP leads: (name, stage, last contact, possible fee)
leads = [
    ("Cafe Sol", "won", date(2026, 11, 20), 295),
    ("Bakery Bloom", "proposal", date(2026, 11, 12), 240),
    ("Shop Hive", "proposal", date(2026, 11, 20), 190),
    ("Diner Nine", "contacted", date(2026, 11, 9), 200),
    ("Pet Palace", "contacted", date(2026, 11, 19), 180),
    ("Print Bay", "contacted", date(2026, 11, 13), 220),
    ("Tea Room", "new", None, 150),
    ("Book Nook", "lost", date(2026, 10, 30), 210),
]
chance = {"contacted": 0.10, "proposal": 0.40}

counts = {}
for lead in leads:
    counts[lead[1]] = counts.get(lead[1], 0) + 1
print("stages:", dict(sorted(counts.items())))

due = [l[0] for l in leads if l[1] in chance and (today - l[2]).days >= 7]
print("follow-ups due:", len(due))
for name in due:
    print("  ", name)
weighted = sum(l[3] * chance[l[1]] for l in leads if l[1] in chance)
print("weighted pipeline:", round(weighted, 1))

# MADE-UP last quarter: reached each stage
reached = {"contacted": 40, "replied": 12, "proposal": 6, "won": 3}
steps = list(reached.items())
for (a, x), (b, y) in zip(steps, steps[1:]):
    print(f"{a} to {b}: {y / x:.0%}")
print("contacted to won:", f"{reached['won'] / reached['contacted']:.1%}")
stages: {'contacted': 3, 'lost': 1, 'new': 1, 'proposal': 2, 'won': 1}
follow-ups due: 3
   Bakery Bloom
   Diner Nine
   Print Bay
weighted pipeline: 232.0
contacted to replied: 30%
replied to proposal: 50%
proposal to won: 50%
contacted to won: 7.5%

Three leads need a follow-up today: the bakery, the diner and the print shop. Each was last contacted ten days ago or more. Without the list, Dev would have remembered the newest and lost the oldest, which is the usual human mistake. The weighted pipeline comes to 232.0, far below the sum of all the possible fees. That is the honest figure: most leads do not become clients, and the weighting says so. The conversion lines show last quarter’s funnel. Of those contacted, 30 replied. Of the repliers, 50 reached a proposal, and of the proposals 50 were won. Overall 7.5 per cent of contacted leads became clients. Dev can now forecast: to win four clients a month at that rate, about 53 people must be contacted. That number is a plan, not a hope.

The follow-up habit

  1. Open the list at the same time each day and check the follow-up column.
  2. Send a short, friendly message to anyone who has been quiet for about a week.
  3. Make the message useful. Add a small tip or answer a question instead of saying ‘just checking in’.
  4. Follow up two or three times at most, then mark the lead as lost with a note.
  5. Move leads between stages the moment something changes.

Learn from the lost ones

Losing a lead is information. Write down why: the price, the timing, a competitor or silence. After ten losses you may see a pattern, such as clients leaving after the quote, which suggests the proposal or price needs work. Some lost leads come back months later, so be polite when you close a file, and note a date to try again.

Keep it light

You do not need special software. A spreadsheet with five columns is enough for years. If you try a tool, check its terms, fees and how it stores your clients’ details, since you are responsible for that information. Tell people what you do with their data on your site, and delete what you no longer need.

Common mistake: following up by feeling

Following up only when you feel like it. Leads go cold on a schedule, not on your mood. Set a rule, such as seven days, and let the list tell you.

Sample data and not advice

The leads, fees, stages and rates are made up and use sample money. Real conversion rates vary hugely by service and market. Handle clients’ details responsibly and follow the privacy rules where you live. This is an outline and not legal advice.

Make a five-column list of real or imagined leads. Add a last-contact date to each and mark which ones need a follow-up today.

Practice for this lesson

Check what you learned

Five quick questions. Pick an answer and you will see straight away whether it is right and why.

What is a pipeline?

  1. A kind of invoice
  2. A list of leads and where each one stands
  3. A website tool only
  4. A tax form

It makes sure no lead is forgotten.

Which column matters most for follow-ups?

  1. Colour
  2. Font
  3. Date of last contact
  4. Postcode

Without the date you cannot tell waiting from cold.

How many leads needed a follow-up in the example?

  1. Three
  2. Eight
  3. One
  4. None

The bakery, the diner and the print shop.

Why weight the pipeline by stage?

  1. To raise fees
  2. To hide leads
  3. Most leads do not become clients
  4. To save time

Weighting gives an honest value.

What should you do with a lost lead?

  1. Write why, and be polite
  2. Delete everything
  3. Send many angry emails
  4. Ignore it

The reason is information, and some leads return.

Summary

  • A pipeline lists every lead with stage, last contact and fee.
  • A date rule finds the follow-ups due each day.
  • Weighting by stage gives an honest forecast.
  • Record why leads are lost.

Next lesson

Lesson 13 covers price objections and negotiation.

Questions

Do I need a CRM tool?

No. A spreadsheet is enough to start. If you use a tool, read its terms and how it stores client details.

How many follow-ups are too many?

Two or three polite ones over a few weeks is common. Then close the file and note a date to try again.

Are the rates typical?

No. They are made-up numbers to show the method. Track your own.

Progress is saved in this browser.