Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Description |
|---|---|---|---|
| TIME | Year | Year | |
| Year & month | Yearmonth | ||
| Year & week (Mon-Sun) | Yearweek | ||
| Month | Month | ||
| Week (Mon-Sun) | Week | ||
| Week (Mon-Sun, dates) | yearweekiso_daterange | ||
| Date | Date | ||
| VIDEO/CHANNEL | Video/channel name | profile | |
| Video/channel ID | profileid | ||
| Video published date | publishedAt | ||
| Video URL | videourl | ||
| Video image URL | videoimage | ||
| Video image | videoimage_image | Thumbnail image of the video | |
| Video description | videoDescription | The video`s description | |
| Video tags | videoTags | A list of keyword tags associated with the video | |
| Video category | videoCategory | The YouTube video category associated with the video | |
| Video length | videoLength | The length of the video | |
| Video resolution | videoResolution | Indicates whether the video is available in high definition (HD) or only in standard definition | |
| Video has captions | videoHasCaptions | Indicates whether captions are available for the video | |
| Video is licensed content | videoLicensedContent | 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 | A rating that YouTube uses to identify age-restricted content | |
| Video privacy status | privacyStatus | The video`s privacy status | |
| USER | Country | country | |
| US state | USstate | ||
| Age group | ageGroup | ||
| Gender | gender | ||
| Gender & age group | genderage | ||
| Operating system | operatingSystem | ||
| Device type | deviceType | ||
| PLAYBACK | Playback location | insightPlaybackLocationType | |
| Playback location detail for embedded playbacks | insightPlaybackLocationDetail | ||
| Traffic source | insightTrafficSourceType | ||
| Traffic source detail | insightTrafficSourceDetail | ||
| Sharing service | sharingService | ||
| AUDIENCE RETENTION | Elapsed video time ratio | elapsedVideoTimeRatio | |
| ADS | Ad type | adType |