From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Solution: Identifying repeat visitors

Solution: Identifying repeat visitors - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Identifying repeat visitors

“

- [Instructor] Hi, everyone. This is the solution video for the assignment on identifying repeat visitors. So Tom's come to you with this ask. He's wondering how often your customers come back, because when he's been setting his bids, he's only been thinking about the first session in terms of customer acquisition. So if customers are coming back later and making purchases, then he's probably been underestimating the value. He wants the data to look like this with the number of repeat_sessions as the dimension, and then the count of users having those repeat_sessions will be the metric. There's a number of ways to do this. Let's go into Workbench and talk through solutions. Alright, so like some of the other things, this will be approached as a multi-step query. You could have done this a number of other ways, but I'm just going to show you the way that I did it. So take a look here, we've got this inner query where we're selecting the user_id and the website_session from…

Contents