SEO Keyword Clusters App – AI-Powered Tool for Keyword Strategy

As an independent project evolved from a university bootcamp, I developed the SEO Keyword Clusters App—a freemium web tool that turns keyword chaos into content strategy in minutes, not hours. This MVP transforms GSC data into actionable insights, surfacing Striking Distance wins (positions 4-15 with high impressions) and clustering by intent for any business, location, or industry—no spreadsheets or guesswork required.

Users upload CSV or connect Google Search Console via one-click OAuth (free tier included), where the app auto-detects local intent against a 325k+ location database (global cities + 300k+ AU spots) and validates via API. It employs HDBSCAN for density-based clustering, SentenceTransformers for semantic similarity, and GPT-4o (Pro tier) for briefs with H1/H2 outlines, FAQ sections, schema markup, ROI projections, and local SEO actions. Export as PDF, Markdown, JSON, or Google Sheets—bulk for Pro users (20 briefs at once). Built for modern SEO, it supports GEO with answer-first formats and entity recognition for AI engines like ChatGPT and Google AI Overviews.

This tool streamlines workflows for solo marketers and agencies, blending my data science background with practical SEO to prioritise quick wins—proven in freelance audits.