YouTube Data API Queries

This section provides detailed instructions for fetching data from the YouTube Analytics API with Tube2Sheet.

Particulary useful metrics are:

• Top videos of your channel
• Views resulting from different advertisement types / related videos
• Top search terms that lead viewers to a specific video
• Gender and age demographics
• Likes/Dislikes
• Subscribers gained from videos

While the YouTube Data API provides a data snapshot (like current views of a video of the number of subscribers of a channel), the YouTube Analytics API can be used to query historic data (i.e. data over a time period, like views or subscribers gained per day or month).

The main difference to the Data API is that the Analytics API is used to get data for you own channel. This is data that only you can access. The data that you can access with this API is technically the same data that you can access in YouTube Studio.

Tube2Sheet will help you to automate the data retrieval so you can use it in your data pipeline or automatically update your reports.

You can also connect to your automatically updated data with visualization tools like Microsoft Power BI or Excel.

Query Types

Videos

Basic Stats

• Basic metrics: Basic metrics for your channel
• Basic metrics for a video: Detailed metrics for a specific video

Geographic

• Country-specific view counts: View counts broken down by country
• Most watched videos: List of your most popular videos
• Monthly annotation metrics by country: Annotation performance by country
• Watch time by country: Watch time statistics per country
• Watch time by country for a video: Country-specific watch time for a video
• Annotation metrics for a country: Detailed annotation performance for a specific country
• Top 10 videos in a country: Most popular videos in a specific country

Playback Location and Traffic Sources

• Views and watch time by playback location: Statistics by viewing platform
• Views by traffic source in a country: Traffic sources breakdown by country
• Top YouTube search terms for a video: Search terms leading to your video
• Traffic from external website for a video: External referral sources
• Traffic from related videos for a video: Traffic from YouTube recommendations
• Traffic from subscription for a video: Views from subscribers
• Traffic from advertisement for a video: Ad-driven traffic

Device and Demographics

• Device type metrics: Views by device type
• Viewer demographics by gender: Gender distribution of viewers
• Viewer demographics by age group: Age distribution of viewers

Engagement and Retention

• Sharing metrics: Video sharing statistics
• Likes and dislikes: Overall engagement metrics
• Likes and dislikes for a video: Engagement metrics for a specific video
• Audience retention for a video: Viewer retention analysis

Playlists

• Basic playlist statistics: Overview of playlist performance
• Daily playlist statistics: Day-by-day playlist metrics
• Top 10 playlists by watchtime: Most-watched playlists

Revenue

• Revenue: Overall revenue statistics
• Ad revenue: Detailed advertising revenue metrics

Compliance with YouTube's API Policies

To ensure compliance with YouTube's API terms, both your use of data requests and the provision of Tube2Sheet as an API client must adhere to the following relevant conditions:

“API Clients may store all types of Authorized Data, except those specified in section (III.E.4.b), only as long as necessary for the specific consent granted by an active user and for no more than 30 calendar days. After this period, the API Client must either delete or refresh the stored data.” (Source)

“API Clients must not (i) replace API Data with similar, independently calculated data, or (ii) use API Data to create new or derived data or metrics.” (Source)

For full details on data storage policies, refer to YouTube's Developer Policies.

Adhering to YouTube's Terms of Service

• Terms of Service: You can view YouTube's Terms of Service here.

By using Tube2Sheet to access YouTube data, you agree to adhere to YouTube's Terms of Service. See our Terms and Conditions.

Intellectual Property Notices

Google Sheets™ web-based spreadsheet program and YouTube™ are trademarks of Google LLC. Use of these trademarks is subject to Google Permissions.

Further Assistance

For additional help, visit our FAQ or Troubleshooting sections.