view: int_dbt_prod_weekly_trending_genres_tiktok {
  sql_table_name: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_GENRES_TIKTOK ;;



  dimension: territory {
    view_label: "Transaction Country"
    label: "Country Code"
    type: string
    sql: ${TABLE}.territory ;;
  }

  dimension: genre {
    view_label: "Genre"
    label: "Genre"
    type: string
    sql: ${TABLE}.genre ;;
  }



  dimension: current_week_creations {
    view_label: "Metrics"
    label: "Weekly Creations"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_creations;;
  }

  dimension: average_creations {
    view_label: "Metrics"
    label: "Average Creations"
    type: number
    hidden: no
    sql: ${TABLE}.avg_creations;;
    value_format: "#,##0"
  }

  dimension: percent_above_average {
    view_label: "Metrics"
    label: "Percent Above Average Creations"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_creations;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation {
    view_label: "Metrics"
    label: "Standard Deviation Creations"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_creations;;
    value_format: "#,##0"
  }

  dimension: spike_score {
    view_label: "Metrics"
    label: "Spike Score Creations"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_creations;;
    value_format: "0.##"
  }

  dimension: current_week_video_views {
    view_label: "Metrics"
    label: "Weekly Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_video_views;;
  }

  dimension: average_video_views {
    view_label: "Metrics"
    label: "Average Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.avg_video_views;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_video_views {
    view_label: "Metrics"
    label: "Percent Above Average Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_video_views;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_video_views {
    view_label: "Metrics"
    label: "Standard Deviation Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_video_views;;
    value_format: "#,##0"
  }

  dimension: spike_score_video_views {
    view_label: "Metrics"
    label: "Spike Score Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_video_views;;
    value_format: "0.##"
  }




  dimension: current_week_comments {
    view_label: "Metrics"
    label: "Weekly Comments"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_comments;;
  }

  dimension: average_comments {
    view_label: "Metrics"
    label: "Average Comments"
    type: number
    hidden: no
    sql: ${TABLE}.avg_comments;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_comments {
    view_label: "Metrics"
    label: "Percent Above Average Comments"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_comments;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_comments {
    view_label: "Metrics"
    label: "Standard Deviation Comments"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_comments;;
    value_format: "#,##0"
  }

  dimension: spike_score_comments {
    view_label: "Metrics"
    label: "Spike Score Comments"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_comments;;
    value_format: "0.##"
  }

  dimension: current_week_likes {
    view_label: "Metrics"
    label: "Weekly Likes"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_likes;;
  }

  dimension: average_likes {
    view_label: "Metrics"
    label: "Average Likes"
    type: number
    hidden: no
    sql: ${TABLE}.avg_likes;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_likes {
    view_label: "Metrics"
    label: "Percent Above Average Likes"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_likes;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_likes {
    view_label: "Metrics"
    label: "Standard Deviation Likes"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_likes;;
    value_format: "#,##0"
  }

  dimension: spike_score_likes {
    view_label: "Metrics"
    label: "Spike Score Likes"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_likes;;
    value_format: "0.##"
  }

  dimension: current_week_shares {
    view_label: "Metrics"
    label: "Weekly Shares"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_shares;;
  }

  dimension: average_shares {
    view_label: "Metrics"
    label: "Average Shares"
    type: number
    hidden: no
    sql: ${TABLE}.avg_shares;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_shares {
    view_label: "Metrics"
    label: "Percent Above Average Shares"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_shares;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_shares {
    view_label: "Metrics"
    label: "Standard Deviation Shares"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_shares;;
    value_format: "#,##0"
  }

  dimension: spike_score_shares {
    view_label: "Metrics"
    label: "Spike Score Shares"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_shares;;
    value_format: "0.##"
  }

  dimension: current_week_favorites {
    view_label: "Metrics"
    label: "Weekly Favourites"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_favorites;;
  }

  dimension: average_favorites {
    view_label: "Metrics"
    label: "Average Favourites"
    type: number
    hidden: no
    sql: ${TABLE}.avg_favorites;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_favorites {
    view_label: "Metrics"
    label: "Percent Above Average Favourites"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_favorites;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_favorites {
    view_label: "Metrics"
    label: "Standard Deviation Favourites"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_favorites;;
    value_format: "#,##0"
  }

  dimension: spike_score_favorites {
    view_label: "Metrics"
    label: "Spike Score Favourites"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_favorites;;
    value_format: "0.##"
  }



  dimension: current_week_engagement_score {
    view_label: "Metrics"
    label: "Weekly Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_engagement_score;;
  }

  dimension: average_engagement_score {
    view_label: "Metrics"
    label: "Average Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.avg_engagement_score;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_engagement_score {
    view_label: "Metrics"
    label: "Percent Above Average Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_engagement_score;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_engagement_score {
    view_label: "Metrics"
    label: "Standard Deviation Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_engagement_score;;
    value_format: "#,##0"
  }

  dimension: spike_score_engagement_score {
    view_label: "Metrics"
    label: "Spike Score Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_engagement_score;;
    value_format: "0.##"
  }



}