What CRM hygiene rules prevent forecast garbage-in-garbage-out failures?

Question

Pulse RevOps · The Machine · Accepted Answer

## 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:** 1. **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 2. **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 3. **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 4. **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 5. **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 6. **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) 7. **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 | ```mermaid flowchart TD A["New Deal Entry"] --> B{"Size≥10%
Quota?"} B -->|No| C["Reject:
Too small"] B -->|Yes| D{"Close Date
Documented?"} D -->|No| E["Hold:
Add date"] D -->|Yes| F{"2+
Contacts?"} F -->|No| G["Hold:
Add contact"] F -->|Yes| H{"Buyer Title
Valid?"} H -->|No| I["Hold:
Verify role"] H -->|Yes| J{"Recent
Activity?"} J -->|No| K["Accept to
Pipeline Only"] J -->|Yes| L["Accept to
Forecast"] ``` TAGS: crm-hygiene,data-quality,forecast-foundation,deal-standards,pipeline-cleanliness,data-governance

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

What CRM hygiene rules prevent forecast garbage-in-garbage-out failures?

Forecast Hygiene: Foundation Layer

Operator Detail

CRM Automation

The Hygiene Audit

What does the score mean?