# View: facts_prod_apple_podcasts_content_performance

**View Name:** facts_prod_apple_podcasts_content_performance
**Table Source:** `FACTS.PROD.APPLE_PODCASTS_CONTENT_PERFORMANCE`
**File Path:** `facts_prod_apple_podcasts_content_performance.view.lkml`

## Overview

- **File Size:** 11241 bytes
- **Lines of Code:** 283
- **Dimensions:** 7
- **Measures:** 27
- **Dimension Groups:** 1
- **Filters:** 0

## Description

Territory in which the Podcast was consumed

## Dimensions

| Name | Type |
|------|------|
| `storefront_name` | string |
| `show_identifier` | number |
| `show_name` | string |
| `episode_identifier` | number |
| `episode_name` | string |
| `episode_guid` | string |
| `episode_type` | string |

## Measures

| Name | Type |
|------|------|
| `total_listening_hours` | sum |
| `number_of_episodes` | count_distinct |
| `subscriber_listening_hours` | sum |
| `non_subscriber_listening_hours` | sum |
| `total_listeners` | sum |
| `subscribed_listeners` | sum |
| `average_subscribed_listening_hours_by_total_engaged_subscribers` | average |
| `average_non_subscribed_listening_hours_by_total_engaged_non_subscribers` | average |
| `average_listening_hours_by_total_listeners` | average |
| `average_subscribed_listeners_per_episode` | number |
| `average_non_subscribed_listeners_per_episode` | number |
| `non_subscribed_listeners` | sum |
| `total_engaged_listeners` | sum |
| `subscribed_engaged_listeners` | sum |
| `non_subscribed_engaged_listeners` | sum |
| `total_plays` | sum |
| `subscriber_plays` | sum |
| `non_subscriber_plays` | sum |
| `average_subscribed_plays_per_subscribed_listener` | average |
| `average_non_subscribed_plays_per_non_subscribed_listener` | average |
| `average_plays_per_listener` | average |
| `subscriber_listening_hours_as_share_of_total_listening_hours` | number |
| `subscriber_plays_as_share_of_total_plays` | number |
| `engaged_subscribed_listeners_as_share_of_total_enagaged_listeners` | number |
| `engaged_subscribed_listeners_as_share_of_total_listeners` | number |
| `average_subscribed_hours_per_subscribed_play` | number |
| `average_non_subscribed_hours_per_non_subscribed_play` | number |

## Dimension Groups

| Name | Type |
|------|------|
| `download_date` | time |