# View: int_dbt_prod_agg_pandora_model

**View Name:** int_dbt_prod_agg_pandora_model
**Table Source:** `INTELLIGENCE.DBT_PROD.AGG_PANDORA_MODEL`
**File Path:** `int_dbt_prod_agg_pandora_model.view.lkml`

## Overview

- **File Size:** 7421 bytes
- **Lines of Code:** 285
- **Dimensions:** 23
- **Measures:** 6
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `user_id` | string |
| `gender` | string |
| `age_bucket` | string |
| `sos_id` | string |
| `source` | string |
| `Source_of_stream_group` | string |
| `source_name` | string |
| `device_type` | string |
| `device_category` | string |
| `sub_store` | string |
| `transaction_type` | string |
| `transaction_detail` | string |
| `cachedplay` | string |
| `country_code` | string |
| `artist_id` | number |
| `artist_name` | string |
| `artist_uri` | string |
| `isrc` | string |
| `track_title` | string |
| `track_uri` | string |
| `upc` | string |
| `label_id` | number |
| `licensor` | string |

## Measures

| Name | Type |
|------|------|
| `count_days` | count_distinct |
| `number_of_users` | count_distinct |
| `total_listening_time` | sum |
| `avg_listening_time` | average |
| `number_of_tracks` | count_distinct |
| `streams` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_date` | time |