Question

Retention: Build an actor property that shows the first day number a user is active.

Additional Context

Build an actor property that uses the event property from question 44. This actor property should use the show method and show first of the event property created in question 44 that is filtered to all events. In time options on the bottom select the time range option and set the time window starting at beginning of time and ending now. Name the property and save it.

Take Note:

Using the First operator is a very easy way to determine the first time a customer did something or a timestamp was generated. Now that we have previously learned that we can nest actor and event properties, we can nest the event property made that calculates the day number, and determine what the first-day number users had. In this case it will look at the returned value of day number (which was created in question 44) and determine which of those has the lowest value and return that as a users “first day.”

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*