Map your top organic queries to GA4 conversions
Cross-reference Search Console queries with GA4 conversion events to find which keywords are actually driving revenue.
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, map organic queries to conversions:
1. From Search Console, get the top 20 organic landing pages by clicks over the last 28 days. For each page, also retrieve its top 3 queries (with clicks, impressions, average position per query).
2. Use list_ga4_properties to identify the matching GA4 property. If multiple exist, list them and ask me to confirm before continuing.
3. For each of the 20 landing pages, run a GA4 report over the same 28-day window with:
- dimension: pagePath
- metrics: sessions, conversions (key_event count or purchase event), totalRevenue
- filter to organic search (sessionDefaultChannelGroup = "Organic Search")
If revenue events are not configured, include totalRevenue = 0 and note it.
4. Join the SC and GA4 data on page path. Output a Markdown table sorted by GA4 conversion value descending with columns: landing page, top query, SC clicks, SC avg position, GA4 sessions, GA4 conversions, conversion rate %, GA4 revenue.
Flag any row where SC clicks > 100 AND GA4 conversion rate < 1% with the label "conversion opportunity" — these pages rank and receive traffic but fail to convert, making them the highest-leverage rewrite candidates.When to use it
Quarterly business review, or whenever you need to prove SEO ROI. This is the single most valuable report you can run — it connects search intent to business outcomes.
What you get back
- Table mapping organic landing pages to both SC metrics (clicks, average position) and GA4 conversion metrics (conversions, conversion rate, revenue if e-commerce), ranked by conversion value.
- Pages flagged as 'conversion opportunity' where SC clicks are high but GA4 conversion rate is low.
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
Automate this as a weekly report. Hands-off — the report lands in your inbox or Slack on schedule.
Tags
- conversions
- revenue
- roi
- ga4
- cross-reference
Frequently asked questions
How do I run the "Map your top organic queries to GA4 conversions" 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.