Solo founder used Claude weekly on Search Console data to get 30K clicks in 3 months
A non-technical solo founder running a marketplace that connects developers selling skills to freelancers and small businesses shares a weekly SEO workflow built entirely around Claude, with no coding involved. Over three months, the site gained 30,500 and 4.4 million impressions with zero ad spend, its Domain Rating rose from 0 to 50, and 330 articles were published. The routine: every Monday, export two CSVs from — Queries and Pages — and feed them to Claude with one prompt asking it to find queries getting impressions but no clicks, pages where position improved but dropped, between pages, and queries already ranking that have no dedicated content yet.
Claude returns 10 to 15 specific, immediately actionable fixes each week rather than vague suggestions. In week three, for instance, Claude flagged that five separate articles were all competing for the same query, "how to install skills in Claude Code."
Key points
- Every Monday, export Queries and Pages CSVs from and feed them to Claude
- The prompt asks for: high-impression/no-click queries, rising-position/falling-CTR pages, , and ranking queries with no dedicated content
- The entire system is just this weekly prompt, returning 10-15 concrete actions each time
- Over three months: 30,500 clicks, 4.4M impressions, Domain Rating 0→50, 330 articles, $0 ad spend
- Claude caught duplicate content competing for the same query (e.g. five articles on installing ) that the founder had missed