# View: staging_raw_spotify_aggregated_streams

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

## Overview

- **File Size:** 3646 bytes
- **Lines of Code:** 190
- **Dimensions:** 23
- **Measures:** 5
- **Dimension Groups:** 2
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `api_licensor` | string |
| `row_id` | number |
| `primary_key` | string |
| `processed_datetime` | string |
| `filename` | string |
| `country` | string |
| `track` | string |
| `track_href` | string |
| `track_isrc` | string |
| `album_name` | string |
| `upc` | string |
| `album_href` | string |
| `artists_names` | string |
| `artists_hrefs` | string |
| `label` | string |
| `licensor` | string |
| `message_name` | string |
| `version` | string |
| `saves_cat` | number |
| `streams_cat` | number |
| `skips_cat` | number |
| `days_since_release` | number |
| `weeks_since_release` | number |

## Measures

| Name | Type |
|------|------|
| `streams` | sum |
| `skips` | sum |
| `saves` | sum |
| `skip_rate` | number |
| `save_rate` | number |

## Dimension Groups

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