Every forecast call starts with the same unspoken question: is this data right? When the answer is "sort of," the meeting becomes an archaeology session. CRM hygiene isn't glamorous, but it's the foundation of every pipeline review, territory plan and board metric. This checklist is the routine we train our Revenue Assistants on.
Why CRM data decays
CRM data goes stale for predictable reasons:
- Reps update records in batches — or not at all — after busy weeks.
- People change jobs, so contact data degrades steadily.
- Imports and integrations create duplicates.
- Close dates get pushed without notes; stages don't reflect reality.
- Required fields get filled with placeholder values to bypass validation.
None of this is a character flaw. It's what happens when the people closing deals are also expected to be data-entry clerks. The fix is a routine with a clear owner.
The daily routine (15–30 minutes)
- Log activities from yesterday's calls and meetings. Notes, outcomes, next steps.
- Every open opportunity has a dated next step. No date, no next step.
- New leads are assigned and tagged with source and segment.
- Bounced emails and unsubscribes are processed so sequences don't keep hitting dead addresses — and so you stay compliant with the CAN-SPAM Act, which requires honoring opt-outs within 10 business days.
The weekly routine (before pipeline review)
Run this the day before your forecast or pipeline meeting.
Opportunities
- [ ] Close dates in the past are updated or the deal is closed-lost with a reason.
- [ ] Close dates pushed more than once in 30 days are flagged for the manager.
- [ ] Stage matches the exit criteria for that stage (for example, "Proposal" means a proposal was actually sent).
- [ ] Amount and products are populated and plausible.
- [ ] Opportunities with no activity in 14+ days are flagged.
- [ ] Primary contact and economic buyer are identified.
Accounts and contacts
- [ ] Duplicates created this week are merged.
- [ ] Contacts at target accounts have titles and roles.
- [ ] Contacts who've left the company are marked and replaced where possible.
Reporting
- [ ] Pipeline report by stage, owner and close month is refreshed.
- [ ] Week-over-week changes are summarized: new pipeline, moved, pushed, won, lost.
- [ ] Exceptions list is sent to the sales leader.
The monthly routine
- Field audit: which required fields are frequently blank or filled with junk values? Fix the field or the process.
- Duplicate sweep across accounts, contacts and leads.
- Enrichment refresh for target accounts using your data tools.
- Closed-lost review: are loss reasons consistent and useful?
- Ownership check: accounts and opportunities owned by departed reps are reassigned.
The quarterly routine
- Review stage definitions and exit criteria with sales leadership.
- Retire unused fields and picklist values.
- Audit integrations that write to the CRM.
- Review user access and permissions; remove departed users.
Who should own CRM hygiene?
Reps should own the information only they know: what happened on the call, the next step, their confidence in the deal. Everything else — formatting, de-duplication, enrichment, reports, flagging stale records — is better owned by someone whose job it is.
That might be a RevOps analyst, a sales coordinator or a dedicated revenue assistant. The key is that it's someone's job, with a checklist and a deadline, not everyone's afterthought.
How to measure CRM health
Pick a handful of metrics and track them weekly:
| Metric | What it tells you |
|---|---|
| % open opportunities with a future-dated next step | Whether deals are actively managed |
| % opportunities with close date in the past | Forecast hygiene |
| Average pushes per opportunity | Forecast realism |
| Duplicate records created per week | Data-entry and integration health |
| % target-account contacts with title and role | Coverage for multi-threading |
Improvements in these numbers are what you should expect from a hygiene program. Set your own baseline in week one and track from there.
Salesforce and HubSpot tips
- Use validation rules sparingly; too many encourage junk data. Better to use reports that surface problems for a person to fix.
- Build a "hygiene exceptions" report or view with filters for each checklist item, so the weekly routine is a matter of working down a list.
- Use duplicate rules (Salesforce) or duplicate management (HubSpot) to catch the easy cases automatically.
- Both vendors publish detailed documentation: Salesforce Help and the HubSpot Knowledge Base.
Common mistakes
- Making it a one-time cleanup. Data decays continuously; hygiene must be a routine.
- Adding more required fields. This often makes data worse, not better.
- No definitions. If "Stage 3" means different things to different reps, no amount of cleanup will help.
- No owner. If everyone owns it, nobody does.
A worked example: a CRM health score
A single number makes hygiene visible. Here's an illustrative score built from five checks, each weighted equally:
| Check | How measured | This month |
|---|---|---|
| Open opportunities with a next step and date | % of open opps | 82% |
| Opportunities with a close date in the future | % of open opps | 91% |
| Contacts with a valid email | % of contacts added in the last 90 days | 95% |
| Accounts with an owner | % of accounts | 99% |
| Duplicate records | Duplicates per 1,000 records (scored inversely) | 88% |
| Health score | Average | 91% |
Track it monthly. A falling score is an early warning that reports and forecasts are drifting away from reality.
Checklist: field rules worth enforcing
- Required fields per stage, enforced with validation rules in Salesforce or required properties in HubSpot
- Picklists instead of free text for industry, lead source and loss reason
- Standard naming for opportunities: "[Account] – [Product] – [Month Year]"
- A single owner per account, with a documented process for transfers
- Loss reasons required when an opportunity closes lost
Fewer, enforced fields beat many optional ones. Every optional field invites inconsistency.
Who should do what
Reps own the facts only they know: deal stage, next step, close-date judgment. An assistant or sales-ops person owns everything else: deduplication, enrichment, field formatting, missing-data chasing and the health report. Splitting it this way keeps reps selling while the data stays clean. Write the split down so nobody assumes the other side has it covered.
A quarterly cleanup sprint
Once a quarter, run a focused two-day sprint: merge duplicates, archive contacts who have bounced or left their companies, close stale opportunities with a loss reason, and review picklist values that nobody uses. Report the before-and-after health score to the sales leader so the work is visible.
The bottom line
A trustworthy forecast is the product of boring, consistent routines: daily activity logging, a weekly pre-review checklist and monthly audits. Give the routine an owner, measure a few health metrics, and your pipeline meeting can go back to being about deals.
ExecWing Revenue Assistants run this checklist every week for sales leaders. Read also: VA for sales leaders and revenue assistant vs SDR.
Sources
- Federal Trade Commission, CAN-SPAM Act: A Compliance Guide for Business.
- Salesforce Help and HubSpot Knowledge Base — vendor documentation on duplicate management and reports.
Want a dedicated assistant who already knows this playbook?
ExecWing places full-time, managed assistants from the Philippines with US leaders. Month-to-month, from $1,900/mo. See pricing or how it works.
Book a 20-minute fit call