The Salesforce Cleanup Playbook: Restoring Trust in Your CRM
Three generations of well-intentioned admins have made your Salesforce org a graveyard of stale fields and broken automations. Here's a 30-day playbook to restore trust without burning it down.
Every five years, a Salesforce org needs a haircut. Three generations of admins, two re-orgs, and one well-meaning consulting engagement later, you have 400 custom fields, 80 of which are populated, 20 of which are trusted, and 6 of which actually drive a report leadership reads. Here's how to fix that without breaking the business.
Week 1: Audit, don't change
- Pull a field-usage report on Account, Contact, Lead, and Opportunity.
- Tag every field: actively used, system required, historical-only, or dead.
- List every active automation: Flows, Process Builders, Apex triggers, Workflow Rules.
- Map every integration writing into Salesforce. Note its field ownership.
Week 2: Define the target model
Before deleting anything, write the model you want to land on. One page per object. What fields exist, what each one means, who owns it, and what report or process consumes it. If a field doesn't have a documented consumer, it doesn't survive.
Week 3: Quiet the noise
- Deprecate (don't delete) unused fields: rename with a "zzz_" prefix and remove from layouts.
- Consolidate duplicate picklist values; standardize country, industry, and segmentation.
- Disable Process Builder and Workflow Rules superseded by Flow; never leave parallel automations active.
- Lock down field-level security so only the right roles can write to revenue-critical fields.
Week 4: Rebuild the reporting layer
Once the data model is clean, rebuild the dashboards on top of it. Five reports leadership actually uses beats fifty that nobody opens. Each report should map to a decision and an owner.
The trust restoration moment
The signal that the cleanup worked isn't a tidier org. It's the next forecast call. When Sales leadership pulls a number from a dashboard and nobody challenges it, you've restored trust. That's the only KPI that matters for a Salesforce cleanup.
Need a hand putting this into practice?
We help revenue teams turn the ideas in these posts into working systems, usually in weeks, not quarters.