I want to dynamically plot the difference between a group property date (Signup-date) and Event Date's. My goal is to visualize what events are commonly happening during a users lifecycle (eg; what are most common event's being tracked in 0-30 days after sign-up, 30-60 days, etc, etc.). Can I do this in Mixpanel?
Hi Jeroen v., 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
Yes, you can achieve this in Mixpanel using a combination of features. Firstly, you can use the mixpanel.numeric_bucket()
function to segment events over a calendar period when applied to the time property. This function can be used to create buckets for calendar days, weeks, months, quarters, and years. This can be useful for segmenting your data into periods like 0-30 days, 30-60 days, etc. Here is an example of how to use it:LBKSfunction main() { return Events({ from_date: "2016-01-01", to_date: "2016-01-30", }).groupBy([mixpanel.numeric_bucket('time', {bucket_size: 86400 * 1000})], mixpanel.reducer.count()); }LBKS
(Source: JQL Builtins)Secondly, you can use the Flows feature to identify the most frequent paths taken by users both to or from any event. This can help you understand how your users sequentially perform events in your product, and when they are most likely to drop off. (Source: Build User Flows)Lastly, you can use the Insights tool to visualize trends and compositions within your data. You can analyze events, cohorts, and user profiles, and display the data in a wide variety of chart types. Advanced Insights features also allow you to create formulas, compare current data to past data, and generate custom events and properties for deeper analysis.(Source: Insights)However, please note that calculating the difference between a group property date (Signup-date) and Event Date's specifically might require some custom properties or additional setup. You might want to refer to the Mixpanel documentation or reach out to their support for more specific guidance.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
Let me check the knowledge base for you again. One moment! 📚
Yes, you can do this in Mixpanel using the Retention report. The Retention report allows you to analyze how often your users return and engage with your application after their initial visit. You can use the Custom Retention Brackets feature to split up your retention buckets into customized intervals of multiple days, weeks, or months to create meaningful touchpoints. For example, you can create a bracket for 0-30 days after sign-up to see what actions users are taking during this period. Here's how you can do it:1. In the Retention report, select the event that represents your users' sign-up action as the 'Start Event'. 2. Then, select the events that you want to track within the 30 days after sign-up as the 'Return Event'. 3. Set the 'Conversion Window' to 30 days. 4. Finally, set the 'Retention Mode' to 'Custom Bracket' and define your brackets as 0-30 days.This will give you a report showing how many users performed the return event within 30 days after sign-up.For more complex analysis, you might want to use Mixpanel's JQL (JavaScript Query Language) to write custom queries. However, this requires a good understanding of JavaScript and Mixpanel's data structure.Please refer to the Mixpanel documentation on Retention for more detailed instructions.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
kapa.ai But in the retention report you can only select 2 events? The start event, and the event that should follow after. Besides, we want to see the variety of the events that are ‘most popular’ within the first 30 days of sign-up. And as mentioned in the initial Slack message, the sign-up date should be dynamic. So, for a user who signed up on January 1st, we want to see Jan. 1st until Jan. 31st as their ‘first 30 days’, but someone who signed up on August 1st, their first 30 days should be from until August 31st. How can we achieve this?
Let me check the knowledge base for you again. One moment! 📚
I understand your requirement better now. You want to track multiple events within the first 30 days of a user's lifecycle, with the sign-up date being dynamic. While Mixpanel's Retention report does allow you to track a user's interaction with your application after their initial visit, it is limited to tracking a single 'Return Event' after the 'Start Event'. However, you can use Mixpanel's Custom Events feature to merge multiple events into a single event. For example, you can create a custom event that includes all the events you want to track within the first 30 days after sign-up. Then, you can use this custom event as the 'Return Event' in your Retention report. Here's how you can create a Custom Event:1. Expand the Event dropdown in either an Insights, Funnels or Retention report. 2. Select the plus button to the right of the search bar. 3. Select the events and properties you’d like to include. 4. Name your custom event, and click Save.Please note that this approach will give you a count of users who performed any of the included events within the first 30 days after sign-up, but it won't give you a breakdown of each individual event.For a more detailed analysis, you might need to use Mixpanel's JQL (JavaScript Query Language) to write custom queries. However, this requires a good understanding of JavaScript and Mixpanel's data structure.Please refer to the Mixpanel documentation on Custom Events for more detailed instructions.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
Let me check the knowledge base for you again. One moment! 📚
I understand your requirement. Unfortunately, the standard Mixpanel reports may not provide the level of granularity you're looking for. However, Mixpanel's Query API could be a potential solution for your needs.The Query API allows you to make custom queries to fetch data from Mixpanel. You can use it to fetch event data for each user and then process this data to find out which events a user performed within the first 30 days of signing up. Here's a high-level overview of how you could do this:1. Fetch the sign-up event for each user to find out when they signed up. 2. Fetch all events for each user. 3. For each user, filter out the events that occurred more than 30 days after the user's sign-up date. 4. Count the occurrences of each event within this 30-day period.Please note that this approach requires a good understanding of how to work with APIs and how to process the returned data. Also, the Query API has a rate limit of 60 queries per hour and a maximum of 5 concurrent queries.You can find more information about the Query API in the Mixpanel documentation.For a more detailed and tailored solution, I would recommend reaching out to Mixpanel's support or consulting with a developer who is familiar with Mixpanel and its API.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
Let me check the knowledge base for you again. One moment! 📚
No, the Query API does not cost extra. It's included as part of your Mixpanel plan. However, it's important to note that the Query API has a rate limit of 60 queries per hour and a maximum of 5 concurrent queries. This means you can only make a certain number of requests to the API within a given timeframe. If you exceed this limit, you may experience slower response times or temporary blocks.You can find more information about the Query API in the Mixpanel documentation.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.