YouTube automatically generates a set of system-managed ad revenue reports for content owners that have access to the corresponding reports in Creator Studio. These reports are designed to provide programmatic access to data that is also available in manually downloadable reports accessible in the Reports section of the YouTube Creator Studio.
Note: The API provides access to a different set of reports than Creator Studio, though the reports contain similar data. API reports might have different fields and also use different field names than Creator Studio reports.
Since YouTube automatically generates system-managed reports, the process for retrieving these reports is different than for the YouTube Analytics bulk data reports available via the API.
The following steps explain how to retrieve system-managed reports via the API.
Step 1: Retrieve authorization credentials
All YouTube Reporting API requests must be authorized. The Authorization guide explains how to use the OAuth 2.0 protocol to retrieve authorization tokens.
YouTube Reporting API requests use the following authorization scopes:
|https://www.googleapis.com/auth/yt-analytics.readonly||View YouTube Analytics reports for your YouTube content. This scope provides access to user activity metrics, like view counts and rating counts.|
|https://www.googleapis.com/auth/yt-analytics-monetary.readonly||View YouTube Analytics monetary reports for your YouTube content. This scope provides access to user activity metrics and to estimated revenue and ad performance metrics.|
Step 2: Retrieve the job ID for the desired report
jobs.list method to retrieve a list of system-managed jobs. Set the
includeSystemManaged parameter to
reportTypeId property in each returned
Job resource identifies the type of system-managed report associated with that job. Your application needs the
id property value from the same resource in the following step.
Step 3: Retrieve the report's download URL
jobs.reports.list method to retrieve a list of reports created for the job. In the request, set the
jobId parameter to the job ID of the report that you want to retrieve.
You can filter the list of reports using any or all of the following parameters:
createdAfterparameter to indicate that the API should only return reports created after a specified time. This parameter can be used to ensure that the API only returns reports that you have not already processed.
startTimeBeforeparameter to indicate that the API response should only contain reports if the earliest data in the report is before the specified date. Whereas the
createdAfterparameter pertains to the time the report was created, this date pertains to the data in the report.
startTimeAtOrAfterparameter to indicate that the API response should only contain reports if the earliest data in the report is on or after the specified date. Like the
startTimeBeforeparameter, this parameter value corresponds to the data in the report and not the time the report was created.
The API response contains a list of
Report resources for that job. Each resource refers to a report that contains data for a unique period.
- The resource's
endTimeproperties identify the time period that the report's data covers.
- The resource's
downloadUrlproperty identifies the URL from which the report can be fetched.
- The resource's
createTimeproperty specifies the date and time when the report was generated. Your application should store this value and use it to determine whether previously downloaded reports have changed.
Step 4: Download the report
Send an HTTP GET request to the
downloadUrl obtained in step 4 to retrieve the report.
Applications that use the YouTube Reporting API should always follow these practices:
Use a report's header row to determine the ordering of the report's columns. For example, do not assume that views will be the first metric returned in a report just because it is the first metric listed in a report description. Instead, use the report's header row to determine which column contains that data.
Keep a record of the reports you have downloaded to avoid repeatedly processing the same report. The following list suggests a couple of ways to do that.
Each time you retrieve and successfully process reports, store the timestamp corresponding to the date and time when the newest of those reports was created. Then, update the
createdAfterparameter value on each successive call to the
reports.listmethod to ensure that you are only retrieving new reports, including new reports with backfilled data, each time you call the API.
As a safeguard, before retrieving a report, also check to ensure that the report's ID is not already listed in your database.
Store the ID for each report that you have downloaded and processed. You can also store additional information like the date and time when each report was generated or the report's
endTime, which together identify the period for which the report contains data. For reports that retrieve bulk data for YouTube Analytics, each job will likely have many reports since each report contains data for a 24-hour period. System-managed jobs that cover longer time periods will have fewer reports.
Use the report ID to identify reports that you still need to download and import. However, if two new reports have the same
endTimeproperty values, only import the report with the newer
API reports are versioned
.csv (comma-separated values) files that have the following characteristics:
Each report contains data for a unique period lasting from 12:00 a.m. Parcific time on the report's start date through 11:59 p.m. Pacific time on the report's end date.
Report data is not sorted.