# View: int_dbt_prod_agg_apple_model

**View Name:** int_dbt_prod_agg_apple_model
**Table Source:** `INTELLIGENCE.DBT_PROD.AGG_APPLE_SUMMARY`
**File Path:** `int_dbt_prod_agg_apple_model.view.lkml`

## Overview

- **File Size:** 13485 bytes
- **Lines of Code:** 345
- **Dimensions:** 23
- **Measures:** 4
- **Dimension Groups:** 1
- **Filters:** 0

## Description

Date at which activity occured

## Dimensions

| Name | Type |
|------|------|
| `apple_id` | number |
| `transaction_country` | string |
| `subscription_type` | string |
| `subscription_mode_original` | string |
| `subscription_mode_grouped` | string |
| `channel_partner` | string |
| `device_type` | string |
| `source_of_stream` | string |
| `container_subtype` | string |
| `container_id` | string |
| `container_name` | string |
| `end_reason_type` | string |
| `offline` | string |
| `isrc` | string |
| `upc` | string |
| `label_id` | number |
| `item_title` | string |
| `item_artist` | string |
| `item_artist_id` | number |
| `audio_format` | string |
| `days_since_release` | number |
| `weeks_since_release` | number |
| `months_since_release` | number |

## Measures

| Name | Type |
|------|------|
| `number_of_tracks` | count_distinct |
| `media_duration` | average |
| `streams` | sum |
| `skips` | sum |

## Dimension Groups

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