# View: int_dbt_prod_playlist_model_apple

**View Name:** int_dbt_prod_playlist_model_apple
**Table Source:** `intelligence.dbt_prod.playlist_model_apple`
**File Path:** `int_dbt_prod_playlist_model_apple.view.lkml`

## Overview

- **File Size:** 6066 bytes
- **Lines of Code:** 189
- **Dimensions:** 15
- **Measures:** 3
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- Used for calculating average time a track stays in a playist
- Detail of playlist/ radio names
- Grouped by Radio/ Playlist

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `transaction_country_code` | string |
| `label_id` | number |
| `upc` | string |
| `isrc` | string |
| `apple_id` | number |
| `source_of_stream_breakdown` | string |
| `source_of_stream` | string |
| `playlist_id` | string |
| `playlist_name` | string |
| `track_name` | string |
| `artist` | string |
| `playlist_author` | string |
| `playlist_url` | string |
| `playlist_type` | string |

## Measures

| Name | Type |
|------|------|
| `count_days_2` | count_distinct |
| `count_isrc` | count_distinct |
| `streams` | sum |

## Dimension Groups

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