A One-Week CRM Cleanup Sprint for Stale Leads
A CRM full of 90-day-old 'new' leads hides the real pipeline. Run a one-week cleanup sprint for stale leads: define stale, work the buckets, dispose honestly, and lock the habit.
Monday morning, the internet director opens the CRM and filters to "open." The count is 2,400. The store did not talk to 2,400 shoppers last week. It talked to a few dozen, and then years of "new," "working" and "hot" piled up because nobody wanted to mark a name lost. Reps skip the list because it is unusable. Managers skip the aging report because it is a lie. The real pipeline is maybe 80 people. It is buried under a museum.
A cleanup is not a reporting project and it is not a mass email blast. A one-week CRM cleanup sprint for stale leads is a scheduled, owned, finite pass that turns the open list into something a floor can work. You will dispose a lot of records. That is the point. A smaller honest book sells more cars than a giant fictional one.
This guide is for used-car managers and internet directors who know the CRM is dirty and keep waiting for "a slow week." There is no slow week. Block the calendar, run the sprint, and put a rule in place so the pile cannot rebuild.
Define Stale Before You Touch a Record
If you do not define stale, every rep will protect their favorite names and dump someone else's. Write the definition on a whiteboard and do not argue it mid-sprint.
A working definition
Treat a lead as stale when all of the following are true:
- No inbound or outbound contact logged inside your chosen window (many stores use 14 days for active internet, 30 days for long-nurture — pick one and write it down).
- No future appointment on the calendar.
- Status still implies work: new, contacted, working, hot, follow-up.
- The customer has not asked you to pause contact.
That definition is an operating standard, not a law. Tighten it for Marketplace-speed traffic. Loosen it only for a documented long-nurture list with a real next date, not for names you are afraid to close.
What is not stale
- Sold-pending delivery.
- Appointments in the next seven days, even if the last note is thin — fix the note, do not dispose the file.
- Customers who opted out. Those are closed, not stale. Do not "clean" them by calling.
- Duplicate records of an active file. Merge them; do not work them as extras.
For how to close the ones that are truly done, keep lead disposition codes for lost internet leads next to the sprint so "stale" does not become a junk drawer status.
The One-Week CRM Cleanup Sprint, Day by Day
Assign a single owner — usually the internet director or used-car manager — and a helper who can merge duplicates. Reps do not get a vote on definitions. They do get a list of their own names to confirm before you dispose.
Day 1: Freeze, export, bucket
- Announce the sprint. No new mass campaigns into the old book this week.
- Export or filter all open internet leads.
- Split into buckets you can finish:
- Touched in the last 7 days — leave them. They are not the sprint.
- 8–30 days, no next step — working list.
- 31–90 days — likely dispose or one last attempt.
- 90+ days — dispose unless a manager flags a real exception.
- No phone, no email, no thread link — dispose or merge. You cannot work a ghost.
- Count each bucket. If 90+ days is enormous, that is Day 2's entire job.
Do not start calling on Day 1. Sorting is the work. Calling into an unsorted pile recreates the mess.
Day 2: Kill the museum (90+ days)
Managers review 90+ day records in batches. Default action is a lost disposition with a reason: no contact, bought elsewhere, unresponsive, duplicate, invalid. Reps may submit a short exception list — names they have actually spoken with in the last two weeks that the CRM missed. If the CRM missed it, that is a note-standard problem, not a reason to keep 400 extra files.
Exceptions need a next-step date this week. No date, no exception.
Day 3: Deduplicate and fix identity
Stale lists are full of the same person three times: Marketplace, website, and a walk-in with a misspelled last name. Merge before you call. One person, one owner, one status. If two reps both have a live thread, a manager picks an owner using your dispute rule and logs it.
Also fix the obvious data:
- Dummy phones and emails — treat as missing.
- Source "Other" or blank — set it if you know it, else leave it and do not invent.
- Stock numbers for units long sold — update the vehicle of interest or note "original unit sold."
Day 4: One last attempt on 31–90 days
This is the only day that looks like "working leads." Use a single, honest message: you are checking whether they still want help on a vehicle, and they can say stop. Do not send a price-drop blast to the entire stale list as a cleanup tactic. If you later want a reactivation program, that is a different process — see reactivating old internet leads without spamming.
Log every attempt. If they reply, they leave the stale pile and get a real next step. If they do not, they move to Day 5 disposition.
Day 5: Dispose 8–30 days that have no owner or no contact path
The 8–30 day bucket is where the sprint can go wrong. Some of these are alive and poorly noted. Pull each owner's list. The owner has until end of day to add a next-step date or agree to disposition. Manager overrides silence. Unowned leads in this bucket are either assigned now or closed. They do not remain "house" for another quarter.
Weekend / Day 6–7: Lock the rules so the pile cannot rebuild
Write three standing rules and put them in the Monday meeting:
- Every new internet lead gets an owner, a source and a next-step date at create.
- A lead with no contact and no future date past your stale window auto-ages into a manager review, not into infinity.
- Mass outbound into 90+ day records is not allowed without a named campaign and an opt-out path.
If you already have lead recycling rules for unworked leads, connect them here: recycling is for unworked recent leads, not for resurrecting the museum you just closed.
What "Done" Looks Like at the End of the Week
Use a short scoreboard. Invent no percentages. Count files.
| Item | Monday | Friday |
|---|---|---|
| Open internet leads | (your number) | (your number) |
| Open with next-step date | ||
| Open with no owner | ||
| Open older than 90 days | ||
| Merges completed | — | |
| Dispositions completed | — |
Friday should show a smaller open count, almost no ownerless files, and almost no 90+ day "working" records. If the open count barely moved, you sorted and did not dispose. That is not a sprint. That is a tour of the museum.
What not to do in the name of cleanup
- Delete records you may need for a later sold-match or a customer who returns. Dispose (lost/inactive) instead of destroy, unless counsel says otherwise for a specific data type. This is not legal advice.
- Let reps "save" unlimited names with no date.
- Dump the stale list into a drip that ignores opt-outs.
- Clean only one rep's book as a punishment. The sprint is store-wide or it is politics.
After the CRM Cleanup Sprint: A 15-Minute Daily Habit
The pile grew because there was no daily owner of aging. After Friday:
- Each morning, a manager glances at leads that crossed the stale window overnight.
- Each owner gets a short list, not the whole database.
- New duplicates merge the day they appear, not in the next annual panic.
A quarterly audit, which is a different job, then inspects whether sources, statuses and sold matches still make sense. The sprint's job is to make the open list true.
How PostToMarket Automates This
Stale CRM records often match stale Marketplace listings: sold cars still advertised, units claimed by a rep who is not working them, inquiries sitting in one phone. A cleanup week in the CRM goes faster when inventory and posting ownership are already honest. PostToMarket does not purge your CRM. It stops the operational drift that refills it with ghosts.
Stop advertising units that are no longer the reason for the lead
- Mark as sold and archive from inventory or the queue so the vehicle a stale lead originally asked about is not still live if it has delivered.
- Inventory statuses (draft, posting, posted, sold, failed) so coverage and BDC can see what is actually on the lot while they work the remaining live names.
- Unlimited vehicles in inventory, so you are not keeping parallel spreadsheets that disagree with the CRM stock numbers you are trying to clean.
Make ownership visible before the sprint starts
- Per-rep queues and manager assignment for associates, so "unowned" is a rare state on the posting side.
- Team queue view to release claims that match the CRM names you are about to reassign or close.
- Roles with separate logins, so the sprint is not also a hunt for who was using the shared Facebook session.
Give managers a current inquiry list, not a folklore list
- Leads inbox so the live conversations you should not dispose are visible next to the CRM filter.
- Team analytics by rep and source to compare posting activity with the owners who still have giant books of untouched names.
Clean the CRM once with a clock on the wall. Use PostToMarket so sold units, queues and inquiries do not silently rebuild the fiction.
Finish the Week With a Smaller, True Book
A one-week CRM cleanup sprint for stale leads is a definition, five days of buckets, and a lock so 2,400 "open" never happens again. Dispose the museum. Merge the twins. Give living names a date. Then measure the open list like it is a floor board, not a trophy count.
If the same names keep returning because the cars they asked about are still listed after delivery, fix that hole the same week. PostToMarket keeps inventory status, queues and a manager leads inbox in one dashboard, with human-paced posting and bulk import when the next auction file lands.
You can run Starter at $59 per month with one login, or Dealership at $299 per month with up to 13 logins. Both include a 10-day free trial.
Start your 10-day free trial through secure Stripe checkout. Get sold units off the lot's public list while you clean the CRM, and cancel anytime if it is not the workflow you want.