Organic landing pages ranked by business value, Search Console plus GA4

Management wants to know which organic pages actually bring business, not just traffic. 1) List the GA4 key events for [GA4 property] and confirm which ones count as business conversions: [key event names]. Tell me if the property has other key events too, because GA4 reports key events as one combined total. 2) For the last 90 days, pull Search Console clicks, impressions and average position per page for [property URL], with a limit high enough to cover all pages with clicks. 3) For the same 90 days, pull GA4 sessions and key events by landing page split by channel, and keep only the Organic Search rows. - If the business events are the only key events in the property, use that key event count directly. - If there are other key events, also pull landing page by event name and use it to estimate the share of each page's key events that are business events. Say clearly that this split covers all channels, so the organic figure is an estimate. 4) Join the two sources by URL path: strip the hostname, query strings and fragments, lowercase, and treat a trailing slash as the same page. List the pages that appear in only one source. Build a table with these columns: - page - organic clicks - average position - organic sessions - key events (business only) - conversion rate (key events divided by organic sessions) Leave pages with fewer than 30 organic sessions out of the median calculation, since their conversion rate is noise, and list them separately. Then sort the pages into four groups. If I have not given a [click threshold], use the median organic clicks of the included pages and tell me the number. - Push SEO: conversion rate above the site median but fewer clicks than the threshold. - Fix conversion: clicks above the threshold but conversion rate below half of the median. - Protect: clicks above the threshold and conversion rate above the median. - Deprioritize: everything else. Add a short note under the table on data limits: Search Console clicks and GA4 sessions are counted differently, consent banners hide part of GA4 traffic, and GA4 attributes key events to the landing page of the session. Close with the 3 pages where one improvement (better rankings for Push SEO pages, a better offer or form for Fix conversion pages) would add the most conversions, with a rough estimate of the gain and how you calculated it.