Level 3 - Question 47

Question

Build an actor property that counts the number of active days a user has in the last trailing 1 month.

Additional Context

Build an actor property that will return the number of unique days each user has had. Using the show method count unique values of =day_of_month([timestamp]), with a trailing time window of 1 month. Name the actor property and save it.

Take Note:

In questions 47, 48, 49, and 50 we’re going to look at New, Churned, Returned, and Retained users. This can be done by setting different time frames (1 month, 1 week, 1 day, whatever you like) that counts the number of active days they have had in that time period, meaning they at least generated one event.
Another way to look at retention is to count the number of active days a user has had in a certain time period and then using a histogram, determine the percentage of users that have x number of active days in that time period. It’s a great way to break down your whole user group and determine what expected retention or usage numbers you should see as an average with other queries. You can also dig deeper by segmenting users into different groups based on attributes like region, age, and purchase behavior and determine the number of active days they've had in a given time period.

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*