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.

Solution: Finding top traffic sources

Solution: Finding top traffic sources - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Finding top traffic sources

“

- [Instructor] Alright, this is the solution video for the assignment on finding top traffic sources. As a reminder, Cindy is looking for you to pull session volumes cut by UTM source, UTM campaign, and HTTP referer. She wants data for company's launch to date, so all you'll need to do is limit to a date range where your created at is less than April 12th, 2012. Let's jump into Workbench and go through the solution. Alright, so here, you see we've got use Maven Fuzzy Factory, just to name the schema that we want to use. And then I've already started this query with a where created at less than 2012, April 12th. And that's just prescribed based on the date that you received the assignment from Cindy. You should plan on starting each of your solution queries with the where condition just so you don't forget it, and that way, your output will match the output that your business stakeholder's expecting and that I've put together in my solution video. So we're going to be looking for…

Contents