<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Grant Hobbs</title>
    <description>The latest articles on DEV Community by Grant Hobbs (@grant_hobbs_bf5787df9fc12).</description>
    <link>https://dev.to/grant_hobbs_bf5787df9fc12</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4237295%2F935e99b0-cdfa-4fb9-b9c8-87463671035b.png</url>
      <title>DEV Community: Grant Hobbs</title>
      <link>https://dev.to/grant_hobbs_bf5787df9fc12</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/grant_hobbs_bf5787df9fc12"/>
    <language>en</language>
    <item>
      <title>How to turn a local business CSV into an SEO review queue</title>
      <dc:creator>Grant Hobbs</dc:creator>
      <pubDate>Tue, 10 Nov 2026 14:31:56 +0000</pubDate>
      <link>https://dev.to/grant_hobbs_bf5787df9fc12/how-to-turn-a-local-business-csv-into-an-seo-review-queue-3hl3</link>
      <guid>https://dev.to/grant_hobbs_bf5787df9fc12/how-to-turn-a-local-business-csv-into-an-seo-review-queue-3hl3</guid>
      <description>&lt;p&gt;&lt;em&gt;Disclosure: I build Lead Atlas, the tool used in this walkthrough.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;h2&gt;
  
  
  Start with one niche and one location
&lt;/h2&gt;

&lt;p&gt;For example, search for &lt;strong&gt;roofing contractor&lt;/strong&gt; in &lt;strong&gt;Leeds, United Kingdom&lt;/strong&gt;, and request &lt;strong&gt;25 results&lt;/strong&gt;. 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.&lt;/p&gt;

&lt;h2&gt;
  
  
  Turn the export into a review queue
&lt;/h2&gt;

&lt;p&gt;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:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;=IFERROR(REGEXEXTRACT(REGEXREPLACE(LOWER(TRIM(A2)),"^(https?://)?(www\.)?",""),"^[^/?#]+"),"")
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;For example, &lt;code&gt;https://www.example.com/services/&lt;/code&gt; and &lt;code&gt;http://example.com/contact&lt;/code&gt; both become &lt;code&gt;example.com&lt;/code&gt;. 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.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Column&lt;/th&gt;
&lt;th&gt;What to record&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Fit&lt;/td&gt;
&lt;td&gt;Is this business in your target market and area?&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Evidence&lt;/td&gt;
&lt;td&gt;Which page did you check, and what did you observe?&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Next step&lt;/td&gt;
&lt;td&gt;What specific improvement could you discuss with this business?&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;h2&gt;
  
  
  Review first, enrich second
&lt;/h2&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;p&gt;You can try this workflow in &lt;a href="https://tasksmith.online/contact/" rel="noopener noreferrer"&gt;Lead Atlas&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>marketing</category>
      <category>productivity</category>
      <category>seo</category>
    </item>
  </channel>
</rss>
