Hi all – need help with a time-based funnel filter! I’m trying to create a funnel with the following logic for our app: Goal: Track users who did an image search in their first 3 days after signup, and then opened the app again between Day 4–7. Here’s what I’ve set up so far:
Step 1: search event where searchType = image
Step 2: app_opened event
Conversion window: 10 days
Challenge: I want to limit Step 1 to image searches done within 3 days of signup (or first app open), and Step 2 to only count app opens that happen between Day 4–7. I can’t find a way to express those relative time filters based on the user’s first event. Mixpanel doesn’t seem to support “Time since first app_opened” or “days since signup” directly in funnel filters. Has anyone figured out a way to do this? Maybe via session numbers, custom properties, or a workaround?
Hi Manoj- Julianne from Mixpanel Support here!
Diving right in, it isn't possible to specify relative time filters within one funnel. That said, it would be a great feature to develop! I highly recommend submitting your use case and request for this feature via the 'Submit Feedback' form (under the ? menu). This will flag your use case and support of the feature to the Product team. They use the logged gaps to develop future releases and improvements of the product.
As a workaround, one way to achieve this is by using a custom event property. You can create a custom property using the DATEDIF function to get the days between the event and a user profile property representing the onboarding date. This will allow you to filter events based on the number of days since the user completed onboarding.
I've generated an example of this here, https://mixpanel.com/s/41edXN, in our demo dataset. The first step in the Funnel is being filtered for instances that took place within 3 days of the users 'Created' profile property.
Inline Attachment: image.png
Would something like this work for your use case?
