YouTube report building guide

Prev Next

Use the YouTube connector to pull your video data easily into reports. Quickly see which content has created the most engagement — including how your video likes, comments, and channel subscribers have changed over time and whether there are any seasonal patterns.

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Query types

With this data source, you need to select a query type to get the right type of data:

  • Videos performance: Fetches engagement data per video for up to 1,000 of the most recently published videos on the selected channel. Splittable by date.

  • Single video performance: Fetches engagement data for a specific video, defined by video ID. Splittable by date.

  • Channel overview: Performance data for the channel, such as subscribers, likes, and average view duration.

  • Geographies: Breakdown of viewer engagement by country and state.

  • Demographic: Breakdown of viewer percentage by age and gender.

  • Device: Breakdown of viewer engagement by device type and operating system.

  • Traffic sources: Breakdown of viewer engagement by traffic source.

  • Ad performance: Gross revenue and ad impressions for your channel, broken down by ad type.

Note

To pull monetization data using the Ad performance query type, your YouTube channel must have monetization enabled.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

Review video views, likes, and comments

See how many views, likes, and comments each of your videos received over the last 28 days. Use this data to identify which content is resonating with your audience and inform your video strategy.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Videos performance

Date range

Last 28 days

Metrics

Video views, Likes, Comments

Dimensions

Video title, Video ID

Suggested visualization

Table

Understanding the data

  • Video views: The number of times the video was viewed within the reporting period.

  • Likes: The number of times users gave the video a positive rating.

  • Comments: The number of times users commented on the video.

  • Video title: The title of the video, used to identify each video in the results.

  • Video ID: The unique identifier of the video.

See video views by country

Explore the geographic distribution of your audience this month. This is useful for understanding which markets are watching your content and informing regional content or targeting decisions.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Geographies

Date range

This month to date

Metrics

Video views

Dimensions

Country

Suggested visualization

Geo chart

Understanding the data

  • Video views: The number of times videos were viewed within the reporting period.

  • Country: The country of the viewer, used to segment results by geographic location.

Analyze viewer demographics

See the age and gender breakdown of your viewers last week — useful for understanding whether your content is reaching your intended audience and informing creative decisions.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Demographic

Date range

Last week

Metrics

Viewer percentage

Dimensions

Age group, Gender

Suggested visualization

Bar or column chart

Understanding the data

  • Viewer percentage: The percentage of viewers in each demographic segment who were logged in when watching the video or playlist.

  • Age group: The age bracket of the viewer, used to segment results by age.

  • Gender: The gender of the viewer, used to segment results by gender.

View channel lifetime totals

See the current lifetime totals for your channel — total subscribers, total public videos, and total page views — fetched at the time the query is refreshed, useful for adding channel context to your reporting dashboard.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Channel overview

Date range

Today

Metrics

Channel total subscribers, Channel total video count, Channel total page views

Dimensions

Channel name

Suggested visualization

Table

Understanding the data

  • Channel total subscribers: The all-time number of subscribers for the channel. This value is rounded down to three significant figures.

  • Channel total video count: The number of public videos uploaded to the channel all time. Reflects public videos only.

  • Channel total page views: The total number of times the channel page has been viewed all time.

  • Channel name: The name of the YouTube channel, used to compare totals across multiple channels.

Track audience engagement over the last 28 days

See how your channel's views, likes, and subscriber changes have trended day by day over the last 28 days — useful for understanding what's driving audience growth and identifying periods of higher or lower engagement.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Channel overview

Date range

Last 28 days

Metrics

Views, Likes, Gained subscribers, Lost subscribers

Dimensions

Date

Suggested visualization

Time series chart

Understanding the data

  • Views: The number of times videos on the channel were viewed within the reporting period.

  • Likes: The number of times users gave a positive rating to a video within the reporting period.

  • Gained subscribers: The number of times users subscribed to the channel within the reporting period.

  • Lost subscribers: The number of times users unsubscribed from the channel within the reporting period.

  • Date: Splits results by day so you can track daily engagement trends.

More resources

You might also be interested in: