Bounce Rate by Day or Hour
February 11, 2016
|
SELECT HOUR(SEC_TO_TIMESTAMP(visitStartTime)) AS sessionHour,
COUNT(totals.bounces)/COUNT(totals.visits) AS bounceRate
FROM [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]
GROUP BY sessionHour