origins_eligible_to_bfcache_by_tech.sql

SELECT
  date,
  client,
  technologies.technology,
  category,
  COUNT(DISTINCT IF(lighthouse.audits['bf-cache'].details.items IS NULL, page, NULL)) as bfcache_eligible_origins,
  COUNT(DISTINCT PAGE) as origins,
  ROUND(SAFE_DIVIDE(
    COUNT(DISTINCT IF(lighthouse.audits['bf-cache'].details.items IS NULL, page, NULL)),
    COUNT(DISTINCT PAGE)
  ),4) as bfcache_eligible_origins_perc
FROM `httparchive.latest.pages`, 
    UNNEST(technologies) as technologies,
    UNNEST(technologies.categories) as category
WHERE
  is_root_page = TRUE AND
  category IN (
    "CMS",
    "CDN",
    "Ecommerce",
    "Page builders",
    "JavaScript frameworks",
    "Analytics",
    "Web servers",
    "Tag managers",
    "Live chat",
    "Cookie compliance",
    "Advertising",
    "Hosting"
  )
GROUP BY 1, 2, 3, 4
ORDER BY origins DESC