On This Page
YouTube Analytics provides you reports that help you understand channel performance and expenses and user base of your videos to help you boost and manage your views. You can also generate reports around the monetary spends and ad performance.
Reports are classified into two categories depending on the account permissions of the user generating these:
Channel Reports: Reports that provide details of statistics and trends of a particular YouTube channel.
Content Owner Reports: Reports that provide an aggregation of all statistics related to the YouTube channels that a user owns.
These reports are generated using YouTube’s Bulk API.
A functioning YouTube account with access to at least one YouTube channel.
The user has Viewer or Owner channel access, for generating channel reports.
The user has Content Owner or Content Manager access, for generating Content Owner reports. To verify access, check if your Youtube Studio URL appears as:
https://www.youtube.com/analytics?o=. If not, then contact your YouTube content owner to grant you access.
Content Owner is an umbrella account that owns one or more YouTube channels and the videos on those channels. Content Manager is a user who has been granted rights to administer the content for a Content Owner. Read more.
Note: Content Owner/Content Manager access allows you to generate Channel reports also.
Configuring YouTube Analytics as a Source
Perform the following steps to configure YouTube Analytics as a Source in Hevo:
Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select YouTube Analytics.
In the Configure your YouTube Analytics Account page, click + ADD YOUTUBE ANALYTICS ACCOUNT.
Authorize Hevo using the Google account that has Content Owner/Content Manager access, if you want to generate Content Owner reports.
In the Configure your YouTube Analytics Source page, specify the following:
Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
Content Owner: The Youtube content owner account for which you want to generate reports.
Channel Reports: One or more channel reports that you want to load to the Destination.
Content Owner Reports: One or more content owner reports that you want to load to the Destination.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.
In YouTube, a job has to be explicitly triggered to generate the Reports. Hevo triggers this job when you create the Pipeline, and once the reports are ready, Hevo fetches these. The first time the reports are triggered, it takes up to two days for these to get generated.
The reports are generated daily and contain data that is two days old. This is loaded as rows in the Destination. If on a given day, there is no data for a report, YouTube generates an empty report. In such a case, Hevo does not make any update in your Destination, that is, no NULL rows are added to the Destination. The position in the Pipeline Overview page reflects the date of creation of the reports.
For example, if a report is created on 10th June 2020, then the data in this report will be up till 8th June 2020.
|Default Pipeline Frequency||Minimum Pipeline Frequency||Maximum Pipeline Frequency||Custom Frequency Range (Hrs)|
|1 Hr||15 Mins||24 Hrs||1-24|
Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.
Historical Data: By default, Hevo loads reports for up to 30 days prior to the date the Pipeline is created. For example, if you create a Pipeline on Oct 1st, then, you would get the historical reports from Sept 1st.
The historical reports are retained for 30 days. If you refresh an object (report) using Restart or Change Position option, you can obtain the historical reports only if any historical report period remains within the last 30 days.
For example, if the Pipeline was created on Oct 1st, and on Oct 10th, you change the position to Oct 1st, then, you would get historical reports from Sept 10 to Oct 1 (remaining historical report period).
However, if you change the position on Nov 5th, you cannot retrieve the historical reports as these are saved only for 30 days from Pipeline creation, which would be Nov 1st in this case.
Incremental Data: After the Pipeline is created, each run of the Pipeline fetches any new reports that were generated since the previous run.
Incremental reports (generated after Pipeline creation date) are retained for 60 days.
If you change the position for incremental reports, then, you can get the data for up to 60 days prior.
For example, if a Pipeline is created on Oct 1st, and on Dec 5th you change the position to Oct 2nd, you would get reports for Oct 5th to Dec 5th, in accordance with the 60 days retention stipulation.
Data Refresh: YouTube generates backfill data reports along with daily reports, and Hevo loads these reports in each run.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination:
The following reports (objects) are created at the Destination when you run the Pipeline:
|channel_video_user_activity||User activity statistics for channels and their videos.|
|channel_video_user activity_by_province||User activity statistics for channels and their videos, segmented by province.|
|channel_video_playback_location||Statistics related to the type of page or application where video playbacks occurred.|
|channel_video_traffic_source||Statistics related to sources which led a viewer to the videos.|
|channel_video_device_type_and_operating_system||Statistics related to a viewer’s device type and operating system.|
|channel_video_viewer_demographic||Statistics related to viewers’ age group and gender.|
|channel_video_content_sharing_by_platform||Statistics related to frequency and type of sharing platform.|
|channel_video_annotation||Statistics related to annotations that display during a channel’s videos.|
|channel_video_card||Statistics related to performance of individual cards.|
|channel_video_end_screen||Statistics related to end screens that display after a video stops playing.|
|channel_video_subtitle||Statistics related to subtitles and language used in the videos.|
|channel_video_combined||Statistics for videos obtained by combining dimensions used in the playback location, traffic source, and device/OS reports.|
|channel_playlists_user_activity||User activity statistics for playlists and its videos.|
|channel_playlists_user_activity_by_province||User activity statistics for playlists & its videos, segmented by province.|
|channel_playlists_playback_location||Statistics related to the type of page or application where playlist playbacks occurred.|
|channel_playlists_traffic_source||Statistics related to sources which led the viewer to the playlist.|
|channel_playlists_device_type_and_operating_system||Statistics related to viewer’s device type and operating system.|
|channel_playlists_combined||Statistics for playlists obtained by combining dimensions used in the playback location, traffic source, and device/OS reports.|
|CONTENT OWNER REPORTS|
|content_owner_ad_rate||Statistics based on impression-based metrics for ads that ran during video playbacks.|
|content_owner_estimated_asset_revenue||Statistics based on total earnings for all of a content owner’s assets and some ad performance metrics.|
|content_owner_estimated_video_revenue||Statistics based on total earnings for all of a content owner’s videos and some ad performance metrics.|
|content_owner_video_user_activity||User activity statistics for a content owner’s channels and their videos.|
|content_owner_video_user_activity_by_province||User activity statistics for a content owner’s channels and their videos, segmented by province.|
|content_owner_video_playback_location||Statistics related to the type of page or application where video playbacks occurred.|
|content_owner_video_traffic_source||Statistics related to sources which led the viewer to the videos.|
|content_owner_video_device_type_and_operating_system||Statistics related to viewer’s device type & operating system.|
|content_owner_video_viewer_demographic||Statistics related to viewers’ age group and gender.|
|content_owner_video_content_sharing_by_platform||Statistics related to frequency & type of sharing platform.|
|content_owner_video_annotation||Statistics related to annotations that display during a channel’s videos.|
|content_owner_video_card||Statistics related to performance of individual cards.|
|content_owner_video_end_screen||Statistics related to end screens that display after a video stops playing.|
|content_owner_video_subtitle||Statistics related to subtitles & language used in the videos.|
|content_owner_video_combined||Statistics for videos obtained by combining dimensions used in the playback location, traffic source, and device/OS reports.|
|content_owner_playlists_user_activity||User activity statistics for playlists & its videos.|
|content_owner_playlists_user_activity_by_province||User activity statistics for playlists and their videos, segmented by province.|
|content_owner_playlists_playback_location||Statistics related to the type of page or application where playlist playbacks occurred.|
|content_owner_playlists_traffic_source||Statistics related to sources which led the viewer to the playist.|
|content_owner_playlists_device_type_and_operating_system||Statistics related to viewer’s device type & operating system.|
|content_owner_playlists_combined||Statistics for playlists obtained by combining dimensions used in the playback location, traffic source, and device/OS reports.|
|content_owner_assets_user_activity||User activity statistics for a content owner’s assets.|
|content_owner_assets_user_activity_by_province||User activity statistics for a content owner’s assets, segmented by province.|
|content_owner_assets_playback_location||Statistics related to the type of page or application where video playbacks occurred.|
|content_owner_assets_traffic_source||Statistics related to sources which led the viewer to the videos linked to content owner’s assets.|
|content_owner_assets_device_type_and_operating_system||Statistics related to viewer’s device type and operating system.|
|content_owner_assets_viewer_demographic||Statistics related to viewers’ age group and gender.|
|content_owner_assets_content_sharing_by_platform||Statistics related to frequency and type of sharing platform.|
|content_owner_assets_annotation||Statistics related to annotations that display during a channel’s videos linked to the content owner’s assets.|
|content_owner_assets_card||Statistics related to performance of individual cards.|
|content_owner_assets_end_screen||Statistics related to end screens that display after a video stops playing.|
|content_owner_assets_combined||Statistics for videos linked to content owner’s assets obtained by combining dimensions used in the playback location, traffic source, and device/OS reports.|
The Content Owner Reports might not be as per your expectations. Testing for these reports is still underway.
How can I become a Content Manager?
How can I see content owner reports?
Ask your YouTube content owner to grant you a Content Owner or Content Manager access.
Post that, while creating a Pipeline, authorize using the Google account with Content Owner/Content Manager access.
How can I see the monetary reports?
Check if you have Content Owner/Content Manager access. If not, ask your Youtube Content owner to grant you Content Owner or Content Manager access.
If you are a Content Manager, by default you should have access to Monetary reports. If you do not have it, ask your Content Owner/Content Manager to provide
Read access for these reports.
For which dates can I generate reports?
The reports generated today will have data for dates up to two days prior, as defined by YouTube.
If you find that the latest date in your reports table is not 2 days before today, then it may be the case that there is no data for that particular date. In case there is no data in the report type for a given day, Youtube generates an empty report. In such cases, Hevo does not load any data into the Destination.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|Oct-25-2021||NA||Added the Pipeline frequency information in the Data Replication section.|