# View: daily_apple_podcasting_events_snapshots_joined

**View Name:** daily_apple_podcasting_events_snapshots_joined
**Table Source:** `"INTELLIGENCE"."DBT_PROD"."APPLE_PODCASTING_MODEL"`
**File Path:** `views/apple_podcasts/daily_apple_podcasting_events_snapshots_joined.view.lkml`

## Overview

- **File Size:** 4481 bytes
- **Lines of Code:** 143
- **Dimensions:** 8
- **Measures:** 10
- **Dimension Groups:** 1
- **Filters:** 0

## Description

The Apple ID for the channel.

## Comments & Notes

- ## Event Measures
- ## Snapshot Measures

## Dimensions

| Name | Type |
|------|------|
| `channel_apple_id` | string |
| `channel_name` | string |
| `device` | string |
| `storefront_name` | string |
| `subscription_apple_id` | string |
| `subscription_duration` | string |
| `subscription_name` | string |
| `subscription_sub_type` | string |

## Measures

| Name | Type |
|------|------|
| `event_quantity` | sum |
| `event_quantity_other` | sum |
| `event_quantity_new_paid_subs` | sum |
| `event_quantity_new_free_trial_subscribers` | sum |
| `event_quantity_cancels_and_refunds_trial` | sum |
| `event_quantity_cancels_and_refunds` | sum |
| `event_combined_negative_cancels_and_refunds` | sum |
| `snapshot_subscription_count` | sum |
| `snapshot_weekly_subscription_count` | sum |
| `snapshot_monthly_subscription_count` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `event` | time |