view: int_dbt_prod_youtube_monthly_ads_adjustment {
  sql_table_name: INTELLIGENCE.DBT_PROD.YOUTUBE_ADS_ADJUSTMENT_V2_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: 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_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: label_id {
    label: "Label ID"
    view_label: "Label"
    type: string
    sql: ${TABLE}.label_id ;;
  }

  dimension: grid {
    label: "Grid"
    view_label: "Adjustments"
    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: "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: 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: youtube_revenue_split_auction {
    label: "YouTube Revenue Split Auction"
    view_label: "Metrics"
    hidden: yes
    type: sum
    sql: ${TABLE}.youtube_revenue_split_auction ;;
    value_format: "$#,##0.00"
  }


  measure: youtube_revenue_split_reserved {
    label: "YouTube Revenue Split Reserved"
    hidden: yes
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.youtube_revenue_split_reserved ;;
    value_format: "$#,##0.00"
  }


  measure: YOUTUBE_REVENUE_SPLIT_PARTNER_SOLD_YOUTUBE_SERVED {
    label: "YouTube Revenue Split Partner Sold Youtube Served"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.YOUTUBE_REVENUE_SPLIT_PARTNER_SOLD_YOUTUBE_SERVED ;;
    value_format: "$#,##0.00"
    hidden: yes
  }

  measure: YOUTUBE_REVENUE_SPLIT_PARTNER_SOLD_PARTNER_SERVED {
    label: "YouTube Revenue Split Partner Sold Partner Served"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.YOUTUBE_REVENUE_SPLIT_PARTNER_SOLD_PARTNER_SERVED ;;
    value_format: "$#,##0.00"
    hidden: yes

  }

  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_AUCTION {
    label: "Partner Revenue Auction"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.PARTNER_REVENUE_AUCTION ;;
    value_format: "$#,##0.00"
    hidden: yes
  }

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

  measure: PARTNER_REVENUE_PARTNER_SOLD_YOUTUBE_SERVED {
    label: "Partner Revenue Partner Sold Youtube Served"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.PARTNER_REVENUE_PARTNER_SOLD_YOUTUBE_SERVED ;;
    value_format: "$#,##0.00"
    hidden: yes

  }

  measure: PARTNER_REVENUE_PARTNER_SOLD_PARTNER_SERVED {
    label: "Partner Revenue Partner Sold Partner Served"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.PARTNER_REVENUE_PARTNER_SOLD_PARTNER_SERVED ;;
    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"
  }

  }