Querying YouTube Analytics using ShufflePoint

Summary

The YouTube Analytics API is marked as 'experimental' but it seemed solid enough to get it integrated with ShufflePoint. It is pretty similar to Google Analytics in having metrics and dimensions. For a list of allowed dimension/metric combinations visit the page https://developers.google.com/youtube/analytics/v1/available_reports.

Setup

Visit "Manage Datasources" then click "YouTube Analytics". You will be asked to grant access.

Running Queries

An example query is:

SELECT
   METRICS yt:views ON COLUMNS
   DIMENSIONS yt:day ON ROWS
FROM [MyChannel]
WHERE TIMEFRAME lastMonth

Replace "MyChannel" with the name of your YouTube channel.

You can find you channel name in YouTube. Use the account dropdown located in the upper-right cornder and select "My Channel". In the resulting browser URL you will see something like:
https://www.youtube.com/user/mychannel?....
The channel name is the string after "/user/" - in this case "mychannel".

If you have a "Channel Partner" account, then there are additional metrics and dimensions you can use. We'd like to hear from you so that we can test these other metrics and dimensions.

Note the "yt" prefix which indicates YouTube. You will not see this prefix in Google's documentation - it was added to make it consistent with AQL.

YouTube Analytics Documentation

https://developers.google.com/youtube/analytics/: - YouTube Analytics API
https://developers.google.com/youtube/analytics/v1/dimsmets/mets: - Available Metrics
https://developers.google.com/youtube/analytics/v1/dimsmets/dims: - Available Dimensions