Pipeline Hygiene in Salesforce: 8 Rules That Compound
The 8 pipeline hygiene rules we engineer into every Salesforce org, close-date discipline, next-step field, stage gates, aging alerts, and validation rules that keep the forecast honest.
Pipeline hygiene is not a rep problem. It is a system-design problem. Every org we audit has the same top complaint from the CRO: "our pipeline is not real." The reason is always the same, the system does not enforce the discipline that would make it real. Here are the 8 rules we engineer into Salesforce so the forecast becomes trustworthy again.
Rule 1: Close date must be justifiable
Every open opportunity has a close date. Every close date has a story. If the story is "I put a date in because Salesforce forced me to," you have no forecast. Enforce a validation rule: close date within the last 6 months of history triggers a mandatory Reason for Slip field. Track slippage per rep as a leading indicator.
Rule 2: The Next Step field is not optional
Every open opportunity must have a Next Step and a Next Step Due Date. If both are blank or overdue, the opportunity is quarantined out of the forecast automatically. This one rule alone drops rep-call forecast optimism by 10 to 15 percent within a quarter.
Rule 3: Stage advancement has exit criteria
Each stage has checklist items enforced by validation rules. Stage 2 needs an identified pain and a decision-maker. Stage 3 needs an economic buyer. Stage 4 needs a mutual close plan. Stage 5 needs verbal commit and paper motion started. No exceptions.
Rule 4: Amount cannot change without an audit trail
Field History Tracking on Amount, plus a Reason for Amount Change picklist required on save when Amount decreases by more than 20 percent. Prevents silent deal shrinkage that shows up in the final week of the quarter.
Rule 5: Days in stage is a first-class metric
Formula field: today minus StageChangeDate. Reports every Monday morning to each manager: opportunities in stage longer than the 90th percentile of historical winning deals for that stage. Those are your rescue calls.
Rule 6: Opportunity Contact Roles are required at Stage 3
An opportunity with no contact roles has no buying group and cannot be forecasted. Validation rule at Stage 3: require at least two Contact Roles, at least one flagged as Economic Buyer. See adoption KPIs for how we track compliance.
Rule 7: Losses must be dispositioned
Closed Lost requires a Loss Reason picklist and a Competitor field. Without this, you have zero learning loop. Quarterly loss-reason report goes to the product marketing team and the enablement team.
Rule 8: Manual pipeline adjustments are logged
Manager forecast adjustments are permitted (encouraged even), but they must land in a Forecast Adjustment record with a written reason. Track adjustment accuracy over time, that is manager judgment quality data.
How to roll it out without a revolt
- Roll out rules 1, 2 and 3 in week 1. These give 70 percent of the value.
- Announce the changes at the sales all-hands with the CRO, not by email.
- Give reps a 30-day grace period where rules trigger warnings, not blocks.
- After 30 days, switch to hard validation rules.
- Publish weekly hygiene dashboards by rep and by team. Peer pressure is the enforcement engine.
What good looks like after 90 days
- Percentage of open opps with next step and next step due date, above 95 percent.
- Percentage of Stage 3+ opps with Economic Buyer contact role, above 90 percent.
- Percentage of close dates changed in the last 30 days, under 25 percent.
- Rep-call forecast vs Einstein forecast variance, under 15 percent.
Frequently asked questions
Will validation rules push reps to fake data?
Only if the fields are unclear or the rules are stupid. Well-designed validation rules with reasonable exit criteria produce cleaner data, not fake data. The dashboards catch faking within a quarter.
What about small deals under $10k?
Exempt small deals from the heaviest rules (Contact Roles, Economic Buyer) if your business economics allow. Do not exempt them from Close Date and Next Step, ever.
How do we handle legacy dirty pipeline?
Run a one-time pipeline clean-up week. Any open opp without Close Date within a reasonable window and without a Next Step gets moved to a Pipeline Cleanup workspace. Reps have two weeks to rescue or close-lose them.
Can we automate any of this?
Yes. Flows can require fields conditionally, quarantine stale opps and route hygiene reports to managers. See our Flow migration guide.
If this sounds like your CRM, let's look at it together.
Thirty minutes, no deck, no pitch. You leave with a diagnosis either way.