Pipeline Hygiene: Clean Up Duplicates and Dead Deals

Your pipeline is lying to you

It's Friday, you open your CRM to answer one question — how many quotes went out this week — and the number's rubbish. Two records for the same customer. A deal from March still sitting in "quoting" with nobody's name on it. A lead you already lost, never marked lost, so the follow-up robot keeps texting them.

That's dirty pipeline. It double-books jobs, chases the same quote twice with two staff, and hands you reports you can't trust. The fix isn't a data project. It's one hour today, then a short weekly habit.

Here's what we'd do, in order.

Key takeaways

• Dedupe on mobile number, not name — "Dave Smith" and "David Smith" are one person, one number
• Four mandatory fields only: name, mobile, service type, deal stage — anything more and staff fake it
• Owner plus close date on every open deal, then archive what's gone quiet for a quarter
• Standing rules and automation keep it clean so you never do the big clean-up twice

Start by killing duplicates on the mobile number

Merge duplicate contacts by matching mobile number, not name. Names are unreliable — a customer is "Bob", "Robert", "Rob at the Brown job" and "0412..." across four bookings. The mobile number is the one field that stays constant, so it's the only safe key to merge on.

Sort your contacts by mobile, find the repeats, and merge them into a single record with the full history attached. A plumber who does this stops sending two blokes to the same address because the job lived on two cards.

If your CRM can auto-detect matching numbers and merge them for you, turn that on. Doing merge after merge by hand is how a clean-up stalls early.

Set four mandatory fields — and only four

Make exactly four fields compulsory: name, mobile, service type and deal stage. That's it. When you force ten fields, your staff type "n/a" and "asdf" to escape the form, and now your data's worse than blank.

Four fields answer the questions you actually ask: who is this, how do I reach them, what do they want, where are they up to. A salon owner filtering "colour enquiries in booking stage" gets a real list, not a guess.

Everything else — address, referral source, notes — stays optional. Optional fields get filled when they matter and skipped when they don't, which is exactly right.

Give every open deal an owner and a close date

Assign one owner to every open deal, then force a close date on each. No deal sits ownerless. "Who's chasing the Henderson quote?" should never get the answer "I thought you were." A single owner is the rule that stops leads falling through the crack between two staff — the same logic behind routing rules that give every lead one owner.

The close date is your forcing function. A deal with a date you've blown past is either dead or being ignored — both need a decision. Without a date, deals drift forever and your forecast is fiction.

If you're not sure where deals keep dying, find where your pipeline leaks before you clean, so you fix the stage, not just the symptom.

Archive anything untouched for a quarter

Archive every deal with no activity for a quarter — no call, no text, no note. Not delete. Archive. The history stays searchable, but the card leaves your active board so your live pipeline shows only real, live work.

A "dead" lead that's never marked lost is worse than useless. It inflates your numbers and keeps the follow-up sequence texting someone who bought elsewhere in April. Mark it lost, archive it, and your reporting gets honest overnight.

Some of those quiet leads aren't dead — they're just not ready. Move those into a 90-day nurture plan instead of the bin, and know when to stop chasing a lead without burning it.

The standing rules that stop it reforming

Set the rules once so the mess can't rebuild. A clean-up you have to repeat every quarter isn't a fix — it's a chore you've scheduled. Lock in these five:

1. New contacts match on mobile — a duplicate number flags for merge, not a new card
2. The four fields are required at capture; the rest stay optional
3. Every new deal gets an owner the moment it's created
4. Every deal carries a close date — no date, no save
5. Deals auto-archive after a quarter of silence, tagged so you can review the batch

A clean CRM is also quieter compliance. Fewer stale records means less outdated personal and contact info sitting around indefinitely — which matters if you're a clinic under privacy obligations. Tidy pipeline, tidy data trail.

How IgniteOS does this for you

IgniteOS runs these rules for you instead of leaving them on a sticky note. The CRM merges contacts on matching mobile numbers, holds your four required fields, and forces an owner and close date on every deal. The automations auto-tag and archive deals that go quiet, so your live board only ever shows real work — no manual sweep every quarter.

That's the same engine behind our automate-your-follow-up tools: leads get chased once, by one owner, and dead ones stop getting texted. It sits with the rest of the platform — many tools and features in one login, so your pipeline, your quotes and your reviews all read off the same clean records.

Want to see how much a tidy, single stack replaces? Our calculator puts a typical replaced tool stack at about $18,000 a year. Start with a free trial, and the fastest win is this: run the one-hour clean-up above once, then never do it by hand again.

Frequently asked questions

Should I merge CRM duplicates by name or phone number?

Merge on mobile number, not name. A single customer shows up as Bob, Robert and Rob across bookings, but their mobile stays constant, so it's the only safe key to match on. Sort contacts by number, merge the repeats into one record with full history, and turn on auto-detection if your CRM offers it.

How many required fields should a CRM have?

Four: name, mobile, service type and deal stage. Force more and staff type "n/a" and "asdf" to escape the form, leaving data worse than blank. Four fields answer who this is, how to reach them, what they want and where they're up to. Keep address, referral source and notes optional.

When should I mark a deal dead or archive it?

Archive any deal with no activity — no call, text or note — for a quarter. Archive, don't delete, so history stays searchable while your live board shows only real work. Leads that aren't dead, just not ready, belong in a nurture plan rather than the bin. IgniteOS can auto-archive quiet deals for you via automations.

Does a clean CRM help with privacy compliance?

Yes. Fewer stale records means less outdated personal and contact information sitting around indefinitely, which matters for clinics and any business under privacy obligations. Regular archiving of dead deals keeps your data trail as tidy as your pipeline, so you're not holding contact details you no longer have a reason to keep.