Analytics Log - Adil Khan

View Original

How to Filter YouTube Metrics By Video Upload Month in Google Data Studio

So, there’s a native YouTube data connector for Data Studio and it can show you most of the relevant video metrics in your Data Studio dashboard. What happens if you only want to show metrics for content that was uploaded during a particular reporting month? [We’ll use month as an example here].

The default report shows metrics for all content that was previously uploaded, if it was within your requested date range.

AFAIK, there’s no option to filter this natively. IF there is, please let me know via comments. Till then, will use a trick in Google Sheets to create a BOOLEAN output, TRUE/FALSE and use it as a helper column.


Let’s say your Sheets contain the below columns with these sample values:

  • Column A / Report Month / 8/30/2018

  • Colum B / Video upload date / 8/15/2018

  • Colum C / Video titlte / ‘Cool video title goes here’

  • Column D / Views / 100

You can now add a new column and run this formula to match if the value created by concatenating month&year of column A = month&year of Column B, return TRUE [ELSE, False]

See this content in the original post

Putting the = sign in between automatically makes this a Boolean [no need to build IF / ELSE condition]

Data Studio does not allow you to have an = sign in the custom formula [yet]


You can now setup your filter in Data Studio like this.



Once done, apply the filter to widgets/pages to create to create tables that only show metrics for content that was uploaded in a particular report month.

See this form in the original post