Disclosure: I build Lead Atlas, the tool used in this walkthrough.
A list of businesses is only a starting point. For an SEO agency, the useful result is a shortlist where every business matches the market you serve and every outreach idea points to something you actually checked.
Start with one niche and one location
For example, search for roofing contractor in Leeds, United Kingdom, and request 25 results. Save the query and the date so you can repeat the exercise. If you already have a client or prospect list, add those websites to your exclusions before running the search.
Turn the export into a review queue
Export the results to CSV. Keep the original website URL in column A. In Google Sheets, use this formula in B2 and fill it down to group URLs from the same host:
=IFERROR(REGEXEXTRACT(REGEXREPLACE(LOWER(TRIM(A2)),"^(https?://)?(www\.)?",""),"^[^/?#]+"),"")
For example, https://www.example.com/services/ and http://example.com/contact both become example.com. Review rows that share a host before removing duplicates because separate branches can use the same website. Keep rows with blank website fields in a separate review queue.
| Column | What to record |
|---|---|
| Fit | Is this business in your target market and area? |
| Evidence | Which page did you check, and what did you observe? |
| Next step | What specific improvement could you discuss with this business? |
Open the official website and check the service and location pages. For instance, if the site says it serves Leeds but offers no information about emergency roof repairs, record the URL and what you found. Treat that as a question for the business. The missing page alone tells you nothing about demand or rankings.
Review first, enrich second
Hide irrelevant results and enrich the leads you decide to keep. Public business emails and social links may be available. Check that a contact belongs to the business before using it, and leave missing details blank.
Keep the CSV with your review notes. For the next run, add the domains you’ve already reviewed to your exclusions so you can spend your time on new businesses.
You can try this workflow in Lead Atlas.
Top comments (0)