view: int_dbt_prod_youtube_subscription {
  sql_table_name: INTELLIGENCE.DBT_PROD.YOUTUBE_SUBSCRIPTION_MRR_UPDATE;;

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

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


  dimension: uploader {
    label: "Uploader"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.uploader ;;
  }
  dimension: policy {
    label: "Policy"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.policy ;;
  }
  dimension: multiple_claims {
    label: "Multiple Claims"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.multiple_claims ;;
  }
  dimension: username {
    label: "Username"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.username ;;
  }
  dimension: claim_type {
    label: "Claim Type"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.claim_type ;;
  }
  dimension: mcn_account {
    label: "MCN Account"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.mcn_account ;;
  }
  dimension: imprint_name {
    label: "Imprint Name"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.imprint_name ;;
  }
  dimension: channel_display_name {
    label: "Channel Display Name"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.channel_display_name ;;
  }
  dimension: filename {
    label: "Filename"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.filename ;;
  }
  dimension_group: date {
    type: time
    sql: ${TABLE}.day_formatted;;
    timeframes: [
      date,
      week,
      month,
      quarter,
      year
    ]
    label: "Activity"
    view_label: "Date"
  }

  dimension_group: Date {
    type: time
    sql: ${TABLE}.download_date;;
    timeframes: [
      date,
      week,
      month,
      quarter,
      year
    ]
    label: "Report"
    view_label: "Date"
  }

  dimension: video_id {
    label: "Video ID"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.video_id ;;
  }

  dimension: video_title {
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.video_title ;;
  }

  dimension: channel_id {
    type: string
    view_label: "Metadata"
    sql: IFF(${TABLE}.channel_id LIKE 'UC%', ${TABLE}.channel_id, 'UC' || ${TABLE}.channel_id) ;;
  }

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

  dimension: isrc {
    label: "ISRC"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.isrc ;;
  }

  dimension: upc {
    label: "UPC"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.current_upc;;
  }

  dimension: asset_id {
    label: "Asset ID"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.asset_id ;;
  }

  dimension: asset_channel_id {
    label: "Asset Channel ID"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.asset_channel_id ;;
  }

  dimension: asset_title {
    label: "Asset Title"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.asset_title ;;
  }

  dimension: asset_labels {
    label: "Asset Labels"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.asset_labels ;;
  }

  dimension: asset_Type {
    label: "Asset Type"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.asset_type ;;
  }

  dimension: grid {
    label: "Grid"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.grid ;;
  }

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

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

  dimension: artists {
    label: "Artist"
    view_label: "Metadata"
    type: string
    sql: ${TABLE}.artists ;;
  }

  dimension: release_name_yt_provided {
    type: string
    view_label: "Metadata"
    label: "Release Name (YT Provided)"
    sql: ${TABLE}.release_name_yt_provided ;;
  }

  measure: video_duration_seconds {
    type: number
    view_label: "Metadata"
    sql: ${TABLE}.video_duration_seconds ;;
    drill_fields: [video_id, video_title]
  }


  measure: owned_views {
    label: "Total Views"
    view_label: "Views"
    type: sum
    sql: ${TABLE}.owned_views ;;
  }

   measure: monetized_views_audio {
    label: "Monetized Views Audio"
    hidden: yes
    type: sum
    sql: ${TABLE}.monetized_views_audio ;;
  }

  measure: monetized_views_audio_visual {
    label: "Monetized Views Audio Visual"
    type: sum
    hidden: yes
    sql: ${TABLE}.monetized_views_audio_visual ;;
  }

  measure: monetized_views {
    label: "Monetized Views"
    hidden: yes
    type: sum
    sql: ${TABLE}.monetized_views ;;
  }

  measure: YOUTUBE_REVENUE_SPLIT {
    label: "Gross Youtube Revenue"
    view_label: "Revenue"
    type: sum
    sql: ${TABLE}.YOUTUBE_REVENUE_SPLIT ;;
    value_format: "$#,##0.00"
  }

  measure: PARTNER_REVENUE {
    label: "Net Partner Revenue"
    view_label: "Revenue"
    type: sum
    sql: ${TABLE}.PARTNER_REVENUE ;;
    value_format: "$#,##0.00"
  }

  measure: PARTNER_REVENUE_PRO_RATA {
    label: "Partner Revenue Pro Rata"
    type: sum
    hidden: yes
    sql: ${TABLE}.PARTNER_REVENUE_PRO_RATA ;;
    value_format: "$#,##0.00"
  }

  measure: PARTNER_REVENUE_PER_SUB_MIN {
    label: "Partner Revenue Per Sub Min"
    type: sum
    hidden: yes
    sql: ${TABLE}.PARTNER_REVENUE_PER_SUB_MIN ;;
    value_format: "$#,##0.00"
  }

}