Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

NOTE: We also have a dedicated connector to the YouTube Data API.


What It's For

Whereas the YouTube Data Connector allows you to get some pre-defined insights into your videos' usage and perform searches across all the public videos, the YouTube Analytics Connector focuses entirely on your channels and videos, enabling you to create your own customised reports.

Usage

Firstly you need to authenticate with your YouTube account, which you need to ensure is able to administrate the channels you want to report on.

From QVSource select the YouTube Analytics Connector and either double click it or press the 'Configure' button, which will display the Connector's configuration screen. Click on the 'Authenticate' button

Image

When prompted enter your YouTube account details and when asked to give QVSource permissions on your account, click 'Accept'.

Image

Having done this you'll see the 'Token' box has been populated with your token.

Now you can check that you are authenticated properly with YouTube. Select the 'CanAuthenticate' table on the list of tables on the left, then click on the 'Run Table/Generate Script' button along the bottom. On doing this the table on the right side will populate and should say under the 'authenticated' column, 'true'.

Image

Getting Your User and Channel IDs

In order to generate report using the YouTube Analytics API you will need to have your YouTube USER_ID and/or the CHANNEL_IDs.

There are two ways to do this.

Manually

You can manually retrieve these from your YouTube account by accessing this link and being logged into Google with your YouTube account.

Image

Through QVSource

Alternatively, you can select the MyID or MyChannels tables where on clicking 'Run Table' you will be presented with the IDs on the right.

Image

Reports

In creating reports it takes a little bit of thought and consideration as you have a high degree of flexibility - as you can see in the following screenshot you can define which metrics and dimensions you want to work with.

Image

The first thing you need to do is to enter set the channel to be your userID. So, you need to type 'channel==[MyID]' into the 'ids' box - you can get the ID as described above and be sure to put a double equals sign.

Image

You will most probably need to reference the YouTube documentation to understand the metrics and dimensions available. You can find the dimensions here and the metrics here.

Also very useful is this page showing valid combinations of inputs for various types of content owner reports and this page which does similar for channel reports].

As an example we want to look at the number of views by country.

So, from the metrics documentation we can see that we need the 'views'

Image

and from the dimensions we need the 'country'

Image

So, in QVSource we enter the date range, the metric (views) and dimension (country). Then click the 'Run Table' button to populate the table on the right.

Image

Optional Parameters

Some reports can take Filters, Sort and in some cases there is a Maximum Number of results.

Note the following 2 pages show descriptions of different types of reports that the API supports (i.e. valid combinations of dimensions, metrics and filters):
Please note that if there is a maximum number of results and you do not set it, you will get an error back.

As an example we want to look at the number of views by video. We can see from the documentation that we need to sort by the views and there is a maximum of 10 results.

Image

So, we enter these details into QVSource

Image

This posting explains quite well how to work with these limitations.

Troubleshooting

If you are not getting back the data you expect, it is likely this is not a QVSource issue but rather a question in general about the YouTube Analytics API and we would recommend asking about it on the forums.

YouTube Analytics API

Quota Limits

There are some quota limits, although there are no set levels. Instead, Google give a guide to the kinds of quota limits you can find out more information here.

As a general rule though, try not to include too many metrics in your reporting as even having just 3 metrics is classified as having a 'very high quota cost'.

Changelog

You can view the YouTube Analytics API Changelog here.

Change Log

1.0.4 - 16/12/15
  • Added quotaUser parameter to Report and MyChannels tables which helps enforce per user quota limits.

1.0.3 - 02/06/15
  • Added the https://www.googleapis.com/auth/yt-analytics-monetary.readonly scope for authentication.
  • Updated description on Report table.

1.0.2 - 22/05/15
  • Upgraded to use new OAuth2 framework.
  • Minor performance improvements.
  • Table names should now be logged as part of API logging.

1.0.1 - 30/01/14
  • Add links in notes for Report table to pages on YouTube docs.
  • Added missing end points to About tab.

1.0.0 - 03/01/14
  • Taken out of beta.

0.9.0 - 09/07/13
  • Added request for permission to read monetary values during authentication.

0.9.0 - 09/07/13
  • Added max results and sort inputs.

0.8.0 - 08/07/13
  • Initial version.


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd