view: advertising_campaigns {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."ORCHARD_NEW_ADVERTISING_CAMPAIGNS" ;;

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

  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}."RELEASE_UPC" ;;
  }

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

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

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

  dimension: operational_rate {
    description: "Operational Rate"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."OPERATIONAL_RATE" ;;
  }

  dimension: distro_fee {
    description: "Distro Fee"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."DISTRO_FEE" ;;
  }

  dimension: activity_invoices {
    description: "Activity Invoices"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."ACTIVITY_INVOICES" ;;
  }

  dimension: quarter {
    description: "Quarter"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."QUARTER" ;;
  }


  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: request_id {
    description: "ID of the request the campaign is tied to"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUEST_ID" ;;
  }

  dimension: request_status {
    description: "Status of the request the campaign is tied to"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUEST_STATUS" ;;
  }

  dimension: form_submitted {
    description: "Form Submitted"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."FORM_SUBMITTED" ;;
  }

  dimension: service_type {
    description: "Service Type"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."SERVICE_TYPE" ;;
  }

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

  dimension: label_tier {
    description: "Label Tier"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."LABEL_TIER" ;;
  }

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

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

##  measure: total_adjusted_cost {
##    description: "Total monthly costs + total adjustments"
##    view_label: "Advertising"
##    type: sum
##    sql: ${TABLE}."TOTAL_ADJUSTED_COSTS" ;;
##    value_format:"$#,##0"
##  }

  measure: total_fees {
    description: "Sum of the fees that were applied to the campaign"
    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: assigned_to_name {
    description: "Who is the campagin assigned to  - legacy field"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."ASSIGNED_TO_NAME" ;;
  }

  dimension: support_assigned_to_name {
    description: "Who is the request assigned to?"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."SUPPORT_ASSIGNED_TO_NAME" ;;
  }

  dimension: media_buy_assigned_to_name {
    description: "Who has been assigned to book the ads"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."MEDIA_BUY_ASSIGNED_TO_NAME" ;;
  }

  dimension: review_assigned_to_name {
    description: "Review Assigned to"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REVIEW_ASSIGNED_TO" ;;
  }

  dimension: report_assigned_to_name {
    description: "Report Assigned to"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REPORT_ASSIGNED_TO" ;;
  }

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

  measure: total_label_amount {
    description: "The total amount that needs to be charged to the label"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."TOTAL_LABEL_AMOUNT" ;;
    value_format:"$#,##0"
  }

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

##  measure: total_monthly_costs {
##    description: "Same as Total Adjusted Costs"
##    view_label: "Advertising"
##    type: sum
##    sql: ${TABLE}."TOTAL_MONTHLY_COSTS" ;;
##    value_format:"$#,##0"
##  }

##  measure: new_monthly_costs {
##    description: ""
##    view_label: "Advertising"
##    type: sum
##    sql: ${TABLE}."NEW_MONTHLY_COSTS" ;;
##    value_format:"$#,##0"
##  }

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

dimension: range_months {
  description: "Range Months"
  view_label: "Advertising"
  type: string
  sql: ${TABLE}."RANGE_MONTHS" ;;
}

dimension: link_to_ad_plan {
  description: "Link to Ad Plan"
  view_label: "Advertising"
  type: string
  sql: ${TABLE}."LINK_TO_AD_PLAN" ;;
}

dimension: cta_link {
  description: "CTA Link"
  view_label: "Advertising"
  type: string
  sql: ${TABLE}."CTA_LINK" ;;
}


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



 ## dimension_group: created{
 ##   description: "When the campaign line was created"
 ##    view_label: "Advertising"
 ##    type: time
 ##    timeframes: [raw, date, week, month, quarter, year]
 ##    convert_tz: no
 ##    datatype: date
 ##    sql: ${TABLE}."CREATED" ;;
 ##  }

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

  dimension_group: start_date{
    description: "Campaign Start Date"
    view_label: "Advertising"
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."START_DATE" ;;
  }

  dimension_group: end_date{
    description: "Campaign End Date"
    view_label: "Advertising"
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."END_DATE" ;;
  }

  dimension: campaign_phase {
    description: "Phase of the Campaign"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."CAMPAIGN_PHASE" ;;
  }

 ## dimension: basecamp_ticket_submitted {
 ##     description: "Field indicating whether a ticket has been submitted to the design team for assets creation"
 ##     view_label: "Advertising"
 ##     type: string
 ##     sql: ${TABLE}."BASECAMP_TICKET_SUBMITTED" ;;
 ##   }

 ## dimension: custom_title {
 ##  description: "Any additional info needed on the campaign name"
 ##   view_label: "Advertising"
 ##    type: string
 ##  sql: ${TABLE}."CUSTOM_TITLE" ;;
 ## }

 ## dimension: platform_billing_name {
 ##    description: "Extended name of the ad platform for billing"
 ##    view_label: "Advertising"
 ##    type: string
 ##    sql: ${TABLE}."PLATFORM_BILLING_NAME" ;;
 ##  }

  dimension: platform {
    description: "Which platform the ads will run on"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."PLATFORM" ;;
  }

## dimension: platform_id {
##    description: "ID assigned to the ad platform chosen"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."PLATFORM_ID" ;;
##  }

##  dimension: platform_shorthand {
##    description: "The 3 letters assigned to each platform and platform combination in the campaign name"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."PLATFORM_SHORTHAND" ;;
##  }

##  dimension: campaign_id {
##    description: "Campaign ID"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."CAMPAIGN_ID" ;;
##  }

 ## dimension: over_budget {
 ##    description: "Field indicating whether campaign went overbudget or not"
 ##   view_label: "Advertising"
 ##    type: string
 ##    sql: ${TABLE}."OVER_BUDGET" ;;
 ##  }

  dimension: campaign_reference {
    description: "Full Campaign Name"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."CAMPAIGN_REFERENCE" ;;
  }

##  dimension: naming_convention_new {
##    description: "Campaign name with assigned new naming convention"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."NAMING_CONVENTION_NEW" ;;
##  }

  dimension: request {
    description: "The request to which the campaign is tied"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUEST" ;;
  }

##  measure: full_campaign_budget {
##    description: "Field summing data from all campaigns related to the request."
##    view_label: "Advertising"
##    type: sum
##    sql: ${TABLE}."FULL_CAMPAIGN_BUDGET" ;;
##    value_format:"$#,##0"
##  }

  measure: platform_budget {
    description: "Budget minus admin fee to place as budget on the ad platform"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."PLATFORM_BUDGET" ;;
    value_format:"$#,##0"
  }

  measure: platform_balance {
    description: "The balance of what was spent on the ad platform"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."PLATFORM_BALANCE" ;;
    value_format:"$#,##0"
  }

}