# View: int_dbt_prod_youtube_summary_streams_daily

**View Name:** int_dbt_prod_youtube_summary_streams_daily
**Table Source:** `INTELLIGENCE.DBT_PROD.YOUTUBE_SUMMARY_STREAMS_DAILY`
**File Path:** `int_dbt_prod_youtube_summary_streams_daily.view.lkml`

## Overview

- **File Size:** 15938 bytes
- **Lines of Code:** 536
- **Dimensions:** 41
- **Measures:** 11
- **Dimension Groups:** 3
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `label_id` | number |
| `label_name` | string |
| `label_country` | string |
| `parent_company` | string |
| `brand_name` | string |
| `service_tier_name` | string |
| `primary_relationship_manager` | string |
| `subaccount_id` | number |
| `subaccount_name` | string |
| `upc` | string |
| `release_name` | string |
| `genre` | string |
| `imprint` | string |
| `isrc` | string |
| `track_name` | string |
| `asset_isrc` | string |
| `transaction_country_name` | string |
| `transaction_country_code` | string |
| `transaction_region` | string |
| `artist` | string |
| `video_id` | string |
| `video_url` | string |
| `business_model` | string |
| `business_model_normalized` | string |
| `platform` | string |
| `content_type` | string |
| `traffic_source_type` | string |
| `traffic_source_detail` | string |
| `user_request` | string |
| `playback_location_type` | string |
| `playback_location_group` | string |
| `playback_location_detail` | string |
| `subscription_type` | string |
| `is_label_owned_channel` | string |
| `is_multi_claim_video` | string |
| `is_audio_play` | string |
| `is_audio_tier_mode` | string |
| `is_livestream` | string |
| `is_shorts_eligible` | string |
| `is_music` | string |
| `is_shorts_playback_experience` | string |

## Measures

| Name | Type |
|------|------|
| `isrc_count` | count_distinct |
| `video_id_count` | count_distinct |
| `plays` | sum |
| `watch_time_sec` | sum |
| `net_likes` | sum |
| `net_dislikes` | sum |
| `video_comments` | sum |
| `video_shares` | sum |
| `users_subscribed_to_uploader` | sum |
| `users_not_subscribed_to_uploader` | sum |
| `no_of_users` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_date` | time |
| `release_date` | time |
| `sale_start_date` | time |