I need to calculate and display the percentage of days, over a given period (e.g., the last 30 days), on which a user conducted a specific Mixpanel event. For example: If a user conducted 60 events across 3 unique days in the last 30 days, the percentage would be: (3/30)×100=10%(3 / 30) \times 100 = 10\%(3/30)×100=10%. Explain me step by step how it can be done in Mixpanel current version
Hi Ilya L., 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 calculate and display the percentage of days over a given period where a user conducted a specific Mixpanel event, you can use a combination of Mixpanel's Insights report and custom calculations. Here's a step-by-step guide on how to achieve this in the current version of Mixpanel: 1. Create an Insights report:
Go to the Insights report in Mixpanel and select the specific event you want to analyze.2. Set up the measurement:
Click on the measurement dropdown (usually set to "Unique Users" by default) and select "Aggregate Property per User" Measurements.3. Configure the aggregation:
- Choose the event you're interested in.
- Select "Distinct Count" as the aggregation type.
- For the property, choose the default "Time" property, which represents the timestamp of the event.4. Set the time range:
Adjust the date range in the top right corner to cover the period you're interested in (e.g., Last 30 days).5. Group by user:
In the "Group By" section, add a user identifier property (e.g., "Distinct ID" or a custom user ID property) to see results per user.6. Customize the display:
Change the chart type to "Table" for a clearer view of the data.Now, you have a table showing the number of unique days each user performed the event within the specified time range. However, to get the percentage, we need to do some additional calculations: 7. Create a custom formula:
Click on the "Metrics" button and select "Formula" Formulas.8. Set up the formula:
Assuming your aggregated property is represented by 'A', and your time range is 30 days, your formula would be:
(A / 30) * 100 This calculates the percentage of days the event occurred for each user.9. Rename and format the formula:
Give your formula a descriptive name like "% of Active Days" and set the number format to "Percentage" with the desired number of decimal places.10. Apply and analyze:
Apply the changes and you'll now see a table with each user's percentage of active days over the specified period.Please note that this method gives you a per-user breakdown. If you want an overall average, you might need to export the data and do further calculations, or use Mixpanel's JQL (JavaScript Query Language) for more complex computations.Remember that the exact steps might vary slightly depending on your specific Mixpanel setup and the properties you have available. Always ensure you're working with the correct event and properties for your use case.
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! 📚
I apologize for the confusion in my previous response. You are correct, and I thank you for pointing that out. Let me provide a more accurate explanation based on the available information in Mixpanel's current version.You're right that "Distinct count" is available for "Aggregate Property" but not for "Aggregate Property per User". Let's look at the correct options for "Aggregate Property per User": According to the Aggregate Property per User documentation, the available functions for this measurement are: 1. Sum 2. Average 3. Distinct count 4. Minimum 5. MaximumEach of these has different aggregation options, including Average, distribution, median, percentiles, minimum, and maximum.For your specific use case of calculating the percentage of days a user performed an event, we can modify the approach. Here's a corrected method: 1. In Insights, select your desired event.2. For the measurement, choose "Frequency per User" instead of "Aggregate Property per User" Measurements.3. Set your desired time range (e.g., Last 30 days).4. For the aggregation options of "Frequency per User", select "Distinct Count" Additional Aggregation Option Examples.This will give you the number of unique days each user performed the event within the specified time range.5. To convert this to a percentage, you can use a formula as described in the previous response. Create a custom formula that divides this result by the total number of days in your selected period and multiplies by 100.I apologize again for the earlier misunderstanding. Thank you for bringing this to my attention, as it allows me to provide more accurate information about Mixpanel's current capabilities.
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! 📚
I apologize for the confusion in my previous responses. You are correct, and I thank you for your patience. Let me provide a more accurate explanation based on the available information about Mixpanel's current version.After carefully reviewing the documentation, I realize that the specific functionality we've been discussing is not directly available as a pre-built option in Mixpanel's standard reports. The "Frequency per User" and "Aggregate Property per User" options don't provide the exact calculation we need for your use case.Given this limitation, we need to approach the problem differently. Here's an alternative method that might help you achieve your goal: 1. Use Mixpanel's Behavioral Properties feature. This allows you to create a virtual property based on user behavior.2. Create a behavioral property that counts the number of days a user performed the specific event within your desired time frame (e.g., last 30 days).3. Once you have this behavioral property, you can use it in Insights to segment your users based on the number of active days.4. To get the percentage, you would need to export this data and perform the final calculation (dividing by the total number of days in your time frame and multiplying by 100) outside of Mixpanel, using a tool like Excel or a custom script.If this approach doesn't meet your needs, you might need to consider using Mixpanel's more advanced features: 1. JQL (JavaScript Query Language) could be used to create a custom query that calculates this percentage directly.2. Alternatively, you could use Mixpanel's API to extract the raw data and perform the calculation in your own application or analysis tool.I apologize again for the earlier inaccuracies. If you need a more precise solution, it might be best to consult with Mixpanel's support team directly, as they would have the most up-to-date information on the platform's capabilities and could potentially suggest a more tailored approach for your specific use case.
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! 📚
Certainly, I'll explain step 2 in more detail. This step involves creating a behavioral property in Mixpanel to count the number of days a user performed a specific event within a given time frame.Here's a detailed breakdown of how to create this behavioral property: 1. Navigate to the Data Management section in Mixpanel and select "Behavioral Properties" Behavioral Properties.2. Click on "Create New Property" to start defining your behavioral property.3. Choose "Frequency per User" as the type of behavioral property.4. Select the specific event you want to track (e.g., "Video Watched", "Purchase Made", etc.).5. Set the time range for your analysis (e.g., Last 30 days).6. In the advanced settings, you'll need to specify how you want to count the frequency. For your use case, you want to count the number of unique days. Look for an option like "Count unique days" or "Distinct count of days". The exact wording might vary depending on Mixpanel's current interface.7. If available, set the "Aggregate by" option to "Day" to ensure you're counting unique days.8. Name your behavioral property (e.g., "Days Active in Last 30 Days") and save it.This behavioral property will now calculate, for each user, on how many unique days they performed the specified event within the last 30 days (or whatever time range you set).It's important to note that the exact steps and options might vary slightly depending on your specific Mixpanel setup and the current version of the platform. If you don't see these exact options, look for similar ones that allow you to count unique occurrences of an event over time.Remember, this property will give you the count of days, not the percentage. To get the percentage, you'll need to use this property in your analysis and then perform an additional calculation (dividing by the total number of days in your time frame and multiplying by 100).If you're having trouble finding these exact options or if they're not available in your version of Mixpanel, I recommend reaching out to Mixpanel's support team for the most up-to-date guidance on creating custom behavioral properties.
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! 📚
I apologize for the confusion in my previous response. After carefully reviewing the available documentation, I realize I made an error in referring to a "Data Management" section, which doesn't appear to be a standard section in Mixpanel's current interface.Instead, to create a behavioral property in Mixpanel, you should follow these steps: 1. Go to the main Mixpanel dashboard. 2. Look for a "+" or "Add" button, often located near the top of the interface. 3. Select "Behavioral Property" from the options.If you're having trouble finding this option, it's possible that the feature might be located in a different place depending on your specific Mixpanel setup or version.For the most accurate and up-to-date information on how to access and create behavioral properties in your specific Mixpanel instance, I recommend checking the Mixpanel documentation on Behavioral Properties or contacting Mixpanel's support team directly. They can provide you with the most current guidance based on your account's configuration and the version of Mixpanel you're using.I apologize again for any confusion my previous response may have caused.
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.
