From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Solution: Calculating bounce rates

Solution: Calculating bounce rates - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Calculating bounce rates

“

- [Instructor] Alright, this is the solution video for calculating bounce rates. As a reminder, Morgan is interested in understanding what the bounce rate is for the homepage, where all of your traffic is going right now. Let's jump into Workbench and we can walk through the solution. Alright, so this is again going to be a multi-step query. Anytime we're doing a multi-step query, I always like to break down the analysis into the steps that we're going to need to go through to get the results. So here we've got step one, which is finding the first website pageview ID for the relevant sessions. Then we've got step two, which is identifying the landing page for those sessions. And then we've got step three, counting the pageviews for each session, where we'll understand which of those sessions was a bounce, those that only have one pageview, and which of those are non-bounces, those with more than one pageview. And then finally, we'll summarize the results by counting the total sessions…

Contents