# View: spotify_sos_aggregated

**View Name:** spotify_sos_aggregated
**Table Source:** `prod.spotify.spotify_sos_aggregated`
**File Path:** `spotify_sos_aggregated.view.lkml`

## Overview

- **File Size:** 12309 bytes
- **Lines of Code:** 456
- **Dimensions:** 45
- **Measures:** 8
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- view_label: Required Fields
- hidden: true
- ,##0.0,,\" M\"; #,##0"

## Dimensions

| Name | Type |
|------|------|
| `artist_name_track_name` | string |
| `adsupported_or_premium` | string |
| `free_or_paid` | string |
| `measure` | string |
| `aggregate` | string |
| `album_code` | string |
| `album_name` | string |
| `cached` | string |
| `count_tid` | string |
| `country_code` | string |
| `country_subregion` | string |
| `device_type` | string |
| `isrc` | string |
| `label_is_red` | string |
| `labelid` | string |
| `length_seconds` | number |
| `stream_duration_track_length_cat` | number |
| `weeks_since_release` | number |
| `days_since_release` | number |
| `months_since_release` | number |
| `effective_units_calc_cat` | number |
| `os` | string |
| `os_group` | string |
| `playlist_id` | string |
| `playlist_is_unknown` | string |
| `playlist_owner_group` | string |
| `spotify_curated` | string |
| `playlist_owner_id_from_source_uri` | string |
| `playlist_uri` | string |
| `product_partner` | string |
| `product_type` | string |
| `region_group` | string |
| `source` | string |
| `source_group` | string |
| `source_original_values` | string |
| `orchard_source_group` | string |
| `units_cat` | number |
| `track_album_artist` | string |
| `track_artists` | string |
| `track_name` | string |
| `track_uri` | string |
| `user_access` | string |
| `user_type` | string |
| `users` | string |
| `zipcode` | string |

## Measures

| Name | Type |
|------|------|
| `avg_completion` | average |
| `estimated_revenue` | sum |
| `streams` | sum |
| `count` | count |
| `count_playlist_uri` | count_distinct |
| `distinct_days` | count_distinct |
| `count_distinct_weeks` | count_distinct |
| `streams_per_week` | number |

## Dimension Groups

| Name | Type |
|------|------|
| `date_paulo_downloaded_file` | time |
| `friday_weekof` | time |
| `activity_date` | time |