view: int_dev_fact_yt_estimated_revenue_by_asset {
  sql_table_name: intelligence.dev.fact_youtube_estimated_revenue_by_asset ;;

  dimension: processeddaytime {
    type: date_time
    sql: ${TABLE}.processeddaytime ;;
    hidden: yes
  }

  dimension_group: activity {
    view_label: "Date"
    type: time
    sql: ${TABLE}.download_activity_date ;;
    timeframes: [
      date,
      day_of_week,
      day_of_week_index,
      day_of_month,
      week,
      week_of_year,
      month,
      month_name,
      month_num,
      quarter,
      quarter_of_year,
      year
    ]
  }

  dimension: dayid {
    type: number
    sql: ${TABLE}.dayid ;;
    hidden: yes
  }

# SOURCE
  dimension: storeid {
    type: number
    sql: ${TABLE}.storeid ;;
    hidden: yes
  }

  dimension: activitycountryid {
    type: number
    sql: ${TABLE}.activitycountryid ;;
    hidden: yes
  }

#   dimension: content_owner {
#     type: string
#     sql: ${TABLE}.contentowner ;;
#   }

  dimension: channel_id {
    view_label: "Video"
    type: string
    sql: ${TABLE}.channelid ;;
  }

  dimension: uploader_type {
    view_label: "Video"
    type: string
    description: "Partner Uploaded or UGC"
    case: {
      when: { sql: ${TABLE}.uploadertype = 'self' ;; label: "Partner Uploaded" }
      when: { sql: ${TABLE}.uploadertype = 'thirdParty' ;; label: "UGC" }
    }

  }

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

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

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

# DESTINATION
  dimension: labelid {
    type: number
    sql: ${TABLE}.labelid ;;
    hidden: yes
  }

  dimension: artistid {
    type: number
    sql: ${TABLE}.artistid ;;
    hidden: yes
  }

  dimension: subaccountid {
    type: number
    sql: ${TABLE}.subaccountid ;;
    hidden: yes
  }

  dimension: releaseid {
    type: number
    sql: ${TABLE}.releaseid ;;
    hidden: yes
  }

  dimension: genreid {
    type: number
    sql: ${TABLE}.genreid ;;
    hidden: yes
  }

  dimension: imprintid {
    type: number
    sql: ${TABLE}.imprintid ;;
    hidden: yes
  }

  dimension: isrcid {
    type: number
    sql: ${TABLE}.isrcid ;;
    hidden: yes
  }

  dimension: trackid {
    type: number
    sql: ${TABLE}.trackid ;;
    hidden: yes
  }

  dimension: catalogid {
    type: number
    sql: ${TABLE}.catalogid ;;
    hidden: yes
  }

# METRICS
  measure: ad_impressions {
    type: sum
    sql: ${TABLE}.ad_impressions ;;
    description: "The number of verified ad impressions served."
  }

  measure: estimated_cpm {
    label: "CPM"
    type: sum
    sql: ${TABLE}.estimated_cpm ;;
    description: "The estimated gross revenue per thousand ad impressions."
  }

  measure: estimated_playback_based_cpm {
    label: "CPM (per Playback)"
    type: sum
    sql: ${TABLE}.estimated_playback_based_cpm ;;
    description: "The estimated gross revenue per thousand playbacks."
  }

  measure: estimated_monetized_playbacks {
    label: "Monetized Playbacks"
    type: sum
    sql: ${TABLE}.estimated_monetized_playbacks ;;
    description: "The number of instances when a viewer played your video and was shown at least one ad impression. A monetized playback is counted if a viewer is shown a preroll ad but quits watching the ad before your video ever starts. The expected estimated error for this figure is ±2.0%."
  }

  measure: estimated_partner_ad_auction_revenue {
    label: "Ad Revenue (Auction-Sold)"
    type: sum
    sql: ${TABLE}.estimated_partner_ad_auction_revenue ;;
    description: "The total estimated earnings (net revenue) from auction-sold advertising via AdSense for the selected date range and region. This metric was previously named estimated_partner_ad_sense_revenue."
  }

  measure: estimated_partner_ad_reserved_revenue {
    label: "Ad Revenue (Reserved-Sold)"
    type: sum
    sql: ${TABLE}.estimated_partner_ad_reserved_revenue ;;
    description: "The total estimated earnings (net revenue) from reserved-sold advertising via DoubleClick (DCLK) and other YouTube-sold sources. This metric was previously named estimated_partner_double_click_revenue."
  }

  measure: estimated_partner_ad_revenue {
    label: "Ad Revenue (Subtotal)"
    type: sum
    sql: ${TABLE}.estimated_partner_ad_revenue ;;
    description: "The total estimated net revenue from all Google-sold advertising sources for the selected date range and region. Estimated revenue metrics are subject to month-end adjustment and do not include partner-sold and partner-served advertising."
  }

  measure: estimated_partner_red_revenue {
    label: "Revenue (YouTube Red Only)"
    type: sum
    sql: ${TABLE}.estimated_partner_red_revenue ;;
    description: "The total estimated earnings (net revenue) from YouTube Red subscriptions."
  }

  measure: estimated_partner_revenue {
    label: "Revenue (Total)"
    type: sum
    sql: ${TABLE}.estimated_partner_revenue ;;
    description: "The total estimated net revenue from all Google-sold advertising sources as well as from non-advertising sources for the selected date range and region."
  }

  measure: estimated_partner_transaction_revenue {
    label: "Revenue (Transactions Only)"
    type: sum
    sql: ${TABLE}.estimated_partner_transaction_revenue ;;
    description: "The total estimated revenue from transactions, such as paid content and Fan Funding, minus any partner-charged refunds."
  }

  measure: estimated_youtube_ad_revenue {
    type: sum
    sql: ${TABLE}.estimated_youtube_ad_revenue ;;
    hidden: yes
  }
}