Creating a Report to Analyze Event Frequency by Time of Day Over Months
how do i create a report that highlights the time of day a certain event occurs the most often over a range of several moths
Hi Tobias, 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 create a report that highlights the time of day a certain event occurs most often over a range of several months in Mixpanel, you can use the Insights report with some specific settings. Here's how you can do it:1. Start by creating an Insights report. Navigate to the Insights section in Mixpanel.2. Select the event you want to analyze in the "Select Event" field.3. For the measurement, choose "Total" or "Unique Users" depending on whether you want to count total occurrences or unique users performing the event.4. Set your date range to cover several months using the date range selector. You can use the "Custom" option to select a specific range of months Docs Reports Overview > Date Range> .5. To break down the data by time of day, add a breakdown by clicking on "Breakdown" and selecting the "Time" event property. Then choose "Hour of Day" as the breakdown option Docs Features > Advanced> .6. To visualize the data effectively, you might want to change the chart type to a bar chart or heatmap, which can better represent the distribution of events across hours of the day.7. If you want to see how this pattern changes over the months, you can add a second breakdown by "Month" or "Week" depending on your preferred granularity.This setup will show you how often your selected event occurs at different hours of the day over your chosen time range, allowing you to identify peak times of activity.Remember that Mixpanel uses the project timezone for all date and time calculations, so make sure your project timezone is set correctly for accurate results.Docs Reports > Insights: Visualize trends and compositions within your data>
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! đź“š
To add the maximum number of events that ever happened at a certain hour of day to your Insights report in Mixpanel, you can use the "Aggregate Property" measurement function. Here's how you can modify your existing report to include this information:1. In your Insights report, add a new event or metric by clicking the "+" button.2. Select the same event you're analyzing for time of day occurrence.3. Instead of using "Total" or "Unique Users" as the measurement, click on the measurement dropdown and select "Aggregate Property" under the "Event Property Values" section Docs Reports > Insights: Visualize trends and compositions within your data > Advanced > Measurements > Aggregate Property> .4. In the property selection dropdown that appears, choose the "Time" property.5. For the aggregation function, select "Maximum" from the options provided.6. Keep the breakdown by "Hour of Day" as you had in your previous setup.This configuration will show you the maximum number of events that occurred for each hour of the day across your entire date range. The "Maximum" aggregation will give you the highest count of events that ever happened for each hour, regardless of which specific day it occurred on.Remember that the maximum number of events shown will be the peak for each hour across all days in your selected date range. If you want to see this maximum alongside your original time-of-day distribution, you can keep both metrics in your report for comparison.Docs Reports > Insights: Visualize trends and compositions within your data > Advanced > Measurements> Note that there may be limits on how many segments are returned and displayed in your report, depending on your Mixpanel plan and report settings Docs Features > Advanced > Limits and Ordering> .
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.