Close CRM Journal · July 2, 2026 · 8 min read

How to Clean Up a Messy Close CRM Account, Step by Step

Statuses nobody remembers creating. Three fields for the same phone number. A Workflow paused since last year and 4,000 leads that are "probably duplicates." Every lived-in Close account drifts — here's how to pull one back without breaking what still works.

How accounts get like this (it's nobody's fault)

CRM mess isn't a discipline failure — it's sediment. Every quarter someone adds a status for an edge case, a field for a campaign, a Smart View for a question they had once. Nothing is ever removed, because removing feels risky. Three years later the account has two dozen statuses, forty fields, and a pipeline whose total value everyone silently ignores. The fix isn't more discipline; it's one deliberate restructuring, then guardrails.

Rule zero: audit before you touch anything

The urge is to start deleting immediately. Resist it. First, inventory the account — a spreadsheet with one tab each for:

• Statuses (lead and opportunity): name, record count, last time a record entered it
• Custom fields: name, type, fill rate — a field filled on 4% of leads is already telling you its future
• Smart Views: owner, and whether anyone can explain what it's for
• Templates and Workflows: active or abandoned, last used, reply rates
• Users and API connections/integrations: who and what can write to the account

Two hours of inventory turns "this account is chaos" into a fixable list — and it's the difference between surgery and flailing.

Step 1 — Design the target structure first

You can't map old-to-new without a "new." Define the destination exactly as you would for a fresh account — six or seven lead statuses with entry rules, verifiable pipeline stages, a short list of fields that earn their place. The new-account checklist is the blueprint; the clean-up is just the route there.

Step 2 — Map statuses, then bulk-move

For every legacy status, decide its destination: merge into a new status, or split by a rule ("'In Progress' older than 90 days → Nurture; newer → Attempting Contact"). Use Smart Views to isolate each group and Close's bulk edit to move them. Two rules:

• Never delete a status that still has records in it. Move the records first; retire the empty shell after.
• Write the mapping down before you run it. When someone asks in a month why lead X is in Nurture, the answer should be a document, not a shrug.

Step 3 — Merge duplicates while history still matters

Duplicate leads split your history: half the calls on one record, half the emails on the other, and neither tells the full story. Hunt them by domain and company name, and merge — merging in Close combines the activity timelines, so nothing is lost. Do this before rebuilding automation, or your shiny new Workflow will email the same person twice from two half-records.

Step 4 — Close zombie opportunities honestly

Every stale opportunity gets one of three verdicts: alive (gets a next step with a date, today), lost (marked lost with a reason — "no decision" is a valid reason and the most common one), or not now (lost, lead moved to Nurture with a future follow-up task). Yes, the pipeline number drops — sometimes dramatically. It hurts once, and then your forecast means something for the first time in years. Your win rate and cycle-length metrics only become readable after this step (see the reporting guide).

Step 5 — Retire dead weight

With records clean, sweep the configuration: fields below a meaningful fill rate (fold the rare exceptions into a note), Smart Views nobody claims within a week, templates that haven't been sent in months, Workflows nobody can explain. Be ruthless — everything here survived the audit unowned and unloved, and every survivor you keep is a question a new hire will someday ask.

Step 6 — Rebuild automation fresh

Don't renovate the old Workflows; rebuild the one or two you actually need on top of the clean structure — typically a follow-up cadence and the five core Smart Views. Old automation encoded the old mess; carrying it forward re-imports the problem you just fixed.

Step 7 — Retrain, document, assign an owner

A clean account with an untrained team is a countdown timer. Finish with a one-hour walkthrough (what changed and why), a one-page playbook (statuses with entry rules, stages, the morning Smart View routine), and one named owner who approves any new field, status or view going forward. That last one is the guardrail that prevents Clean-Up: The Sequel.

Keeping it clean: the monthly hygiene loop

• 15 minutes monthly: scan fill rates, unowned views, and opportunities without next steps
• Required fields at the moments that matter (e.g. a lost reason when a deal is lost, a value on every new opportunity)
• New configuration goes through the owner — additions are proposals, not defaults

Drift never fully stops — but with the loop in place, it stays a monthly trim instead of a yearly excavation.