# View: int_dbt_prod_struggling_deal_analysis

**View Name:** int_dbt_prod_struggling_deal_analysis
**Table Source:** `intelligence.dbt_prod_strategy.struggling_deal_analysis`
**File Path:** `views/deal_risk_analysis/int_dbt_prod_struggling_deal_analysis.view.lkml`

## Overview

- **File Size:** 11318 bytes
- **Lines of Code:** 329
- **Dimensions:** 29
- **Measures:** 20
- **Dimension Groups:** 0
- **Filters:** 0

## Description

Primary Key

## Comments & Notes

- dimension: primary_key {
- primary_key: yes
- hidden: yes

## Dimensions

| Name | Type |
|------|------|
| `parent_company` | string |
| `brand` | string |
| `label_id` | number |
| `label_name` | string |
| `service_tier_name` | string |
| `label_country` | string |
| `closer` | string |
| `relationship_manager` | string |
| `owner` | string |
| `status` | string |
| `us_latin_label` | string |
| `total_active_tracks` | number |
| `ltm_release_count` | number |
| `latest_accounting_month` | date |
| `last_advance_paid_date` | date |
| `total_advance_paid` | number |
| `has_outstanding_advance` | string |
| `outstanding_balance` | number |
| `advance_recoupable_percentage` | number |
| `flow_through_rate` | number |
| `original_contract_start_date` | date |
| `current_contract_end_date` | date |
| `remaining_term_years` | number |
| `years_since_initial_contract` | number |
| `is_early_stage_deal` | string |
| `expected_balance_at_the_end_of_current_terms_pct_of_outstanding_balance` | number |
| `contract_extension_years` | string |
| `expected_balance_at_end_of_term_plus_extension_years_pct_of_current_outstanding_balance` | number |
| `recoupment_risk_staus` | string |

## Measures

| Name | Type |
|------|------|
| `ltm_gross_revenue_usd` | sum |
| `ltm_net_revenue_usd` | sum |
| `ltm_min_1_gross_revenue_usd` | sum |
| `ltm_min_1_net_revenue_usd` | sum |
| `total_advance_paid_to_date` | sum |
| `unpaid_advance_amount` | sum |
| `outstanding_balance_usd` | sum |
| `balance_per_year_of_remaining_term` | sum |
| `balance_outstanding_pct_of_total_advance` | sum |
| `recoupable_revenue` | sum |
| `balance_per_dollar_of_ltm_revenue` | sum |
| `est_revenue_over_remaining_term_run_rate` | sum |
| `expected_balance_at_the_end_of_current_term` | sum |
| `expected_balance_at_end_of_term_plus_one_year` | sum |
| `expected_balance_at_end_of_term_plus_two_years` | sum |
| `expected_balance_at_end_of_term_plus_three_years` | sum |
| `expected_balance_at_end_of_term_plus_four_years` | sum |
| `expected_balance_at_end_of_term_plus_five_years` | sum |
| `expected_balanace_at_end_of_term_plus_years_needed_to_recoup` | sum |
| `deals_count_by_risk_status` | number |