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: Cross-sell analysis

Assignment: Cross-sell analysis - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Cross-sell analysis

“

- [Instructor] All right, we're ready for your assignment on cross-sell analysis. For this assignment, Cindy needs your help understanding the impact of adding cross-sell functionality to the website. On September 25th, they started giving customers the option to add a second product from the cart page. She'd like you to analyze the month before and the month after, and she'd like to see the click-through rate from the cart page, the average products per order, the average order value, and the overall revenue per cart page view. Your results should look like this, with two time periods: pre-cross-sell and post-cross-sell. And again, make that one month before and one month after the change on September 25th. And then your metrics will be cart sessions, click-throughs, cart click-through rate, products per order, average order value, and then revenue per cart session. I would say this exercise is firmly in the category of advanced SQL. This is definitely going to be a multi-step data…

Contents