I was trying to find users that fit the following segments, but wasn’t sure how to represent that using the filters and conditions on Mixpanel.
Segment 1: Users who have used the app 20+ days in the last 30 (In detail, users who fire at least 1 ‘any event’ for a day and also does this for any 20+ days in the last 30 days range)
Segment 2: Users who have used the app less than 8 days in the last 30 days (Similar to the previous, but the user has fired at least 1 ‘any event’ for a day and only did this for less than 8 days in the last 30 days)
For both these segments, I need to export a csv list of users that match those criteria (cohort) so that we can target these users with special promotions or retain them if possible.
I couldn’t do total events count as a way to count it because it needs to counted uniquely per day and not like 30 in one day.
One way I thought might be possible is to add ‘AND’ filters for a ‘any event’ on every day using fixed date range of a single day, but that’s just hardcoding it and I would need to update the dates every time I want to run this report. Also, using this approach, I can’t really do the ‘any 8 or 20 days out of 30 day range’.
I looked at Retention, but didn’t seem like it was possible with it either.
Best answer by Muffaddal QutbuddinView original