Debbie CuhaGet in touch
Back to field notes

The CRM Cleanup SOP: Fix Your Database in One Week

By Debbie Cuha, October 27, 2026. 6 min read

Title card: The CRM Cleanup SOP: Fix Your Database in One Week, by Debbie Cuha

You clean a CRM in five working days by doing five things in order: export a backup, remove the dead records, merge the duplicates, tag everyone who is left, and assign every record a next action. Then you set one weekly rule so you never have to do it again.

Key takeaways

  • A CRM can be cleaned in five working days with a fixed procedure.
  • Back up and count before you delete anything.
  • Mark unsubscribed contacts do not contact. Never delete them.
  • Every contact gets one relationship tag, one status tag and a next action with a date.
  • Fifteen minutes every Friday keeps it clean.

A dirty database is not a technology problem. It is a missing procedure. I was CFO of a company with 280 offices, and my position has not changed: a database is only as good as the rule for what goes into it.

How do you clean a CRM in five days?

One job a day, in a fixed order, each with a test that tells you the day is done.

Day Job Done when
1 Back up and count The export is saved with the date and six numbers are written down
2 Remove No working record is left without a phone or an email
3 Merge A sort by phone and a sort by email show no repeats
4 Tag Every record has one relationship tag and one status tag
5 Assign Every record has a next action and a date
The five-day cleanup: Day 1: back up and count, Day 2: remove dead records, Day 3: merge duplicates, Day 4: tag everyone, Day 5: assign a next action

What do you do before you delete anything?

Export the full database to a spreadsheet, save it with the date, and write down your starting numbers. The export is your undo button. The numbers are your before picture, and you will want them on Friday.

Count Monday Friday
Total contacts
No phone
No email
No activity in 12 months
No tags
No next action

What should you delete, and what should you archive?

Delete what was never a real contact. Archive what was real and went quiet. Mark anyone who asked you to stop, and keep the record.

Record Action Why
No phone and no email Delete There is no way to reach them
Test entries and obvious junk Delete Never a person
Bounced email and no other contact method Delete Same as no contact method
Vendors mixed into the client list Move to a vendor list They are not leads
Lead older than 24 months with no reply to anything Archive Out of the working list, still searchable
Unsubscribed, or asked not to be contacted Keep and mark do not contact Delete the record and the next import brings them back with no flag
Past client with old details Keep and fix A past client is never archived

If you cannot bring yourself to delete, archive. Just get them out of the working list. Your broker's policy and the law on opt-outs and do-not-call lists come before this table.

Delete, archive or keep: delete records with no phone and no email, archive leads silent for 24 months, move vendors to a vendor list, keep and mark anyone who unsubscribed, keep and fix every past client

Should you try to re-engage old leads before you archive them?

Once, with one personal message and a deadline. Ask whether they still plan to move. Anyone who answers gets a status tag and a next action. Anyone who has not answered in two weeks is archived.

For the people you do want back, Jason Pantana's episode on warming up cold contacts on Tom Ferry's This Week in Marketing (May 15, 2023) starts where this does: organize and pick your contacts first.

How do you find and merge duplicates?

Run the duplicate tool if your CRM has one, then sort the list by phone number and again by email to catch what the tool missed. When you merge, keep the record with the most history, and copy the notes from the other record before it disappears.

How many tags does a contact need?

Two. One says who they are to you. One says when they are likely to act.

Relationship Status
Past client Active now
Sphere Next 90 days
Lead This year
Vendor or agent Nurture

Two tags. Not eleven. A tag system fails when nobody can remember it. If a tag does not change what you do next, remove it.

Two tags per contact: a relationship tag such as past client, sphere, lead, vendor or agent, and a status tag such as active now, next 90 days, this year or nurture

What is a next action, and why does every record need one?

A next action is one specific step with a date and an owner: a call, a note, a market update or a nurture plan. No contact leaves Friday without one. "Zero leads in the CRM without a next task" is the standard in my 12-SOP kit.

A record with no next action is how leads go quiet, which I covered in the speed-to-lead SOP.

What should every new record contain?

Five fields, entered the same day the contact is made.

  1. Name
  2. Phone or email, both when you have them
  3. Source: where they came from
  4. One relationship tag and one status tag
  5. Next action and a date

If a field is missing, the record is not finished.

The minimum record: name, phone or email, source, one relationship tag and one status tag, next action and a date

How do you know the cleanup worked?

Count again on Friday and fill in the second column. No tags and no next action should both be zero. Total contacts, no phone and no email should be smaller. If a number did not move, that day's job is not done.

Who should do the cleanup?

The first one, you or your admin with you in the room, because the decisions about who stays are yours.

After that, the Friday 15 minutes belongs to each agent for their own records. If you are thinking about your first assistant, this is a good first project to hand over with a written SOP.

How long does it take, and how often should you repeat it?

Five working days for the first cleanup, one job a day. With a large database, block the same hour each day and work one segment at a time, in the same order.

After that you should not need another big cleanup. Run the six counts once a quarter with the quarterly SOP audit.

What keeps it clean?

One standard, enforced weekly: if it is not in the CRM, it did not happen.

  • Every new contact is entered the same day with both tags.
  • Every conversation gets a note and a next action before the day ends.
  • Fifteen minutes every Friday to clear anything untagged.

Put that in your team standards and review it in the weekly numbers meeting. The other procedures that depend on a clean database are in my guide to real estate SOPs.

Key takeaways card for The CRM Cleanup SOP: five working days, back up and count first, mark unsubscribed contacts and never delete them, two tags and a next action on every contact, fifteen minutes every Friday

Next steps

  • Get the free 12-SOP kit and put your name on the first five.
  • See how SOP consulting works if you want these built for your team.
  • Or email me a question at dc@syngp.com. I read every one.