Build a Full Prospect Pipeline in One Weekend With Scan Data

At some point every growing agency hits the same wall. Manual research that felt manageable at ten prospects a week becomes impossible at fifty. At that pace, building a pipeline of two hundred qualified prospects would take weeks of research time, most of it spent gathering data you can’t even fully use in outreach.

F! Insights bulk scanning compresses that timeline. You upload a CSV of business names and locations, the plugin runs scored GBP audits in the background, and the results populate your pipeline dashboard automatically. This guide covers how to build a full prospect pipeline in a focused weekend sprint – from a blank list on Saturday morning to a tiered, scored, outreach-ready pipeline on Sunday night.

What You Need Before You Start

• F! Insights installed on your WordPress site with both API keys configured. See F! Insights Setup: Connect Google and Anthropic API in 15 Minutes if you have not done this yet. Setup takes about 15 minutes for the API connections.
• A target vertical and a target city or metro area. The more specific the better: “HVAC contractors in Austin” will produce more useful scan comparisons than “home services in Texas” because competitor data is pulled from the same market.
• A Google account for Maps research. Incognito mode is useful to see results without personalization.
• A spreadsheet tool (Google Sheets or Excel) for building and cleaning the CSV before upload.
• Three to four hours on Saturday for list building, and two to three hours on Sunday for review and segmentation.

You do not need to have any existing client relationships or agency case studies to run this sprint. The scan data gives you a legitimate reason to reach out to every business on the list regardless of your prior relationship with that vertical.

Day One: Build the Target List

Open Google Maps and search your target category in your target city. The goal is to build a raw list of 150–200 business names and addresses before you apply any filtering. More than 200 can create bulk scan timeouts without a server with enough resources; fewer than 100 gives you a thin Tier 1 list after scoring.

To learn more about building a local SEO prospect pipeline, visit Build a Prospect Hit List From Local Scan Data. Turn Website Traffic Into Local SEO Leads Automatically Each Day and Win Local SEO Clients With Data-Backed Prospecting cover adjacent steps in detail.

As you scroll through Google Maps results, add each business to your spreadsheet. Work systematically through the map: zoom out, scroll to a new section of the city, and repeat. Google Maps typically shows 20 results per search area before you need to zoom or move. For a city like Austin, you can cover most of the metro in 2–3 hours this way.

While building the list, note any surface-level signals that suggest a high-gap prospect:

• Under 30 reviews visible in the map listing
• No website linked from the GBP
• Profile photo that looks like a stock image or is missing entirely
• Business hours listed as “open now” with no specific hours
• Categories that are very broad (“Local Business” as primary)

You don’t need to do deep research on each business at this stage – the scan will do that. These surface signals help you mentally note businesses to look at first when results come in. For guidance on which verticals tend to have the most consistent GBP gaps, see Best Niches for Local SEO: Where the Scan Data Points. HVAC contractors, plumbers, roofers, electricians, and dental practices consistently show the largest gaps in most markets.

Format Your CSV

F! Insights bulk scanning accepts a CSV with at minimum two columns: business name and city (or full address for disambiguation). A full address (street, city, state) produces more accurate results because it removes ambiguity for businesses with common names or multiple locations.

Recommended columns:

• Column A: Business name (exactly as it appears in Google Maps)
• Column B: Full street address
• Column C: City
• Column D: State
• Column E: (Optional) Notes from your surface-level pass

Clean the list before upload: remove duplicate entries, check for businesses you already work with (remove them), and verify that multi-location businesses are listed per location if you want per-location scan data. A business with 5 locations that you list once will only scan the primary location.

Save the sheet as a CSV. Name the file with your niche and date (hvac-austin-2026-06.csv) so you can reference it when reviewing results.

Running the Bulk Scan

1. In your WordPress admin, go to F! Insights → Market Leads → Bulk Scan.
2. Upload your CSV file.
3. Set the scan radius for competitor detection. Two to five miles works for most urban and suburban markets. For rural markets or businesses with large service areas, 10–15 miles may be more appropriate.
4. Start the scan. F! Insights processes the list in the background via WP-Cron. You do not need to stay on the page or keep your browser open.

A list of 150–200 businesses typically completes in 4–8 hours depending on your server speed and API response times. F! Insights includes automatic recovery for stuck items. If a scan stalls on a particular business, it logs the error and continues to the next entry. You’ll see completion status in the Bulk Scan dashboard.

Start the scan early Saturday afternoon so results are ready by Saturday evening or Sunday morning. While the scan runs, you can start drafting your outreach templates so they’re ready to personalize when the data comes in.

Each completed scan produces an 8-category score for the business (0–100) across: Competitive Position, Customer Reviews, Website Performance, Business Information, Local SEO Signals, Photos and Media, Q&A Activity, and Service Coverage. It also generates an AI pitch draft specific to that business’s gaps and named competitors.

Day Two: Review and Prioritize

When the bulk scan completes, you have a scored list of every business you uploaded. The raw data is useful; the sorted, tiered version is what you actually outreach from.

Start in the pipeline dashboard with overall score ascending. Businesses with the lowest composite scores have the most documented gaps and are your highest-priority prospects. Scan the top 40–50 entries and look for patterns:

• Which categories are failing most consistently? If 70% of your top-gap businesses are failing on Customer Reviews and Competitive Position, your outreach lead is the review gap.
• Which businesses have the most severe single-category failures? A business with a Website Performance score of 12 is a web performance conversation. A Competitive Position score of 8 means the Map Pack leader is winning by a documented margin you can quote.
• Are there any businesses you already have a connection to – through a client referral, a mutual contact, or a prior conversation? Flag those for your Tier 1 immediate outreach.

Export the scored list from F! Insights as a CSV. Open it in your spreadsheet tool and add a tier column.

Building Your Tier System

Segment your prospect list into three tiers based on composite score and gap severity:

Your Tier 1 list from a 150-business scan is typically 25-40 businesses, a manageable immediate outreach queue. This is the right size for one person to contact and follow up with without letting anything slip.

Tier 2 becomes your second wave outreach starting week two. Tier 3 goes into a nurture sequence: a scheduled email or LinkedIn touch every 6–8 weeks. Their scores may change as local competition evolves, and re-scanning Tier 3 businesses every 90 days with a fresh bulk scan is a useful way to identify businesses that have declined into Tier 1 territory.

For a more detailed scoring and prioritization framework, see Build a Prospect Hit List From Local Scan Data Results.

Making the List Outreach-Ready

F! Insights includes an AI pitch generator in the Leads tab. For each lead, it uses the specific gaps from their scan to draft a personalized outreach message referencing the named competitor, the review gap, and the lowest-scoring category. The draft is a starting point, not a final send, but it gives you the specific data points so you don’t have to look them up before writing each email.

For each Tier 1 business, open the AI pitch draft and customize:

• Verify the named competitor in the draft is real and current (it’s pulled from the live scan, but occasionally a competitor shifts before you send).
• Adjust the tone to match the vertical. An HVAC contractor responds to different language than a dental practice.
• Add one specific local detail if you have it – a recent review mentioning a specific problem, a visible website issue you noticed while building the list. One specific detail is usually enough to make the message feel personally researched.

For the complete cold email methodology – subject lines, message structure, follow-up cadence – see Cold Email Local Businesses: The Data-First Approach.

Building the Outreach Sequence

A Tier 1 outreach sequence for a single prospect has at least three touches:

• Touch 1 (Day 1): Email with one specific data point from the scan. Short – under 100 words. No pitch. The goal is a response, not a close. “Your mobile site scored 19 on Google’s PageSpeed tool. The top-ranked HVAC company in Austin scored 81. I have a full comparison. Worth a look?”
• Touch 2 (Day 5–7): Follow-up that adds one more data point, different category. Review gap or Competitive Position. Still no full pitch. Still short.
• Touch 3 (Day 12–14): Offer to send the full scan report. “I put together the full audit for [Business Name] – it covers 8 categories with a score breakdown and the specific gaps between you and the Map Pack leader. Happy to send it if useful.”

If no response after three touches, move the prospect to Tier 2 timing and try again in three weeks with a different entry point. Some Tier 1 prospects don’t respond to cold email but do respond to LinkedIn or a direct call. The scan data works as a conversation opener across channels.

For the objection handling playbook once you’re in a conversation, see Build an Objection Cheat Sheet From GBP Scan Patterns.

What Comes Next

A prioritized, scored list of 150–200 prospects with personalized outreach drafts is a fundamentally different starting point than a spreadsheet of names. The pipeline you’ve built this weekend has documented problems, named competitors, and specific gaps your service solves, and you haven’t written a single cold email from scratch yet.

The sprint produces three immediate outputs: a Tier 1 immediate outreach queue (25–40 businesses), a Tier 2 scheduled queue (45–60 businesses), and a Tier 3 nurture list (the rest). Work Tier 1 this week, Tier 2 over the next two weeks, and set a calendar reminder to re-scan Tier 3 in 90 days.

For the proposal workflow when a prospect responds and asks what you’d do for them, see Local SEO Proposal Template: Data-Backed and Ready to Send.

Ready to run your first bulk scan? See F! Insights pricing here.

Frequently Asked Questions

How long does a 200-business bulk scan take?

A 200-business bulk scan typically completes in 4–8 hours via WP-Cron on standard shared or VPS hosting. The time varies based on API response speeds from Google Places and Anthropic, and your server’s WP-Cron configuration. On a properly configured VPS with standard resource limits, 200 businesses usually scan overnight. Do not restart a scan that appears slow: it processes items in sequence and restarts from the beginning if interrupted.

What if some businesses fail to scan?

F! Insights logs scan failures and continues to the next entry rather than halting the batch. Failures typically occur when a business name is too common and Google Places can’t disambiguate it without a more specific address, or when a business doesn’t have a verified GBP. After the batch completes, the Bulk Scan dashboard shows which entries failed and why. For failed entries, try re-running with a full street address instead of just a city.

Can I build a pipeline in a vertical I’ve never worked in before?

Yes. The scan data gives you documented, specific gaps regardless of your prior knowledge of the vertical. You don’t need to know HVAC to tell an HVAC contractor that their mobile PageSpeed score is 23 and the Map Pack leader’s is 78. The data is the authority. What you do need is the ability to deliver the service once a prospect converts, which is a separate consideration from whether the pipeline approach works.

How many Tier 1 prospects should I contact per week?

15–25 new outreach contacts per week is manageable for one person handling both business development and client delivery. At that cadence, you’ll work through a 30-business Tier 1 list in 2 weeks, with enough time to follow up properly on each. More contacts per week is possible if you have a dedicated BD person, but follow-up quality matters more than volume. A personalized 3-touch sequence to 20 prospects outperforms a mass-blast to 100.