Convex Logo
Hamburger icon
Sell Smarter
Crm

How to Clean Up CRM Data: Separate Dead Leads From Accounts Worth Calling

Most of the stale records in a commercial services CRM aren't dead leads. The building is still there and still needs the service. Something changed since the last touch, and you can check what.

Read Time

15 minutes

Author

Convex

Published

November 17, 2026

TL;DR

  • In commercial services, stale CRM records usually go quiet for one of four reasons: the contact moved, the building changed hands, the timing was wrong, or the account was never a fit to begin with.

  • Only the last reason makes a record a dead lead. The other three are dormant accounts you can check against property data and work again.

  • To clean up CRM data, sort by building fit first. Archive the buildings that were never a fit, and check everything else.

  • Duplicate accounts in commercial services often come from one building worked through the tenant, the owner and the management company, so link each company to the building instead of merging them.

  • Closed-lost accounts are worth revisiting once time has passed and something has changed, such as a contract coming up, a new owner or someone at the building searching for your service.

  • CRM data hygiene holds when reps log the timing on every "not now" and the whole book gets reviewed on a regular cadence.


Every account in your CRM represents work your team has already done: finding the building, qualifying it and making the first calls. But in a lot of teams, the CRM is the tool reps trust least. 

Contacts bounce, numbers ring the wrong person, and reports come back full of accounts nobody has touched in a year.

Most advice on how to clean up CRM data treats that as a hygiene job. Archive what’s unresponsive, dedupe by email or domain, and purge anything that stays quiet for six to twelve months. It’s good advice, and for companies that sell to other companies, it works.

In commercial services, though, the account is a building. When a contact stops answering, the building still needs its HVAC serviced, its main areas cleaned, and its roof inspected. Purge that record and you throw away work your team already paid for.

Clean the CRM with the building in mind, and your team can get three things back: a shorter list of accounts worth calling this month, closed-lost accounts with a reason and a date to come back, and reports reps trust enough to open.


  • 76% of organizations say less than half of their CRM data is accurate and complete (Validity, 2025).

  • 13.5% of unsuccessful B2B cold calls reached the wrong person or the wrong number, which points to a data problem rather than a selling one (Belkins, 2026).

  • Median tenure with a current employer was 4.1 years in January 2026 (U.S. Bureau of Labor Statistics, 2026).

  • 176,445 U.S. commercial properties changed hands in 2025, the first annual increase in deal count since 2021 (Altus Group, 2026).

  • 78% of commercial contractors use a CRM, but only 41% are satisfied with it (ServiceTitan, 2025).


Why Does CRM Data Go Stale in Commercial Services?

CRM records in commercial services go stale for four reasons: the person moved, the building changed hands, the timing was wrong, or the account was never a fit. Each leaves a different mark on the record, so each one needs a different check.

Ben Walters, Sales Leader at Convex, warned about this at Ignite 2026. Dump every lead into the CRM on day one, he said, and the data decays until it becomes a liability instead of an asset. 

Reps pull a report, run into duplicate contacts and information they can't trust, and start resisting the CRM altogether. That's the hidden cost of bad data, and it's part of why some field sales teams move away from traditional CRMs.

Data decay hits sales reps selling into commercial buildings especially hard because a single record ties together a building, a company and the people in it, and any of the three can change.

Changes usually look like this:

The person moved. The U.S. Bureau of Labor Statistics put median tenure with a current employer at 4.1 years in January 2026. Facility managers and property managers change roles and companies like everyone else, and when they go, their email bounces and their direct line rings somewhere new. The record looks dead even though the building still needs the work.

The building changed hands. Altus Group counted 176,445 U.S. commercial property sales in 2025, the first year-over-year rise since 2021. When a building sells, new decision-makers often review the vendor contracts they inherited, so the person who signs may not be anyone your CRM has met.

The timing was wrong. The rep called while the building was locked into an agreement, and how long that lasts depends on the trade. An elevator maintenance agreement often renews automatically unless the building sends notice 60 to 120 days before the end date (Elevator Blueprint, 2026), while a seasonal snow removal contract may cover a single winter, from November through March (Davey, 2022). The contact said "not now," and nobody wrote down when "now" would be.

It was never a fit. Somebody uploaded a list or added the record before anyone checked whether the building matched the kind of buildings you win.

These changes impact your sales team in many ways, but the most common is when they send outreach or try to reach a contact. 

In a cold calling study by Belkins, 13.5% of the calls that didn’t succeed reached the wrong person or the wrong number. That's time spent on calls that never had a chance, before the rep “gets a word out.”

That’s why the first step is sorting out which records are worth fixing and which were never worth keeping.


  • CRM data decay: the gradual drift of CRM records out of date as contacts change jobs, buildings change owners and phone numbers change hands.

  • Dead lead: a record with no realistic path to a deal, because the building was never a fit or no longer needs the service.

  • Dormant account: a good-fit building where the contact, the owner or the timing changed after the last touch.


How Do You Tell a Dead Lead From a Dormant Account?

A dead lead is an account you wouldn’t want even if the right person picked up a cold call tomorrow, because it’s the wrong type of building or size or it no longer needs the service. 

A dormant account is a building you’d still want, where something changed since the last touch: the contact, the owner or the timing.

Your ideal customer profile (ICP) is the key to sorting these accounts. 

Ben has spent his whole career in sales, 10 to 15 years by his count. He co-founded a landscaping company in Colorado, where he ran sales and marketing, then joined Convex as roughly its 20th employee six years ago, and now leads one of its sales teams. 

He defines a well-built ICP by three things: the verticals and contract types you win, signals that point to buying interest, such as an ownership change, and how decisions get made at the property, from a single owner-occupant to a property management group.

If you’ve already built a property-based ICP, each record either describes a building you want to win, or it doesn’t.

Haynes Mechanical Systems, a 230-person HVAC and building automation contractor in Colorado, shows what a clear fit rule looks like. The team avoids what it calls the “3 Rs”: restaurants, retail and residential. That alone is an easy profile to build on, but Haynes also sets a size floor, targeting only buildings of 50,000 square feet and up, so every account on the list is big enough for its services.

A rule that specific makes the first cut quick, because most dead leads fail it on building type or size alone. The accounts that were never a fit drop out, and your team is left with a shorter list it can work with a higher-touch approach.

Richard Lopez, Commercial Sales Manager at Beyer Plumbing in San Antonio, saw what a shorter list does. He cut his outreach from about 100 businesses to 10 or 20 at a time, and that’s when responses started coming in.

Then look at what’s left with timing in mind. 

At Ignite, Ben gave the example of a contact who said their landscape contract renews in March. That timing, plus good contact information, is what made the lead worth keeping and maybe even placing in a nurture campaign with a follow-up attached.

Why it went quiet

What to check

Lead status

What to do

Never an ICP building

Property type, size, how decisions get made

Dead

Archive

Contact left or changed roles

Current contacts at the property

Dormant

Update the record and reintroduce yourself

Building sold or management changed

Ownership and transaction history

Dormant

Treat it as a new account

Bad timing or under contract

Logged renewal date, budget season

Nurture

Re-time the next touch

Lost to a competitor

Closed-lost reason, permits filed since

Closed-lost

Move it to the win-back list

How Do You Stop Duplicate Accounts in Your CRM?

Give each building its own record, link the companies tied to it, and search for the building before anyone adds a new account.

Most CRMs are built for selling to companies, so they catch the same company entered twice. They don’t catch one building being worked through three different companies: the tenant, the owner and the management company. 

Each has its own name and often its own address, and a management company may run dozens of other buildings. If you don’t start with the property itself, three reps can end up working the same building without knowing it.

Linking each company to the buildings it’s connected to fixes that. A rep who opens one building sees everyone tied to it, and a rep who opens the management company sees every building it runs.

If your CRM syncs with a property-based tool like Convex, accounts are matched to properties by their billing or shipping address. That lines up tenants and owner-occupants with their buildings, though a management company billed from its own office may require an additional link.

How Do You Check What Changed at the Building?

Run four checks on each good-fit record: who the current contacts are, whether the building changed hands, what permits were filed since your last touch, and whether anyone there is searching for your service now.

At first glance this seems a bit complex, but it’s simple once your team has the right tools in place.

Enrichment tools refresh titles and phone numbers, but they won’t tell you a property sold last spring or that a new management company took over. Doing that by hand means a county records search, a LinkedIn search and a permit portal for every address, which is why it rarely gets done. 

The ownership and permit data is public, but it’s scattered and hard to reconcile without manual effort.

If your CRM is connected to a property intelligence tool like Convex, your accounts are already matched to the buildings they sit at. A manager can pull the oldest good-fit accounts from a CRM report and check each building in Convex. One shows a sale last spring. Another lists a property manager the CRM has never heard of. Neither change arrives as an alert, so the review is what surfaces them.

The contact check can also turn up people the CRM doesn’t have yet. 

Terri Reddan, Director of Operations at Stratus Building Solutions’ Pittsburgh franchise, found a new contact on an existing customer’s property who was only two weeks into the role. “It was shocking to me that the system had that name there,” she said.

When the decision-maker on file has left, and there’s no new contact in the system, reps will need to put their research hat on.

Taj Shaw, Manager of Customer Success at Convex, coaches customers to start by looking for the person who runs the building: “The facilities manager is the person that would usually run and operate this, and they are the go-to person. The owner is most likely just the contract signer.”

If you can find the facilities manager and link them to the account, you’ll have someone who knows the building day to day and can help you get in front of whoever signs.

Permits can help you answer a bigger question: what’s happened at the building since you last called. A permit shows what work was done, when it was done and which contractor did it. If a competitor pulled a permit there last year, you know who you’re up against and roughly where their work stands.

And finally, signals add timing. Buying intent signals show when someone at the property has been searching for a service like yours, which can tell you a building that went quiet is looking again.

These four filters will help you turn records into accounts that your team can pursue.

How Do You Win Back Closed-Lost Accounts?

Closed-lost accounts are worth revisiting, but only after some time has passed and something shows the building may be open to a change. 

A "no" from last month still means no. The same building a year or two later, with a contract coming up, a new owner or someone searching for your service, is a very different conversation.

The time matters because the buyer just made a decision, and most likely won't reopen it without a reason. Dan Mandelbrot, Group VP of Convex Sales at ServiceTitan, holds every deal to the same test:

"If you don't have a problem, you're not going to spend money." - Dan Mandelbrot, Group VP, Convex Sales, ServiceTitan

So the question for a closed-lost account is whether anything has changed since you lost it. A few signs are worth watching for:

  • A contract approaching renewal. IFMA warns facility managers that evergreen contracts often roll over year after year without a market test, and it advises a contract calendar so each renewal becomes a deliberate choice to renew, renegotiate or re-tender. One multifamily expert quoted by Multi-Housing News tells operators to talk to vendors a year before their contracts expire, so the window opens well before the end date. These renewal warnings give your team a reason to at least make contact and offer a proposal.

  • An ownership or management change. New decision-makers often review the vendor contracts they inherit - and can lead to opportunities especially within the first 90 days post transition.

  • A new permit at the building. It shows what work happened there and who did it, which gives the rep something specific to ask about.

  • Someone at the building searching for your service. Signals won't tell you the buyer is ready, but they show someone at the property is looking for a solution like yours.

Climate Engineering, a Colorado HVAC company that was recently acquired by Harris, used Convex to highlight its current and lost customers and build a list of targets for a quick check-in. Because Convex syncs with Salesforce, the details on every account stayed one click away. Across his campaigns, maintenance sales rep Branden Jovaag tracked more than 1,250 qualified prospects, booked more than 140 first appointments and generated more than 10 proposals.

Current information is often what restarts a stalled deal, as Branden found:

“On another deal I’d had outdated information and was stuck at a dead end. Convex gave me the information needed for the conversation to take off.” - Branden Jovaag, then Maintenance Sales Rep, Climate Engineering

You can also set the follow-up date before the deal is ever lost. 

One attendee at Ignite 2026 sends a short form before the first meeting asking whether the buyer has projects planned over the next one to five years. If the deal doesn’t close, that answer tells the rep when a second conversation might make sense.

How Often Should You Clean Up CRM Data?

Many teams clean up CRM data once a quarter, with a lighter monthly review if they’re noticing a large number of outdated accounts. Contact data goes out of date on its own as people change jobs and buildings change hands, so a once-a-year cleanup isn’t enough.

The reason is simple. Say a quarter of your contacts change roles in a year, and ten percent of the buildings in your territory change hands, by the end of the year, close to 30% of what’s in your CRM could be out of date.

That quarterly pass is a common recommendation in CRM data hygiene guides. It doesn’t have to be a full rebuild, but merging duplicates, refreshing job titles and contact information, and enriching active accounts give your team a far better dataset to work from.

A quarterly pass fixes the records. A monthly review shows which ones nobody is working. Dan runs that review with his team every month. It covers how the entire book has been engaged, how many leads came in, whether each rep has enough pipeline and their win rates. 

Run it alongside your pipeline management numbers, and accounts nobody has touched in a quarter show up before they go truly cold.

Keeping the CRM from filling back up starts with what goes into it in the first place. Ben’s answer is to keep a guardrail on it, so that when someone pulls a report, the data is something reps can trust.

Ben’s example from Ignite shows how clean data drives a sales team’s next move. Once a rep learns a prospect’s landscape contract renews in March, the lead is worth keeping, and it comes with a follow-up date for re-engagement.

It goes into the CRM with an automated reminder set a couple of months before the window opens. “So few people actually follow through on what they say they’re going to do,” Ben said, and a system of record is what makes the follow-through possible.

Ben is just as specific about data entry. Don’t make reps log calls and emails by hand. Nobody enjoys it, and the records come out less accurate. Tools that log activity automatically keep the CRM closer to what actually happened.

A CRM Cleanup Checklist for This Week

The easiest place to start is small; 10 to 20 of the oldest records in your best-fit building type, depending on the size of your CRM.

Run the four checks on each one, contacts, ownership, permits and current searches, and by the end of the week you’ll have a first read on how many are dead leads and how many are dormant accounts worth a call.

If the CRM holds thousands of accounts and data decay is already getting in the way of prospecting, a sample won’t be enough. That’s the point where it’s worth bringing in a Salesforce administrator, or whoever manages the CRM, to filter and clean the accounts before the team starts working them.

From there, a few questions are worth taking into your next pipeline review:

  • How many of your CRM accounts are buildings that match your ICP?

  • How many changed hands since your team last touched them?

  • How many closed-lost accounts are past the contract term they were lost to?

  • Who on your team owns the dormant list, and when do they review it?

Some of the pipeline you’re looking for may already be sitting in your CRM. Stratus found a new contact two weeks into the role on an existing customer’s property, and Climate Engineering built check-in lists from its current and lost customers.

If you want to see how that works, schedule a demo of Convex and we’ll walk you through it.

FAQs

How do you clean up CRM data? 

Start by sorting records by fit. Archive the accounts that were never a fit, then check the rest for what changed: the contact, the owner, recent permits and current search activity. Merge duplicates to the building, and log the timing on every "not now" so the next round of cleanup is smaller.

How often should you clean CRM data? 

Many sales ops teams run a quarterly pass to merge duplicates, refresh contact data and enrich active accounts. Sales managers also catch dormant accounts in a monthly business review of how the whole book has been engaged.

What is CRM data decay? 

CRM data decay is the gradual drift of records out of date as people change jobs, companies change hands and phone numbers get reassigned. In commercial services, building sales add a second layer, because a new owner can bring a new decision-maker.

What is the difference between a dead lead and a dormant lead? 

A dead lead has no realistic path to a deal, usually because the building was never a fit. A dormant lead is a good-fit building where the contact, owner or timing changed, so it belongs in a nurture status, not the archive.

How do you stop duplicate accounts in your CRM? 

Email and domain matching often miss commercial services duplicates, because the tenant, owner and management company each use a different domain. Merge to the building address, then attach each contact to that one record.

Should cold outbound prospects be kept in the CRM? 

Keep a guardrail on what goes in. A prospect earns a CRM record when the building fits and you have good contact information and some sense of timing, such as a renewal month.

How much does bad CRM data cost a business?

It shows up as wasted calls, unreliable forecasts and reps who stop trusting the CRM. In one 2026 benchmark, 13.5% of unsuccessful B2B cold calls reached the wrong person or the wrong number.

How do you re-engage old leads and closed-lost deals?

Check what changed at the building first, then reach out with that change as your reason to call. For closed-lost accounts, give it time, and wait for a reason to reach out, such as an upcoming contract renewal, an ownership change or someone at the building searching for your service.


Share

Subscribe to Convex news & insights

By entering your information above and clicking the submit button, you agree to our Terms of Use, Privacy Policy, and that we may contact you, by SMS, at the phone number and email address you provide in this form in accordance with our Terms of Use.

Resources

The latest articles from Convex

Get Started

Find the solution that's right for you

Convex is here to help you achieve your goals. Tell us what you’re looking for and we'll match you with a solution that meets your needs.