Level 3 - Question 59

Question

Open the retention app and run the rate of retention for users that had high purchase volume. We built that actor property in question 39. This should look at 8 weeks since a users first ever purchase event for high purchasing users from the beginning of time to now.

Additional Context

Using the Retention app, return a query that will show retention for users who fit into the category of "high purchasers" that starts from the day of their very first purchase and looks how well they're retained for the following 8 weeks after their first purchase. Using the retention app build a query that shows during 8 weeks after each users first ever event with action that matches purchase for user actors with the actor property created in question 39 that matches high purchase volume. Show retention on any event. Split by start date limited to 10 order by ascending run the query from the beginning of time and ending now.

Take Note:

Retention can be done more easily than we built out in our previous examples by using the retention app. Also note that you can measure things with a “before” statement in the app as well.

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*