🎬 Sales Pipeline Template: score your pipeline in a minute — the phantom-pipeline problem, the coverage-ratio math, and a walkthrough of the free Pipeline Health Calculator. Watch on YouTube
TL;DR
- A sales pipeline template is not a prettier spreadsheet. It is a set of stage exit criteria plus two numbers that tell you the truth: weighted value and coverage ratio.
- Use the Pipeline Health Calculator below to see how much of your pipeline is real and whether you have enough of it to hit your number. Most owners are shocked how thin the honest figure is.
- Coverage ratio has a rule most people quote wrong. The right number is not a flat 3x, it is 1 divided by your win rate, so a 20% win rate needs 5x.
- The one column that separates a working template from a graveyard is days-in-stage. A deal untouched for longer than your sales cycle is not pipeline, it is decoration.
- For an Upwork agency, the pipeline starts two stages before the CRM, at proposals sent and reply rate. Across 133,872 GigRadar proposals, reply rate sat at 6 to 9 percent, not the 20 most owners assume.
Open any struggling agency's CRM and the pipeline looks healthy: forty open deals, a six-figure total, green everywhere. Then the quarter closes at a third of the number and nobody can explain it.
The pipeline was never healthy. It was a list of deals nobody qualified, stages nobody defined, and probabilities somebody rounded to 50 percent, which is exactly what a real sales pipeline template exists to stop.
This guide is about the tracker itself: the template, the two metrics that make it honest, and an interactive tool that scores your pipeline in about a minute. For the model behind the stages read the 7-stage pipeline breakdown; to turn a clean pipeline into a revenue number, use the sales forecast template.
A pipeline template is a set of exit criteria, not a prettier spreadsheet
Most "sales pipeline template" downloads are a grid with pretty conditional formatting and stage names like "Interested" and "Hot". That is the problem, not the solution.
A stage is only useful if it has an exit criterion: a specific, observable thing the buyer did that lets the deal advance. "Hot" is a feeling; "sent a signed order form" is an exit criterion, and without one, reps park deals wherever feels good and the whole forecast inherits the lie.
Most templates ship with the vague labels in the middle column below. The exit criteria in the right column, tied to something the buyer actually did, are what make a stage mean anything.
| Stage | Vague label (useless) | Exit criterion (what actually moves it) |
|---|---|---|
| 1 · Qualification | "Interested" | Confirmed budget, decision-maker, and a timeline in writing. |
| 2 · Solution design | "Working on it" | Scope agreed and a demo or sample delivered to the buyer. |
| 3 · Proposal | "Hot" | Written proposal or SOW sent, with pricing the buyer has seen. |
| 4 · Verbal commit | "Almost closed" | Buyer said yes out loud; only signature or paperwork remains. |
Write the exit criteria once, put them at the top of the template, and every deal has to earn its stage. That single discipline does more for forecast accuracy than any tool.
Score your pipeline before you trust it
Interactive Tool
Pipeline Health Calculator
Enter the total value of your open deals by stage, your revenue target, and your win rate. The tool returns your weighted pipeline, your real coverage ratio, and whether you have enough pipeline to actually hit the number.
Benchmark close probability: 22%.
Benchmark close probability: 45%.
Benchmark close probability: 72%.
Benchmark close probability: 88%.
B2B average is around 20%. Use your own if you have it.
Stage probabilities default to a common B2B benchmark set. Replace them with your own stage win rates once you have 12 months of closed data; until then, these are a defensible starting point.
Do you actually have enough pipeline? The coverage ratio nobody calculates right
Coverage ratio answers one question: is there enough open pipeline to hit quota at normal conversion? The formula is simple, and almost everyone quotes the benchmark wrong.
Coverage ratio equals total qualified pipeline value divided by your revenue target for the same period. A $360,000 pipeline against a $120,000 target is 3x, and that part everyone gets.
The mistake is treating 3x as universal, when the honest rule is that your required coverage equals 1 divided by your win rate. At a 33% win rate 3x is right, but at the B2B-average 20% you need 5x, and most agencies are nowhere near it.
Required coverage climbs fast as win rates fall. Find your row before you celebrate a pipeline total.
| Your win rate | Coverage you actually need | Typical profile |
|---|---|---|
| 40% | 2.5x | Warm inbound, tight niche, short cycle. |
| 33% | 3x | The classic benchmark. Rare in practice. |
| 25% | 4x | Typical mixed inbound and outbound agency. |
| 20% | 5x | Outbound-led, cold pipeline, longer cycle. |
| 15% | 6.7x | Enterprise or highly competitive deals. |
Required coverage = 1 ÷ win rate. Sources: Clari, Fullcast, Landbase.
Weighted pipeline: why most of your number is phantom
Raw pipeline treats a first-call deal and a verbal-commit deal as equally likely, and they are not. Weighted pipeline fixes this by multiplying each deal by the historical close probability of its stage, then summing.
A $80,000 deal sitting in Qualification at 22 percent is worth $17,600 to your forecast, not $80,000. Do that across every deal and the healthy-looking pipeline usually shrinks by more than half, and that gap is your phantom pipeline.
Notice where the phantom sits: the tallest grey bar, Qualification, contributes the least real value. Teams that miss plan pile most of their pipeline into that first stage and call it coverage, when it is nothing of the sort.
Avoid round-number probabilities like 25, 50, 75; they signal nobody measured. Pull your own stage win rates from the last 12 to 18 months, or start from a benchmark set like HubSpot's 20/40/60/80/90 and refine from there.
The seven columns every sales pipeline template needs
You do not need a 12-tab model, just one clean row per open deal with seven columns, the same core fields Smartsheet and Salesforce build around. One of them is the column most templates skip, and it is the one that keeps the pipeline honest.
The account or project. One row, one deal, no duplicates.
A dropdown tied to the exit criteria above, never free text. "Qualified", "qualified", and "Qual" are how reporting dies.
Raw, unadjusted contract size. For retainers, use monthly value times expected months.
The column most templates skip and the one that matters most. A deal untouched longer than your sales cycle is stalled, not open.
Deal value times stage probability. The single number your forecast should sum, not the raw column.
Drives which month the deal lands in. Push it to match your true cycle, not wishful thinking.
Who moves it and what happens next. A deal with no next step is a dead deal in disguise.
Grab the template
Copy these seven columns straight into Google Sheets or Excel, or download the CSV. Two example rows are included, one of them deliberately stalled, so the days-in-stage flag is obvious.
For an Upwork agency, the pipeline starts before the CRM
A standard pipeline template assumes the top stage is a qualified opportunity, but for an Upwork agency two stages sit above that: proposals sent and replies received. Ignore them and you are managing the visible 20 percent of your pipeline while the other 80 percent decides everything.
The input that governs the whole thing is reply rate, and most owners model it wrong. Across 133,872 outbound proposals in GigRadar's pipeline (December 2025 to February 2026), reply rate settled around 6 to 9 percent, not the 20 percent most founders assume when they size their funnel.
So the Upwork agency pipeline template adds two rows above Qualification: proposals sent per week, and expected replies. Feed those into the forecast template for the revenue number, tie the retainer side to a retention plan with the customer success plan template, and size it all against your sales plan and the break-even calculator.
This is also why two agencies sending the same 100 proposals a week can be $20,000 a month apart. The gap is almost never the closer; it is the reply rate at the very top, the one lever most owners never instrument.
Free for Upwork agencies
Your pipeline is only as full as the top of it
GigRadar runs your Upwork outbound through a real Business Manager account, so proposals go out at volume with human review on every one. A steady flow of qualified replies is what keeps the top of your pipeline from running dry.
Get Your Free Agency Audit →Build and maintain your pipeline in five steps
The template only works if you maintain it, so here is the weekly sequence that turns a spreadsheet into a pipeline you can forecast from. It takes an afternoon the first time and 20 minutes a week after that.
Define what observable buyer action moves a deal to each stage. Put it at the top of the template before you add a single deal.
A deal with no confirmed budget, decision-maker, or timeline is a lead, not pipeline. Keep it off the sheet until it qualifies.
Multiply each deal by its stage probability. Sum the weighted column, then divide by your target to get real coverage.
Any deal with no logged activity in 30 days, or open longer than twice your sales cycle, gets flagged and either revived or removed. Do not let it inflate coverage.
Compare what the weighted pipeline predicted to what actually closed. If you are off by more than 20 percent twice running, your probabilities are wrong.
The pipeline habits that quietly kill agency revenue
Most bad pipelines fail for the same handful of reasons. Fix these four and you close most of the gap between the number on the sheet and the number in the bank.
Counting every unqualified lead as pipeline to inflate the total is the single most common coverage error. Only count deals with documented budget, timeline, and a real stakeholder.
A deal open for 180 days in a 60-day cycle is not worth its face value, and deals open longer than twice your cycle rarely close. Track the clock or the pipeline lies to you.
50 percent on everything is a coin toss dressed up in a spreadsheet. Use stage win rates from real closed data, and refine them quarterly.
Forecast accuracy tracks pipeline hygiene in the Ebsta and Pavilion benchmarks. You only improve the number you measure, so reconcile every month.
None of these need a better tool; they need honest inputs, which is the entire discipline of pipeline management. Write the exit criteria, weight the deals, track the clock, and check yourself monthly.
Do that and the pipeline stops being the number you dread in the board deck and becomes the number you plan hiring and spend against.
