You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
WITH ha AS (
SELECT
page
FROM`httparchive.all.pages`WHEREdate='2023-10-01'AND
rank =1000AND
is_root_page
),
crux AS (
SELECT
DISTINCT CONCAT(origin, '/') AS page
FROM`chrome-ux-report.materialized.metrics_summary`WHEREdate='2023-09-01'AND
rank =1000
)
SELECT
page
FROM
crux
LEFT OUTER JOIN
ha
USING
(page)
WHEREha.page IS NULLORDER BY
page
This has been pretty consistent:
Row
date
top_1k
1
2023-01-01
918
2
2023-02-01
922
3
2023-03-01
910
4
2023-04-01
924
5
2023-05-01
916
6
2023-06-01
913
7
2023-07-01
908
8
2023-08-01
917
9
2023-09-01
910
10
2023-10-01
908
And here are the top 1k home pages that have consistently been missing all year (202301–202309):
For some reason HA has no data for ~90 of the top 1k sites in CrUX:
This has been pretty consistent:
And here are the top 1k home pages that have consistently been missing all year (202301–202309):
Are the tests erroring out? Are they blocking us?
The text was updated successfully, but these errors were encountered: