Bounce Rate by Landing Page

November 04, 2018
By Bounteous

Legacy SQL

SELECT
     hits.page.pagePath AS Landing Page,
     COUNT(totals.bounces)/COUNT(totals.hits) AS Bounce_Rate, 
     COUNT(totals.bounces) AS Bounces, 
     COUNT(totals.hits) AS Entrances 
FROM 
     [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]  
WHERE 
     hits.type="PAGE" AND hits.hitNumber=1
GROUP BY 
     Landing Page
ORDER BY 
     Entrances DESC

Standard SQL

SELECT
     hits.page.pagePath AS Landing_Page,
     COUNT(totals.bounces)/COUNT(totals.hits) AS Bounce_Rate, 
     COUNT(totals.bounces) AS Bounces, 
     COUNT(totals.hits) AS Entrances 
FROM 
     'google.com:analytics-bigquery.LondonCycleHelmet.ga_sessions_20130910' AS GA,
     UNNEST(GA.hits) AS hits
WHERE 
     hits.type="PAGE" AND hits.hitNumber=1
GROUP BY 
     Landing_Page
ORDER BY 
     Entrances DESC