Patch Crm Hygiene

---
name: patch-crm-hygiene
description: "The user says \"the pipeline number is wrong,\" \"the forecast keeps missing,\" \"our CRM is a graveyard,\" or \"I can't trust the data.\" Load for pipeline audit, contact-data cleanup, stale-deal sweep, or a defensible forecast. Pairs with operating-rhythm — the CRM feeds the weekly tactical's pipeline-cov"
metadata:
  author: wayland
  version: "1.0.0"
  category: "patch"
---

# CRM hygiene

## When to load this mode

The user says "the pipeline number is wrong," "the forecast keeps missing," "our CRM is a graveyard," or "I can't trust the data." Load for pipeline audit, contact-data cleanup, stale-deal sweep, or a defensible forecast. Pairs with operating-rhythm — the CRM feeds the weekly tactical's pipeline-coverage number.

## What CRM hygiene is for

A CRM is a single source of truth for two questions: *what is the realistic next 90 days of revenue, and which deals deserve an hour this week.* Both answers degrade fast. Stale stages, duplicates, unowned deals, "next step: follow up" with no date — each is a small lie. The forecast sums them.

Hygiene is the discipline of writing down what's actually true.

## The procedure

**1. Define stages by buyer behavior, not seller activity.** A stage is what the *buyer* has done. "Demo scheduled" is a stage. "Reach out" is a task. Map every stage to a buyer-observable event:

- Stage 1: buyer confirmed a meeting on calendar
- Stage 2: buyer named the problem and the cost out loud
- Stage 3: buyer pulled in a second stakeholder
- Stage 4: buyer requested pricing or asked legal/procurement to engage
- Stage 5: buyer signed

If a deal can't be mapped to an observable event, it's a hope. Move it to "not a deal yet" and stop counting it.

**2. Sweep for staleness.** Look at the **last buyer-initiated touch** — not the last seller activity. Five "just checking in" emails do not advance a deal. The buyer not responding is the signal.

- No buyer-initiated touch in 14 days → flag yellow
- No buyer-initiated touch in 30 days → close-lost or move to a "long-term nurture" segment outside the pipeline
- "Next step: follow up" with no date → the deal is dead. Close it.

**3. Audit contact data.** Three checks:

- **Duplicates** — same email or company at two contacts. Merge.
- **Owner integrity** — exactly one owner per contact and deal. Unassigned and co-owned both don't get worked.
- **Required fields filled** for active deals: contact email, company, stage, next-step description and date, deal value, source. Empty field on a stage-3+ deal means it's not stage 3+.

**4. Reconcile pipeline math against history.** Sum the active pipeline. Multiply by historical close rate per stage (if unknown: 20% stage-2, 40% stage-3, 70% stage-4 as starting estimate, flag as hypothesis). Compare against the rep's verbal forecast. Verbal beats math by 30%+ → rep is forecasting from feeling. Math beats verbal by 30%+ → rep has stopped trusting the CRM. Both diagnostic.

**5. Install a 15-minute weekly hygiene ritual.** Every rep, before the tactical: sweep their pipeline. Stale flagged. Next steps dated. Stages moved on buyer behavior. The weekly reviews the *result*, not raw chaos.

## Decision rules

- **Buyer-observable behavior advances stages. Nothing else does.** A rep "feeling good about the deal" is not a stage move.
- **The pipeline number is the math, not the rep's gut.** Both get logged. Persistent gaps are coachable.
- **No deal lives more than 2x the average sales cycle.** If the average is 45 days and a deal is 120 days old, it's not closing — it's being avoided. Close it or escalate it.
- **Contact data quality is a single-owner job.** Spread it across the team and it rots in three weeks.
- **Don't add fields to fix data problems.** New fields create new empty fields. Fix what's required first.

## Anti-patterns

- **The custom-field-of-the-month.** Three weeks after the new field is added, 80% of records have it blank. Fill existing fields before adding new ones.
- **"Pipeline coverage of 5x quota" with no stage discipline.** 5x of garbage is still garbage.
- **Marking deals "lost — no budget."** Usually means "lost — no urgency." Force the loss-reason taxonomy to map to real causes: no urgency, lost to competitor, lost to non-consumption, disqualified, ghosted.
- **Quarterly CRM cleanups.** Three months of bad forecast between scrubs. Only weekly hygiene compounds.
- **Buying a better CRM to fix a process problem.** A new tool inherits the old hygiene.

## Before / after

**Before:**

> Founder: "Pipeline says $1.2M. Reps tell me Q3 is going to be huge."

Audit: 38% of deals last buyer-touched 30+ days ago. 22% have "next step: follow up" with no date. Two reps co-own five deals. Loss-reason empty on 60% of closed-lost.

**After:**

> Pipeline rebuilt: $1.2M raw → $640K active (stage 2+, buyer touch in 14 days, single owner, next step dated). Forecast: $185K weighted close, with three deals worth $310K combined named as "needs founder air-cover this month." Smaller number. Defensible. The weekly tactical now reviews seven deals instead of forty, and decisions get made.