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: Bid optimization for paid traffic

Solution: Bid optimization for paid traffic - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Bid optimization for paid traffic

“

- [Instructor] All right, this is the solution video for your assignment on traffic source bid optimization. As a reminder, Tom is looking for some help analyzing device-specific conversion rates. Your results should look something like this with sessions, orders, and session to order conversion rate broken down by device_type. Let's jump into Workbench and walk through the solution. All right, so per usual, we're going to approach this as if we were the analyst fielding the request in the present day. So we'll limit our results to records where created_at is earlier than May 11th, 2012. This is another one where we'll use the website_session table (keyboard clacking) and we'll be interested in nonbrand gsearch traffic. So we'll say utm_source equals gsearch and utm_campaign is nonbrand. And then we're going to use website_sessions.device_type, and we'll be doing a COUNT of website_sessions.website_session_id, and that's sessions. And we'll make this DISTINCT just for good measure. So…

Contents