We are publishing a video view event every 15 seconds until the video is completed or the user closes the tab/viewer. I would like compute the approximate time that the video is counting all the video view event for that user and that specific video. Is there a way I can do that ?
Best answer by JennRu
View original
+10
can you show what the event looks like? what properties does it have?
+8
+1 to Timothy’s inquiry above ^
Does this Video View event contain a duration or time spent event property?
If the event does not contain this metadata, you could try a proxy formula such as (TOTALS(A) * 15)/60
where A = Video View event * 15 seconds and then / by 60 seconds to yield a result in minutes
Then you can group by User ID and then group again by the video identifier event property e.g. video id or video name or video url
If you are tracking video duration as an event property, then you can use the “Average of Property Value” metric to get the average duration per day as seen in this demo chart -https://analytics.amplitude.com/demo/chart/new/tdo4rzkg
You can further use a group by on User ID to see the averages of individual users or filter on a given User ID. And a second group by on the video identifier property.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
