Skip to content

Instantly share code, notes, and snippets.

@sterlingsky

sterlingsky/Queries missing from site after num=10000

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

  • Select an option

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

Select an option

Learn more about clone URLs
Save sterlingsky/846b3faa7be3019a4e8f30a4c6800794 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Queries missing from site after num=10000
WITH A AS (
SELECT
query,
SUM(clicks) as clicks,
SUM(impressions) as impressions
FROM `project`.`searchconsole`.`searchdata_site_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_site_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