Level 3 - Question 46

Question

Build an event property that tells me the number of days it has been since a user's first day.

Additional Context

Build an event property that returns the number of days it has been since a user's first day. Using the calculate method, build a calculation that subtracts the event property from question 44 to the actor property from question 45. =([44]-[45]). Name the property and save it.

Take Note:

And finally, we create the calculation that determines the number of days since a user's first day. In question 44 we assigned a day number to each day (which is the number of days since Jan 1, 1970), in question 45 we built an actor property to determine the first-day number for each user by using the “first” operator and returning day number from question 44. And lastly, we can subtract the two against each other to get the number of days since a user's first day. This can also be used to calculate every day that a user is active since their first day, as we will do in our retention query.

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*