Level 3 - Question 54
Question
Use the line view in Explore to build a retention query that will use the nested event property built in question 46. This should show day 0 for all users and the % of those users that return each day since their first day, for every day into the future. This should be run from the beginning of time to now.
Take Note:
Retention is the foundation for some of the most powerful and valuable queries you can construct in Scuba. As we learned when creating the actor property from question 46, we can assign a day number to each day, we can determine a users first day number and then by subtracting the two we can see how many days it has been since a users first day. In this query, every user has a day 0, which is their first day, but every users day 0 does not have to be the same calendar day. Day 1 that we see in the returned results is 1 day since the users first day, day 2 is 2 days since the users first day and so on. This query is simply counting if a user had generated an event on a given day number since their first day and if they did they are considered retained. So when we see that 100% of users have a day 0 that is because every user has to have a first day at some point in time, and when we see that 27% of users have a day 1, that's because 27% of users return 1 day after their first day.