view: staging_raw_youtube_monthly {
  sql_table_name: facts.prod.staging_raw_youtube_monthly_v2 ;;

#   measure: count {
#     type: count
#     drill_fields: [detail*]
#   }

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

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

  dimension: upc {
    type: string
    label: "UPC"
    sql: ${TABLE}.EXTRACTED_UPC ;;
  }

  dimension: extracted_upc_long {
    type: string
    label: "Extracted UPC Long"
    sql: ${TABLE}.EXTRACTED_UPC_LONG ;;
  }

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

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

  dimension_group: download_date {
    type: time
    label: "Date"
    timeframes: [
      year,
      month,
      month_num,
      quarter,
      month_name,
      quarter_of_year,
      week_of_year
    ]
    sql: ${TABLE}.DOWNLOAD_DATE ;;
  }

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

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

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

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

  measure: watch_page_views {
    type: sum
    label: "Watch Page Views"
    sql: ${TABLE}.owned_views_watch_page ;;
  }

  measure: embedded_views {
    type: sum
    label: "Embedded Views"
    sql: ${TABLE}.owned_views_embedded_player ;;
  }

  measure: channel_page_views {
    type: sum
    label: "Channel Page Views"
    sql: ${TABLE}.owned_views_channel_page ;;
  }

  measure: live_views {
    type: sum
    label: "Live Views"
    sql: ${TABLE}.owned_views_live ;;
  }

  measure: recorded_views {
    type: sum
    label: "On Demand Views"
    sql: ${TABLE}.owned_views_on_demand ;;
  }

  measure: ad_enabled_views {
    type: sum
    label: "Ad Enabled Views"
    sql: ${TABLE}.owned_views_ad_enabled ;;
  }

  measure: gross_dbl_click_yt_sold_rev {
    type: sum
    label: "Gross DoubleClick YouTube Sold"
    sql: ${TABLE}.youtube_revenue_split_doubleclick_served_youtube_sold ;;
  }

  measure: gross_dbl_click_partner_sold_rev {
    type: sum
    label: "Gross DoubleClick Partner Sold"
    sql: ${TABLE}.youtube_revenue_split_doubleclick_served_partner_sold ;;
  }

  measure: gross_adsense_sold_rev {
    type: sum
    label: "Gross AdSense YouTube Sold"
    sql: ${TABLE}.youtube_revenue_split_adsense_served_youtube_sold ;;
  }


  measure: net_dbl_click_yt_sold_rev {
    type: sum
    label: "Net DoubleClick YouTube Sold"
    sql: ${TABLE}.partner_revenue_doubleclick_served_youtube_sold ;;
  }

  measure: net_adsense_sold_rev {
    type: sum
    label: "Net AdSense YouTube Sold"
    sql: ${TABLE}.partner_revenue_adsense_served_youtube_sold ;;
  }

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

  dimension: ingestion_time {
    type: string
    label: "Ingestion Time"
    sql: ${TABLE}.INGESTION_TIME ;;
  }

  dimension: filename {
    type: string
    label: "Filename"
    sql: ${TABLE}.FILENAME ;;
  }

  dimension: filesize {
    type: number
    label: "File Size"
    sql: ${TABLE}.FILESIZE ;;
  }

  dimension: source {
    type: string
    label: "Source"
    sql: ${TABLE}.SOURCE ;;
  }

  dimension: artist {
    type: string
    label: "Artist"
    sql: ${TABLE}.ARTIST ;;
  }

  dimension: title {
    type: string
    label: "Title"
    sql: ${TABLE}.TITLE ;;
  }

  dimension: ad_requested_views {
    type: number
    label: "Ad Requested Views"
    sql: ${TABLE}.owned_views_ad_requested ;;
  }

  measure: youtube_revenue_split_partner_served_partner_sold {
    type: sum
    label: "Gross Partner Served Partner Sold"
    sql: ${TABLE}.youtube_revenue_split_partner_served_partner_sold ;;
  }

  measure: youtube_revenue_split {
    type: sum
    label: "Gross YouTube Revenue"
    sql: ${TABLE}.youtube_revenue_split ;;
  }

  measure: partner_revenue_doubleclick_served_partner_sold {
    type: sum
    label: "Net DoubleClick Partner Sold"
    sql: ${TABLE}.partner_revenue_doubleclick_served_partner_sold ;;
  }

  measure: partner_revenue_partner_served_partner_sold {
    type: sum
    label: "Net Partner Served Partner Sold"
    sql: ${TABLE}.partner_revenue_partner_served_partner_sold ;;
  }

  measure: count_distinct_videos {
    type: count_distinct
    sql: ${TABLE}.video_id ;;
  }

  parameter: label_rev_multiplier {
    type: number
    view_label: "Label Rev - Do Not Use"
    default_value: "1"
    description: "Used to calculate the label revenue - e.g. if label takes 80%, multiplier will = 4 as net partner revenue shows orchard take. of 20% and 20% x 4 = 80%"
  }

  measure: label_revenue {
    type: number
    view_label: "Label Rev - Do Not Use"
    sql: ${total_earnings}*{% parameter label_rev_multiplier %} ;;
    value_format_name: usd
    description: "Only use with label rev multipler filter - otherwise will show incorrect result"
  }

#   set: detail {
#     fields: [
#       video_id,
#       custom_id,
#       extracted_upc,
#       extracted_upc_long,
#       isrc,
#       grid,
#       download_date,
#       country,
#       content_type,
#       policy,
#       total_views,
#       watch_page_views,
#       embedded_views,
#       channel_page_views,
#       live_views,
#       recorded_views,
#       ad_enabled_views,
#       total_earnings,
#       gross_youtube_sold_revenue,
#       gross_partner_sold_rev,
#       gross_adsense_sold_rev,
#       net_yt_sold_rev,
#       net_adsense_sold_rev,
#       ingestion_time,
#       filename,
#       filesize,
#       source,
#       artist,
#       title,
#       ad_requested_views
#     ]
#   }
}