Question

Using line view, build a query from the actor property created in question 55 and the event property created in question 46 that will show the daily rate of retention for users based on the number of times they executed a search in their first 7 days.

Additional Context

Using explore view, build a retention query using line view that will return the daily rate of retention for users who have searched in the first 7 days of being a user. Measure 1 should return a count of unique user actors filtered to all user actors, split by the actor property built in question 46 with a limit of 25, and a second split by that uses the actor property created in question 55 with a limit of 10. Measure 1 should also include "as a fraction of..." the actor property created in question 55. In the order by section below the split by, select the actor property created in question 46 as ascending. The query should start from the beginning of time and end now.

Take Note:

Now we get to some real value. In this query just like we saw in the results of question 54, we’re looking at the rate of retention for users x number of days since their first day. But in this case, we’re able to determine whether they are more likely or less likely to be retained based on how many times they performed a specific action in their first week of being a user.

Solution

Note: The numbers and result do not need to be an exact match as the data changes over time. The query construction is what is most important. See images below.

*Click to enlarge*