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.

Assignment: Analyzing new and repeat conversion rates

Assignment: Analyzing new and repeat conversion rates - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Analyzing new and repeat conversion rates

“

- [Instructor] Hi everyone. You're ready for an assignment on new versus repeat performance. For this assignment, Morgan has become interested in all of the repeat customer behavior analysis you've been doing. She'd like you to help her out understanding the conversion rates and revenue per session for your repeat sessions versus your new sessions. Since you've been working with 2014 to date, she says "Go ahead and continue to use that date range." She's coming to you on November 8th, 2014, so limit your date range accordingly. Your results should look like this, grouping your results into new and repeat using the is_repeat_session flag, which is set to one or zero. And then pulling sessions, your conversion rate, and your revenue per session. This should be fairly straightforward for you. I don't think you'll have much trouble. Go ahead and get to the answer and then come back and watch the solution, and we'll talk about results. Good luck.

Contents