# View: prod_yt_reports_api_useractivity_intermediate

**View Name:** prod_yt_reports_api_useractivity_intermediate
**Table Source:** `prod.yt_reports_api.useractivity_intermediate`
**File Path:** `views/prod_yt_reports_api_useractivity_intermediate.view.lkml`

## Overview

- **File Size:** 6299 bytes
- **Lines of Code:** 289
- **Dimensions:** 12
- **Measures:** 25
- **Dimension Groups:** 2
- **Filters:** 0

## Comments & Notes

- #This field needs a weighted averge based on views in order to show correct number when aggregated
- #This field needs a weighted averge based on views in order to show correct number when aggregated

## Dimensions

| Name | Type |
|------|------|
| `feedid` | number |
| `dayid` | number |
| `storeid` | number |
| `activitycountryid` | number |
| `videoid` | string |
| `videourl` | string |
| `videolink` | string |
| `channelid` | string |
| `channelurl` | string |
| `uploadertype` | string |
| `contentowner` | string |
| `country_code` | string |

## Measures

| Name | Type |
|------|------|
| `average_view_duration_percentage` | average |
| `average_view_duration_seconds` | average |
| `red_views` | sum |
| `views` | sum |
| `ads_views` | sum |
| `watch_time_minutes` | sum |
| `watch_time_hours` | sum |
| `red_watch_time_minutes` | sum |
| `red_watch_time_hours` | sum |
| `subscribers_gained` | sum |
| `subscribers_lost` | sum |
| `ad_impressions` | sum |
| `estimated_cpm` | average |
| `estimated_monetized_playbacks` | sum |
| `estimated_playback_based_cpm` | average |
| `estimated_youtube_ad_revenue` | sum |
| `estimated_partner_revenue` | sum |
| `estimated_partner_ad_revenue` | sum |
| `estimated_partner_red_revenue` | sum |
| `comments` | sum |
| `shares` | sum |
| `videos_added_to_playlists` | sum |
| `videos_removed_from_playlists` | sum |
| `likes` | sum |
| `dislikes` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `processeddaytime` | time |
| `download_activity_date` | time |