view: int_dbt_prod_new_deal_revenue_summary {
  # You can specify the table name if it's different from the view name:
  sql_table_name: intelligence.dbt_prod_strategy.salesforce_new_deal_revenue_summary ;;

  # Define your dimensions and measures here, like this:
  dimension: label_id {
    description: "Unique Label ID"
    type: number
    sql: ${TABLE}.label_id ;;
  }

  dimension: label {
    description: "Label Name"
    type: string
    sql: ${TABLE}.label ;;
  }

  dimension: deal_type {
    description: "Type of deal executed"
    type: string
    sql: ${TABLE}.deal_type ;;
  }

  dimension: contracting_entity {
    description: "Orchard team executing the contract"
    type: string
    sql: ${TABLE}.contracting_entity ;;
  }

  dimension: label_country {
    description: "Country where the label operates from"
    type: string
    sql: ${TABLE}.label_country ;;
  }

  dimension: service_tier {
    description: "Assigned service tier for the label"
    type: string
    sql: ${TABLE}.service_tier ;;
  }

  dimension: closer {
    description: "Name of the Orchard closer for the label's deal"
    type: string
    sql: ${TABLE}.closer ;;
  }

  dimension: relationship_manager {
    description: "Name of the Orchard assigned Relationship Manager"
    type: string
    sql: ${TABLE}.relationship_manager ;;
  }

  dimension: owner {
    description: "Orchard defined label owner"
    type: string
    sql: ${TABLE}.owner ;;
  }

  measure: active_tracks {
    description: "Number of current active tracks released by the label"
    type: sum
    sql: ${TABLE}.active_tracks ;;
  }

  measure: projected_first_year_revenue {
    description: "Projected first year revenue defined by the deal model"
    type: sum
    sql: ${TABLE}.projected_first_year_revenue ;;
  }

  measure: advance_amount {
    description: "Advance agreed to as part of the deal"
    type: sum
    sql: ${TABLE}.advance_amount ;;
  }

  dimension: currency {
    description: "Currency of the advance amount"
    type: string
    sql: ${TABLE}.currency ;;
  }

  measure: advance_in_usd {
    description: "Advance amount converted to USD"
    type: sum
    sql: ${TABLE}.advance_in_usd ;;
  }

  measure: distribution_fee {
    description: "Digital distribution fee agreed to in the deal"
    type: average
    sql: ${TABLE}.distribution_fee ;;
  }

  dimension: contract_executed_date {
    description: "Date in which the contract was executed"
    type: date
    sql: ${TABLE}.contract_executed_date ;;
  }

  dimension: account_activated_date {
    description: "Date in which the account was activated in OA"
    type: date
    sql: ${TABLE}.account_activated_date ;;
  }

  dimension: activated_month {
    description: "Month when the account was activated in OA"
    type: date
    sql: ${TABLE}.activated_month ;;
  }

  dimension: max_activity_date {
    description: "Most recent month of activity revenue (null if no revenue generated)"
    type: date
    sql: ${TABLE}.max_activity_date ;;
  }

  dimension: min_activity_date {
    description: "First month of activity revenue (null if no revenue generated)"
    type: date
    sql: ${TABLE}.min_activity_date ;;
  }

  dimension: months_from_activated {
    description: "Number of months since the account was activated (-1 if this month)"
    type: number
    sql: ${TABLE}.months_from_activated ;;
  }

  dimension: months_from_first_rev {
    description: "Number of months since first activity revenue (0 if no revenue generated)"
    type: number
    sql: ${TABLE}.months_from_first_rev ;;
  }

  measure: gross_revenue_to_date {
    description: "Total revenue generated to date"
    type: sum
    sql: ${TABLE}.gross_revenue_to_date ;;
  }

  dimension: score {
    description: "Score based on the difference between revenue generated and projected revenue, as well as time elapsed"
    type: number
    sql: ${TABLE}.score ;;
  }

  dimension: score_status {
    description: "Status of score based on value (Red < 75, Green > 100, no data = either no revenue generated or no projection input)"
    type: string
    sql: ${TABLE}.score_status ;;
  }
}