How many hostname are delivering webp file extension and also which CDN provider is delivering those:
select req_host, _cdn_provider,
from [httparchive:runs.latest_requests]
WHERE regexp_match(url, r'\.(webp)$')
GROUP BY req_host, _cdn_provider
How many hostname are delivering webp file extension and also which CDN provider is delivering those:
select req_host, _cdn_provider,
from [httparchive:runs.latest_requests]
WHERE regexp_match(url, r'\.(webp)$')
GROUP BY req_host, _cdn_provider
A few things to note here:
For example you consider the URL at http://www.webpagetest.org/result/141127_9Q_DV4/1/details/ to be a webp based on your query but you can see it returned a standard JPG rather than webp
You can still send any response mime type for webp but chrome will still pick it up and do its thing so my suggestions is not 100% accurate way of detecting it
I am not sure you can do your analysis on public data of httparchive as its collected using IE8/9 (http://httparchive.org/about.php#datagathered) which does not render webp . However you can run your own private instance of httparchive and use chrome as your browser to collect the same
Funnily some data in the dataset does return image/webp for IE albeit cannot be rendered.
Chrome: http://www.webpagetest.org/result/141127_GS_E5D/
IE8: http://www.webpagetest.org/result/141127_TC_E56/
Happy Thanksgiving!