This application demonstrates how to use the
YouTube connector for both searches across YouTube and for the Insights of videos that you own or administer.
Download
You can download the application here:
YouTube_v1.4,zipUseage
The demo application requires QVSource version 1.2.1.0 or later.
To use this demo application you will need to ensure that you are authenticated with the QVSource
YouTube connector, which you can read about setting up
here.
If you have uploaded your own videos, then you need to use the account details that manage those videos so that you can get Insights data.
Configuration
As with all our demo applications, this one is easy to configure for your own needs.
YouTube Searches
The application has been reloaded using the search terms 'QlikView' and 'Qonnections'.
You can easily edit the application for any search term. To do this open the QlikView script editor and near the top find the YouTubeSearchTerms and alter the table accordingly.
//The search terms
YouTubeSearchTerms:
LOAD * INLINE [
SearchTag, YouTubeSearchTerm
QlikView, 'QlikView'
QlikView, 'Qonnections'
];
Once you have done this, you can hit reload in the QlikView application and you should see something like this.
YouTube Insights
If you have the right credentials or have uploaded your own videos, then you can get Insights on those videos.
Although this application has Insight data, the load scripts have been set so that it does not get Insight data by default - this is because you may not have uploaded videos.
To turn this on, edit this part of the script, which is near the top:
//To get Insights data, set to 1
Let vGetInsightsData = 0;
You can get insights data for a particular date range. To set this range, again edit the script:
//Date range for the Insights data
Let vInsightsStartDate = "25-12-2011";
Let vInsightsEndDate = "25-01-2012";
The following dashboard shows the demographics of the videos
Further Enhancements
This is quite a simple application and could be expanded in many ways. For example, the comments could be processed using the
Sentiment Analysis Connector or a metric could be created that makes use of the number of views, average rating and number of comments.