# View: label_offering

**View Name:** label_offering
**Table Source:** `"INTELLIGENCE"."DBT_PROD"."LABEL_OFFERING"`
**File Path:** `views/label_offering.view.lkml`

## Overview

- **File Size:** 10985 bytes
- **Lines of Code:** 380
- **Dimensions:** 44
- **Measures:** 3
- **Dimension Groups:** 3
- **Filters:** 0

## Description

Closer Name - per most recent contract

## Comments & Notes

- measure: count {
- type: count
- drill_fields: [youtube_channel_service_tier_name, closer_name, youtube_channel_partner_status_name, label_country_name, label_name]

## Dimensions

| Name | Type |
|------|------|
| `closer_name` | string |
| `service_tier_name` | string |
| `collaborators_report_created` | yesno |
| `lifecycle_term_end` | string |
| `number_of_contracts_excl_flowthrough` | string |
| `lifecycle_term_start` | string |
| `has_flowthrough_contract` | string |
| `digital_split` | string |
| `flowthrough_rate` | string |
| `is_label_active` | string |
| `label_country_name` | string |
| `label_DSP_restrictions` | string |
| `label_ID` | number |
| `label_manager` | string |
| `label_name` | string |
| `label_territory_restrictions` | string |
| `notice_required_in_days` | string |
| `number_releases_ltm` | number |
| `owner` | string |
| `performance_rights_label_split` | string |
| `performance_rights_producttrack_split` | string |
| `performance_rights_uptake` | string |
| `d2c_pure_merch_label_split` | string |
| `d2c_pure_merch_producttrack_split` | string |
| `d2c_uptake` | string |
| `sync_label_split` | string |
| `sync_producttrack_split` | string |
| `sync_uptake` | string |
| `physical_label_split` | string |
| `physical_producttrack_split` | string |
| `physical_uptake` | string |
| `brand_partnership_label_split` | string |
| `brand_partnership_producttrack_split` | string |
| `brand_partnership_uptake` | string |
| `total_number_active_releases` | number |
| `youtube_channel_monetization_status` | string |
| `youtube_number_of_channels` | string |
| `youtube_channel_partner_status_name` | string |
| `youtube_channel_service_tier_name` | string |
| `contract_id` | string |
| `advertising_service_type` | string |
| `ad_credits` | string |
| `uses_advertising_services` | string |
| `publisher_earnings` | string |

## Measures

| Name | Type |
|------|------|
| `unrecouped_balance_usd` | sum |
| `gross_revenue_LTM` | sum |
| `total_advertising_amount` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `date_created` | time |
| `latest_release_sale_start` | time |
| `first_contract_start_date` | time |