YouTube Reporting Partition Connector

Intro

YouTube Reporting Partition supports predefined reports and Jobs reports that contain a comprehensive set of YouTube Analytics data for a channel or a content owner. Use Domo's YouTube Reporting partition connector to download the bulk data sets that you can query with the YouTube Analytics API. This connector allows you to connect your YouTube analytics to Domo to refine your YouTube strategy.

The YouTube Reporting Partition 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 Reporting account in the Data Center. This topic discusses the fields and menus that are specific to the YouTube Reporting Partition 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.

Note: When you create a report using this connector, a job is created and takes 24 hours to return data.

Primary Use Cases	Pulling all video metrics across channels, devices, location so you can understand how people are consuming video content on YouTube.
Primary Metrics	Number of views Channel details and statistics Video details and statistics Public channel information Number of comments
Primary Company Roles	Content creators Digital asset managers Digital marketers Content asset managers
Average Implementation Time	If you pull predefined, standard reports, you could have any report up and running within a couple of hours. If you need more than 180 days of history or if you want to pull in millions of rows, implementation could take up to 30 hours.
Ease of Use (on a 1-to-10 scale with 1 being easiest)	5

Best Practices

In order to pull metrics for a channel, the owner of the provided credentials must be the owner of that channel.
You will only be able to backfill 60 days of history when the report is configured.
If you are using Content Manager or are pulling metrics "On behalf of the content owner," you should use the YouTube Reporting Enterprise connector. This will allow you to pull metrics for channels that you are not the direct owner of. Additionally, YouTube can update metrics for any report for up to 30 days of that activity. It is recommended that you set up up the connector to replace at least 35 days of history. To build history beyond 180 days, you must setup a recursive DataFlow to capture that information going forward. For more information, see Creating a Recursive/Snapshot Magic ETL DataFlow.
DataSets should run only ONCE within a 24-hour period because the data is updated only once a day.
When a Report is created a job is generated and takes 24 -72 hours before returning data. After you schedule a reporting job, YouTube generates reports from that day forward and also generates reports covering the 180-day period prior to the time the job was scheduled.
Any date prior to the Job creation date for a Report Type is considered historical. YouTube will generate up to about 6 months of historical data (180 days). Historical reports are posted as soon as they are available and in no particular order. It takes roughly one month for all of the historical data to be posted for a job. So, a month after scheduling a reporting job, you will have access to around seven months of data.

Prerequisites

To connect to your YouTube account and create a DataSet, you must have a Google email address and password.

Connecting to Your YouTube Reporting Account

This section enumerates the options in the Credentials and Details panes in the YouTube Reporting Partition 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

The Domo YouTube Reporting Partition connector uses OAuth to connect, so there is no need to enter credentials within Domo. Click Connect (or select Add Account if you have existing YouTube Reporting accounts in Domo) to open the YouTube Reporting OAuth screen where you can enter your Google credentials. Once you have entered valid Google credentials, you can use the same account any time you go to create a new YouTube Reporting Partition 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.

Note: If you are already logged into Google when you connect in Domo, you are authenticated automatically when you click Add account. If you want to connect to an account that is different from the one you are logged into, you must first log out of your Google account.

Details Pane

This pane contains a primary Reports menu from which you can select a Jobs report or predefined report or other reports. If you select a predefined report, various other menus may or may not appear depending on the configuration options you select.

Menu

Description

Report

Select the YouTube Reporting Partition report you want to run. The following reports are available:

Available Reports	Returns the list of available reports based on report type.
Channel Details and Statistics	Returns Content Details, Snippet, and Statistics data for the authenticated channel.
Jobs	Lists reporting jobs that have been scheduled for a channel or content owner.
Other Video Details and Statistics	Returns Content Details, Snippet, and Statistics data for the specified Channel Ids
Predefined Report Types	Predefined Report types that the channel or content owner can retrieve.
Public Channel Information	Returns public information of channels entered.
Video and Channel Names	Returns the list of video and channel names.

Call on Behalf of Content Owner

Select Yes if you are planning to retrieve a predefined 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 content owner ID for the user with content you want to pull. To find your content owner ID, you must be a member of an MCN (Multi-Channel Network). For more information, see https://support.google.com/youtube/answer/2737059?hl=en.

To find your content owner ID, do the following:

Log into YouTube.
Click your profile picture in the top right.
Select Studio in the dropdown menu.
Copy the portion of the page URL following o=.

For example, if the page URL was https://www.youtube.com/dashboard?o=abc123_qrs_654, the content owner ID would be abc123_qrs_654.

Report Types

Select the predefined report you want to run. The list of reports available to you is based on what you are authorized to see. For this reason, we do not offer a list of report descriptions for this connector.

Preserve Column Names

Determines whether to preserve column names within a dataset when a report is changed.

NOTE: Best Practice is to preserve column names to keep cards that depend on those column names from breaking when a report is changed.

Channel IDs

Enter a Channel ID or comma separated list of Channel IDs.

Retrieve Video and Channel Names

Specify whether you want to retrieve video and channel names when a Video or Channel ID or both are present in a report.

Duration

Select whether you want to pull data for a specific date or a date range.

Report Date

Select whether the report data is for a specific date or for a relative number of days back from today.

Select Specific Date

Select the date for the report.

Days Back

Enter the number of past days that should appear in the report.

Start Date

Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date.

End Date

Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date.

Select Specific Start Date

Select the first date in your date range.

Select Specific End Date

Select the second date in your date range.

Days Back to Start From

Enter the number of the farthest day back that should be represented in the report. Combine with Days Back to End At to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago.

Days Back to End At

Enter the number of the most recent day back that should be represented in the report. Combine with Days Back to Start From to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago.

Backfill Days

Enter the number of backfill days.

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

What kind of credentials do I need to power up this connector?

You need a Google account that is either an owner or manager of a YouTube channel.

How frequently will my data update?

When you first kick off a Report Type with the connector it may take 48-72 hours before the report you request is generated for that day. YouTube will then process a daily report every day going forward.
The daily reports are only updated once every 24 hours.

IMPORTANT: For historical data (data for dates that are prior to the date you initially kicked off the report), it may take approximately 30 days to generate. Historical data may appear in random order until 30 days has passed. YouTube only generates 180 days of historical data from the date the Report Type was kicked off.

What's the difference between the YouTube Reporting and YouTube Reporting Partition Connectors?

The YouTube Reporting Partition connector supports Date partitioning and backfilling for the Available Reports and Predefined Report Types.

I've waited 3 days and no data has been returned. Why?

Confirm that you authenticated with a Channel and not a user (a user can have videos that are not part of a channel which have no statistics). If still seeing issues, contact Domo Support.

I keep seeing this error messgage: "Domo is ready, but encountered a maximum allowed usage exceeded. If the issue persists contact the data provider for support."

Your account has made too many requests for a report.
NOTE: YouTube only generates a report every 24 hours. Run the report a maximum of once per day.

Troubleshooting

YouTube only allows you to pull 180 days of history when setting up a report. When you first run a report, it may take 24-48 hours before data is available. Additionally, YouTube can update their metrics for any report for up to 30 days of that activity.