Document

The 15-Minute CRM Cleanup Map

A fast way for a small office to inspect whether the CRM or spreadsheet is helping follow-up or just storing old names.

The 15-Minute CRM Cleanup Map

A CRM does not have to be perfect to be useful.

For a two-person office, the first goal is simple: make sure open opportunities are visible enough that follow-up does not depend on memory.

Use this 15-minute map before rebuilding anything.

Minute 1-3: List every place leads arrive

Write down the real intake paths:

  • website form
  • phone calls
  • direct email
  • Facebook or Instagram messages
  • referrals
  • Google Business Profile messages
  • walk-ins
  • text messages
  • quote forms

If leads arrive in more than one place, the CRM must help connect them, not become one more place to forget.

Minute 4-6: Find the open statuses

Look at your CRM, spreadsheet, inbox labels, or board.

Can you quickly tell which leads are:

  • new
  • waiting on reply
  • waiting on customer
  • quoted
  • callback due
  • booked
  • closed lost
  • dead or bad fit

If everything is just “open,” the team cannot see what to do next.

Minute 7-9: Check ownership

For each open lead, ask:

  • who owns the next step?
  • what is the next step?
  • when is it due?

If ownership is unclear, the CRM is not protecting the work.

Minute 10-12: Check stale records

Find anything that has not moved in 7 days.

For each stale item, choose one:

  • follow up
  • book
  • close
  • wait with a dated reminder
  • mark dead

A stale list is usually a follow-up leak in disguise.

Minute 13-15: Decide the first cleanup

Do not clean everything at once.

Pick one useful fix:

  • add a follow-up date field
  • create a callback status
  • make quote follow-up visible
  • assign one owner per open lead
  • create a simple daily review list
  • close dead records

The smallest useful cleanup is better than a giant CRM reset nobody maintains.

The core rule

Every open record should answer:

  • what is it?
  • who owns it?
  • what happens next?
  • when will we check it again?
  • what was the outcome?

If the CRM cannot answer those questions, the team will keep working around it.

Read the missed follow-up checklist Book a Follow-Up Leak Review