# View: awal_salesforce_opportunities

**View Name:** awal_salesforce_opportunities
**Table Source:** `BUSINESS_SYSTEMS_SALESFORCE_DATA.AWAL.OPPORTUNITY`
**File Path:** `awal_salesforce_opportunities.view.lkml`

## Overview

- **File Size:** 11614 bytes
- **Lines of Code:** 506
- **Dimensions:** 41
- **Measures:** 21
- **Dimension Groups:** 4
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `id` | string |
| `name` | string |
| `is_migrated_c` | string |
| `record_type_name` | string |
| `migrated_from_opportunity_c` | string |
| `artist_or_label_name_c` | string |
| `deal_type_masters_c` | string |
| `EXISTING_AGREEMENTS_ABACUSACCOUNT_ID_C` | string |
| `existing_agreements_c` | string |
| `RELATIONSHIP_TO_EXISTING_AGREEMENTS_C` | string |
| `EXISTING_AGREEMENTS_DETAILS_C` | string |
| `CROSSED_WITH_PRIOR_AGREEMENTS_C` | string |
| `stage_name` | string |
| `lead_deal_maker_c` | string |
| `other_deal_makers_c` | string |
| `deal_lawyer_c` | string |
| `deal_lost_to_c` | string |
| `LICENSE_PERIOD_IN_YEARS_C` | string |
| `scope_of_deal_c` | string |
| `client_type_c` | string |
| `client_service_tier_c` | string |
| `opportunity_currency_c` | string |
| `primary_genre_c` | string |
| `artist_gender_c` | string |
| `artist_ethnicity_race_c` | string |
| `CURRENT_LABEL_DISTRIBUTION_PARTNER_C` | string |
| `client_lawyer_c` | string |
| `LAWYER_FIRM_C` | string |
| `lawyer_email_address_C` | string |
| `country_c` | string |
| `contracting_party_country_c` | string |
| `manager_country_c` | string |
| `smereferral_c` | string |
| `smepartner_c` | string |
| `marketing_fund_admin_by_c` | string |
| `has_contingent_funding_c` | string |
| `awalrevenue_share_c` | string |
| `uplift_creative_c` | string |
| `UPLIFT_CREATIVE_ASSUMPTION_C` | string |
| `IRR_C` | string |
| `TIME_TO_RECOUP_YRS_C` | string |

## Measures

| Name | Type |
|------|------|
| `exchange_rate_c` | sum |
| `MARKETING_FUND_COMMITTED_C` | sum |
| `MARKETING_FUND_COMMITTED_USD` | sum |
| `ADVANCE_ON_SIGNING_C` | sum |
| `ADVANCE_ON_SIGNING_C_USD` | sum |
| `OTHER_COMMITTED_ADVANCES_C` | sum |
| `OTHER_COMMITTED_ADVANCES_USD` | sum |
| `RECORDING_FUND_C` | sum |
| `RECORDING_FUND_USD` | sum |
| `tour_funding_c` | sum |
| `tour_funding_USD` | sum |
| `non_recoupable_funding_c` | sum |
| `non_recoupable_funding_USD` | sum |
| `legal_fees_contribution_c` | sum |
| `legal_fees_contribution_USD` | sum |
| `contingent_funding_c` | sum |
| `contingent_funding_USD` | sum |
| `ESTIMATED_REVENUE_3_YR_C` | sum |
| `ESTIMATED_REVENUE_3_YR_USD` | sum |
| `ESTIMATED_REVENUE_BASE_CASE_C` | sum |
| `estimated_revenue_base_case_USD` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `signed_date_c` | time |
| `close_date` | time |
| `estimated_delivery_c` | time |
| `EST_RELEASE_TIMING_DATE_ESTIMATE_C` | time |