Skip to main content

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 ?

can you show what the event looks like? what properties does it have?

+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.

Reply


Terms & ConditionsCookie settings