RPT 203 · Practitioner · Finance track · 10 min read
Pipeline Report
The weighted view of opportunities a contractor is pursuing but has not yet won, used to forecast future bookings and decide where to spend scarce estimating capacity.
Definition — what it is
A pipeline report tracks the opportunities a contractor is pursuing that are not yet under contract, staged by how far each has progressed and weighted by the probability of winning, to forecast future bookings and guide where to invest pursuit effort. It is the forward complement to the backlog report: backlog is work already sold, pipeline is work being chased. A pipeline value is a probabilistic figure, not a promise - a 5 million dollar opportunity at 30 percent stage weight contributes 1.5 million of weighted pipeline, and treating the full value as expected revenue is the most common way the report misleads. It is not a bid log either; a pipeline report tracks pursuit and probability across the whole business-development funnel, of which bidding is only the late stage.
Also known as: Sales Pipeline, Opportunity Pipeline, Prospect Report, Weighted Pipeline
Why it matters — what it protects
The pipeline is where a contractor decides how to spend its scarcest resource: estimating and pursuit capacity. Every bid costs real money and senior time to prepare, and a firm that chases everything wins a lower share of what it pursues while exhausting the people who prepare the bids. The pipeline report exists to force triage - to concentrate effort on the opportunities the company can actually win and wants to win.
Pipeline is the leading indicator of backlog, which is itself the leading indicator of revenue. A thinning pipeline today becomes a thinning backlog in a few months and thinning revenue after that, so the pipeline is the earliest place a downturn is visible. Reading pipeline against backlog and the win rate is how a contractor sees a revenue problem while there is still time to pursue more work.
The report keeps pursuit honest about probability. Optimism is structural in business development - every opportunity feels winnable to the person chasing it - and an unweighted pipeline is a wish list. Staging and probability weighting turn that wish list into a forecast the company can plan capacity and cash around, and the discipline of the weighting is what makes the number usable.
Pipeline composition steers the business. A pipeline concentrated in one client, one sector, or one project size tells ownership where future revenue will come from and whether that future is diversified. Because pursuit choices made today shape the company two years out, the pipeline is where strategy is actually executed, one go/no-go decision at a time.
Lifecycle — how it moves
Lead capture
An opportunity enters the pipeline from a relationship, a public solicitation, a plan room, or a repeat client. The entry point matters: relationship-sourced leads win at far higher rates than blind public bids, and the pipeline should carry the source.
Qualification
The opportunity is assessed for fit - right size, right market, right client, adequate margin potential, and winnable. Qualification is where a disciplined firm kills opportunities early, before they consume estimating time on work it cannot win.
Go/no-go decision
A formal decision commits or declines pursuit resources. The go/no-go is the pipeline's most important gate, and treating it as a formality rather than a real choice is how estimating capacity gets wasted on hopeless pursuits.
Stage progression
The opportunity moves through stages - identified, qualified, pursuing, proposed, shortlisted - each carrying a probability weight. Stage discipline is what keeps the weighted pipeline honest; opportunities that stall must be down-staged, not left at their peak weight.
Proposal and bid
The estimate and proposal are prepared and submitted. This is the most expensive stage in real cost, and the pipeline should show how much pursuit spend is committed against each opportunity so win rate can be read against cost.
Outcome
The opportunity is won, lost, or cancelled. Won opportunities transfer to backlog; lost ones are logged with a reason, which is the raw material for improving qualification and win rate.
Win/loss analysis
Outcomes are analyzed by source, sector, client, and estimator to learn where the company wins and where it wastes effort. Skipping this step means the same unwinnable pursuits get chased again next quarter.
Pipeline hygiene
Dead and stale opportunities are removed or down-staged so the weighted pipeline reflects reality. A pipeline that only ever grows because nothing is ever removed becomes fiction that overstates future bookings.
Anatomy — the data it carries
- Opportunity name / project
- What is being pursued. The identifier the whole pipeline is organized around.
- Estimated contract value
- The full potential value if won. The unweighted number, dangerous when read as expected revenue.
- Stage
- Where the opportunity sits in the funnel. Drives the probability weight and the pursuit effort justified.
- Probability / stage weight
- Likelihood of winning, from stage or estimator judgment. Converts value into weighted pipeline - the only figure safe to forecast on.
- Weighted value
- Contract value times probability. What the opportunity actually contributes to the forecast.
- Expected decision date
- When the award is expected. Distributes weighted pipeline across future periods for a bookings forecast.
- Client / owner
- Who the work is for. Feeds concentration analysis and win-rate-by-relationship.
- Market / sector
- The type of work. Shows whether future bookings are diversified or narrowing.
- Source
- How the lead arrived - relationship, referral, public bid, plan room. The strongest predictor of win probability.
- Pursuit cost
- Estimating and BD spend committed to the opportunity. Lets win rate be read against the cost of chasing.
- Go/no-go status
- Whether pursuit has been formally committed. Distinguishes real pursuits from opportunities merely being watched.
- Loss reason
- Why a lost opportunity was lost - price, relationship, schedule, qualification. The feedback that improves future qualification.
Failure modes — how it breaks
Unweighted pipeline as forecast
The full contract value of every opportunity is summed and treated as expected revenue, producing a number several times larger than the company could ever book. Planning against the unweighted total leads to over-hiring and disappointment when reality lands at the weighted figure.
Stale opportunities inflating the total
Dead pursuits are never removed and stalled ones are never down-staged, so the pipeline only grows. It becomes a monument to past optimism that overstates future bookings and hides that new opportunity creation has actually dried up.
Probability by hope, not evidence
Estimators assign win probabilities based on how much they want the job rather than on stage, source, and history. The weighting is systematically too high, and the forecast is optimistic in exactly the way the weighting was meant to correct.
Go/no-go as rubber stamp
Every opportunity is a go because declining feels like giving up, so estimating capacity is spread across too many pursuits. Win rate falls, the estimating team burns out, and the quality of every proposal suffers because none got enough attention.
No win/loss learning
Losses are logged without reasons, or the reasons are never analyzed, so the company keeps chasing the same unwinnable work. The pipeline records outcomes but never improves the judgment that fills it.
Concentration ignored in pursuit
The pipeline is chased for volume without regard to how it concentrates future revenue in one client or sector. The company wins its way into a fragile future that was visible in the pipeline composition the whole time.
Metrics — how it is measured
Weighted pipeline value
Sum of contract value times probability across opportunities. The forecastable figure, read against future revenue needs.
Win rate
Opportunities won divided by opportunities pursued, by count and by value. The core efficiency metric of business development.
Pipeline coverage ratio
Weighted pipeline divided by the bookings needed to hit plan. Below the target multiple, the company is not pursuing enough to make its number.
Stage conversion rates
Share advancing from each stage to the next. Reveals where opportunities die and whether stage weights are calibrated.
Pursuit cost per win
Total pursuit spend divided by wins. Measures the real cost of the business the pipeline produces.
Pipeline aging
How long opportunities sit at a stage. Stale opportunities that never advance signal hygiene problems and inflated totals.
Source win rate
Win rate by lead source. Usually shows relationship leads win far more than blind bids, which should steer pursuit.
The AI shift — what actually changes
Conversational
The pipeline stops being a spreadsheet you sort and becomes something you question. You ask which opportunities are stale and should be down-staged, whether the weighted pipeline covers next year's bookings target, where future revenue is concentrating, and how win rate differs by source and sector - with the underlying opportunity records cited rather than a single unweighted total.
Generative
Pipeline commentary and go/no-go briefs are drafted from the record: a summary of pipeline movement this period, a win/loss narrative by source and sector, or a go/no-go recommendation that pulls the client history, the fit against the company's strengths, the concentration effect, and the realistic win probability into a decision memo the pursuit committee can act on.
Orchestrated
The pipeline stops living apart from the rest of the business. Won opportunities transfer to backlog with their margin, lost ones feed win/loss analysis automatically, probability weights are calibrated from actual stage-conversion history rather than guessed, and pipeline coverage is checked against the bookings the revenue plan requires so pursuit effort is steered by evidence.
Autonomous
The routine motion runs continuously: opportunities aged and down-staged as they stall, weighted pipeline and coverage recomputed as opportunities move, win/loss patterns surfaced by source and estimator, and concentration monitored as pursuit choices are made - while humans make every go/no-go decision, own the probability judgments that override the model, and decide which markets and clients the company will chase.
Prompts — put it to work
Tool-agnostic and copy-ready. Adapt the specifics — thresholds, contract windows, cost codes — to your own project before you run them.
Conversational — Reviewing whether pursuit effort is aimed at winnable, wanted work.
Analyze our current pipeline. Give me total unweighted value and total weighted value, and tell me plainly not to plan on the unweighted number. Show the weighted pipeline distributed by expected decision quarter, and compare it to the bookings we need to hit next year's revenue plan - is our coverage ratio adequate? Identify opportunities that have sat at the same stage for more than 90 days as candidates to down-stage or kill. Break win rate down by lead source and by sector, and flag any client or sector where more than 40 percent of our weighted pipeline is concentrated.
What good output looks like: A weighted, time-distributed pipeline read against plan coverage, with stale opportunities, source win rates, and concentration surfaced - not an inflated unweighted total.
Follow-ups:
- Which stale opportunities are consuming estimating time with little chance of a win?
- If our public-bid win rate is much lower than our relationship win rate, where should we redirect pursuit?
- What does our pipeline say about where revenue will come from in two years?
Generative — The pursuit committee needs a go/no-go brief on a large opportunity.
Draft a go/no-go recommendation for this opportunity: a 9 million dollar public parking structure, hard-bid, decision expected in six weeks. Pull our history with this owner and this project type, assess fit against our strengths and current capacity, estimate a realistic win probability from our win rate on comparable hard-bid public work, quantify the pursuit cost to prepare a competitive bid, and note the concentration effect on our pipeline. Give a clear go or no-go with the reasoning, and if go, what would have to be true for us to actually win. Keep it to a one-page decision memo in measured language.
What good output looks like: A grounded go/no-go memo with a realistic win probability from history, pursuit cost, fit, and concentration - a real decision, not an encouragement to bid.
Follow-ups:
- Redraft as a no-go and explain how to decline gracefully without damaging the relationship.
- What margin would we need to bid to make this pursuit worthwhile given the pursuit cost?
- Write the two-sentence version for the weekly pursuit meeting agenda.
Orchestrated — A bid was just won and you want the pipeline, backlog, and forecasts to stay consistent.
We just won the opportunity we bid last month. Move it out of pipeline and into backlog with its buyout margin, recompute weighted pipeline and coverage without it, update our win rate for this source and sector, and check the concentration effect the new backlog creates. Then tell me whether the remaining weighted pipeline still covers the bookings we need for the rest of the year, and which stale opportunities should be down-staged now that this one has resolved. Cite the records for each step and flag anything uncertain.
What good output looks like: A consistent transfer from pipeline to backlog with weighted pipeline, coverage, win rate, and concentration all recomputed and reconciled, records cited.
Follow-ups:
- Draft the win/loss note capturing why we won this one for the pursuit debrief.
- What does removing this from pipeline do to our coverage for the third quarter specifically?
- Which similar open opportunities should we prioritize given that we just won this type?
Autonomous — Standing policy for keeping the pipeline honest and calibrated between pursuit meetings.
Maintain the pipeline continuously under these rules. Calibrate probability weights from actual stage-conversion history by source and sector rather than from estimator optimism, and recompute weighted pipeline and coverage as opportunities move. Down-stage any opportunity that has sat at a stage past its normal cycle time and surface any that should be considered dead. Transfer won opportunities to backlog with their margin and feed lost ones into win/loss analysis. Monitor coverage against the bookings the revenue plan requires and concentration by client and sector. Never make a go/no-go decision, never commit pursuit resources, never override a probability weight downward on your own without flagging it, and never remove an opportunity from the pipeline without my approval.
What good output looks like: A continuously calibrated, hygienic pipeline with a short review queue, where every go/no-go and every removal stays with a person.
Follow-ups:
- Show me everything you down-staged and everything you propose killing this week.
- Where has your calibrated win probability diverged most from what estimators assigned, and why?
- Is our coverage falling below target in any quarter, and what pursuit would close the gap?
Get the full Construction AI Prompt Catalog — every prompt in the library in one document.
Maturity — locate yourself honestly
Level 0 - Heads and hunches
Opportunities live in the heads of business developers and a few scattered emails. There is no weighted forecast and no view of coverage or win rate.
Level 1 - Listed
A pipeline list exists with values and stages. It is often unweighted and rarely cleaned, so the total overstates likely bookings.
Level 2 - Weighted
Opportunities are probability-weighted by stage, distributed across decision periods, and read against a bookings target, with win/loss reasons captured.
Level 3 - Assisted
Probability weights are calibrated from conversion history, stale opportunities are flagged, go/no-go briefs are drafted, and coverage against plan is monitored for review.
Level 4 - Operated
The pipeline stays calibrated and clean inside guardrails - weighting, aging, transfer, and coverage monitoring - while humans own every go/no-go, every override, and every strategic pursuit choice.
Common questions
Why weight the pipeline instead of summing contract values?
Because summing full contract values produces a number the company has almost no chance of booking, and planning capacity or cash against it leads to over-hiring and disappointment. Weighting each opportunity by its probability of winning turns a wish list into a forecast: a 10 million dollar opportunity you have a 25 percent chance of winning contributes 2.5 million of expected bookings, not 10. The weighted total is the only figure safe to plan on, and calibrating the weights against real win history is what keeps that figure honest.
What is a healthy pipeline coverage ratio?
Coverage is weighted pipeline divided by the bookings you need to hit plan, and the right multiple depends on your win rate and sales cycle. If you win one in four of what you pursue, you need roughly four dollars of weighted pipeline for every dollar of bookings you need, adjusted for how long deals take to close. The specific number matters less than the trend: coverage falling below your historical target is an early warning that revenue will fall in a few quarters unless pursuit picks up.
How is a pipeline report different from a bid log?
A bid log tracks estimates prepared and submitted - the late stage of pursuit. A pipeline report tracks the whole funnel, from a lead first identified through qualification, go/no-go, and proposal to outcome, with probability weighting at each stage. Bidding is only the expensive tail end; the pipeline's real value is upstream, where qualification and go/no-go decisions decide which bids ever get prepared and where scarce estimating capacity is spent.