I am interested in working out if the number of requests over HTTPS have increased / decreased over the past few years and what trends I can associate with them. I’m using the following basic query to start off with:
SELECT count(pageid) as NumberHttps, 'Nov-2010' as CreatedDate
FROM [httparchive:runs.2010_11_15_requests]
WHERE (url LIKE ("https%"))
GROUP BY CreatedDate
While this request works great, it doesn’t take into account redirects to HTTPS. For example, a site may have a URL of http://acme.com, but actually get redirected to https://acme.com.
I did have a look at the following question - http://bigqueri.es/t/how-many-https-websites-are-using-mixed-content/244, but wasnt sure if this is along the right lines!
Any advice would be appreciated!