Weekly revenue by organic landing page
For e-commerce: rank your top organic landing pages by GA4 revenue this week, paired with their SC click counts.
The prompt
Copy this and paste it into Claude, Cursor, or any AI client connected to your GenieSeo MCP URL.
For my main Search Console property AND its matching GA4 property:
1. From GA4, run a report for the last 7 days with:
- dimension: pagePath
- metrics: totalRevenue, sessions, conversions
- filter to organic search (sessionDefaultChannelGroup = "Organic Search")
- sort by totalRevenue descending, limit 20
2. Run the same GA4 report for the prior 7 days. Compute revenue delta per page.
3. From Search Console, for each of the 20 pages, pull clicks, impressions, and average position over the last 7 days.
4. Output a Markdown table: page, GA4 revenue last 7d, revenue prior 7d, delta %, SC clicks, SC impressions, SC avg position. Sort by current-week revenue descending.
If my GA4 property doesn't have e-commerce events configured, return totalRevenue=0 across the board and note it in the caption — the table is still useful as an organic-traffic ranking.When to use it
Every Monday morning. Replaces 'how did SEO do this week?' with a real revenue number per page — the only metric the rest of the org actually cares about.
What you get back
- Top 20 organic landing pages by GA4 revenue (last 7 days).
- Paired with each page's SC clicks, impressions, and average position over the same period.
- Week-over-week revenue delta per page so movers are obvious.
How this runs
GenieSeo doesn't execute prompts — your AI client does. Make sure your MCP URL is connected to Claude, Cursor, Codex, or Antigravity. New here? Read the 60-second setup guide.
Automate it
Schedule this every Monday with a Claude Code Routine. Hands-off — the report lands in your inbox or Slack on schedule.
Tags
- ga4
- revenue
- weekly
- e-commerce
Frequently asked questions
How do I run the "Weekly revenue by organic landing page" prompt?+
Sign up for GenieSeo, connect Google OAuth, paste your MCP URL into Claude or Cursor, then copy the prompt from this page into a new chat. The model will call the relevant Search Console or GA4 tools automatically.
Does this recipe change my Google data?+
No. This recipe only uses read-only Search Console and GA4 scopes. It will not submit sitemaps or modify properties unless you use a separate write-enabled recipe.
What is a GenieSeo recipe?+
A recipe is a copy-paste prompt you run inside Claude, Cursor, or Codex after connecting your GenieSeo MCP URL. It tells the model which Search Console or GA4 tools to call and how to format the answer.
Do I need GenieSeo connected before using a recipe?+
Yes. Sign up at GenieSeo, approve Google OAuth, paste your personal MCP URL into your AI client, then paste the recipe prompt. Without MCP, the model cannot reach live Google data.