Question

Build a query off of the query built in question 50, in explore using bar view that returns churned users, and returned users in the last month by using the actor properties built in questions 47, 48, and 49. This query will use 3 measures.

Additional Context

Build a query in explore off of the query built in question 50. This will include 2 new measures. The first new measure will show churned users and should count unique user actors filtered to user actors with the actor property created in question 47 that matches 0 and user actors with the actor property created in question 48 that is greater than 0 and user actors with the actor property created in question 49 that is greater than 0. The second new measure will show returned users and should count unique user actors filtered to user actors with the actor property created in question 47 that is greater than 0, and user actors with the actor property created in question 48 that matches 0, and user actors with the actor property created in question 49 that is greater than 0. This query should start 2 months ago and end now.

Take Note:

In this query were adding 2 new groups of users, one for users who have churned and another for users who have returned. The measures follow the same structure and we’re only changing what time periods the users are active in. For example, if I have been active for the last 2 months but haven't been active in the most recent month I could be considered a churned user.

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*