Use Claude to find SEO opportunities from your own data

A founder loaded weekly traffic and search exports into Claude to uncover gaps, then turned those findings into content and site updates.

Done with Claude· Intermediate

What they did
Each week, the founder sent Claude fresh exports from Google Search Console, Ahrefs, and Google Analytics so it could compare what people searched for with what the site already ranked for. Claude flagged issues such as missed query clusters, searches that produced views but few visits, pages competing with each other, indexing holes, and titles that were underperforming. The founder then used those insights to plan new articles and page changes, including question-led headings, concise openers, comparison tables, on-site cross links, FAQ/schema additions, and technical edits made through Lovable prompts and verified with curl plus GSC checks.
How it went
They say they published 96 articles and raised weekly clicks from 5 to over 1,000, alongside 300K monthly impressions, 878+ rankings on page one, 348 AI-referred sessions each month, and 10,000 active users in six weeks, with no ad spend. Some commenters disputed the traffic numbers using third-party SEO tools, while the founder pointed back to first-party GSC and GA4 data.
Tips
Claude was useful only after being fed actual exports and competitor data. Have it rank the best opportunities first, then pause before publishing, editing, or shipping any technical change.

Try it yourself with Claude

I run [product name] for [target audience]. I’ve attached exports from my search and analytics tools for the last [time period], plus any competitor data I have. Please review everything and identify the best SEO opportunities: queries where I already show up but get little traffic, pages that may overlap with each other, terms I’m missing, indexing issues, and titles that deserve improvement. Return a ranked list of [number] actions with the target page or keyword, the reason it matters, and a suggested title or update for each. Stop after the plan and ask for my approval before you create content, edit pages, submit changes, or do anything irreversible.

Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.

Get 3 agent uses like this every morning

With the day's top AI news. Free, and one click to unsubscribe.