Home Services Brand
Programmatic SEO Site — 400 City Pages
A data-driven site that generates optimized landing pages for every service in every city — with automated content, schema markup, and lead tracking built in.
The Problem
A home services brand wanted to rank in 80+ cities across 5 service categories. Building 400 pages by hand wasn't realistic. They'd tried it before with a content agency — took 4 months, cost $40k, and half the pages were thin filler that never ranked.
What We Built
We built a programmatic site using Astro and a structured data model in Airtable. Services, cities, pricing data, and local details feed into templates that generate fully optimized pages — each with unique content, proper schema markup, internal linking, and conversion-focused CTAs.
A content pipeline in n8n handles ongoing updates: new cities get added to the data model, the build runs, and pages go live automatically. Every page has call tracking and form attribution so we know exactly which cities and services generate revenue.
The Results
- 400 pages live in 3 weeks (vs. 4 months previously)
- 62% of pages ranking in top 10 within 90 days
- Attributable leads tracked by city, service, and page
- New city pages added in minutes, not weeks