# View: staging_raw_youtube_monthly

**View Name:** staging_raw_youtube_monthly
**Table Source:** `facts.prod.staging_raw_youtube_monthly_v2`
**File Path:** `staging_raw_youtube_monthly.view.lkml`

## Overview

- **File Size:** 5971 bytes
- **Lines of Code:** 278
- **Dimensions:** 16
- **Measures:** 19
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- measure: count {
- type: count
- drill_fields: [detail*]

## Dimensions

| Name | Type |
|------|------|
| `video_id` | string |
| `custom_id` | string |
| `upc` | string |
| `extracted_upc_long` | string |
| `isrc` | string |
| `grid` | string |
| `country_code` | string |
| `content_type` | string |
| `policy` | string |
| `ingestion_time` | string |
| `filename` | string |
| `filesize` | number |
| `source` | string |
| `artist` | string |
| `title` | string |
| `ad_requested_views` | number |

## Measures

| Name | Type |
|------|------|
| `total_views` | sum |
| `watch_page_views` | sum |
| `embedded_views` | sum |
| `channel_page_views` | sum |
| `live_views` | sum |
| `recorded_views` | sum |
| `ad_enabled_views` | sum |
| `gross_dbl_click_yt_sold_rev` | sum |
| `gross_dbl_click_partner_sold_rev` | sum |
| `gross_adsense_sold_rev` | sum |
| `net_dbl_click_yt_sold_rev` | sum |
| `net_adsense_sold_rev` | sum |
| `total_earnings` | sum |
| `youtube_revenue_split_partner_served_partner_sold` | sum |
| `youtube_revenue_split` | sum |
| `partner_revenue_doubleclick_served_partner_sold` | sum |
| `partner_revenue_partner_served_partner_sold` | sum |
| `count_distinct_videos` | count_distinct |
| `label_revenue` | number |

## Dimension Groups

| Name | Type |
|------|------|
| `download_date` | time |

