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.

Assignment: Product-level website pathing

Assignment: Product-level website pathing - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Product-level website pathing

“

- [Instructor] All right, you're ready for your assignment on product pathing analysis. So previously, you've looked at a new product launch and analyzed the results on company sales performance. But this time, we're going to analyze the impact on customer website behavior. For this request, Morgan is coming to you to understand how many customers are hitting your products page and then what they do next on the website. Some of those customers will just abandon at the products page, and others will click to one of your products. She'd like you to analyze this click-through rate and next page performance for three months leading up to the product launch, and then for the three months since the product launch, she's coming to you on April 6th. So use that date range. Here's a preview of your results. You're going to want to group your results into two time periods. One for pre product two, which is the three month period leading up to launch, and a second time period for post-product…

Contents