view: int_dbt_prod_youtube_subscription_adjustment {
  sql_table_name: INTELLIGENCE.DBT_PROD.YOUTUBE_SUBSCRIPTION_ADJUSTMENT_MRR_UPDATE ;;

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



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

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

  dimension_group: day_formatted {
    label: "Activity"
    description: "Date of consumption"
    view_label: "Date"
    type: time
    sql: ${TABLE}.day_formatted;;
    timeframes: [
      date,
      week,
      month,
      quarter,
      year
    ]
  }

  dimension: adjustment_type {
    label: "Adjustment Type"
    view_label: "Adjustments"
    type: string
    sql: ${TABLE}.adjustment_type ;;
  }

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

  dimension: video_title {
    label: "Video Title"
    view_label: "Video"
    type: string
    sql: ${TABLE}.video_title ;;
  }

  dimension: video_duration_sec {
    label: "Video Duration (seconds)"
    view_label: "Video"
    type: number
    sql: ${TABLE}.video_duration_sec ;;
  }

  dimension: username {
    label: "Username"
    view_label: "Video"
    type: string
    sql: ${TABLE}.username ;;
  }

  dimension: uploader {
    label: "Uploader"
    view_label: "Video"
    type: string
    sql: ${TABLE}.uploader ;;
  }

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

  }

  dimension: channel_name {
    label: "Channel Name"
    view_label: "Channel"
    type: string
    sql: ${TABLE}.channel_name ;;

  }

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

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

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

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

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

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

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

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

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

  dimension: imprint {
    label: "Imprint Name"
    view_label: "Release"
    type: string
    sql: ${TABLE}.subaccount ;;
  }

  dimension: yt_provided_artist_name {
    label: "Artist Name (YT provided)"
    view_label: "Artist"
    type: string
    sql: ${TABLE}.yt_provided_artist_name ;;
  }

  dimension: yt_provided_release_name {
    label: "Release Name (YT provided)"
    view_label: "Release"
    type: string
    sql: ${TABLE}.yt_provided_release_name ;;
  }

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

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

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

  dimension: claim_type {
    label: "Claim Type"
    view_label: "Claim"
    type: string
    sql: ${TABLE}.claim_type ;;
  }

  dimension: multiple_claims {
    label: "Multiple Claims (Yes/ No)"
    view_label: "Claim"
    type: string
    sql: ${TABLE}.multiple_claims ;;
  }

  dimension: subscription_type {
    label: "Subscription Type"
    view_label: "Video"
    type: string
    sql: ${TABLE}.subscription_type ;;
  }

  dimension: claim_origin {
    label: "Claim Origin"
    view_label: "Claim"
    type: string
    sql: ${TABLE}.claim_origin ;;
  }

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

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

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

  measure: monetized_views_video {
    label: "Monetized Views (Video)"
    hidden: yes
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.monetized_views_video ;;
  }

  measure: monetized_views_audiovisual {
    label: "Monetized Views (Audiovisual)"
    hidden: yes
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.monetized_views_audio_visual ;;
  }

  measure: YOUTUBE_REVENUE_SPLIT {
    label: "Gross YouTube Revenue"
    description: "Total revenue generated including YT share"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.YOUTUBE_REVENUE_SPLIT ;;
    value_format: "$#,##0.00"
  }

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

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

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

}