# View: int_dev_nsuzara_awal_discovery

**View Name:** int_dev_nsuzara_awal_discovery
**Table Source:** `INTELLIGENCE.DEV_AWALSPOTIFY.AWALDISCOVERY04`
**File Path:** `int_dev_nsuzara_awal_discovery.view.lkml`

## Overview

- **File Size:** 14313 bytes
- **Lines of Code:** 469
- **Dimensions:** 22
- **Measures:** 12
- **Dimension Groups:** 6
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `TRACK_NAME` | string |
| `ARTIST_NAME` | string |
| `CAMPAIGN_DURATION_MONTHS` | string |
| `DISCOVERYGROUP` | string |
| `USER_ID` | string |
| `SOURCE_URI` | string |
| `SPOTIFY_TRACK_ID` | string |
| `SPOTIFY_SOURCE` | string |
| `DEVICE_TYPE` | string |
| `OS` | string |
| `TRACK_URI` | string |
| `ISRC` | string |
| `UPC` | string |
| `LABELID` | string |
| `USER_COUNTRY_CODE` | string |
| `USER_ACCOUNT_TYPE` | string |
| `USER_GENDER` | string |
| `USER_BIRTH_YEAR` | string |
| `LICENSOR` | string |
| `USER_AGE_GROUP` | string |
| `Source_type` | string |
| `Source_type_group` | string |

## Measures

| Name | Type |
|------|------|
| `SHUFFLE_PLAY_YES_STREAMS` | sum |
| `SHUFFLE_PLAY_NO_STREAMS` | sum |
| `SHUFFLE_PLAY_NULL_STREAMS` | sum |
| `REPEAT_PLAY_YES_STREAMS` | sum |
| `REPEAT_PLAY_NO_STREAMS` | sum |
| `REPEAT_PLAY_NULL_STREAMS` | sum |
| `DISCOVERY_FLAG_YES_STREAMS` | sum |
| `DISCOVERY_FLAG_NO_STREAMS` | sum |
| `DISCOVERY_FLAG_NULL_STREAMS` | sum |
| `TOTAL_LISTEN_DURATION` | number |
| `units` | sum |
| `AVG_LISTEN_DURATION` | average |

## Dimension Groups

| Name | Type |
|------|------|
| `CAMPAIGN_START` | time |
| `CAMPAIGN_END` | time |
| `TRACK_RELEASE_DATE` | time |
| `CAMPAIGN3MOSBEFORE` | time |
| `CAMPAIGN3MOSAFTER` | time |
| `ACTIVITY_DATE` | time |