Cross-referencestarter~15 seconds

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.

prompt

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.

Setup guide →