Data Studio
2.9K members online now
2.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Creating a New Metric for YouTube Average Percentage of Video Viewed

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I've connected YouTube Channel as data source and can pull in the Watch Time metric, which is see is the average watch time. But for a collection of different length videos, it would be more helpful to see on average, or per video, what is the average percentage of video watched. 

 

Is there someway to use a calculated field to do this? Or, some other way people are using in Data Studio to make video engagement metrics more visible?

Creating a New Metric for YouTube Average Percentage of Video Viewed

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I too am trying to figure this out. 

 

Currently I have the watch time in one column, but there isn't a straight forward option to show the percentage watched of a video.

 

I am wondering if somehow I have to edit the formula of Watch Time which is:

 

t0.watch_time_msec/1000

 

Any help would be greatly appreciated!