Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | Year | dim | |
| Year & month | Yearmonth | dim | ||
| Year & week (Mon-Sun) | Yearweek | dim | ||
| Month | Month | dim | ||
| Week (Mon-Sun) | Week | dim | ||
| Week (Mon-Sun, dates) | yearweekiso_daterange | dim | ||
| Date | Date | dim | ||
| VIDEO/CHANNEL | Video/channel name | profile | dim | |
| Video/channel ID | profileid | dim | ||
| Video published date | publishedAt | dim | ||
| Video URL | videourl | dim | ||
| Video image URL | videoimage | dim | ||
| Video image | videoimage_image | dim | Thumbnail image of the video | |
| Video description | videoDescription | dim | The video`s description | |
| Video tags | videoTags | dim | A list of keyword tags associated with the video | |
| Video category | videoCategory | dim | The YouTube video category associated with the video | |
| Video length | videoLength | dim | The length of the video | |
| Video resolution | videoResolution | dim | Indicates whether the video is available in high definition (HD) or only in standard definition | |
| Video has captions | videoHasCaptions | dim | Indicates whether captions are available for the video | |
| Video is licensed content | videoLicensedContent | dim | Indicates whether the video represents licensed content, which means that the content was uploaded to a channel linked to a YouTube content partner and then claimed by that partner | |
| Video age restriction | videoAgeRestriction | dim | A rating that YouTube uses to identify age-restricted content | |
| Video privacy status | privacyStatus | dim | The video`s privacy status | |
| CHANNEL STATISTICS | Channel subscribers count | subscriberCount | met | |
| Channel video count | videoCount | met | ||
| USER | Country | country | dim | |
| US state | USstate | dim | ||
| Age group | ageGroup | dim | ||
| Gender | gender | dim | ||
| Gender & age group | genderage | dim | ||
| Operating system | operatingSystem | dim | ||
| Device type | deviceType | dim | ||
| PLAYBACK | Playback location | insightPlaybackLocationType | dim | |
| Playback location detail for embedded playbacks | insightPlaybackLocationDetail | dim | ||
| Traffic source | insightTrafficSourceType | dim | ||
| Traffic source detail | insightTrafficSourceDetail | dim | ||
| Sharing service | sharingService | dim | ||
| AUDIENCE RETENTION | Elapsed video time ratio | elapsedVideoTimeRatio | dim | |
| ADS | Ad type | adType | dim | |
| VIEWS | Video views | views | met | |
| Estimated time watched (days) | timeWatched | met | ||
| Estimated time watched (minutes) | timeWatched_minutes | met | ||
| Avg. view percentage | averageViewPercentage | met | ||
| Avg. view duration (min) | avgTimeViewed_minutes | met | ||
| Avg. view duration (sec) | avgTimeViewed_seconds | met | ||
| Avg. view duration (h:m:s) | avgTimeViewed_hms | met | ||
| Viewer percentage | viewerPercentage | met | ||
| ENGAGEMENT | Comments | comments | met | |
| Likes | likes | met | ||
| Dislikes | dislikes | met | ||
| Shares | shares | met | ||
| Subscribers gained | subscribersGained | met | ||
| Subscribers lost | subscribersLost | met | ||
| AUDIENCE RETENTION | Audience watch ratio | audienceWatchRatio | met | |
| Relative retention performance | relativeRetentionPerformance | met | ||
| ADS | Earnings (Google-sold ads) | earnings | met | |
| Estimated ad revenue | estimatedAdRevenue | met | The total estimated net revenue from all Google-sold advertising sources for the selected date range and region | |
| Estimated Premium partner ad revenue | estimatedRedPartnerRevenue | met | The total estimated revenue earned from YouTube Premium subscriptions for the selected report dimensions | |
| Gross revenue (Google-sold & DoubleClick partner-sold ads) | grossRevenue | met | ||
| Ad impressions | adImpressions | met | ||
| Monetized playbacks | monetizedPlaybacks | met | ||
| Gross revenue per 1000 impressions | playbackBasedCpm | met | ||
| Gross revenue per 1000 playbacks | impressionBasedCpm | met | ||
| ANNOTATIONS | Annotation impressions | annotationImpressions | met | |
| Annotation clicks | annotationClicks | met | ||
| Annotation clickable impressions | annotationClickableImpressions | met | ||
| Annotation click-through rate (CTR) % | annotationCTR_perc | met | ||
| Annotation closes | annotationCloses | met | ||
| Annotation closable impressions | annotationClosableImpressions | met | ||
| Annotation close rate % | annotationCloseRate_perc | met | ||
| DEPRECATED | Unique viewers (deprecated by Google, don't use) | uniques | met | Please note that this field was removed on 2016-09-27 |