List of domains using a given technology

Analysis
1

Hello! I would like to know if there is a way we can check the CMS technology reported by a given domain on the Core Web Vitals technology report

Specifically, I am curious to see which are the 93 domains that are flagged as using a given CMS

image
image1005×105 6.92 KB

Is there any way to check that on BigQuery or someplace else?

2

You can get the URLs from BigQuery from the table httparchive.technologies.2024_05_01_.

WITH base AS (
  SELECT
    date,
    origin,
    CONCAT(origin, '/') AS page,
    CASE
      WHEN device = 'phone' THEN 'mobile'
      ELSE device
    END AS client,
    p75_fid,
    p75_inp,
    p75_lcp,
    p75_cls,
    p75_fcp,
    p75_ttfb
  FROM
    `chrome-ux-report.materialized.device_summary` TABLESAMPLE SYSTEM (1 PERCENT)
  WHERE
    device IN ('desktop', 'phone') AND
    date IN ('2024-04-01')
),

tech AS (
  SELECT
    _TABLE_SUFFIX AS client,
    app AS technology,
    url AS page
  FROM
    `httparchive.technologies.2024_05_01_*`
  WHERE
    app = "WordPress"
)

SELECT
  date,
  client,
  technology,
  page,
  p75_fid,
  p75_inp,
  p75_lcp,
  p75_cls,
  p75_fcp,
  p75_ttfb
FROM
  base
JOIN
  tech
USING
  (client, page)

Note that in the preceding query I am sampling the results using TABLESAMPLE SYSTEM (1 PERCENT).

This will output the following results:

+------------+---------+------------+--------------------------------------------------+---------+---------+---------+---------+---------+----------+
|    date    | client  | technology |                       page                       | p75_fid | p75_inp | p75_lcp | p75_cls | p75_fcp | p75_ttfb |
+------------+---------+------------+--------------------------------------------------+---------+---------+---------+---------+---------+----------+
| 2023-04-01 | mobile  | WordPress  | https://www.moveaheadmedia.co.th/                |      75 |     550 |    8700 |       0 |    8100 |     5600 |
| 2023-04-01 | mobile  | WordPress  | https://www.mieuxvivre-votreargent.fr/           |      50 |     475 |    1900 |       0 |    1700 |      700 |
| 2023-04-01 | mobile  | WordPress  | https://www.momoyama-usagi.com/                  |     100 |     650 |    6200 |    0.15 |    6000 |      500 |
| 2023-04-01 | mobile  | WordPress  | https://www.mymillennialguide.com/               |      50 |     375 |    3300 |    0.05 |    2100 |      700 |
| 2023-04-01 | mobile  | WordPress  | https://www.micropress.com.br/                   |     225 |     750 |    9800 |    0.05 |    7000 |     4000 |
3

Thank you very much, it works like a charm!