# View: int_dev_awalspotify_awaldiscovery_v04ebba

**View Name:** int_dev_awalspotify_awaldiscovery_v04ebba
**Table Source:** `INTELLIGENCE.DEV_AWALSPOTIFY.AWALDISCOVERY_V04EBBA`
**File Path:** `int_dev_awalspotify_awaldiscovery_v04ebba.view.lkml`

## Overview

- **File Size:** 7641 bytes
- **Lines of Code:** 379
- **Dimensions:** 23
- **Measures:** 12
- **Dimension Groups:** 6
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `TRACK_NAME` | string |
| `ARTIST_NAME` | string |
| `ISRC` | string |
| `CAMPAIGN_DURATION_MONTHS` | string |
| `DISCOVERYGROUP` | string |
| `IYEAR` | string |
| `IMONTH` | string |
| `SPOTIFY_SOURCE` | string |
| `SOURCE_URI` | string |
| `SPOTIFYISRC` | string |
| `UPC` | string |
| `LABELID` | string |
| `USER_ID` | string |
| `USER_COUNTRY_CODE` | string |
| `USER_ACCOUNT_TYPE` | string |
| `USER_GENDER` | string |
| `USER_BIRTH_YEAR` | string |
| `LICENSOR` | string |
| `USER_AGE_GROUP` | string |
| `SOURCETYPEGROUP` | string |
| `CATALOG_TYPE` | string |
| `SOURCES_STREAM_TYPE` | string |
| `DEVICE_TYPE` | 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 |
| `FIRSTUSERDISCOVERYDATE` | time |