a n00b question 🙂 : In insights reports, how do I set date to a rolling "greater than" . Use-case: we have an event for when someone starts a trial, but I would like to know which users have passed trial days (14 days). To know who are currently in a trial, I have "Last 14 days" and that works fine.
Hi Mattias N., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To set a rolling "greater than" date range in Mixpanel Insights reports for your use case, you can use the custom date range option with a relative time setting. Here's how you can do it: 1. In the date range selector of your Insights report, click on "Custom". 2. Select the "Last" option. 3. Set the time value to 14 and the unit to "days". 4. Click on the "+ Ending" button. 5. Set the ending value to 1 day.This configuration will give you a rolling time range that includes all data from 14 days ago up until yesterday, effectively showing you users who have passed the 14-day trial period.For a more detailed explanation of date range options in Mixpanel, you can refer to the Mixpanel documentation on Date Range.Additionally, you might want to consider using Mixpanel's Cohorts feature to create a group of users who started their trial more than 14 days ago. This would allow you to easily filter and analyze this group across different reports.Mixpanel documentation on Cohorts provides more information on how to create and use cohorts for your analysis.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai This seems to give result of anyone that is currently in a trial (last 14) days and everyone that have had a trial (over 14 days ago), I would only like to have the later, i.e. everyone that have had a trial (that's ended, i.e. over 14 days ago). Is this possible?
Let me check the knowledge base for you again. One moment! đź“š
I apologize for the confusion in my previous answer. You're right, and I understand you want to focus only on users whose trial has ended (i.e., started more than 14 days ago). Yes, this is possible in Mixpanel. Let me provide you with a more accurate solution: To get users whose trial started more than 14 days ago (i.e., trial has ended), you can use the custom date range option in Insights reports with a specific configuration: 1. In the date range selector of your Insights report, click on "Custom". 2. Select the "Since" option. 3. Set the date to be 14 days before the current date.This configuration will give you all users who started their trial more than 14 days ago, effectively showing you users whose trial period has ended.For a more detailed explanation of date range options in Mixpanel, including the "Since" option, you can refer to the Mixpanel documentation on Date Range.Additionally, you might find it useful to create a cohort for these users. You can do this in the Cohort Builder by setting up a condition like "Users who did 'Start Trial' event before 14 days ago". This cohort will automatically update to always include users whose trial has ended. You can then use this cohort in your analyses across different reports.For more information on creating cohorts, you can check the Mixpanel documentation on Cohorts.I apologize again for the initial misunderstanding, and I hope this clarifies how to get the specific group of users you're looking for.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai, sorry this didn't seem to work either. "Since" still displays those users who have an active trial, because "since" includes every day up-until now. I also tried creating a cohort, but the event trial_started is a numeric value of example 1 and 0, it doesn't seem to work to include the date information for that event in cohort. Any other suggestions?
Let me check the knowledge base for you again. One moment! đź“š
I apologize for the confusion in my previous responses. You're right, and I understand the challenge you're facing. Let me provide a more accurate solution based on the information you've shared: Given that your "trial_started" event is a numeric value (1 or 0) rather than a date, we need to approach this differently. Here's a suggestion that might work better for your use case: 1. First, create a cohort for users whose trial has ended. You can do this in the Cohort Builder: - Go to the Cohort Builder - Set up a condition: "Users who did 'trial_started' event with value 1 more than 14 days ago" - Save this cohort with a name like "Trial Ended Users"2. Once you have this cohort, you can use it in your Insights reports: - In your Insights report, click on the "Filter" button - Select your "Trial Ended Users" cohort - This will filter your report to only show data for users whose trial has endedThis approach should give you the results you're looking for - users who started a trial more than 14 days ago (i.e., their trial has ended).If you're still having trouble, it might be helpful to review how you're tracking the trial start event. Ideally, you should track a date property along with the trial_started event, which would make this kind of analysis easier.For more advanced cohort creation techniques, you can refer to the Mixpanel documentation on Creating Cohorts.If this solution doesn't work for your specific setup, please provide more details about how you're tracking trial starts and ends, and I'll be happy to suggest a more tailored approach.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai, sorry that doesn't work either. Because the only data I have is trial_started with 1 or 0 (beause trial can only be started once), so if I filter by the cohort, it will still not contain "more then 14 days ago".
Let me check the knowledge base for you again. One moment! đź“š
I apologize for the continued confusion. You're right, and I understand the limitations of your current data structure better now. Given that you only have a trial_started event with values 1 or 0, and no date information associated with it, it's indeed challenging to determine when the trial started or ended using Mixpanel's standard features.In this case, the knowledge sources don't provide a direct solution for your specific scenario. However, I can suggest a potential workaround, though it would require changes to your data tracking: 1. Instead of (or in addition to) tracking trial_started as a 1 or 0, consider tracking it as an event with a timestamp. This way, Mixpanel will automatically record when the trial started for each user.2. If possible, add a user property that stores the trial start date. This would allow you to create cohorts and filters based on the time since the trial started.If implementing these changes is not feasible in the short term, you might need to rely on your backend systems to determine which users started their trial more than 14 days ago, and then import this information into Mixpanel as a cohort or user property.For more information on best practices for tracking events and user properties in Mixpanel, you can refer to the Mixpanel documentation on User Profiles.I apologize that I couldn't provide a direct solution based on your current setup. If you have the ability to adjust your tracking method, it would significantly improve your ability to perform this kind of analysis in Mixpanel.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai, yes I think suggestion 1 or 2 is needed to make this work as I'd wanted. However we do know when the user started the trial, based on the date event when the trial_started event was triggered. So I think what would also work is if Insight and Custom contained function of "Greater than" days ago, instead of just Since or Last or Ending.
Let me check the knowledge base for you again. One moment! đź“š
You're absolutely right, and I appreciate your insight. Your suggestion of having a "Greater than" days ago function in Insights and Custom reports would indeed be a valuable feature for scenarios like yours. Unfortunately, based on the current knowledge sources provided, Mixpanel doesn't offer this exact functionality in the way you've described.However, your observation about knowing when the user started the trial based on the date of the trial_started event is crucial. This information can be leveraged to create a workaround using Mixpanel's existing features. Here's a potential solution: 1. Use Custom Properties: You can create a custom property that calculates the number of days since the trial started. As described in the Mixpanel documentation on Custom Properties, you can create a property that calculates the difference between the current date and the date of the trial_started event.2. Once you have this custom property, you can use it in your Insights reports to filter for users whose trial started more than 14 days ago.This approach would effectively give you the "Greater than" days ago functionality you're looking for, albeit in a roundabout way.Your suggestion about adding a "Greater than" days ago function is an excellent one, and it would indeed make this kind of analysis more straightforward. While it's not currently available, Mixpanel does take user feedback into account for future updates. You might want to consider submitting this as a feature request to Mixpanel's support team.Thank you for your patience as we worked through this problem. Your insights have been valuable in understanding the limitations of the current system and potential areas for improvement.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai thank you, I tried it a little bit differently and it seems to be working now. If anyone is reading this: I created a custom event property (Filter + Create) name it Formula: Borrow Property trial_started -> Time Save That seems to give the time of the event. And in the insight report, I chose Filter by -> select above custom event property Choose "Not in the last" 14 days
Let me check the knowledge base for you again. One moment! đź“š
Thank you for sharing your solution! It's great to hear that you found a way to make it work. Your approach is clever and utilizes Mixpanel's Custom Properties feature effectively. Let me break down what you've done for anyone else who might be reading this: You've created a custom event property using the "Borrowed Properties" feature, which is indeed a powerful tool for this kind of analysis. Here's a bit more context on what you've done: 1. You used the "Create Custom Property" feature in Mixpanel. 2. You chose the "Borrow Property" formula type. 3. You borrowed the "Time" property from the "trial_started" event.This approach allows you to access the timestamp of when the trial started, which you can then use in your analyses to filter for trials that started more than 14 days ago.Your solution aligns well with the capabilities of Mixpanel's Custom Properties and Borrowed Properties features. As described in the Mixpanel blog on Borrowed Properties, this feature allows you to "borrow" a property from one event to another on the fly, which is exactly what you've done here.For anyone else facing a similar challenge, this is an excellent example of how to use Borrowed Properties to access time-based data from specific events for use in other analyses.Thank you for sharing this solution. It's a great workaround for the lack of a direct "Greater than X days ago" filter, and it demonstrates a creative use of Mixpanel's features to solve complex analytical problems.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! đź“š
Thank you for sharing your complete solution! It's excellent that you found a way to achieve what you were looking for. Your approach is a great example of leveraging Mixpanel's features creatively. Let me break down your solution and provide some additional context: 1. Creating a custom event property: You used the Custom Properties feature in Mixpanel. This allows you to create new properties based on existing data.2. Using Borrowed Properties: You utilized the Borrowed Properties feature to borrow the "Time" property from the "trial_started" event. This is a powerful way to use data from one event in the context of another.3. Filtering in Insights: By using the custom property in your Insights report filter and selecting "Not in the last 14 days", you've effectively created a filter for trials that started more than 14 days ago.Your solution is an excellent workaround for the lack of a direct "Greater than X days ago" filter. It demonstrates how to use Mixpanel's Custom Properties, Borrowed Properties, and filtering capabilities together to solve complex analytical problems.This approach should work well for identifying users whose trials have ended (started more than 14 days ago). It's a great example of how to overcome limitations in the standard date range options by creating custom properties and using them in filters.Thank you for sharing this detailed solution. It will undoubtedly be helpful for other users facing similar challenges in their Mixpanel analyses.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
