I’m trying to create user Cohorts for user’s who are Subscribers, Churned Subscribers, in a Free Trial, churched Free Trial users, ect.
Due to constraints from Apple’s subscription service, this can only be accomplished by analyzing the `expiration_at` property of these events. These events are sent from Apple to our subscription management platform (RevenueCat) via web hook. RevenueCat then sends these events to Amplitude via web hook.
For example, A Free Trial user would have to be inferred by the trial_started event whose expiration_at date is in the future.
I can’t find a way to filter an event by a relative date, i.e. “trial_started where expiration_at in the next week). It looks like amplitude allows me to filer by expiration_at but only by the specified values.
I’ve attached a screenshot of how it’s down in MixPanel