ga4_gsc_query_revenue
Attribute revenue and conversions to search queries by joining GA4 and GSC data with proportional click-share attribution, revealing which keywords actually drive sales.
Instructions
Which search queries actually drive revenue and conversions? Uses proportional attribution: if a page gets clicks from 3 queries, revenue is split by click share. The 'revenue per keyword' metric SEOs have wanted for years. 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 clicks per query | |
| ga4_dataset | No | BigQuery dataset containing GA4 data | |
| gsc_dataset | No | BigQuery dataset containing GSC data |