Skip to content

Instantly share code, notes, and snippets.

@sterlingsky

sterlingsky/Queries missing from URLs after num 100

Last active October 18, 2025 20:53
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save sterlingsky/638eb560ddc5078edb5b73fb1723c5c1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Queries missing from URLs after num 100
WITH A AS (
SELECT
query,
SUM(clicks) as clicks,
SUM(impressions) as impressions
FROM `project`.`searchconsole`.`searchdata_url_impression`
WHERE data_date BETWEEN '2025-09-03' AND '2025-09-09' -- Week 1
GROUP BY query
),
B AS (
SELECT
query,
SUM(clicks) as clicks,
SUM(impressions) as impressions
FROM `project`.`searchconsole`.`searchdata_url_impression`
WHERE data_date BETWEEN '2025-09-10' AND '2025-09-16' -- Week 2
GROUP BY query
)
-- Queries in A but not in B
SELECT A.*
FROM A
LEFT JOIN B ON A.query = B.query
WHERE B.query IS NULL
ORDER BY A.impressions DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment