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: Traffic source trending

Assignment: Traffic source trending - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Traffic source trending

“

- [Instructor] All right. We're ready for your assignment on traffic source trending. This is a pretty cool one, you're going to get to use date functions, which will be one of your best friends as an analyst. So based on your last assignment, Tom realized you guys were over bidding for the gsearch nonbrand traffic. He bid down nonbrand on April 15th. Now it's almost a month later, on May 10th, and he's come to you to pull some trended session volumes so that he can understand how those bid changes impacted overall volume of sessions coming to the website. Here's a preview of what your results should look like. You're going to want to show him the week, and then the number of sessions that are coming from gsearch nonbrand. So just like the other assignments, you're going to want to limit your query to sessions where the created app is less than May 10th, 2012. Go ahead and give this a shot. Struggle through it if you have trouble, and then come back and watch the solution video. Good…

Contents