YouTube Analytics

YouTube is a free video sharing website that makes it easy to watch online videos. You can even create and upload your own videos to share with others. The YouTube Analytics API enables you to generate custom reports containing YouTube Analytics data.

How to Connect

There are two ways to connect to YouTube Analytics: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the YouTube Analytics button in the list of connectors or type ‘youtube’ in the search field and select it:

3. Click the button and follow the instructions:

Usage

The YouTube Analytics API connector introduces a new virtual schema youtube_analytics that contains the following stored procedures:

In addition to these public API procedures, there is the  youtube_analytics_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping youtube_analytics_examples.