How to Build a Simple Sales Pipeline
A sales pipeline is just a list of who you are talking to and what happens next. How to set one up in an afternoon and actually keep using it.
A sales pipeline sounds like something for companies with sales teams. It is really just an organized answer to two questions: who is currently thinking about buying from us, and what needs to happen next with each of them?
If you keep that in your head, you will lose track at around the tenth open inquiry. A pipeline puts it where you can see it.
The stages
Every pipeline is a set of stages a customer moves through. For most service businesses, five or six are enough.
| Stage | Meaning | What you do |
|---|---|---|
| New | They have got in touch; you have not replied | Respond quickly |
| Contacted | You have spoken or messaged | Find out what they need |
| Quoted | They have a price | Follow up |
| Won | They said yes | Schedule and deliver |
| Lost | They said no or went silent | Record why |
Add a stage only if something genuinely different happens there, such as a site visit before quoting.
Resist making it complicated. A pipeline with twelve stages is one nobody updates.
Define each stage by what the customer did
"Quoted" should mean an estimate was sent, not that you think they are interested. Stages based on feelings drift. Stages based on events stay accurate.
A good test: could two different people look at a lead and agree which stage it is in?
What to record for each lead
Keep it minimal, or it will not be filled in.
- Name and contact details
- What they want
- Where they came from
- Current stage
- The next action and its date
- Estimated value, once quoted
The next action is the most important field. A lead without a next step is a lead being forgotten.
Where to keep it
A spreadsheet works for a handful of leads a month. One row per lead, a column per field, a dropdown for the stage.
A CRM is better once volume picks up or more than one person is involved. Most show the pipeline as columns you drag cards between, and can send reminders.
Start with whichever you will actually use. See CRM vs spreadsheet for where the line falls.
The weekly review
A pipeline only works if someone looks at it. Block fifteen minutes each week and go through every open lead:
- Is it in the right stage?
- Is there a next action with a date?
- Has anything been sitting in one stage too long?
- Should anything be marked lost?
Be ruthless about that last one. A pipeline full of quotes from four months ago hides the live opportunities.
What it tells you
After a couple of months, patterns appear:
- Where leads stall. If many get stuck at "Quoted", your follow-up or your pricing needs attention.
- Which sources convert. If referrals close far more often than ad leads, that changes where you put effort.
- How long a sale takes. Useful for forecasting and for timing follow-ups.
- Your win rate. What share of quotes become jobs.
Record why leads were lost, even briefly: price, timing, went with a competitor, no response. Ten entries are enough to show a pattern.
Make it automatic where you can
Three things are worth automating early:
- New inquiries create a lead without anyone typing. See connecting your CRM to your website.
- Reminders fire when a next-action date arrives.
- Follow-ups send when a quote has had no response. See automating customer follow-ups.
The moving of leads between stages can stay manual at first. It takes seconds, and doing it by hand keeps you close to what is happening.
A common objection
"I am too busy to keep a pipeline updated." The pipeline exists because you are busy. It takes less time to move a card than to remember, at eleven at night, the name of the person who wanted a quote last Tuesday.
