Knowledge Library · crm-hygiene
What CRM hygiene rules prevent forecast garbage-in-garbage-out failures?
Forecast Hygiene: Foundation Layer
Direct: Enforce deal-entry standards: deal size minimum, contact count requirement, documented close date, buyer title validation. Bad data erases forecast accuracy.
Operator Detail
Garbage data produces garbage forecasts, no matter how sophisticated your weighting model. Hygiene rules catch rot before it spreads.
The seven non-negotiable hygiene rules:
- Deal size floor: Enforce minimum deal value
- Rule: No deal under 10% of quarterly quota target
- Why: Prevents noise and vanity deals inflating pipeline
- Example: If quota = $100K/month, minimum = $10K deal
- Close date requirement: No date = no forecast
- Rule: Every deal must have documented, buyer-confirmed close date
- Ban: "Early Q2" or "End of month" — dates only
- Audit: Monthly check for deals over 90 days old with no close date
- Contact requirement: Minimum buying committee
- Rule: At least 2 contacts (champion + one decision maker)
- Why: Single-contact deals slip 3x more often
- Audit: Remove deals with 1 contact from commit forecast
- Buyer title validation: No "admin" or "general" roles
- Rule: Primary contact must be economic buyer or direct report
- Ban: "Contacted" or "unknown" titles — ask before entering
- Verify: Annually, title data against LinkedIn against CRM
- Deal age ceiling: No 180+ day staleness
- Rule: Deals over 180 days without activity flag red
- Move: Stale deals to "zombie" pool for quarterly cleaning
- Resurrect: Only if new meeting or activity in last 30 days
- Activity baseline: Recent engagement is mandatory
- Rule: Commit-forecast deals must have activity in last 14 days
- Activity = email, call, meeting, or sequence engagement
- Exception: Deals in final signature (legal hold)
- Stage consistency: No backwards movement without comment
- Rule: If deal moves backwards (Proposal → Qualification), require AE note
- Why: Catches rep panic-downgrades or data errors
- Audit: Weekly check for stage reversals
CRM Automation
Set up CRM rules to flag violations before entry or flag deals weekly that breach hygiene. Top ops teams use Pavilion or custom Salesforce workflow to lock down data.
The Hygiene Audit
Monthly report to leadership:
| Metric | Target | Actual | Risk |
|---|---|---|---|
| Deals with close date | 100% | 96% | 4 deals need dates |
| Deals with 2+ contacts | 100% | 89% | 11 deals need champion |
| No 180+ day zombies | 100% | 85% | 15 zombie deals |
| Average deal age | 30-45 days | 51 days | Pipeline aging |
flowchart TD
A["New Deal Entry"] --> B{"Size≥10%<br/>Quota?"}
B -->|No| C["Reject:<br/>Too small"]
B -->|Yes| D{"Close Date<br/>Documented?"}
D -->|No| E["Hold:<br/>Add date"]
D -->|Yes| F{"2+<br/>Contacts?"}
F -->|No| G["Hold:<br/>Add contact"]
F -->|Yes| H{"Buyer Title<br/>Valid?"}
H -->|No| I["Hold:<br/>Verify role"]
H -->|Yes| J{"Recent<br/>Activity?"}
J -->|No| K["Accept to<br/>Pipeline Only"]
J -->|Yes| L["Accept to<br/>Forecast"]
TAGS: crm-hygiene,data-quality,forecast-foundation,deal-standards,pipeline-cleanliness,data-governance
Keep reading
Sales TrainingFixing Duplicate Contacts in the CRM — 60-Min TrainingRead →KnowledgeHow do I clean a CRM that has 5 years of bad data?Read →Sales TrainingThe CRM Hygiene and Adoption Reboot — 60-Min TrainingRead →Sales TrainingFixing Missing Economic Buyer Fields in Salesforce — 60-Min TrainingRead →Sales TrainingThe Split Documentation Standup — 60-Min TrainingRead →KnowledgeWhat's the right CRM hygiene policy that reps actually follow?Read →
Was this helpful?
Sources cited
clari.comhttps://www.clari.com/gartner.comhttps://www.gartner.com/en/documents/sales-forecastingclari.comhttps://www.clari.com/blog/sales-pipeline-management/gong.iohttps://www.gong.io/blog/sales-pipeline/gartner.comhttps://www.gartner.com/en/sales/researchbvp.comhttps://www.bvp.com/atlas/state-of-the-cloud-2026⌬ Apply this in PULSE
Free CRM · Revenue IntelligenceAudit pipeline, score reps, ship the fixRelated in the library
Sales TrainingFixing Duplicate Contacts in the CRM — 60-Min TrainingRead →KnowledgeHow do I clean a CRM that has 5 years of bad data?Read →Sales TrainingThe CRM Hygiene and Adoption Reboot — 60-Min TrainingRead →Sales TrainingFixing Missing Economic Buyer Fields in Salesforce — 60-Min TrainingRead →Sales TrainingThe Split Documentation Standup — 60-Min TrainingRead →KnowledgeWhat's the right CRM hygiene policy that reps actually follow?Read →KnowledgeCan Snowflake compete with Databricks in 2027?Read →KnowledgeHow do we avoid common pitfalls in win-loss program design and execution?Read →KnowledgeHow do you measure and improve health-score model accuracy?Read →KnowledgeWhen does adding a sales operations BDR (admin assistant for reps) actually free up real selling time?Read →
More from the library
revenue-architecture · gtm-designPartner Enablement Program Design in 2027revenue-architecture · gtm-designHow to design SDR compensation that retains top performers in 2027revenue-architecture · gtm-designHow to design Mid-Market AE territories by industry vertical in 2027franchise · franchisesShould I open or buy a Sport Clips franchise in 2027?revenue-architecture · gtm-designProcurement-Friendly Pricing Presentation in 2027revenue-architecture · gtm-designSales Manager to Director Promotion Path in 2027electronic-review · top-10Top 10 USB Conference Microphones for Home-Office Sales Calls in 2027revenue-architecture · gtm-designCustomer Health Score Design for SaaS CS in 2027electronic-review · top-10Top 10 Premium Belts for Sales Executives in 2027electronic-review · top-10Top 10 Premium Ergonomic Chairs Over $1000 for Sales Executives in 2027electronic-review · top-10Top 10 Travel Adapters for International Sales Reps in 2027franchise · franchisesShould I open or buy a Kona Ice franchise in 2027?revenue-architecture · gtm-designHow to design a CRO scorecard for monthly board reporting in 2027revenue-architecture · gtm-designHow to build a forecast roll-up across multiple selling motions in 2027revenue-architecture · gtm-designHow to structure a renewals team separate from new-business AEs in 2027