Querying YouTube Analytics using ShufflePoint
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.
Visit "Manage Datasources" then click "YouTube Analytics". You will be asked to grant access.
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:
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
- - YouTube Analytics API
- - Available Metrics
- - Available Dimensions