# View: chartmetric_airplay

**View Name:** chartmetric_airplay
**Table Source:** `Derived from: Chartmetric.Raw_Data, Raw_Data.Acr_Channel, Raw_Data.Acr_Track, Raw_Data.Acr_Track_Stat`
**File Path:** `views/chartmetric_airplay.view.lkml`

## Overview

- **File Size:** 9523 bytes
- **Lines of Code:** 311
- **Dimensions:** 31
- **Measures:** 4
- **Dimension Groups:** 2
- **Filters:** 0

## Comments & Notes

- =========================================================================
- 1. PRIMARY KEY & CORE ID LINKS
- =========================================================================

## Dimensions

| Name | Type |
|------|------|
| `play_id` | number |
| `track_pk_id` | number |
| `channel_pk_id` | number |
| `played_duration_seconds` | number |
| `track_name` | string |
| `isrc` | string |
| `album_name` | string |
| `artist_name` | string |
| `acr_track_identifier` | string |
| `track_duration` | number |
| `track_duration_formatted` | number |
| `channel_name` | string |
| `channel_genre` | string |
| `channel_market` | string |
| `channel_station_city` | string |
| `channel_station_state` | string |
| `channel_country_code` | string |
| `channel_broadcast_area` | string |
| `channel_slogan` | string |
| `channel_frequency` | string |
| `channel_haat` | string |
| `channel_class` | string |
| `channel_platform` | string |
| `channel_owner` | string |
| `channel_website` | string |
| `channel_rw_station_name` | string |
| `channel_aqh` | number |
| `channel_city_id` | number |
| `channel_is_selected` | yesno |
| `channel_is_valid` | yesno |
| `channel_image_url` | string |

## Measures

| Name | Type |
|------|------|
| `play_count` | count |
| `unique_track_count` | count_distinct |
| `unique_channel_count` | count_distinct |
| `total_played_duration_seconds` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `play_timestamp` | time |
| `play_stat_created` | time |

## SQL Comments

- Base Event Columns (ACR_TRACK_STAT)
- Track Metadata Columns (ACR_TRACK)
- Channel/Station Columns (ACR_CHANNEL)

## Derived Table

```sql
sql:
      SELECT
        -- Base Event Columns (ACR_TRACK_STAT)
        ts.ID AS play_id,
        ts.ACR_TRACK AS track_pk_id,
        ts.ACR_CHANNEL AS channel_pk_id,
        ts.PLAYED_DURATION AS played_duration_seconds,
        ts.TIMESTP AS play_timestamp,
        ts.CREATED_AT AS play_stat_created_at,

      -- Track Metadata Columns (ACR_TRACK)
      t.TRACK_NAME AS track_name,
      t.ISRC AS isrc,
      t.ALBUM_NAME AS album_name,
      t.ARTIST_NAME AS artist_name,
      t.DURATION AS track_duration,
      t.ACR_ID AS acr_track_identifier,
      t.CREATED_AT AS track_created_at,
      t.MODIFIED_AT AS track_modified_at,

      -- Channel/Station Columns (ACR_CHANNEL)
      c.NAME AS channel_name,
      c.GENRE AS channel_genre,
      c.MARKET AS channel_market,
      c.IMAGE_URL AS channel_image_url,
      c.STATION_CITY AS channel_station_city,
      c.STATION_STATE AS channel_station_state,
      c.CODE2 AS channel_country_code,
      c.BROADCAST_AREA AS channel_broadcast_area,
      c.SLOGAN AS channel_slogan,
      c.FREQUENCY AS channel_frequency,
      c.HAAT AS channel_haat,
      c.CLASS AS channel_class,
      c.PLATFORM AS channel_platform,
      c.OWNER AS channel_owner,
      c.WEBSITE AS channel_website,
      c.AQH AS channel_aqh,
      c.SELECTED AS channel_is_selected,
      c.CITY_ID AS channel_city_id,
      c.RW_STATION_NAME AS channel_rw_station_name,
      c.VALID AS channel_is_valid,
      c.CREATED_AT AS channel_created_at,
      c.MODIFIED_AT AS channel_modified_at
      FROM CHARTMETRIC.RAW_DATA.ACR_TRACK_STAT ts
      LEFT JOIN CHARTMETRIC.RAW_DATA.ACR_TRACK t ON ts.ACR_TRACK = t.ID
      LEFT JOIN CHARTMETRIC.RAW_DATA.ACR_CHANNEL c ON ts.ACR_CHANNEL = c.ID
      ;;
```