# View: int_dbt_prod_playlist_model_spotify

**View Name:** int_dbt_prod_playlist_model_spotify
**Table Source:** `intelligence.dbt_prod.playlist_model_spotify`
**File Path:** `int_dbt_prod_playlist_model_spotify.view.lkml`

## Overview

- **File Size:** 8529 bytes
- **Lines of Code:** 295
- **Dimensions:** 15
- **Measures:** 17
- **Dimension Groups:** 1
- **Filters:** 0

## Description

Primary Key

## Comments & Notes

- sql: IFF((${TABLE}.total_listen_duration/(${TABLE}.streams*${facts_prod_dim_track.duration})) >= 1, 1, (${TABLE}.total_listen_duration/(${TABLE}.streams*${facts_prod_dim_track.duration})))  ;;

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `transaction_country_code` | string |
| `isrc` | string |
| `upc` | string |
| `labelid` | number |
| `device_type` | string |
| `source_of_stream` | string |
| `subscription_type` | string |
| `playlist_type` | string |
| `playlist_author` | string |
| `playlist_name` | string |
| `playlist_uri` | string |
| `playlist_track_count` | number |
| `playlist_follower_count` | number |
| `playlist_genre_list` | string |

## Measures

| Name | Type |
|------|------|
| `count_days_2` | count_distinct |
| `max_activity_date` | date |
| `min_activity_date` | date |
| `count_isrc` | count_distinct |
| `number_of_playlists` | count_distinct |
| `total_listen_duration` | number |
| `average_listen_duration` | number |
| `discovery_streams` | sum |
| `streams` | sum |
| `editorial_streams` | sum |
| `3rd_party_streams` | sum |
| `user_streams` | sum |
| `voice_streams` | sum |
| `completion_rate_streams` | average |
| `completion_rate_voice_streams` | average |
| `track_count` | number |
| `follower_count` | number |

## Dimension Groups

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