view: int_dbt_prod_new_deal_revenue_activity {
  # 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_by_activity_date ;;

  # 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 ;;
  }

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

  dimension: activity_date {
    description: "Month of activity"
    type: date_month
    sql: ${TABLE}.activity_date ;;
  }

  measure: gross_revenue {
    description: "Activity revenue"
    type: number
    sql: sum(${TABLE}.gross_revenue) ;;
  }

  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 ;;
  }
}