Creating a Report for Average Duration Between Events

Hi Karen 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> 👋

To create a report showing the average duration between two events along with another event property in Mixpanel, you can use the Insights report. Here's how you can set it up: 1. Go to the Insights report in Mixpanel.2. In the query builder, select "Aggregate Property" as your measurement type.3. Choose the event you want to measure the duration for.4. Select the "Session Duration (seconds)" property, which is automatically created by Mixpanel for session events.5. Choose "Average" as the aggregation type.You can then add breakdowns or filters based on other event properties you're interested in analyzing alongside the average duration.For a more detailed guide on using Aggregate Properties in Insights, you can refer to the Mixpanel documentation on Aggregate Property measurements.If you need to measure the duration between two specific events rather than using the built-in session duration, you may need to implement custom timing using the timeEvent method when tracking your events. This is described in the iOS SDK documentation on Timing Events, but the concept applies to other platforms as well.Remember that the exact steps might vary slightly depending on your specific Mixpanel setup and the events you're tracking. If you need more specific guidance, you may want to consult with your team's Mixpanel administrator or reach out to Mixpanel support.

ℹ️ 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 understand you want to measure the average time between the "bank linking completed" event and when the "bank account bind at" profile property is set. This is a more complex scenario that requires careful consideration of how Mixpanel handles events and profile properties. Unfortunately, the knowledge sources provided don't contain specific information on how to directly measure the time between an event and a profile property update.However, I can suggest a potential approach based on the available information: 1. First, ensure that you're updating the "bank account bind at" profile property with a timestamp when the bank account is actually bound.2. You might need to use Mixpanel's JQL (JavaScript Query Language) to create a custom query that can compare the timestamp of the "bank linking completed" event with the "bank account bind at" profile property.3. Alternatively, you could consider tracking an additional event when the bank account is bound, which would allow you to use Mixpanel's built-in time measurement features between two events.For more advanced queries like this, you might find the JQL Builtins helpful. The JQL Builtins documentation provides information on functions like mixpanel.reducer.avg() which could be useful for calculating average time differences.However, without more specific information about your exact setup and data structure, I can't provide a definitive solution. This kind of complex analysis might require custom implementation or consultation with Mixpanel's support team.If you need a more precise answer, I recommend reaching out to Mixpanel's support team or consulting with a Mixpanel expert who can look at your specific project setup and data structure.

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