Google Analytics 4 tells me which pages convert. Search Console tells me which organic queries drive clicks. Neither tells me which keywords drive revenue. Because in 2013, Google killed keyword level revenue tracking. Universal Analytics died, and took the one report SEOs actually relied on with it. GA4 replaced it with "(not provided)" and a shrug. Google's own blending tool won't let you add conversion metrics. Looker Studio is a workaround. Supermetrics is a subscription. And every SEO I know is still answering "how much is this keyword worth?" with spreadsheets, gut feelings, and increasingly creative lies in client reports. So I built 6 tools that join GSC and GA4 inside BigQuery, through Claude. → Revenue per keyword, actually attributed, not vibes. → Content ROI diagnosis, which articles convert vs just rank. → Position value modelling, what's it worth to go from #5 to #2. → Page performance with search and conversion in one table. → Snippet mismatch detection, CTR anomalies that signal title or meta problems. → Query revenue attribution, proportional to clicks. Upfront caveat: This is proportional click attribution, not ground truth. Google doesn't expose ground truth keyword revenue, and no tool can fabricate it. Same methodology used by paid tools, just automated. Directionally right, good enough for real decisions, miles better than spreadsheets. Free and open source. Runs through Claude via two MCP servers wired together. Set it up in about 20 minutes. Link in the comments 👇… more