gilbertococchi

/*
 * Utility helper to detect a navigationType across all the different standards methods.
 *  Possible values:
 *    - "navigate": Navigation started by clicking a link, document was not cached
 *    - "navigational-prefetch": The resource was retrieved from a prefetched response stored in an in-memory cache via the Speculation Rules API
 *    - "prerender": Navigation to a Prerendered document via Speculation Rules API: https://developer.mozilla.org/en-US/docs/Web/API/Document/prerendering
 *    - "cache": Navitation to a resource that was retrieved from the cache
 *    - "reload": Navigation is through the browser's reload operation
 *    - "restore": Page was previously discarded by the browser while in a hidden tab
 *    - "back_forward": Navigation is through the browser's history traversal operation, back/forward Cache handled differently

gilbertococchi

const RATING_COLORS = {
   "good": "#0CCE6A",
   "needs-improvement": "#FFA400",
   "poor": "#FF4E42",
   "invalid": "#FFC0CB",
   "default": "inherit",
 };

 const LCP_THRESHOLDS = {
   good: 2500,

gilbertococchi

SELECT 
  FORMAT_DATE('%m-%Y', DATE) as month_year,
  DEVICETYPE,
  USERAGENTFAMILY,
  
  #BEACONTYPE, # 'page view', 'bfcache'
  #NAVIGATIONTYPE, # navigate, reload, back forward, null, 

  ROUND(SAFE_DIVIDE(
    COUNTIF(BEACONTYPE="bfcache"),

gilbertococchi

WITH web_vitals_events AS (
  SELECT 
    event_name as metric_name, * EXCEPT(event_name, is_last_received_value) FROM (
    SELECT *, IF (ROW_NUMBER() OVER (
      PARTITION BY (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'metric_id')
      ORDER BY (SELECT COALESCE(value.double_value, value.int_value) FROM UNNEST(event_params) WHERE key = 'metric_value') DESC
    ) = 1, true, false) AS is_last_received_value
    FROM `ilaria-food-and-home.analytics_317802288.events_20240519`
    WHERE event_name in ('INP')
  ) WHERE is_last_received_value

gilbertococchi

(function() {
    if (PerformanceObserver.supportedEntryTypes.includes('long-animation-frame')) {
        window.longestINPtoLoAFScript = null;

        function process(eventEntry) {
            let matchingLoafs = [];
            for (const event_entry of eventEntry.entries) {
                if (event_entry.entryType == "first-input")
                    continue;

gilbertococchi

CREATE TEMP FUNCTION IS_GOOD(good FLOAT64, needs_improvement FLOAT64, poor FLOAT64) RETURNS BOOL AS (
  good / (good + needs_improvement + poor) >= 0.75
);

WITH WIX_ORIGINS AS (
  SELECT
    origin,
    fast_inp,
    good_inp
  FROM (

gilbertococchi

# Warning: This Query will process 57GB approx, consider BigQuery API costs.

WITH dates AS
(SELECT
  yyyymm
  FROM
  `chrome-ux-report.materialized.device_summary`
GROUP BY yyyymm
ORDER BY yyyymm DESC
LIMIT 13)