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: Traffic source conversion rates

Solution: Traffic source conversion rates - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Traffic source conversion rates

“

- [Instructor] Alright, this is the solution video for the assignment on traffic conversion rates. So Tom has come to ask you about gsearch nonbrands. He'd like to know the conversion rate from session to order. The results that you're trying to produce here should look like this, with sessions, orders, and conversion rate. The request came in on April 14th, 2012, so you'll want to frame your analysis with data just up until that time period. So let's go through and dig into gsearch nonbrand, so that we can help Tom understand conversion rates. Per usual, we'll start our query with the date restriction so that we're simulating the analyst being there in the moment for this request. So we'll just use data from before April 14th, 2012. And we're also going to want to limit our data to just where UTM source equals gsearch, that's what Tom is asking about. And UTM campaign equals nonbrand. You probably realized we are going to be starting from the website sessions table again because we…

Contents