Quick Answer
To find dead accounts in HubSpot without a data analyst: filter Companies by Last Activity Date older than 365 days and export the results, bulk-check domain health for your top accounts by ACV, run HubSpot's built-in duplicate tool as a first pass, and cross-reference high-value accounts on LinkedIn and Google News. Manual checks work for 20–30 accounts; automation is required for larger territories.
Your HubSpot CRM is only as good as the data inside it. And if you have accounts that have gone dark — companies that have shut down, been acquired, or simply haven't had a touchpoint in 18 months — those records are quietly distorting your pipeline, your territory, and your forecast.
The good news: you don't need a RevOps analyst to find them. Here's how to do it manually, and where that approach breaks down at scale.
What Makes an Account 'Dead' in HubSpot?
Before you start filtering, it's worth defining what you're actually looking for. A dead account in HubSpot is typically one of the following:
- No email, call, or meeting activity logged in the last 12–18 months
- The company domain is unreachable or returns a 404
- The company was acquired and now operates under a different name
- The company shut down entirely — bankrupted, dissolved, or absorbed
- Duplicate records created during data imports that have never been merged
Each of these has a different fix. The first step is separating them.
Step 1: Filter by Last Activity Date
In HubSpot, go to Contacts > Companies and open your filter panel. Add a filter for Last Activity Date and set it to more than 365 days ago. This surfaces accounts your team has had no engagement with in over a year.
Export this list. You now have your baseline stale account set.
Pro tip: Filter for accounts with an associated deal still in an open stage. These are the most dangerous — they're inflating your pipeline and nobody is working them.
Step 2: Check for Domain-Level Signals
For each account in your export, check whether the company's domain is still active. You can do this manually by visiting the website, or by running a bulk domain check using tools like MXToolbox or a simple HTTP ping script.
A dead domain is a strong signal the company is gone. A domain that redirects to a competitor is a strong signal of an acquisition.
Step 3: Look for Duplicate Account Records
HubSpot has a built-in duplicate management tool under Contacts > Actions > Manage Duplicates, but it only catches exact or near-exact name matches. It misses cases where one record uses 'Acme Corp' and another uses 'Acme Corporation Inc.'
For a more thorough pass, export your company list and sort alphabetically. Scan for similar names manually, or run a fuzzy match script if you have technical resources available.
Step 4: Cross-Reference Against News and LinkedIn
For your highest-priority accounts — the ones in active deals or with significant ACV — it's worth doing a quick manual check. Search the company name on LinkedIn to see if their page is still active and employees are still listed there. A page with no recent posts and employees who've all updated their profiles to new companies is a reliable dead-account signal.
Also run a quick Google News search for the company name. Funding announcements, acquisitions, and shutdowns all surface quickly this way.
Where the Manual Process Breaks Down
This workflow works for 20 or 30 accounts. It does not work for a territory of 200 accounts, a team of 10 AEs, or a CRM with 5,000 company records.
At scale, the problems are:
- Manual domain checks take 2–3 minutes per account
- News searches miss acquisitions that weren't widely covered
- HubSpot's duplicate tool has a low recall rate on variant names
- There's no signal about whether a 'live' company is actually worth pursuing right now
This is exactly the problem DeadAccount.ai was built to solve. You upload your accounts, and the system checks domain health, M&A activity, funding signals, duplicate candidates, and HQ changes — automatically, across your entire territory.
Summary: Your HubSpot Dead Account Checklist
- Export accounts with Last Activity Date > 365 days
- Filter for any with open deals still attached
- Check domain health for top 20 by ACV
- Run LinkedIn + News search on high-value accounts
- Use HubSpot's duplicate tool as a first pass
- For full territory coverage, use automated account intelligence