What are the quantiles of the Pagespeed score for the latest crawl?

Analysis
2

Nice. I was also curious about how/if the distribution has changed over time:

Interesting to see that the lower quantiles all gained ~3 extra points over the past two years, whereas the best performers only added one or two points. Full query:

SELECT  
  date,
  NTH(10, quantiles(pageSpeed)) tenth,
  NTH(20, quantiles(pageSpeed)) twentieth,
  NTH(30, quantiles(pageSpeed)) thirtieth,
  NTH(40, quantiles(pageSpeed)) fortieth,
  NTH(50, quantiles(pageSpeed)) fiftieth,
  NTH(60, quantiles(pageSpeed)) sixtieth,
  NTH(70, quantiles(pageSpeed)) seventieth,
  NTH(80, quantiles(pageSpeed)) eightieth,
  NTH(90, quantiles(pageSpeed)) ninetieth
FROM (
  SELECT  STRFTIME_UTC_USEC(INTEGER(createDate*1000000), "%Y-%m") date, pageSpeed FROM 
    httparchive:runs.2012_01_01_pages, httparchive:runs.2012_02_01_pages,
    httparchive:runs.2012_03_01_pages, httparchive:runs.2012_04_01_pages,
    httparchive:runs.2012_05_01_pages, httparchive:runs.2012_06_01_pages,
    httparchive:runs.2012_07_01_pages, httparchive:runs.2012_08_01_pages,
    httparchive:runs.2012_09_01_pages, httparchive:runs.2012_10_01_pages,
    httparchive:runs.2012_11_01_pages, httparchive:runs.2012_12_01_pages,
    httparchive:runs.2013_01_01_pages, httparchive:runs.2013_02_01_pages,
    httparchive:runs.2013_03_01_pages, httparchive:runs.2013_04_01_pages,
    httparchive:runs.2013_05_01_pages, httparchive:runs.2013_06_01_pages,
    httparchive:runs.2013_07_01_pages, httparchive:runs.2013_08_01_pages,
    httparchive:runs.2013_09_01_pages, httparchive:runs.2013_10_01_pages,
    httparchive:runs.2013_11_01_pages
) GROUP BY date, order by date

@stevesoudersorg it would be great to add PageSpeed to mobile runs as well! Currently, all of those columns report zero scores.

3 Likes