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: Finding top website pages - MySQL Tutorial
From the course: Advanced MySQL Data Analysis
Assignment: Finding top website pages
- [Instructor] All right, you're ready for your assignment on identifying top website pages. For this assignment, you'll be working with a new website manager, Morgan Rockwell. Website managers love their analysts because they help them figure out what's going on on the site. So this is a great opportunity for you to make an impact with Morgan and help her figure out how you can make the website better. Morgan's brand new, so she needs help with some day one stuff. The first thing she needs from you is to identify what your most viewed website pages are. She wants to see something like this, where you show her the pageview_url and the count of sessions. And like all the assignments, there'll be a date restriction here based on when the request came in. So you'll want to use traffic where the created at was before June 9th, 2012. Go ahead and give this a shot. Try to do it on your own, struggle through if you need to, and then come back and watch the solution video, and we'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Introduction19s
-
(Locked)
Analyzing top website pages and entry pages16m 42s
-
(Locked)
Assignment: Finding top website pages59s
-
(Locked)
Solution: Finding top website pages3m 15s
-
(Locked)
Assignment: Finding top entry pages1m 7s
-
(Locked)
Solution: Finding top entry pages7m 58s
-
(Locked)
Analyzing bounce rates and landing page tests14m 22s
-
(Locked)
Assignment: Calculating bounce rates39s
-
(Locked)
Solution: Calculating bounce rates9m 25s
-
(Locked)
Assignment: Analyzing landing page tests2m 12s
-
(Locked)
Solution: Analyzing landing page tests11m 56s
-
(Locked)
Assignment: Landing page trend analysis1m 9s
-
(Locked)
Solution: Landing page trend analysis7m 40s
-
(Locked)
Building conversion funnels and conversion paths17m 19s
-
(Locked)
Assignment: Building conversion funnels1m 26s
-
(Locked)
Solution: Building conversion funnels7m 53s
-
(Locked)
Assignment: Analyzing conversion funnel tests1m 49s
-
(Locked)
Solution: Analyzing conversion funnel tests6m 57s
-
(Locked)
-
-
-
-
-
-