# View: int_dbt_prod_spotify_dm_agg_streams

**View Name:** int_dbt_prod_spotify_dm_agg_streams
**Table Source:** `intelligence.dbt_prod_strategy.spotify_dm_agg_streams`
**File Path:** `views/spotify_dm/int_dbt_prod_spotify_dm_agg_streams.view.lkml`

## Overview

- **File Size:** 5618 bytes
- **Lines of Code:** 223
- **Dimensions:** 8
- **Measures:** 11
- **Dimension Groups:** 3
- **Filters:** 0

## Description

Primary Key

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `ISRC` | string |
| `label_name` | string |
| `artist_name` | string |
| `track_name` | string |
| `genre` | string |
| `release_date` | string |
| `Spotify_source` | string |

## Measures

| Name | Type |
|------|------|
| `Max_Activity_Date` | date |
| `streams` | sum |
| `prev_doweek_streams` | sum |
| `wtd_streams` | sum |
| `prev_wtd_streams` | sum |
| `post_dm_streams` | sum |
| `pre_dm_streams` | sum |
| `avg_daily_post_dm_streams` | sum |
| `avg_daily_pre_dm_streams` | sum |
| `moving_14_day_avg` | sum |
| `moving_7_day_avg` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `start_date` | time |
| `end_date` | time |
| `activity_date` | time |