I built a SEO automation, here's the dumb little setup I made
So I run a small SaaS business that relies on SEO for most of our traffic. Been around about two years, bootstrapped, SEO ended up being the main acquisition channel because I'm not great at paid ads and outbound just isn't my thing. Mostly comparison pages and how-to content.
My setup was, I had Claude connected to my GSC (google search), and every week I'd pull the data on the best searched terms we're ranking for. I'd dump it into a spreadsheet, look at what moved, what stalled. Then I'd look at the pages already sitting on position 5 to 10, those are the ones that already have signal, and I'd get some link to them to push them up to position 1. Spending maybe a few hundred a month on this.
And it worked, the rankings actually moved, you could see pages going from 8 to 3, 6 to 2, the data was clean. I was feeling pretty good about it for a while.
However I wasn't seeing much of the monetary impact of any of this. I was trying to get revenue per page out of GA4 but I couldn't get a number I trusted, between sampling, the way the attribution works across sessions, and Stripe data not flowing in, the per-page revenue number GA4 was giving me was basically useless for what I needed. So I started looking for other analytics. My buddy mentioned a few, I tried them, and the revenue per page was right there. I just needed the one with API or MCP so I can wire Claude into it directly.
Basically now my flow looks like this. I connect Claude to GSC so I know what pages are getting traffic and what positions they're at. Then I connect Claude to the Flowsery MCP so I know what pages are actually getting revenue. And then I close the gap between the two. And it turns out some of the pages I'd been putting outreach budget into were not even bringing in any revenue! Even though they were commercial keywords, they were just not converting, people were researching and bouncing. Like one of my biggest spend pages was bringing in less per month than what I was paying to push it up. Meanwhile some pages even on position 10 were just printing, and I'd been doing nothing for them.
So I have a scheduled job now that runs every week. It checks GSC, updates an excel with what positions changed, runs the flowsery MCP, fills in the revenue, and sends me a report of what changed and which pages are worth more attention based on which ones ACTUALLY make money.
curious if anyone here is doing per-page revenue tracking and what your setup looks like, I have a feeling there are smarter ways to do this, than wiring MCP to a spreadsheet.