From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

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

Assignment: Landing page trend analysis

Assignment: Landing page trend analysis - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Landing page trend analysis

“

- [Instructor] Alright, we're ready for your assignment on landing page trend analysis. For this assignment, Morgan wants to follow up on the previous work you did to show that lander-1 had a better bounce rate than the homepage. Based on your previous analysis, she asked Tom to route all of the paid traffic to lander-1. She wants your help confirming that, that's been done correctly. So, she'd like you to pull the overall session volume to those pages and she'd also like you to pull the overall paid search bounce rate trended weekly to make sure that the change has had the positive impact that she expects it to. Your results should look like this, with a week start in the left column, and then bounce rates and home sessions and lander sessions in the other three columns. Again, you'll be performing this analysis as if you were the analyst receiving this on August 31st, 2012. So, limit your data set to records that come before that. Give this one a shot on your own. Try to get to the…

Contents