Home / Insights / Stale CRM

A note, not a case study

What to do with a CRM full of stale leads.

A pipeline of two thousand rows is not a pipeline. It is an archive with a few live conversations hiding in it. Clean that split before you ask anyone to “just work the list.”

Most stale CRMs fail in the same way. Old exhibition scans, web forms, and “we’ll think about it” sit in the same view as a buyer who replied yesterday. The rep starts at the top. The top is whoever was typed in first. The ready buyer is on page four.

Split the list into three piles

Do this before you rewrite stages or buy another field.

  1. Live. There was a real action in the last two weeks: a reply, a meeting, a document, a site visit, a question. These stay on the working list.
  2. Dormant. There was a real conversation once, and then silence. These get one honest follow-up with a reason, then they leave the morning list if nothing comes back.
  3. Archive. No owner, no conversation, or the only activity is a form from months ago. These are not today’s work. Keep them searchable. Take them out of the queue.

Two weeks is a starting line, not a law. A six-month industrial sale can be live with a quieter rhythm. The test is the same: is there a next action a named person will take this week? If nobody can say what it is, the row is not live.

Give every live row four facts

  • An owner. One person.
  • The offer it actually fits, in the words the company sells.
  • The last thing the buyer did, with a date.
  • The next step, specific enough to do without a meeting about it.

If a row cannot hold those four facts, it is not ready to be ranked. Guessing a stage name does not fix that.

Then rank. Do not sort by date created.

Once the live pile is small enough to see, order it by the latest buyer action, not by when the record was born. A form from this morning that only says “hi” sits below a buyer who reopened a quotation yesterday. Creation date is how the mess was built.

What this is not

This is a cleaning order. A pipeline review applies this split to your export, with you on the call.

Related: when the real stage lives on WhatsApp

Free review WhatsApp