view: yt_avod_revenue_views {
 sql_table_name: INTELLIGENCE.DBT_PROD.YOUTUBE_AD_SUPPORTED_MRR_UPDATE ;;

  dimension: primary_key {
    type: string
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.primary_key;;
  }

  dimension: isrc {
    label: "ISRC"
    type: string
    sql: ${TABLE}.isrc ;;
    hidden: yes
  }

  dimension: mcn_account {
    label: "MCN Account"
    type: string
    sql: ${TABLE}.mcn_account ;;
  }

  dimension_group: download_date {
    type: time
    sql: ${TABLE}.download_date ;;
    timeframes: [
      month,
      quarter,
      year
    ]
    label: "Download"
    description: "Month for which the report is"
  }

  dimension: country_code {
    label: "Country Code"
    type: string
    sql: ${TABLE}.country_code ;;
  }

  dimension: content_type {
    label: "Content Type"
    type: string
    sql: ${TABLE}.content_type ;;
  }

  measure: owned_views {
    label: "Total Views"
    description: "Total views on a video"
    type: sum
    sql: ${TABLE}.owned_views ;;
  }

  measure: PARTNER_REVENUE {
    label: "Net Partner Revenue"
    description: "Revenue paid by YT to the Orchard before we have processed revenue statements"
    type: sum
    sql: ${TABLE}.PARTNER_REVENUE ;;
    value_format: "$#,##0.00"
  }

  dimension: channel_id {
    label: "Channel ID"
    type: string
    sql: ${TABLE}.channel_id ;;
  }

  dimension: custom_id {
    label: "Custom ID"
    type: string
    sql: ${TABLE}.custom_id ;;
  }


  dimension: policy {
    label: "Policy"
    type: string
    sql: ${TABLE}.policy ;;
  }
}