ga4_gsc_position_value
Analyze GA4 and GSC data to reveal the revenue and conversion value of each Google search ranking position, with conversion rate and revenue per click by position bucket.
Instructions
What is each ranking position worth in revenue and conversions for YOUR site? Shows conversion rate and revenue per click by position bucket (1, 2-3, 4-5, 6-10, 11-20, 20+). Uses 90 days by default for statistical significance. 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 (longer = more reliable) | |
| max_rows | No | Maximum rows to return | |
| ga4_dataset | No | BigQuery dataset containing GA4 data | |
| gsc_dataset | No | BigQuery dataset containing GSC data |