CRM Deal Hygiene Cleanup Checklist Builder
Create a CRM deal hygiene process for cleaning stale opportunities, close dates, stages, next steps, contacts, forecast categories, and manager inspection notes.
Prompt Template
You are a sales operations leader. Build a CRM deal hygiene cleanup checklist for [sales team/company] before [forecast call, month-end, quarter-end, board reporting]. Context: - CRM: [Salesforce, HubSpot, Pipedrive, Dynamics, other] - Sales motion: [SMB, mid-market, enterprise, PLG-assisted, channel] - Pipeline stages: [stage names] - Required fields: [amount, close date, next step, champion, economic buyer, source, competitors, products] - Forecast categories: [pipeline, best case, commit, closed] - Common data issues: [stale close dates, no next step, duplicate opps, wrong stage, missing contacts] - Inspection cadence: [weekly, monthly, quarter-end] - Team roles: [AE, SDR, manager, sales engineer, deal desk] - Reporting needs: [forecast, board deck, territory review, rep coaching] Deliver: 1. Deal hygiene scorecard with pass/fail criteria 2. Stage-by-stage required field checklist 3. Stale opportunity rules and cleanup actions 4. Close-date and amount validation questions 5. Next-step quality rubric with examples of weak vs strong entries 6. Duplicate, dormant, and sandbagging risk checks 7. Manager inspection questions for forecast calls 8. CRM list views/reports to create 9. 60-minute cleanup sprint agenda for reps 10. Post-cleanup summary template for sales leadership
Example Output
CRM Hygiene Scorecard
A deal is forecast-ready only if it has a dated next step, confirmed buying process, current close date, and at least one verified customer contact.
Required Field Checklist
| Stage | Required Fields | Fail Condition |
|---|---|---|
| Discovery | use case, pain, next meeting date | no customer meeting scheduled |
| Evaluation | champion, decision criteria, competitor | champion blank |
| Proposal | amount, close date, approval path | close date older than today |
| Commit | economic buyer, legal/procurement status, mutual next step | next step is "follow up" |
Weak vs Strong Next Step
- Weak: "Check in next week"
- Strong: "Send security answers by May 10; customer legal review call booked May 13 with Priya and Marcus"
60-Minute Sprint
1. 10 min: Filter stale close dates
2. 15 min: Fix missing next steps
3. 15 min: Validate commit deals with manager questions
4. 10 min: Merge or close duplicate opportunities
5. 10 min: Submit forecast change notes
Tips for Best Results
- 💡Define hygiene rules before the forecast call so managers do not inspect subjectively.
- 💡Require dated next steps; vague follow-ups are where deals go to retire quietly.
- 💡Keep cleanup sprints short and recurring instead of waiting for quarter-end panic.
- 💡Use the process to improve coaching, not just to punish messy CRM notes.
Related Prompts
Sales Territory Planning Framework
Create a data-driven sales territory plan that balances workload, maximizes coverage, and aligns rep strengths with market opportunities.
Cold Email Sequence Writer
Write a 4-email cold outreach sequence that gets replies without being pushy, spammy, or forgettable.
Sales Discovery Call Questions
Generate a structured discovery call question framework that uncovers genuine pain, budget, and buying process.