# Youtube: Video Report

## Description

* Each record represents the daily aggregation of your YouTube video performance.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/youtube_analytics/resources/youtube_analytics.svg" alt="" data-size="line"> YouTube Analytics

## Columns

| Type    | Name                                | Description                                                                          |
| ------- | ----------------------------------- | ------------------------------------------------------------------------------------ |
| DATE    | date\_day                           | The date the video was viewed                                                        |
| STRING  | video\_id                           | Unique ID of the video                                                               |
| STRING  | channel\_id                         | Unique identifier of the video channel                                               |
| STRING  | video\_title                        | Title of the video                                                                   |
| STRING  | video\_description                  | Description of the video                                                             |
| STRING  | channel\_title                      | Title of the channel                                                                 |
| STRING  | published\_at                       | Timestamp of when the video was published                                            |
| STRING  | default\_thumbnail\_url             | The default thumbnail url                                                            |
| STRING  | medium\_thumbnail\_url              | The medium quality thumbnail url                                                     |
| STRING  | high\_thumbnail\_url                | The high quality thumbnail url                                                       |
| DECIMAL | average\_view\_duration\_percentage | Average duration of views represented as a percent of the entire length of the video |
| DECIMAL | average\_view\_duration\_seconds    | Average duration of views for the video in seconds                                   |
| INTEGER | comments                            | Total number of comment posted on the video                                          |
| INTEGER | dislikes                            | Total number of dislikes attributed to the video                                     |
| INTEGER | likes                               | Total number of likes attributed to the video                                        |
| INTEGER | shares                              | Total number of times the video was shared                                           |
| INTEGER | subscribers\_gained                 | Total subscribers gained from the video                                              |
| INTEGER | subscribers\_lost                   | Total subscribers lost from the video                                                |
| INTEGER | views                               | Total number of views the video received                                             |
| DECIMAL | watch\_time\_minutes                | Total watch time in minutes the video received                                       |
| DECIMAL | video\_duration\_seconds            | The total duration of the video in seconds                                           |
| STRING  | daily\_video\_id                    |                                                                                      |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/youtube-video-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.