Calculating Daily Users Spending Over One Hour

Hi Mana H., 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> 👋

To calculate the number of users who spend more than one hour a day in Mixpanel, you have a few different approaches:

You can create a custom property that calculates whether a user's session duration exceeds one hour (3600 seconds). Mixpanel allows you to use comparison operators in your formulas: LBKSif(A > = 3600, "More than 1 hour", "Less than 1 hour")LBKSWhere "A" would be your session duration property. You can also use the ifs function for more complex conditions: LBKSifs(A<3600, "Less than 1 hour", A> =3600, "More than 1 hour")LBKSMixpanel documentation provides these comparison operators that you can use in your formulas.

Mixpanel automatically tracks "Session Duration (seconds)" with its Session events. You can filter for sessions longer than 3600 seconds (1 hour) in your reports.As mentioned in the Sessions FAQ, you can find the average session duration using the "Session Duration (seconds)" property associated with Session Start/End events. To express this in minutes, you can use a formula to divide by 60.

Another approach is to use Mixpanel's Frequency report, which shows how frequently users return to use your product: 1. Go to Reports > Retention 2. Select the "Frequency" option under the toggle for retention 3. Set your time interval to "day" and addiction unit to "hour"This will show you how many users were active for a specific number of hours in a day. In the example from the documentation, you would look at users who were active for at least 2 hours (which would be the second value in the array for each date).

You can also use Insights with custom bucketing to visualize the distribution of session durations: 1. Create an Insights report with your session event 2. Break down by "Session Duration (seconds)" 3. Use Custom Bucketing (from the overflow menu) to create buckets like "0-3600" and "> 3600"This approach is mentioned in the Insights documentation under Custom Bucketing.By using any of these methods, you'll be able to identify and count users who spend more than one hour a day in your product.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.