SEO Consultants: How to Find Local Businesses With Stale Websites in Your City in 20 Minutes

Most SEO consultant prospect lists are built the wrong way around.

You scrape a city, you scrape a category, you get 500 names. You spend the rest of Monday looking at each site one at a time, deciding whether it's "worth contacting." By Wednesday you've covered 80 of them, you've talked yourself out of 60, and the 20 you're left with don't feel materially different from any other 20 you've ever pulled.

The whole process is backwards. You spent the most expensive hour of your week — early Monday morning — doing manual triage that public-web data could have done in 90 seconds.

Here is the 20-minute version.

What you actually need from the list

Be honest about what you're filtering for. As a solo SEO consultant, you are not selling "SEO." You are selling one of three things:

1. A rebuild. Their site is so neglected that the cheapest win is to start over. You quote a one-time project plus a small monthly retainer.
2. A content engine. Their site is fine structurally but has had no new content in two years. You quote a content-led retainer.
3. A technical cleanup. Their site ranks somewhere but has compounding technical debt — broken schema, slow load, redirect chains. You quote a focused audit and a quarterly maintenance retainer.

All three require the same prospect profile: a business whose site has been left alone for long enough that the owner has emotional distance from it. Owners who refreshed their site six months ago will defend it. Owners who haven't touched it in three years know it's a problem before you bring it up.

That's your filter. Everything else is noise.

The 20-minute pull

You need a prospecting tool that scores each business on site freshness — months since the site has meaningfully changed. (Don't confuse "looks dated" with "actually stale." A site can look 2014 and have been updated last month, and that owner doesn't think they have a problem.)

A serviceable pull looks like this:

1. Pick one city and one vertical you already understand. Don't fan out. Solo consultants win by being the obvious choice for one business type in one city, not by being generic.
2. Pull the full local pack. In most mid-size US cities this is 100 to 150 businesses for a healthy service vertical like plumbing, dental, or roofing.
3. Sort by site freshness, descending. Cut everything where the site has been touched in the last 6 months.
4. From the remaining list, sort by review count. You want businesses with real customer demand whose digital presence has gone quiet. A 4-review business with a stale site is probably not a viable customer. A 90-review business with a stale site is a phone call.
5. Take the top 25.

That is one week of outreach.

The whole pull takes 20 minutes. The 4 to 5 hours you save versus the manual triage workflow is the entire point.

Why site freshness beats every other technical signal as a prospecting filter

You can sort a list by PageSpeed score. You'll get something. But a site with a 38 PageSpeed score that was rebuilt last quarter is in a different bucket than the same score on a site that hasn't been touched since 2021. The first owner is paying attention and made a tradeoff. The second owner has stopped paying attention.

You can sort by missing SSL. You'll find something — usually broken sites the owner long forgot about, with a phone number that doesn't work anymore.

You can sort by missing schema markup. You'll find a lot of fine, healthy small businesses whose webmaster never bothered. Not a fit.

Site freshness is the cleanest proxy because it captures the one thing every other signal hints at: owner attention. No attention means no maintenance budget. No maintenance budget means an SEO retainer has an opening.

You can read the full scoring methodology for why this weight is what it is, but for prospecting purposes you only need the heuristic: sort by freshness, cut anything under 18 months stale, keep the rest.

---

See how site-freshness scoring runs against a real city: LocalVein pricing →

---

The first-touch email (do not skip this)

You do not pick up the phone first. You send a 4-sentence email first. Then, if they don't reply in 5 business days, you call once.

The reason is empathy: the owner of a stale-site business is short on time, not short on awareness. They know the site is bad. They've been avoiding it. Calling them on Monday at 10am to tell them their site is bad makes you the seventh person this year to do that. Emailing them with one specific observation and no ask makes you the first.

A reusable template (write your own — this is the shape):

Hi [name],

I was looking at [business name] and noticed the site hasn't been substantially updated since around [year]. I'm an SEO consultant working with [vertical] in [city] and I usually see a few months of compounded ranking decline once a site sits that long.

Not a sales note — happy to point out the two specific things I'd fix first if you reply.

[your name]

This works because every sentence is honest. You did look at the site. The site has been sitting. You do work with that vertical. You are not asking for a meeting. You are offering one piece of information in exchange for one reply.

Reply rate on a freshness-filtered list, sent in that shape, is 4–8× the reply rate on a generic SEO pitch sent to a maps-pulled cold list. Not 20% better. Several times. The list quality does most of the work.

Triage the replies, not the list

The replies sort themselves. Three buckets:

1. "What would you fix?" — They've engaged. Reply with two specific, useful observations. No pitch. The follow-up to that response is the sales conversation, and it happens 5 to 10 days into the thread, not the first reply.
2. "Not interested, thanks." — Move on. Do not retry. Note the date and put them on a 9-month reminder.
3. No reply. — One call, 7 days later. If voicemail, leave one 20-second voicemail referencing the email. Then move on.

The mistake is to treat all three buckets the same. The "what would you fix?" replies are your entire month. Spend the time on those.

Scaling this past one city

The hard part of solo SEO consulting is not finding prospects. It's not having more time. So scale carefully:

• Add a second vertical in the same city before you add a second city. Geographic context is worth more than category breadth.
• Cap weekly outreach at 25 prospects until reply rate stabilizes. Above 40, personalization drops and reply rate drops with it.
• Rotate cities quarterly, not weekly. You want to be remembered as the SEO person in that city — not the email that arrived once and never came back.

A solo consultant running this loop in two cities and two verticals — total 4 lists, 25 prospects per week each, rotated — is generating 100 personalized first touches per week with under 4 hours of prospecting work. That is the entire model. The only thing that breaks it is going wider than you can personalize.

Bottom line

The SEO consultant prospect list isn't a list of "everyone in the city." It's a list of "everyone who has stopped paying attention to their site long enough to be ready to talk." Those are two completely different lists. The first one wastes your Mondays. The second one fills your month.

20 minutes of filtering on Monday morning is the difference.

---

Run your first city scan: See LocalVein plans →