Level 3 - Question 50
Question
Build an explore query that counts users who had at least 1 active day in the last month, but no active days 1 month before and 2 months before the last month. These are new users (they were never active until this last month)
Take Note:
Now we’re putting it all together to determine New Users. A new user could be someone who has been active in the most recent trailing 1 month, but has not had activity in the previous month or the month before that. We can now do this with the properties we created and then count the number of active days they’ve had. For example, if a users has had greater than 0 active days in the most recent month, but their active days matches 0 for the previous month and month before that then they’re considered new , because they did generate a month in this event but did not generate events in the previous 2 months.