Local SEO Leads: Find and Qualify Agency Prospects

Download the local SEO prospecting template

Download the blank prospecting CSV or download the fictional worked example. Both are plain CSV files with the same 20 columns. The template is free to adapt for your own agency workflow; it does not contain purchased leads or pre-verified business contacts.

1. In Google Sheets, open a blank sheet and choose File > Import > Upload. In Excel, use Data > From Text/CSV. Select comma as the delimiter if asked.
2. Keep the fictional example separate from your live prospects. Add one business per location and preserve the source and date for every observation.
3. Score market fit from 0 to 2, verified issue from 0 to 3, customer impact from 0 to 2, delivery fit from 0 to 2 and eligible contact route from 0 to 1. Enter their sum, from 0 to 10, in fit_score_total.
4. Use consistent status values: researching, ready_for_review, contacted, interested, not_now or suppressed. Filter suppressed records out of every outreach export.

The files contain no macros, scripts or automatic verification. They do not calculate scores for you. Blank evidence and contact eligibility fields mean unreviewed, not approved. You can add a spreadsheet sum formula after import, but keep the five component scores visible so a colleague can understand the total.

What each group of template columns is for

In the worked example, an explicitly fictional auto repair business has a booking link issue. Its .example URLs are reserved examples, not real evidence. Replace the entire record before using the sheet operationally. The contact eligibility is deliberately marked unreviewed and the next action is to check it, so a high research score never automatically authorizes sending.

Choose a market you can evaluate and serve

Start with one category in one realistic service area, such as independent auto repair shops in a district you know. Check that your offer fits the business model: appointment businesses need booking enquiries, while emergency services may care most about qualified calls. Separate chains from independently managed locations because the purchasing decision can sit elsewhere.

Define your service before collecting contacts. A profile information cleanup, a service-page project and an ongoing local SEO retainer are different purchases. Write down the deliverables, who must approve access, what you can measure and the work you cannot include at your proposed price. This prevents pitching a retainer to a shop that only needs an incorrect opening time fixed.

• Include: active businesses in your chosen market with a working website or public business contact route.
• Review manually: multi-location brands, businesses that have recently moved and categories with special profile eligibility rules.
• Exclude: permanently closed listings, businesses outside your service area and anyone who has opted out of contact.

Build a prospect list with traceable sources

Use Google Maps for discovery, then check the business website and a relevant local or trade directory. Search a few natural service phrases rather than assuming one phrase finds every business. Deduplicate locations using the website, address and business identity; shared phone numbers alone can incorrectly merge branches.

LeadOutreach can help discover business records and website contact details. Check the current features and pricing before choosing a workflow. A discovered email is neither proof of buying intent nor permission to send marketing. Review applicable rules and source terms, and keep a suppression list for opt-outs.

Populate the source, evidence and date columns first. Add scoring and outreach status only after checking the record; the downloadable template keeps those stages separate.

Keep evidence dated. An hours mismatch can disappear tomorrow, and a website may have been replaced since your last visit. Store the exact page URL and a short factual note. Avoid recording private personal details when a public business contact route is sufficient.

Audit observable problems without inventing ranking claims

Google describes local visibility using relevance, distance and prominence. Those factors mean a low position from your own location cannot prove poor optimization. Compare the same query and location, note the date and device context, and explain that the result is a snapshot. Do not promise a top-three placement.

Treat review counts as context, not a lead score by themselves. A business with fewer reviews may be new, specialized or fully booked. Never sell fake reviews or a guarantee that a particular review count will create a particular ranking. For a fuller inspection workflow, use the Google Business Profile audit checklist.

Qualify local SEO leads with a simple scoring worksheet

Use this illustrative ten-point rubric to decide where to spend research time. It is an internal prioritization model, not a prediction of close rates. Budget, authority and interest remain unknown until a conversation confirms them.

For example, a fictional independent repair shop might score 2 for market fit, 3 for a confirmed broken booking link, 2 for customer impact, 2 for delivery fit and 1 for an appropriate contact route: 10/10 for research priority. It is still not a qualified sales opportunity until the owner confirms the issue matters and wants to discuss it. A shop with only fewer reviews might score much lower.

Work the highest-evidence records first and park uncertain ones for review. Do not label estimated budgets or inferred owner names as confirmed facts. The lead qualification guide explains how to separate fit from buying readiness.

Send a specific outreach message and offer a small next step

Describe what you observed without diagnosing lost revenue you cannot measure. Offer the evidence or a short walkthrough before asking for a large commitment. Adapt this fictional example only after checking the issue yourself:

Subject: Booking link on [shop name]'s mobile site

Hi [name],
I checked the [service] page on [date]. On my phone, the Book button opened an error page; I reproduced it in a second browser.
I help independent repair shops improve their local enquiry path. Would it be useful if I sent the exact page and the two steps that failed?

[Real name and business details]
If this is not relevant, let me know and I will stop contacting you.

Add the sender identity, address and opt-out information required for your situation; this sample is copy guidance, not a complete compliance template. Stop on opt-out. If someone responds, ask who manages the website, whether the problem is already scheduled for repair and what a useful outcome would look like. Do not request profile access before agreeing scope and authorization.

Measure opportunities rather than list size

Track researched records, eligible contacts, positive replies, discovery calls, proposals and customers separately. In a hypothetical batch of 40 researched businesses, 25 eligible contacts and 3 positive replies give a 12% positive reply rate among contacted businesses. That is an arithmetic example, not a benchmark or forecast.

Record why opportunities are lost: already has an agency, no capacity, issue already fixed, wrong contact or offer too broad. Use those reasons to improve the next batch. After winning work, agree the baseline and measurement method before implementation: qualified enquiries and bookings matter more than isolated screenshots of a ranking movement.