ga4_gsc_content_roi
Identify pages ranking well but underperforming in conversions, and high-converting pages with low rankings, to prioritize SEO or page fixes. Diagnoses each page using GA4 and GSC data.
Instructions
Find pages that rank well but don't convert (fix the page, not the SEO) and pages that convert brilliantly but have low rankings (invest in SEO, the payoff is proven). Diagnoses each page. Requires GA4 BigQuery export. IMPORTANT: GA4 and GSC data are joined on normalised landing page URL. Join rates vary by site (typically 70-90%). Numbers may not match GA4 or GSC dashboards exactly due to URL normalisation, timezone differences (GSC uses Pacific Time, GA4 uses property timezone), and sampling. Report the join rate when relevant. IMPORTANT: Base your analysis ONLY on the data returned. Report exact numbers from the results. Do not speculate about causes (e.g. algorithm updates, competitor actions) unless the data explicitly supports it. If the data does not contain enough information to answer a question, say so clearly rather than guessing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | Number of days to analyse | |
| max_rows | No | Maximum rows to return | |
| min_clicks | No | Minimum GSC clicks to include | |
| ga4_dataset | No | BigQuery dataset containing GA4 data | |
| gsc_dataset | No | BigQuery dataset containing GSC data |