What it means
A pipeline is a view of potential sales, and if old deals remain open and values are wrong, the headline total can grow while real buying activity does not. Set stage definitions with evidence for entry and exit, because a proposal sent is not the same as a buyer agreeing to a trial.
Give each deal an owner who is responsible for the next action and for updating the record when the situation changes. Record the buyer's next step as a specific agreed action and date, since "follow up soon" is less useful and a seller-only hope should be labelled as such.
Update close dates with care: a date repeatedly pushed from one month to another without a buyer milestone distorts forecasts, so ask what makes the new date credible. Confirm whether the amount is contract value, annual recurring revenue or expected first-year revenue, and do not combine different bases in one total.
Mark lost deals honestly, because an opportunity with no active buyer process should not stay open just to protect pipeline coverage, and keep loss reasons for learning. Do not delete useful history, since closing a deal as lost is different from erasing the record and past outcomes help diagnose conversion and forecast error.
Identify duplicates, as two reps may have created separate opportunities for the same decision, and double counting inflates pipeline. Look for stale records using a rule such as no meaningful buyer activity in 30 days, which is a trigger to investigate and not automatic proof the deal is dead.
Segment by sales cycle, because an enterprise purchase may have long legitimate gaps while a small repeat order may need faster movement, so one threshold may not fit both. Check contacts and roles too, since a deal can look healthy while its sponsor has left and no decision-maker is engaged, and remember that moving a deal forward to match a target does not create buyer progress, so capture the event that justified each stage change.
In some systems the stage maps to forecast categories, so an incorrect stage can change a manager's projected revenue, and an audit trail of changes in amount, date and stage lets people explain forecast movement later. Salesforce's pipeline inspection material shows forecast categories, overdue opportunities and changes in value or timing, while HubSpot's default deal properties show how stage, amount and close date are represented in customer relationship management (CRM) records.
Automate checks selectively, since missing fields and overdue dates can generate prompts but too many required fields may encourage guesswork or filler values. Make updates part of the work, because a brief review after a buyer call is often more accurate than a large quarterly cleanup from memory, and protect time for selling by focusing on decision-driving fields.
Compare changes over time, since new, won, lost, increased and moved-out opportunities reveal more than one static total, and a simple stale-deal share helps: forty-five of 150 open deals with no meaningful activity in 30 days gives 30% under that team's definition, though a lower figure might mean better buyer engagement, honest closures or a new way of logging activity. For an owner, pipeline hygiene is a habit of telling the truth about opportunities, so use the cleaned data to reallocate coaching, revise forecasts and find bottlenecks while keeping uncertainty visible, because a smaller accurate pipeline is more useful than a large collection of unverified hopes.
In practice
Real-world examples.
Example
A rep updates a buyer-approved security-review date and moves the close estimate accordingly.
Example
A team closes an inactive deal as lost rather than carrying it into another quarter.
Example
A manager identifies duplicate records for one customer purchase and corrects the pipeline total.
Formula
Calculation
Optional stale-deal share = open deals with no defined meaningful activity for 30 days / all open deals x 100. With 45 of 150, the share is 30%. Choose a threshold suited to the sales cycle and investigate before closing.Case study
Seen in the real world.
Fictional case: Horizon Security's pipeline grew each quarter, but bookings did not. Its team reviewed overdue close dates, duplicate opportunities and deals without a buyer next step. The reported pipeline shrank while the forecast became easier to explain. This fictional case shows why accurate stage and timing information beats a larger nominal total.
Watch out
Common mistakes.
- Keeping inactive deals open to make coverage look larger.
- Changing close dates without buyer evidence or a recorded reason.
- Mixing contract value and annual revenue in the same pipeline number.
Questions
People also ask.
What is a stale deal?
A deal that meets a defined inactivity or overdue rule and needs review; it is not automatically lost.
Does cleaning the pipeline reduce sales?
It changes the record, not the underlying customer demand, and can improve decisions.
How often should it be done?
Update after meaningful changes and review the pipeline at a cadence suited to the sales cycle.
From the founder's library

Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%