From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Solution: Analyzing conversion funnel tests

Solution: Analyzing conversion funnel tests - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Analyzing conversion funnel tests

“

- [Instructor] All right, this is the solution video for the assignment on analyzing conversion funnel tests. As a reminder, based on your previous funnel analysis, Morgan put together an updated billing page, and she's run it as a split test 50/50 against the previous billing page. The new billing page lives on billing-2 versus the old billing page that was just billing. She'd like to understand what percentage of sessions for each of those pages ended up placing an order during the test. And she's noted that you ran this for all traffic, not just for your search visitors. So you don't need to limit based on that. Let's jump into workbench and walk through the solution. All right, so the first thing that we're going to do is figure out when billing-2 went live so that we can frame a fair fight analysis. So take a look here, we're doing a select minimum website page view ID from website page views where URL equals billing-2. And we get a first page view ID of 53550. I've noted that…

Contents