How do I clean out dead records without losing history?
Short answer
Archive inactive contacts instead of deleting them, using clear criteria like no activity for a set period, so job history and past revenue stay intact for reporting. Archiving keeps active lists clean while the full record remains available if that customer ever returns.
Before you start
- A definition of what counts as an inactive or dead record for your business.
- An archive or status field, rather than only a delete option.
- A backup or export before running any bulk cleanup.
- Reports that currently include, and should continue to include, historical revenue.
Step by step
- 1
Define what counts as dead
No activity, no reply, and no job for a set period, agreed on in advance.
Without a clear definition, cleanup becomes inconsistent guesswork.
- 2
Separate leads from past customers
A cold lead who never booked is different from a customer with completed job history.
Treating them the same risks losing valuable revenue history along with genuinely dead leads.
- 3
Archive instead of deleting
Move dead records to an archived status rather than removing them from the system.
Archiving keeps the door open if that person returns and preserves reporting history.
- 4
Exclude archived records from active views
Filter dashboards, lists, and outreach to only show active contacts by default.
This is what actually keeps the working list clean day to day.
- 5
Keep archived records in revenue reporting
Confirm that past job value from archived customers still counts in historical reports.
Archiving should tidy the active list without erasing the business's real history.
- 6
Run cleanup on a schedule
Quarterly or twice a year, using the same inactivity definition each time.
A one-time cleanup drifts back into a cluttered list within months.
- 7
Give dead leads one last outreach first
Send a reactivation message before archiving so genuinely dead ones are truly confirmed dead.
Some records marked inactive are simply people who have not been followed up with properly.
What good looks like
- Active lists show only contacts worth working right now.
- Job and revenue history stay intact for reporting and audits.
- Cleanup happens on a predictable schedule instead of piling up.
- Genuinely dead leads are archived, not customers with real history.
Common mistakes
The ways this goes wrong in data, and what to do instead.
Deleting records permanently›
Job history and past revenue disappear along with the contact, breaking historical reports.
Do this instead: Archive inactive records with a status change instead of deleting them outright.
No agreed definition of inactive›
One person archives after thirty days while another waits a year, producing an inconsistent list.
Do this instead: Set a single, documented inactivity threshold the whole team uses.
Cleanup happens once and never again›
The list is tidy for a month and then slowly fills back up with stale records.
Do this instead: Schedule a recurring cleanup pass using the same criteria every time.
Frequently asked
5 questions about clean out dead records without losing historyRelated guides
Pick the next thing to set up, or back up a step if something here assumed work you have not done yet.
Do this next
The natural follow-on tasks once this one is working.
People usually get here from
Guides that lead into this one, in case you skipped a step.
More in Data
Nearby tasks that share the same setup and vocabulary.
Was this guide helpful?
Tell us what worked and what didn't. It shapes what we rewrite next.
You didn't get into business to be in the tech business.
Managed Tech clients hand this to us. We build it, test it, maintain it, and add to it as the business changes, so nobody on your team has to become the person who knows how the system works.