connection: "youtube-looker"
label: "Rights Management & Content Integrity"

include: "/views/dt_youtube_dashboard.view.lkml"
include: "/views/dt_avod_svod_join.view.lkml"
include: "/views/dt_yt_conflicts.view.lkml"
include: "/views/dt_isrc_assignment_history.view.lkml"
include: "/views/dt_account_termination.view.lkml"
include: "/views/facts_prod_youtube_monthly_ad_enabled.view.lkml"
include: "/views/int_dbt_prod_youtube_subscription.view.lkml"
include: "/views/yt_performance_report/month_year.view.lkml"
include: "/views/yt_performance_report/total_revenue_views.view.lkml"
include: "/views/yt_performance_report/avod_revenue_views.view.lkml"
include: "/views/yt_performance_report/svod_revenue_views.view.lkml"
include: "/views/yt_performance_report/ugc_revenue_views.view.lkml"
include: "/views/yt_performance_report/premium_revenue_views.view.lkml"
include: "/views/yt_performance_report/art_tracks_revenue_views.view.lkml"
include: "/views/yt_performance_report/cpm.view.lkml"
include: "/views/yt_performance_report/cpm_fill_rate.view.lkml"
include: "/views/yt_performance_report/revenue_pie_chart.view.lkml"
include: "/views/yt_performance_report/rpm_timeline.view.lkml"
include: "/views/yt_performance_report/views_pie_chart.view.lkml"
include: "/views/dt_apple_lyrics_breakdown.view.lkml"
include: "/views/yt_performance_report/content_type_combined.view.lkml"
include: "/views/yt_performance_report/top_ten_countries.view.lkml"
include: "/views/dt_incomplete_reviews.view.lkml"
include: "/views/yt_performance_report/fiscal_yr_comparison.view.lkml"
include: "/views/dt_registry_territory_match.view.lkml"
include: "/views/tiktok_conflicts/tiktok_carveout_monetization.view.lkml"
include: "/views/tiktok_conflicts/no_tiktok_carveout_no_monetization.view.lkml"
include: "/views/tiktok_conflicts/territory_carveout_missing_monetization.view.lkml"
include: "/views/dt_Third_Party_Publishing_Claims.view.lkml"
include: "/views/dt_tier_change_log.view.lkml"
include: "/views/dt_gross_revenue_active_products.view.lkml"
include: "/views/staging_raw_tiktok_openescrow.view.lkml"
include: "/views/yt_assets_project_space/yt_conflict_report_final.view.lkml"
include: "/views/periscope_migration/content_integrity_team_analytics/cr_team_members.view.lkml"
include: "/views/yt_assets_project_space/dim_track.view.lkml"
include: "/views/yt_assets_project_space/dim_release.view.lkml"
include: "/views/yt_assets_project_space/dim_artist.view.lkml"
include: "/views/yt_assets_project_space/dim_label.view.lkml"
include: "/views/yt_assets_project_space/dim_subaccount.view.lkml"
include: "/views/int_dbt_prod_awal_tier_groups.view.lkml"
include: "/views/yt_assets_project_space/ows_conflict_manager_prod_action.view.lkml"


explore: dt_youtube_dashboard {
  label: "YouTube Partnered Channels"
  view_label: "YouTube"
  hidden: no
}

explore: dt_avod_svod_join {
  label: "AVOD/SVOD Join"
  view_label: "AVOD/SVOD"
  hidden: yes
}

explore: dt_yt_conflicts {
  label: "YouTube Conflicts"
  view_label: "YouTube Conflicts"
  hidden: yes
}

explore: dt_isrc_assignment_history {
  label: "ISRC Assignment History"
  hidden: yes
}

explore: dt_account_termination {
  label: "Account Termination"
  hidden: no
}

explore: month_year {
  label: "Month/Year"
  hidden: yes
}

explore: total_revenue_views {
  label: "Total Revenue/Views"
  hidden: yes
}

explore: avod_revenue_views {
  label: "AVOD Revenue/Views"
  hidden: yes
}

explore: svod_revenue_views {
  label: "SVOD Revenue/Views"
  hidden: yes
}

explore: ugc_revenue_views {
  label: "UGC Revenue/Views"
  hidden: yes
}

explore: premium_revenue_views {
  label: "Premium Revenue/Views"
  hidden: yes
}

explore: art_tracks_revenue_views {
  label: "Art Tracks Revenue/Views"
  hidden: yes
}

explore: cpm {
  label: "CPM"
  hidden: yes
}

explore: cpm_fill_rate {
  label: "CPM Fill Rate"
  hidden: yes
}

explore: revenue_pie_chart {
  label: "Revenue Pie Chart"
  hidden: yes
}

explore: rpm_timeline {
  label: "RPM Timeline"
  hidden: yes
}

explore: views_pie_chart {
  label: "Views Pie Chart"
  hidden: yes
}

explore: dt_apple_lyrics_breakdown {
  label: "Apple Lyrics Breakdown"
  hidden: yes
}

explore: content_type_combined {
  label: "Content Type Combined"
  hidden: yes
}

explore: top_ten_countries {
  label: "Top Ten Countries"
  hidden: yes
}

explore: dt_incomplete_reviews {
  label: "Incomplete Reviews"
  hidden: no
}

explore: fiscal_yr_comparison {
  label: "Fiscal Year Comparison"
  hidden: yes
}

explore: dt_registry_territory_match {
  label: "Registry Territory Match"
  hidden: yes
}

explore: tiktok_carveout_monetization {
  label: "TikTok Carveout with Monetization"
  hidden: yes
}

explore: no_tiktok_carveout_no_monetization {
  label: "No TikTok Carveout with Missing Monetization"
  hidden: yes
}

explore: territory_carveout_missing_monetization {
  label: "Territory Carveout with No Matching Monetization"
  hidden: yes
}

explore: dt_third_party_publishing_claims {
  label: "Third Party Publishing Claims"
  hidden: yes
}

explore: dt_tier_change_log {
  label: "Tier Change Log"
  view_label: "Tier Change Log"
  hidden: yes
}

explore: dt_gross_revenue_active_products {
  label: "Label Gross Revenue vs. Active Products"
  view_label: "Label Gross Revenue vs. Active Products"
  hidden: yes
}

explore: staging_raw_tiktok_openescrow {
  label: "TikTok Open Escrow Reporting"
  view_label: "TikTok Open Escrow Reporting"
  hidden: yes

  join: yt_conflict_report_final {
    relationship: many_to_one
    view_label: "SR Registry"
    sql_on: ${staging_raw_tiktok_openescrow.isrc}=${yt_conflict_report_final.isrc}
        AND ${yt_conflict_report_final.resolved_datetime_date} is null;;
    fields: [isrc]
  }

  join: dim_track {
    sql_on: ${yt_conflict_report_final.tuid} = ${dim_track.track_unique_id};;
    type:  inner
    relationship: many_to_one
  }

  join: dim_release {
    relationship: many_to_one
    sql_on: ${dim_track.upc}=${dim_release.upc};;
  }

  join: dim_subaccount {
    relationship: many_to_one
    sql_on: ${dim_release.subaccount_id}=${dim_subaccount.subaccount_id};;
  }

  join: dim_artist {
    relationship: many_to_one
    sql_on: ${dim_release.artist_id} = ${dim_artist.artist_id} ;;
  }

  join: dim_label {
    relationship: many_to_one
    sql_on: ${dim_artist.label_id} = ${dim_label.label_id} ;;
  }

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${dim_label.label_id}= ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
  }

  join: yt_conflict_action {
    sql_on:   ${yt_conflict_action.conflict_id}=${yt_conflict_report_final.conflict_id} ;;
    type: left_outer
    relationship: many_to_one
  }
}

explore: cr_team_members {
  label: "CR Team Members"
  hidden: yes
}