Bounce Rate

February 11, 2016
By Bounteous

Legacy SQL

SELECT COUNT(totals.bounces)/COUNT(totals.visits) AS bounceRate
FROM [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]

Standard SQL

SELECT COUNT(totals.bounces)/COUNT(totals.visits) AS Bounce_Rate
FROM   'google.com:analytics-bigquery.LondonCycleHelmet.ga_sessions_20130910'