view: advertising_requests {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."ORCHARD_NEW_ADVERTISING_REQUESTS" ;;

  dimension: label_name {
    description: "Label Name"
    view_label: "Label Details"
    type: string
    sql: ${TABLE}."LABEL_NAME" ;;
  }

  dimension: label_manager {
    description: "Label Manager"
    view_label: "Label Details"
    type: string
    sql: ${TABLE}."LABEL_MANAGER" ;;
  }

  dimension: label_id {
    description: "Label ID"
    view_label: "Label Details"
    type: string
    sql: ${TABLE}."LABEL_ID" ;;
  }

  dimension: UPC {
    description: "UPC"
    view_label: "Release"
    type: string
    sql: ${TABLE}."UPC" ;;
  }

  dimension: exceptions {
    description: "Exception (from label) (from release UPC)"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."EXCEPTIONS" ;;
  }

  dimension: artist_name {
    description: "Artist Name"
    view_label: "Release"
    type: string
    sql: ${TABLE}."ARTIST_NAME" ;;
  }

  dimension: release_name {
    description: "Release Name"
    view_label: "Release"
    type: string
    sql: ${TABLE}."RELEASE_NAME" ;;
  }

  dimension: invoice_number {
    description: "Invoice Number"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."INVOICE_NUMBER" ;;
  }

  dimension: distribution_fee {
    description: "Distribution fee"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."DISTRO_FEE" ;;
  }

  dimension: campaign_objective {
    description: "Campaign Objective"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."CAMPAIGN_OBJECTIVE" ;;
  }

  dimension: status {
    description: "Request Status - The stage at which the request is at"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."STATUS" ;;
  }

  dimension: requester_name {
    description: "Name of the person who submitted the form"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUESTER_NAME" ;;
  }

  dimension: requester_email {
    description: "Email of the person who submitted the form"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUESTER_EMAIL" ;;
  }

  dimension: request_id {
    description: "Request ID"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUEST_ID" ;;
  }

  dimension: request_reference {
    description: "Artist name + release name + request ID"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUEST_REFERENCE" ;;
  }

  dimension: assigned_to {
    description: "Who is the request assigned to  - legacy field"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."ASSIGNED_TO" ;;
  }

  dimension: strategy_assigned_to_name {
    description: "Who is the request assigned to  - newer field"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."STRATEGY_ASSIGNED_TO_NAME" ;;
  }

  dimension: autonumber {
    description: "Autonumber"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."AUTONUMBER" ;;
  }

  dimension: priority {
    description: "Priority Level of Label of the Request"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."PRIORITY" ;;
  }

  dimension: PO_number {
    description: "PO number"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."PO_NUMBER" ;;
  }

  dimension: territory_assignment {
    description: "The territory to which the request was assigned"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."TERRITORY_ASSIGNMENT" ;;
  }

  dimension: label_tier_request {
    description: "The Label Tier of requesting Label"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."LABEL_TIER_REQUEST" ;;
  }

  dimension: form_version {
    description: "Which form version was used"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."FORM_VERSION" ;;
  }

  dimension: payment {
    description: "Type of payment (Recoupable, invoice, credits etc.)"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."PAYMENT" ;;
  }

  dimension: admin_fee {
    description: "Advertising fee to charge on top of advertising spend"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."ADMIN_FEE" ;;
  }

  measure: allocated_budget {
    description: "The budget allocated to the request"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."ALLOCATED_BUDGET" ;;
    value_format:"$#,##0"
  }

  measure: budget {
    description: "Amount in dollars to spend"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."BUDGET" ;;
    value_format:"$#,##0"
  }

  measure: new_adjusted_costs {
    description: "The cumulative `total adjusted costs` from all linked Campaign records.Same as Total Adjusted costs"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."NEW_ADJUSTED_COSTS" ;;
    value_format:"$#,##0"
  }

  measure: total_adjusted_cost {
    description: "The cumulative `total adjusted costs` from all linked Campaign records. Same as New Adjusted Costs"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."TOTAL_ADJUSTED_COSTS" ;;
    value_format:"$#,##0"
  }

  measure: new_label_amount {
    description: "The cumulative `total label amount` from all linked Campaign records. Same as Total Label Amount"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."NEW_LABEL_AMOUNT" ;;
    value_format:"$#,##0"
  }

  measure: total_label_amount {
    description: "The cumulative `total label amount` from all linked Campaign records. Same as New Label Amount"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."TOTAL_LABEL_AMOUNT" ;;
    value_format:"$#,##0"
  }

  measure: total_fees {
    description: "Sum of the fees that were applied to the various campaigns assigned to the request"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."TOTAL_FEES" ;;
    value_format:"$#,##0"
  }

  measure: new_fees {
    description: "Commissions charged to date"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."NEW_FEES" ;;
    value_format:"$#,##0"
  }

  dimension_group: form_submitted{
    description: "When the form was submitted (date)"
    view_label: "Advertising"
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."FORM_SUBMITTED" ;;
  }
}