view: int_dbt_prod_spotify_playlist_downstream_impact_6_month_avg {
  sql_table_name: intelligence.dbt_prod.spotify_playlist_downstream_impact_6_month_avg ;;

  dimension: playlist_uri {
    view_label: "Playlist"
    label: "Playlist URI"
    primary_key: yes
    type: string
    hidden: yes
    sql: ${TABLE}.discovery_playlist_uri ;;
  }

  dimension: avg_discovery_playlist_streams_per_track {
    view_label: "Playlist Metrics"
    label: "Potential Discovery Placement Impact (Track Level)"
    type: number
    description: "The potential streaming impact a placement on a playlist could achieve from streams generated by users discovering a track from the playlist only. This metric is derived by taking an average of the streams per track generated over the last 6 months"
    sql: zeroifnull(${TABLE}.avg_discovery_playlist_streams_per_track) ;;
    value_format: "0"
  }


  dimension: avg_discovery_downstream_impact_playlist_streams_per_track {
    view_label: "Playlist Metrics"
    label: "Potential Downstream Impact (Track Level)"
    type: number
    description: "The potential downstream streaming impact a placement on a playlist could achieve from streams generated away from the playlist by users who discovered a track on the playlist. This metric is derived by taking an average of the downstream impact streams per track generated over the last 6 months"
    sql: zeroifnull(${TABLE}.avg_downstream_impact_streams_streams_per_track) ;;
    value_format: "0"
  }

  dimension: avg_total_playlist_streams_per_track {
    view_label: "Playlist Metrics"
    label: "Potential Total Discovery Placement Impact (Track Level)"
    type: number
    description: "The total potential streams generated (both on and off the playlist) from users who discover a track on a playlist. This metric is derived by taking an average of the total streams per track generated over the last 6 months"
    sql: zeroifnull(${TABLE}.avg_total_streams_per_track) ;;
    value_format: "0"
  }


  }