# View: chartmetric_perf_content_income

**View Name:** chartmetric_perf_content_income
**Table Source:** `intelligence.dbt_hstanhope_knr.chartmetric_perf_content_income`
**File Path:** `views/chartmetric_perf_content_income.view.lkml`

## Overview

- **File Size:** 5840 bytes
- **Lines of Code:** 299
- **Dimensions:** 42
- **Measures:** 12
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- 1) Chartmetric plays
- 2) Chartmetric meta
- 3) Content metadata

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |
| `country_name` | string |
| `year` | string |
| `cm_track_id` | number |
| `cm_track_title` | string |
| `cm_album_name` | string |
| `cm_artist_name` | string |
| `cm_track_duration` | number |
| `label` | string |
| `release_date` | date |
| `nr_id` | string |
| `primary_artist_displayed_as` | string |
| `primary_artist_ids` | string |
| `featured_artists_ids` | string |
| `content_contributor_id` | string |
| `contributor_name` | string |
| `stage_name` | string |
| `contributor_type` | string |
| `roles` | string |
| `nr_priority` | number |
| `song_name` | string |
| `recording_version` | string |
| `content_isrc` | string |
| `audio_video` | string |
| `product_name` | string |
| `country_of_mastering` | string |
| `country_of_contribution` | string |
| `country_of_recording_1` | string |
| `country_of_recording_2` | string |
| `country_of_recording_3` | string |
| `first_year_of_recording` | string |
| `original_label` | string |
| `country_of_label_which_funded_recording` | string |
| `first_year_of_release` | string |
| `catalogue_number` | string |
| `duration` | number |
| `number_of_primary_performers` | number |
| `contribution_id` | string |
| `sax_rec_id` | string |
| `income_contributor_id` | string |
| `sale_currency` | string |
| `payee_currency` | string |

## Measures

| Name | Type |
|------|------|
| `play_count_sum` | sum |
| `play_count` | max |
| `total_usd` | sum |
| `withholding_tax_usd` | sum |
| `gross_revenue_sale_currency` | sum |
| `withholding_tax_sale_currency` | sum |
| `gross_revenue_after_withholding_tax_sale_currency` | sum |
| `net_share_sale_currency` | sum |
| `gross_revenue_payee_currency` | sum |
| `withholding_tax_payee_currency` | sum |
| `gross_revenue_after_withholding_tax_payee_currency` | sum |
| `net_share_payee_currency` | sum |

