Skip to content

Instantly share code, notes, and snippets.

@sterlingsky

sterlingsky/Pages with Anonymized Queries

Last active October 18, 2025 19:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sterlingsky/27bf00ac217cab56e1543de37dd6e45b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sterlingsky/27bf00ac217cab56e1543de37dd6e45b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Pages with Anonymized Queries
SELECT
url,is_anonymized_query,
SUM(clicks) as clicks,
SUM(impressions) as impressions,
SAFE_DIVIDE(SUM(sum_position), SUM(impressions)) as avg_position
FROM `project`.`searchconsole`.`searchdata_url_impression` --update project to your GSC project ID
WHERE data_date BETWEEN '2024-09-03' AND '2025-09-09' and is_anonymized_query=true -- pick a date range you want to check
GROUP BY url, is_anonymized_query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment