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.

Solution: Cross-channel bid optimization

Solution: Cross-channel bid optimization - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Cross-channel bid optimization

“

- [Instructor] Alright, this is the solution video for your assignment on cross channel bid optimization. As a reminder, Tom is coming to you, asking you to pull non-brand conversion rates from session to order for gsearch and bsearch. And he'd also like you to slice the data by device type. He's asked you to analyze August 22nd to September 18th. Results should look like this, with device type and UTM source as two of the breakdowns, and then metrics being sessions, orders, and conversion rate. This should feel similar to stuff that you've already done, grouping your data into segments, and then looking at sessions, orders, and conversion rates. The main difference here is we're pulling two segments, so we're having device type, and then additionally slicing by UTM source. Hopefully, this made sense to you. Let's walk through the solution now. Here, I've started specing out a solution query for you. We are pulling data from website sessions and left joining to orders so that we can…

Contents