# View: facts_prod_apple_podcasts_subscription_events

**View Name:** facts_prod_apple_podcasts_subscription_events
**Table Source:** `FACTS.PROD.APPLE_PODCASTS_SUBSCRIPTION_EVENTS`
**File Path:** `facts_prod_apple_podcasts_subscription_events.view.lkml`

## Overview

- **File Size:** 6990 bytes
- **Lines of Code:** 201
- **Dimensions:** 15
- **Measures:** 1
- **Dimension Groups:** 4
- **Filters:** 0

## Description

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

## Comments & Notes

- drill_fields: [facts_prod_dim_sourcetype.sourcetypename, facts_prod_dim_containertype.containertypename, facts_prod_dim_playlist.playlisttype]

## Dimensions

| Name | Type |
|------|------|
| `storefront_name` | string |
| `channel_apple_id` | string |
| `channel_name` | string |
| `event_name` | string |
| `subscription_apple_id` | string |
| `subscription_name` | string |
| `subscription_sub_type` | string |
| `subscription_duration` | string |
| `device` | string |
| `prev_subscription_apple_id` | string |
| `prev_subscription_name` | string |
| `preserved_pricing` | string |
| `proceeds_reason` | string |
| `cancellation_reason` | string |
| `event_type_grouped` | string |

## Measures

| Name | Type |
|------|------|
| `quantity` | sum |

## Dimension Groups

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