# View: itunes_report.hidden_tracks_view

**View Name:** itunes_report_hidden_tracks_view
**Table Source:** `prod.hidden_content.itunes_hidden_view`
**File Path:** `itunes_report.hidden_tracks_view.view.lkml`

## Overview

- **File Size:** 15207 bytes
- **Lines of Code:** 577
- **Dimensions:** 24
- **Measures:** 13
- **Dimension Groups:** 5
- **Filters:** 0

## Comments & Notes

- Auto-generated via Rick's RScript on Tue Apr 12 10:52 AM Eastern
- # ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   START Manually Added   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
- # NOTE:  this SQL view,  itunes_report.hidden_tracks_view,

## Dimensions

| Name | Type |
|------|------|
| `days_since_hidden` | number |
| `within_window` | yesno |
| `apple_id` | string |
| `audio_must_be_redelivered_for_itunes_plus` | yesno |
| `genre` | string |
| `grid` | string |
| `grid_dimension` | number |
| `is_complete` | yesno |
| `reason` | string |
| `total_discs_dimension` | number |
| `total_tracks_dimension` | number |
| `label_client_manager` | string |
| `label_id` | number |
| `label_name` | string |
| `label_priority` | number |
| `master_label` | string |
| `mkt_priority` | string |
| `upc` | number |
| `artist` | string |
| `album` | string |
| `content_owner` | string |
| `track_apple_id` | number |
| `track_isrc` | string |
| `track_name` | string |

## Measures

| Name | Type |
|------|------|
| `hidden_to_date` | running_total |
| `count_distinct_apple_ids` | count_distinct |
| `number_of_rows` | number |
| `total_discs` | sum |
| `total_tracks` | sum |
| `count_distinct_labels` | count_distinct |
| `count_distinct_vendors` | count_distinct |
| `max_date_hidden` | string |
| `max_import_date` | string |
| `max_ingest_date` | string |
| `min_date_hidden` | string |
| `min_import_date` | string |
| `min_ingest_date` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `date_report` | time |
| `date_filter_relative` | time |
| `date_hidden` | time |
| `import_date` | time |
| `ingest_date` | time |