What is a Cohort Analysis? is a free tutorial by A Course You'll Actually Finish from SQL course
Link to this course(Special Discount):
This is the best SQL Course
Course summary:
Analyze user behavior
Find actionable customer/business insights
Make data-driven decisions
Measure and track marketing efforts
Discover sexy marketing stats (e.g. 1 in 4 people love toast!)
English
All right all right welcome back. So in this lecture if you go over what a cohort analysis is the next lecture will be actually writing the query and showing you how to do one but you wanted to prep it with this lecture and kind of go over it for we jump into it David's going to take you through like a sneak peek of what a cohort analysis chart will look like. Boom there it is there is a chart right there. And so it might look a little overwhelming at first but really if they're going to break the sound we're basically doing two things here. First thing on the left hand column we're grouping users by their sign up date. So it is August 2010 that people who joined in August 2010 and then September 2010 that's another group of people. The second thing we're doing is that for each group that cohort the August cohort we're seeing their activity month to month. So we see the first comment as one up top. We're seeing there how many people came to the site in month one hundred people came back to the site months 2 3 4 and so on and so forth. So we're following them following that cohort through their life. This chart has like two really big main benefits so one we can compare different cohorts or groups of users at the same stage in their life cycle so that would be looking down from top to bottom on the chart so like we can see for all the codewords what percentage are coming back to the site three months after they signed up and we can compare how we're doing with our improvement in product and user experience so hopefully that's increasing in our products becoming better and more enjoyable. The second big benefit is we can see the long term relationship that we have with a given user group for each cohort about 25 percent are coming back after 1 month 6 percent coming after two months and we can see how long people from a given cohort are coming back to the site. We can see how strong that cohort is and how valuable they are. Yes well just like a product overview of what I cover and also in the benefits of it but if I was confusing stick around we're going go deeper right now. First off what is the cohort. Yeah. So for our purposes a cohort is a group of people who have become a customer. Around the same time. So people for example using example analogy at the high school people join the high school they become freshmen in high school in 2002. That's one cohort. The next year another professional arrived there they joined in 2003 that's another cohort. So we're grouping people by their joint. So after we've got them will follow each cohort and monitor their behavior every month or every year so on and so forth. Yeah and so that's gone so why are we grouping these people by the joint they are why we want to follow them over time so that we're going to get a really good life example similar to our Siculus database we're going to be talking about. Let's say we're Netflix subscription business where people come in and pay $15 a month to watch our videos our TV shows and we want to grow our avenues and so the first thing we want to do is we want to say we want to get as many new users as we can each month. So that's like people have never used Netflix before and get them to sign up make an account pay us out first months yet. So if you want to grow revenue that's one way to do it right you get new users and what I call Pete that's acquisition that is acquisition time but it'll be up so that once we acquire all these users and that's a higher 5000 last month we acquired another 7000 this month they were like wow we're killing it Caroline edition off the chain. But we're going to be like Missy in a couple big areas. If we just focus on not and pat ourselves on the back and there's two big reasons. There were things that were going to be missing. Yeah. If we see this chart going up instead right new users like dude are companies going like crazy. But you would be misjudging your business for one reason is because what if that group that you acquired last month that 5000 people they pay for a subscription for $15 for that month for the next month only 1 percent of those people continued their subscription. That would be that. And so the those people who come back we call that retention and that's like acquisition and retention those are two key parts of the business. You want to have both really good.