I have an event A (experiment view) with different options (A1, A2, A3). Event A can be performed only one time per session. and an event B that can be sent a few time per session. I want to see the average number of B events brokedown by A options (A1, A2, A3). How can I do that ?
Hi Romane T., 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 analyze the average number of event B occurrences broken down by the options of event A (A1, A2, A3) within a session, you can use Mixpanel's Insights report with the "Aggregate Property per User" measurement. Here's how you can set this up: 1. Start a new Insights report.2. For the first event, select your event A (experiment view).3. For the measurement, choose "Aggregate Property per User" from the dropdown menu.4. In the property selection, choose the property that distinguishes between A1, A2, and A3 options.5. For the second event, select your event B.6. For the measurement of event B, choose "Aggregate Property per User" again.7. This time, select "Count" as the property to aggregate.8. In the "Group by" section, select the property that distinguishes between A1, A2, and A3 options for event A.9. Finally, choose "Average" as the aggregation method for the "Aggregate Property per User" measurement.This setup will calculate the average number of event B occurrences per session for each option of event A (A1, A2, A3).For more detailed information on using "Aggregate Property per User" in Insights, you can refer to the Mixpanel documentation on Measurements.Keep in mind that this approach assumes that your events are properly structured and that you're tracking sessions correctly. If you need to make any adjustments to your event structure or session tracking, you may need to modify your implementation accordingly.
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 providing that clarification. I understand that A1, A2, and A3 are actually 7 different string values rather than numeric options. This doesn't significantly change the approach, but it's good to know for clarity.Given this information, you can still use the Insights report with the "Aggregate Property per User" measurement as I described earlier. The process remains largely the same, but instead of A1, A2, and A3, you'll be dealing with 7 different string values. Here's how you can adjust the setup: 1. In the Insights report, set up event A (experiment view) as the first event.2. For the measurement, use "Aggregate Property per User".3. Select the property that contains your 7 different string values.4. Set up event B as the second event.5. For event B's measurement, use "Aggregate Property per User" and select "Count" as the property to aggregate.6. In the "Group by" section, select the same property you used for event A that contains the 7 string values.7. Choose "Average" as the aggregation method.This setup will calculate the average number of event B occurrences per session for each of your 7 string values from event A.The result will show you a breakdown of the average number of B events per session for each of the 7 string options from event A. This allows you to compare how the different experiment views (represented by the 7 strings) correlate with the frequency of event B.For more details on using breakdowns and aggregations in Insights, you can refer to the Mixpanel documentation on Measurements.If you need any further clarification or have additional questions about setting up this analysis in Mixpanel, please don't hesitate to ask.
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.
