<?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: Rumy M Reyal</title>
    <description>The latest articles on DEV Community by Rumy M Reyal (@rumy_mreyal_b13c66112272).</description>
    <link>https://dev.to/rumy_mreyal_b13c66112272</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.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3893406%2F2b11687d-0bac-49c7-86f3-dd3d205a44d3.jpg</url>
      <title>DEV Community: Rumy M Reyal</title>
      <link>https://dev.to/rumy_mreyal_b13c66112272</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/rumy_mreyal_b13c66112272"/>
    <language>en</language>
    <item>
      <title>Building a local SEO system for a service business: 40 pages in 90 days</title>
      <dc:creator>Rumy M Reyal</dc:creator>
      <pubDate>Thu, 23 Apr 2026 04:10:41 +0000</pubDate>
      <link>https://dev.to/rumy_mreyal_b13c66112272/building-a-local-seo-system-for-a-service-business-40-pages-in-90-days-2fgf</link>
      <guid>https://dev.to/rumy_mreyal_b13c66112272/building-a-local-seo-system-for-a-service-business-40-pages-in-90-days-2fgf</guid>
      <description>&lt;p&gt;TL;DR: I run a cleaning company in the GTA. In 90 days I built 38 niche landing pages using Supabase + a Lovable-built admin form + a pSEO content generator. Here's what worked and what didn't.&lt;/p&gt;

&lt;h2&gt;
  
  
  The problem
&lt;/h2&gt;

&lt;p&gt;Local service businesses compete on Google Maps (Google Business Profile) and on organic search. The GBP side is well-documented. The organic side is where most service businesses lose — they publish a Services page and a Locations page and expect to rank.&lt;/p&gt;

&lt;p&gt;They don't. A single generic "cleaning services Toronto" page is trying to compete with franchise sites, aggregators (Thumbtack, Jiffy, TaskRabbit), and every other cleaning company in the city.&lt;/p&gt;

&lt;p&gt;What works: a page per service × per location. Long-tail keywords with lower search volume but dramatically higher intent.&lt;/p&gt;

&lt;h2&gt;
  
  
  The system
&lt;/h2&gt;

&lt;p&gt;Stack:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Supabase&lt;/strong&gt; (Postgres) for content storage&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Lovable&lt;/strong&gt; (for the admin form that writes to Supabase)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Next.js / React&lt;/strong&gt; (generated by Lovable) for the front-end&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A content generator script&lt;/strong&gt; that reads a table of niche + location combos and outputs seed content for each&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Content generator in rough pseudocode:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="k"&gt;for &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="nx"&gt;niche&lt;/span&gt; &lt;span class="k"&gt;of&lt;/span&gt; &lt;span class="nx"&gt;niches&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="k"&gt;for &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="nx"&gt;location&lt;/span&gt; &lt;span class="k"&gt;of&lt;/span&gt; &lt;span class="nx"&gt;locations&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="nx"&gt;page&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
      &lt;span class="na"&gt;slug&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;`&lt;/span&gt;&lt;span class="p"&gt;${&lt;/span&gt;&lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;slug&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="s2"&gt;-&lt;/span&gt;&lt;span class="p"&gt;${&lt;/span&gt;&lt;span class="nx"&gt;location&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;slug&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="s2"&gt;`&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="na"&gt;h1&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;`&lt;/span&gt;&lt;span class="p"&gt;${&lt;/span&gt;&lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;name&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="s2"&gt; in &lt;/span&gt;&lt;span class="p"&gt;${&lt;/span&gt;&lt;span class="nx"&gt;location&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;name&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="s2"&gt;`&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="na"&gt;subheadline&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nf"&gt;buildSubheadline&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;location&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
      &lt;span class="na"&gt;benefits&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;benefits&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="na"&gt;painPoints&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;painPoints&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="na"&gt;faqs&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nf"&gt;generateFAQs&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;location&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
      &lt;span class="na"&gt;metaTitle&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nf"&gt;buildMetaTitle&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;location&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
      &lt;span class="na"&gt;metaDesc&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nf"&gt;buildMetaDesc&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;niche&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;location&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
      &lt;span class="na"&gt;status&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;draft&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;
    &lt;span class="p"&gt;};&lt;/span&gt;
    &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="nx"&gt;supabase&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="k"&gt;from&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;niche_landing_pages&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;insert&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;page&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  The gotchas
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;1. Sitemap discovery.&lt;/strong&gt; The pages rendered fine and had internal links, but the sitemap.xml generator on Lovable didn't include the &lt;code&gt;/landing/*&lt;/code&gt; route. Google had no way to discover the 38 pages. Added them to the sitemap, submitted via GSC.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;2. Schema markup.&lt;/strong&gt; Each page needs LocalBusiness + Service schema. Initial build only had the homepage schema. Rolling this out per-landing page.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;3. Content generation is the bottleneck, not publishing.&lt;/strong&gt; The system can publish 100 pages in a day. Writing 100 unique, useful pages takes 3 months. Budget accordingly.&lt;/p&gt;

&lt;h2&gt;
  
  
  What ranks
&lt;/h2&gt;

&lt;p&gt;Too early to conclusively say (most pages are 2-4 weeks old). But:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://procleaningpros.ca/landing/airbnb-cleaning-toronto" rel="noopener noreferrer"&gt;Airbnb cleaning Toronto&lt;/a&gt; is showing impressions within the first 10 days&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://procleaningpros.ca/landing/post-construction-cleaning-toronto" rel="noopener noreferrer"&gt;Post-construction cleaning Toronto&lt;/a&gt; pulling some traffic already&lt;/li&gt;
&lt;li&gt;Deep niche pages (dental, law firm) ranking fast because competition is thin&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Next: link acceleration
&lt;/h2&gt;

&lt;p&gt;On-page is necessary but not sufficient. New pages with zero external links take 8-16 weeks to rank page 1. Pages with 2-3 DR 80+ backlinks rank in 2-4 weeks. Running a 30-day link acceleration plan now (you're reading one of the pieces of it).&lt;/p&gt;

&lt;p&gt;If you're building a local service business, full process documented at &lt;a href="https://procleaningpros.ca" rel="noopener noreferrer"&gt;procleaningpros.ca&lt;/a&gt;. Happy to answer any questions in the comments.&lt;/p&gt;

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