# View: int_dbt_prod_agg_weekly_rollup_spotify_model

**View Name:** int_dbt_prod_agg_weekly_rollup_spotify_model
**Table Source:** `INTELLIGENCE.DBT_PROD.agg_weekly_rollup_spotify_model`
**File Path:** `int_dbt_prod_agg_weekly_rollup_spotify_model.view.lkml`

## Overview

- **File Size:** 20078 bytes
- **Lines of Code:** 466
- **Dimensions:** 24
- **Measures:** 12
- **Dimension Groups:** 1
- **Filters:** 0

## Description

Primary Key

## Comments & Notes

- dimension: user_id {
- type: string
- view_label: "User"

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `Source_URI` | string |
| `licensor` | string |
| `Spotify_track_id` | string |
| `Spotify_source` | string |
| `Source_type` | string |
| `Source_type_group` | string |
| `device_type` | string |
| `OS` | string |
| `track_uri` | string |
| `ISRC` | string |
| `UPC` | string |
| `labelid` | number |
| `user_country` | string |
| `Account_type` | string |
| `Gender` | string |
| `user_age_group` | string |
| `days_since_release` | number |
| `weeks_since_release` | number |
| `months_since_release` | number |
| `catalog_type` | string |
| `LYRICS_VIEWED` | string |
| `CANVAS_VIEWED` | string |
| `CONTENT_TYPE_FLAG` | string |

## Measures

| Name | Type |
|------|------|
| `count_days` | count_distinct |
| `Max_Activity_Date` | date |
| `total_listen_duration` | sum |
| `shuffle_streams` | sum |
| `repeat_streams` | sum |
| `discovery_streams` | sum |
| `streams` | sum |
| `completion_rate_streams` | average |
| `voice_streams` | sum |
| `completion_rate_voice_streams` | average |
| `number_of_users` | sum |
| `number_of_tracks` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `ACTIVITY_WEEK_START` | time |