# View: int_dbt_prod_playlist_model_soundcloud

**View Name:** int_dbt_prod_playlist_model_soundcloud
**Table Source:** `INTELLIGENCE.DBT_PROD.PLAYLIST_MODEL_SOUNDCLOUD`
**File Path:** `int_dbt_prod_playlist_model_soundcloud.view.lkml`

## Overview

- **File Size:** 9141 bytes
- **Lines of Code:** 318
- **Dimensions:** 21
- **Measures:** 11
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- Used for calculating average time a track stays in a playist

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `soundcloud_track_id` | string |
| `label_id` | number |
| `transaction_country` | string |
| `operating_system` | string |
| `artist_name` | string |
| `track_title` | string |
| `isrc` | string |
| `upc` | number |
| `release_name` | string |
| `user_country` | string |
| `user_city` | string |
| `user_region` | string |
| `user_age` | string |
| `user_subscription` | string |
| `client_application` | string |
| `device_type` | string |
| `playlist_id` | string |
| `playlist_type` | string |
| `playlist_name` | string |
| `playlist_position` | number |

## Measures

| Name | Type |
|------|------|
| `number_of_users` | sum |
| `number_of_tracks` | count_distinct |
| `total_listen_duration` | sum |
| `avg_listen_duration` | average |
| `streams` | sum |
| `max_playlist_position` | max |
| `track_favourites` | sum |
| `track_message_posts` | sum |
| `track_reposts` | sum |
| `track_to_playlist_added` | sum |
| `count_days_2` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_date` | time |