# View: int_dbt_prod_youtube_subscription_adjustment

**View Name:** int_dbt_prod_youtube_subscription_adjustment
**Table Source:** `INTELLIGENCE.DBT_PROD.YOUTUBE_SUBSCRIPTION_ADJUSTMENT_MRR_UPDATE`
**File Path:** `views/int_dbt_prod_youtube_subscription_adjustment.view.lkml`

## Overview

- **File Size:** 6318 bytes
- **Lines of Code:** 314
- **Dimensions:** 29
- **Measures:** 9
- **Dimension Groups:** 2
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `mcn_account` | string |
| `adjustment_type` | string |
| `video_id` | string |
| `video_title` | string |
| `video_duration_sec` | number |
| `username` | string |
| `uploader` | string |
| `channel_id` | string |
| `channel_name` | string |
| `custom_id` | string |
| `asset_id` | string |
| `asset_type` | string |
| `asset_title` | string |
| `asset_labels` | string |
| `asset_channel_id` | string |
| `isrc` | string |
| `upc` | string |
| `grid` | string |
| `imprint` | string |
| `yt_provided_artist_name` | string |
| `yt_provided_release_name` | string |
| `country_code` | string |
| `content_type` | string |
| `policy` | string |
| `claim_type` | string |
| `multiple_claims` | string |
| `subscription_type` | string |
| `claim_origin` | string |

## Measures

| Name | Type |
|------|------|
| `owned_views` | sum |
| `monetized_views` | sum |
| `monetized_views_audio` | sum |
| `monetized_views_video` | sum |
| `monetized_views_audiovisual` | sum |
| `YOUTUBE_REVENUE_SPLIT` | sum |
| `PARTNER_REVENUE_PRO_RATA` | sum |
| `PARTNER_REVENUE_PER_SUB_MIN` | sum |
| `PARTNER_REVENUE` | sum |

## Dimension Groups

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