From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

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

Solution: Product-level website pathing

Solution: Product-level website pathing - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Product-level website pathing

“

- [Instructor] Hi everyone, this is the solution video for your assignment on product pathing analysis. As a reminder, Morgan's come to you looking for help understanding the impact of your new product launch on website behavior. She's looking for results that look like this, slicing the data into two time periods, the first being three months prior to the launch, and the second being three months post-launch. She wants to see account of the sessions hitting the products showcase page, then account of the number of sessions that hit a next page after the products showcase page, the percentage of those page views, which have another page, and then she wants to see where they're going. Are they going to the Mr Fuzzy page or are they going to the new Love Bear page? Let's jump into Workbench and walk through the solution. Alright, so this will be a multi-step query. It's a little complicated, but it's similar to some of the bounce rate analyses you've done in the past. We're just going…

Contents