How can I import hours watched from Bitmovin Analytics to Google Data Studio?

Following the blog post below, I have managed to link Bitmovin’s analytics system to Google’s Data Studio and import number of impressions but it is not clear how to retrieve other metrics such as hours watched. How do I do this?

I have found by using the following guide, it is possible to extract this data:

Along with the screenshot in the guide linked in the original post:

This is created by clicking ‘Add Metric’, then ‘Create Field’ and writing this in the function:
SUM(Dimension/1000/60/60)

The other values to change are in the parameters section to the following:
Screenshot 2022-05-17 at 09.55.48

In text form here:
Aggregation: SUM
Dimension: PLAYED
Filter: {"name":"PLAYED","operator":"GT","value":0}

1 Like