# View: staging_raw_spotify_v2

**View Name:** staging_raw_spotify_v2
**Table Source:** `facts.prod.staging_raw_spotify_v2`
**File Path:** `staging_raw_spotify_v2.view.lkml`

## Overview

- **File Size:** 19118 bytes
- **Lines of Code:** 735
- **Dimensions:** 45
- **Measures:** 15
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- # ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   Start Staging Raw Spotify v2 View   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
- manually added
- alias: [activity_date]

## Dimensions

| Name | Type |
|------|------|
| `licensor` | string |
| `user_country` | string |
| `weeks_since_release` | number |
| `birth_year` | number |
| `age_group` | string |
| `cached` | yesno |
| `device_type` | string |
| `gender` | string |
| `isrc` | string |
| `length_categorically` | number |
| `message` | string |
| `os` | string |
| `partner` | string |
| `referral` | yesno |
| `row_id` | string |
| `source` | string |
| `source_classic` | string |
| `source_uri` | string |
| `playlist_id_old` | string |
| `playlist_id_new` | string |
| `playlist_id` | string |
| `source_is_playlist` | yesno |
| `playlist_owner_is_spotify` | yesno |
| `playlist_owner_group` | string |
| `playlist_owner_id_or_group` | string |
| `playlist_is_known` | yesno |
| `playlist_owner_id` | string |
| `track_album_artist` | string |
| `track_artists` | string |
| `track_id` | string |
| `track_message` | string |
| `track_name` | string |
| `track_uri` | string |
| `upc` | string |
| `user_access` | string |
| `adsuppported_or_premium` | string |
| `user_id` | string |
| `user_message` | string |
| `user_region` | string |
| `user_type` | string |
| `version_categorically` | number |
| `zipcode` | zipcode |
| `product` | string |
| `album_code` | string |
| `album_name` | string |

## Measures

| Name | Type |
|------|------|
| `number_of_distinct_playlists` | count_distinct |
| `max_activity_date` | date |
| `length` | sum |
| `count_distinct_rows` | count_distinct |
| `count_distinct_days` | count_distinct |
| `number_of_streams` | number |
| `number_of_streams_per_day` | number |
| `count_distinct_releases` | count_distinct |
| `count_distinct_tracks` | count_distinct |
| `count_distinct_isrcs` | count_distinct |
| `count_distinct_listeners` | number |
| `percent_complete` | average |
| `complete_streams` | sum |
| `version` | sum |
| `count_distinct_products` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_date` | time |
| `offline_timestamp` | time |
| `download_date` | time |