YouTube Enterprise Advanced Connector
Intro
You can use Domo's YouTube Enterprise connector to retrieve viewing statistics, popularity metrics, and demographic information for YouTube videos and channels. To learn more about the YouTube API, visit their page (https://developers.google.com/youtube/).
Note: There are currently 3 YouTube connectors available in Domo. The difference between these may be difficult to understand, so here is an explanation of each:
-
YouTube Reporting. This is our entry-level YouTube connector. It requires only a Google username and password to authenticate. Most Domo users should use this connector to retrieve YouTube data.
-
YouTube Reporting Enterprise. This is the enterprise version of the YouTube Reporting connector. This report has a few additional reports and requires you to enter a Google Client ID and Client Secret in addition to a basic Google username and password.
-
YouTube Enterprise Advanced. This is Domo's most advanced YouTube connector. (This is the only version of the YouTube Enterprise connector; there is no connector simply called "YouTube Enterprise.") It requires a Google Client ID and Client Secret as well as a Google username and password. It provides more reports and options than the other YouTube connectors but is also more complicated and much more difficult to configure. This connector is recommended for advanced users only.
The YouTube Enterprise connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window.
You connect to your YouTube Enterprise account in the Data Center. This topic discusses the fields and menus that are specific to the YouTube Enterprise connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
Best practices
When you first power up the connector and request historical data, it takes around 30 days to bring in all the data. This is due to how the YouTube API functions. For example, if a report is first started on April 1, data from April 1 onward will be available 24-48 hours later. Every day, a few more days prior to April 1 will be available. After around 30 days, 6 months of backfill data will have been added to the report (though it comes in a rather sporadic order). In this example, by April 30 the user should end up with 7 months of —datadata for April, plus the 6 prior months.
Prerequisites
To connect to your YouTube Enterprise account and create a DataSet, you must have the following:
-
A Google Client ID.
-
A Google Client Secret.
-
A Google username and password.
For step-by-step instructions on obtaining a Client ID and Client Secret, see https://support.google.com/cloud/answer/6158849.
You must also enable the Google People API to properly configure this connector. For more information about this API, see https://developers.google.com/people/?hl=en_US.
Connecting to your YouTube Enterprise account
This section enumerates the options in the Credentials and Details panes in the YouTube Enterprise Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
Credentials pane
This pane contains fields for entering credentials to connect to your YouTube Enterprise account. For information about obtaining these credentials, see "Prerequisites," above. The following table describes what is needed for each field:
Field |
Description |
---|---|
Client ID |
Enter your Google Client ID. |
Client Secret |
Enter your Google Client Secret. |
After you have entered valid credentials, you are taken to Google's OAuth page where you are prompted to enter your Google username and password. Once you have successfully authenticated, you can use the same account any time you go to create a new YouTube Reporting Enterprise DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.
Details pane
This pane contains two primary menus, API and Report, along with other menus which may appear depending on the selected API and report type.
Menu |
Description |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
API |
Select your YouTube Enterprise API type. Depending on the API you select, a different set of reports is available. You can choose from the following APIs:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Report (Analytics API) |
Select the desired Analytics API report.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Report (Ad Performance) |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Report (Content ID API) |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Report (Content Owner) |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Report (Data API) |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Call on Behalf of Content Owner |
Select Yes if you are planning to retrieve a report for another user (whose ID you will enter in the Content Owner ID field). Select No if you are the content owner for the report you plan to pull. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Content Owner ID |
Enter the ID of the content owner you want to pull data for. If you do not know the ID, ask your partner manager. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
User IDs |
Enter comma-separated IDs for the users you want to retrieve data for. A user’s ID is located at the end of the URL for his YouTube channel. For example, in the URL https://www.youtube.com/user/google, “google” is the user ID. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Video ID |
Enter the ID of the video you want to retrieve comments for. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Region |
Select the country or region you want to pull data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Videos Published After (Days Ago) |
Enter a number of past days to retrieve data for all videos published after that date. For example, if you entered 20, your report would contain information on all videos published within the last 20 days. If you leave this field blank, you will get a breakdown of all videos. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Videos Published Before (Days Ago) |
Enter a number of past days to retrieve data for all videos published before that date. For example, if you entered 20, your report would contain information on all videos published more than 20 days ago. If you leave this field blank, you will get a breakdown of all videos. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Playlist |
Select the playlist you want to retrieve data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Legacy Reporting Mode |
Advanced use only. This is to enable support with data sources made with an old version of the connector. When set to True, the report includes columns that are no longer reported,or whose meanings have changed. For the Videos report, the "kind", "id_kind", and "id_videoId" columns are different or available. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Number of Days Ago |
Enter the most recent past day for which you want to retrieve data. For example, you would enter 2 to get data for the day before yesterday. YouTube does not usually report data less than 2 days old. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Backfill Days |
Enter the number of days prior to Number of Days Ago for which you want to retrieve data. For example, if you entered 7 for Number of Days Ago and 14 for Backfill Days, your report would contain data for all of the days in the week before last. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Prior Days |
Enter the number of days prior to Number of Days Ago for which you want to retrieve data on the second and subsequent runs of the data source. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Dimension |
Specify whether you want a daily or summarized report. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
US State |
Select the U.S. state you want to pull data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Traffic Filter |
Select a traffic option to filter by. For example, if you selected Google Search, only information related to Google would appear in your report. |
Other panes
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.
FAQs
1. Can I pick any invalid accounts from the "Account or Brand" part of OAuth?
Yes, the YouTube Reporting Enterprise connector supports the OAuth2.0 authentication protocol. So, the account validation is a part of the OAuth2.0 mechanism that uses the Client ID and Client Secret associated with a YouTube App (with different YouTube APIs) that the client has registered with Google.
2. When creating accounts in Domo, can I have two different accounts with different brands and the same main account?
According to the connector's current version observations using the test account, it seems that the account may be overridden at Domo if a brand account is used when a main account is already configured.
3. Do I need any specific permissions to pull channel data?
Yes. To retrieve the channel data; the application must switch on or enable the services for "YouTube Data API" in the project from Developer Console's (https://console.developers.google.com/).