From 0 to 40,000 organic visits with a programmatic SEO build

A local-services marketplace needed to rank for “[service] in [city]” across hundreds of cities but had no content team and no budget for thousands of manual pages.

The problem

• Thousands of city × service combinations, all showing an empty or generic page.
• A competitor already dominated the long tail.
• Hiring writers to cover it manually was financially impossible.

What we did

We built a programmatic SEO system:

1. Data layer structured the marketplace’s real supply data (which providers served which city) into a single source of truth.
2. Template a fast Astro template with breadcrumbs, JSON-LD LocalBusiness schema, and clean internal linking.
3. AI generation an agent drafted unique, data-grounded copy for each page (real provider counts, real pricing ranges, city-specific context).
4. Ship generated the full site, validated schema, and deployed to the CDN with a clean sitemap.

The result

Nearly 5,000 pages went live in a single deploy. Six months later the pages were driving 40,000 organic visits a month with 92% indexed and growing. The client now regenerates pages automatically as supply data changes, so the site stays fresh with zero manual effort.

This is the power of engineering-led SEO: one template, one dataset, and compounding traffic for years.