Hello! I'm trying to create an Insights report to identify our Product Adoption Indicator by analyzing user behaviour in their first week after signing up. I want to filter for:
Users whose SIgn up "First Seen" event date is in the last 30 days
AND Total events for Event B that occurred within 7 days of each user's "First Seen" date
I've successfully filtered for "First Seen in last 30 days," but I can't figure out how to add the second condition: " where event Time within 7 days of First Seen." Is this possible in the Insights interface, or do I need to use a different report type or custom formula?" I also tried doing it in the retention report, but was not able to set it up to measure only total events. That was not an option there.
This post is now synced! Check it out here: _How to Filter Events Within 7 Days of User's First Seen Date in Insights Report_ ⤵️ Any future comments will be automatically posted to the thread
Thanks for your question! Hopefully, your peers in the community can help answer your questions.
However, if you need some review from our Support team, leave 🎫 on your question and we should reach out shortly! If you do this, please make sure to not send duplicate tickets through the Support webform. Appreciate it!
In the meantime, let us know if this feedback is similar to any previous discussions below:
How to Track Daily New Users in Mixpanel for Your Dashboard (4 months ago)
Tracking User Cohorts Based on Event Time Gaps (8 months ago)
Creating a User Cohort Based on Event Participation (1 year ago)
Hey Justine! This sounds like a great use case for a DATEDIF() custom property. This allows you to see the time between two timestamps in days. Once the property is created, you can filter for events that took place within 7 days.
