# View: facts_prod_apple_podcasts_subscription_snapshot

**View Name:** facts_prod_apple_podcasts_subscription_snapshot
**Table Source:** `FACTS.PROD.APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT`
**File Path:** `facts_prod_apple_podcasts_subscription_snapshot.view.lkml`

## Overview

- **File Size:** 4574 bytes
- **Lines of Code:** 148
- **Dimensions:** 14
- **Measures:** 5
- **Dimension Groups:** 2
- **Filters:** 0

## Description

Refers to the reporting date that the report was initially generated by Apple

## Dimensions

| Name | Type |
|------|------|
| `storefront_name` | string |
| `channel_apple_id` | string |
| `channel_name` | string |
| `subscription_apple_id` | string |
| `subscription_name` | string |
| `subscription_state` | string |
| `subscription_sub_type` | string |
| `subscription_duration` | string |
| `device` | string |
| `currency_of_proceeds` | string |
| `preserved_pricing` | string |
| `proceeds_reason` | string |
| `apple_vendor_id` | number |
| `apple_vendor_name` | string |

## Measures

| Name | Type |
|------|------|
| `customer_price` | sum |
| `developer_proceeds` | sum |
| `subscription_count` | sum |
| `sony_proceeds` | number |
| `apple_proceeds` | number |

## Dimension Groups

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