follow us in feedly
How to filter YouTube Metrics By Video Upload Month in Google Data Studio

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.

DataStudio Fields - YouTube - 1.JPG


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]

=month(A2)&year(A2)=month(B2)&year(B2)

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]

DataStudio Custom Formula equal to operator not supported.JPG


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



DataStudio Boolean Filter For Video Uploaded Month.JPG

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.





How To Find Out Your Entire Website's PageSpeed Insights Score Using Screaming Frog Crawler

How To Find Out Your Entire Website's PageSpeed Insights Score Using Screaming Frog Crawler

How To Automate Facebook Page Reporting in Google DataStudio

How To Automate Facebook Page Reporting in Google DataStudio