I defined my monthly active users as users who have at least 1 Specific Event in a fixed period of time (from beginning of month until the end of the month) and I defined this for each month of 2021, active users in May, June, July etc following the above rule.
Ok so now whenever I want to see Insights like amount of events done by June active-users only in June I have to create a new bin or bucket with a new letter specifying the event the June cohort and then I have to manually insert $date which is translated into Date and set “contains” 2021-06 and I am able to see the June active users who did a specific event only in June.
The issue is that this is not scalable at all… and Mixpanel as far as I know does not allow the creation of future cohort up-front. Each month I have to create a new cohort for active users in that specific month and I have to add this as a new bin letter to each of my Reports. If I use the breakdown and set there all of my cohorts, I will get an aggregated event number showing all the events done by June active users but what I really need is June only events done by June active-users.
Can I achieve the scalability through a custom property or a custom cohort so I can forget to update each month all of my reports with newly cohorts and set the $date accordingly ?