Need Help Extracting Event Duration Metrics from Mixpanel Data | Mixpanel Community

Need Help Extracting Event Duration Metrics from Mixpanel Data

Hi All, We have created Mixpanel Data pipeline which load event data to Snowflake. In event data, we are getting time when event happened but we want to get Duration (For how much time event was happened) metrics as well in data. We have duration metrics on MixPanel dashboard but not able to find out duration metrics in event data. Can someone please help you to get event duration data ? Please see attached screenshot.

🎫1

9 comments

Sureshkumar S.
·
·
kapa.ai - Can you please check this
kapa.ai
APP
·
·
Please stand by Sureshkumar S. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
I need more specific information about what you'd like me to check regarding Mixpanel. Could you please provide more details about your question? I'm here to help with any Mixpanel-related inquiries about implementation, debugging, data validation, tracking methods, or other features of the platform.
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.
Sureshkumar S.
·
·
Hi All, We have created Mixpanel Data pipeline which load event data to Snowflake. In event data, we are getting time when event happened but we want to get Duration (For how much time event was happened) metrics as well in data. We have duration metrics on MixPanel dashboard but not able to find out duration metrics in event data. Can someone please help you to get event duration data ? Please see attached screenshot.
Sureshkumar S.
·
·
kapa.ai
kapa.ai
APP
·
·
Sorry Sureshkumar S., I'm not sure what you mean. Please try again. 👋
Sureshkumar S.
·
·
Can you please check this thread an reply
Sureshkumar S.
·
·
🎫
Thena
APP
·
·
Hi Sureshkumar! Julianne from Mixpanel Support here. Diving right in, the screenshot appears to show the virtual computed 'Duration' property. If so, I hate to be the bearer of bad news, but the data pipeline is only expected to export raw event data. Since the 'Duration' computed property is calculated within the Mixpanel application, it isn't expected to be exported. In Mixpanel, the 'Duration' property is calculated by looking at the difference in the timestamp for the events for a user. For example, in the screenshot provided, the duration is the time between each 'DMG Viewed Invoice Manager Listing' tracked by the user. This means you can replicate the logic in Snowflake to calculate the duration after the data is exported.