A programmatic SEO engine that publishes long-tail outsourcing pages on autopilot.

Live at outsource.avilava.com. Discovers keywords, generates SERP-grounded pages with Claude, deploys to a static site, and tracks weekly visibility across Google and AI search (ChatGPT, Claude, Perplexity).

The problem

The agency wanted to rank for hundreds of "how to outsource X" long-tail keywords without paying a content team to write each page by hand. Existing tools either produced generic templated junk that Google ignores, or required hours of manual SERP research per page.

What I built

1. Keyword discovery

   A DataForSEO pipeline ranks long-tail keyword opportunities by volume, competition, and commercial intent into a scored CSV.

2. SERP-grounded page generation

   For each keyword, Claude pulls live SERP context and writes a conversion-focused guide page in the agency's voice. Pages read hand-written because each one is grounded in real data, not generic templates.

3. Static deploy

   Pages render to an Astro static site deployed to outsource.avilava.com via Netlify. No CMS, no database, no runtime overhead.

4. AI search visibility tracking

   A weekly job queries the same keywords against Google, ChatGPT, Claude, and Perplexity. Rank position and mention counts get written to a Google Sheet, so the team sees lift across both traditional and generative search.

What it ships

The AI-search tracking is the non-obvious win. Traditional rank trackers ignore ChatGPT and Claude entirely, even though more buying decisions start there every month.

Stack

Claude CodePythonDataForSEO APIAnthropic APIAstroNetlifyGoogle Sheets APIlaunchd cron