view: cm_analytics_instagram_audience_stat  {
  sql_table_name: chartmetric.analytics.instagram_audience_stat ;;

  dimension: account_id {
    type: string
    primary_key: yes
    sql: ${TABLE}.account_id ;;
    hidden: yes
  }

  measure: num_followers {
    type: number
    sql: ${TABLE}.num_followers;;
    hidden: yes
  }

  measure: avg_likes {
    type: number
    sql: ${TABLE}.avg_likes;;
    hidden: yes
  }

  measure: avg_comments {
    type: number
    sql: ${TABLE}.avg_comments;;
    hidden: yes
  }

  measure: avg_views {
    type: number
    sql: ${TABLE}.avg_views;;
    hidden: yes
  }

  measure: likes_not_from_followers {
    label: "Likes from non-followers"
    type: max
    sql: ${TABLE}.likes_not_from_followers;;
    value_format: "0.0%"
  }

  measure: male_amount {
    label: "Male Followers"
    type: max
    sql: ${TABLE}.MALE_AMOUNT;;
    value_format: "0.0%"
  }

  measure: female_amount {
    label: "Female Followers"
    type: max
    sql: ${TABLE}.FEMALE_AMOUNT;;
    value_format: "0.0%"
  }

  measure: ages_13_17 {
    label: "Followers Ages 13-17"
    type: max
    sql: ${TABLE}.AGES_13_17;;
    value_format: "0.0%"
  }

  measure: ages_18_24 {
    label: "Followers Ages 18-24"
    type: max
    sql: ${TABLE}.AGES_18_24;;
    value_format: "0.0%"
  }

  measure: ages_25_34 {
    label: "Followers Ages 25-34"
    type: max
    sql: ${TABLE}.AGES_25_34;;
    value_format: "0.0%"
  }

  measure: ages_35_44 {
    label: "Followers Ages 35-44"
    type: max
    sql: ${TABLE}.ages_35_44;;
    value_format: "0.0%"
  }

  measure: ages_45_64 {
    label: "Followers Ages 45-64"
    type: max
    sql: ${TABLE}.ages_45_64;;
    value_format: "0.0%"
  }

  measure: ages_65_ {
    label: "Followers Ages 65+"
    type: max
    sql: ${TABLE}.ages_65_;;
    value_format: "0.0%"
  }

  measure: male_ages_13_17 {
    label: "Male Followers Ages 13-17"
    type: max
    sql: ${TABLE}.MALE_13_17;;
    value_format: "0.0%"
  }

  measure: female_ages_13_17 {
    label: "Female Followers Ages 13-17"
    type: max
    sql: ${TABLE}.FEMALE_13_17;;
    value_format: "0.0%"
  }

  measure: male_ages_18_24 {
    label: "Male Followers Ages 18-24"
    type: max
    sql: ${TABLE}.MALE_AGES_18_24;;
    value_format: "0.0%"
  }

  measure: female_ages_18_24 {
    label: "Female Followers Ages 18-24"
    type: max
    sql: ${TABLE}.FEMALE_AGES_18_24;;
    value_format: "0.0%"
  }

  measure: male_ages_25_34 {
    label: "Male Followers Ages 25-34"
    type: max
    sql: ${TABLE}.MALE_AGES_25_34;;
    value_format: "0.0%"
  }

  measure: female_ages_25_34 {
    label: "Female Followers Ages 25-34"
    type: max
    sql: ${TABLE}.FEMALE_AGES_25_34;;
    value_format: "0.0%"
  }

  measure: male_ages_35_44 {
    label: "Male Followers Ages 35-44"
    type: max
    sql: ${TABLE}.male_ages_35_44;;
    value_format: "0.0%"
  }

  measure: female_ages_35_44 {
    label: "Female Followers Ages 35-44"
    type: max
    sql: ${TABLE}.female_ages_35_44;;
    value_format: "0.0%"
  }

  measure: male_ages_45_64 {
    label: "Male Followers Ages 45-64"
    type: max
    sql: ${TABLE}.male_ages_45_64;;
    value_format: "0.0%"
  }

  measure: female_ages_45_64 {
    label: "Female Followers Ages 45-64"
    type: max
    sql: ${TABLE}.female_ages_45_64;;
    value_format: "0.0%"
  }

  measure: male_ages_65_ {
    label: "Male Followers Ages 65+"
    type: max
    sql: ${TABLE}.male_ages_65_;;
    value_format: "0.0%"
  }

  measure: female_ages_65_ {
    label: "Female Followers Ages 65+"
    type: max
    sql: ${TABLE}.female_ages_65_;;
    value_format: "0.0%"
  }

  measure: follower_lang_en {
    label: "English Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_en;;
    value_format: "0.0%"
  }

  measure: follower_lang_es {
    label: "Spanish Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_es;;
    value_format: "0.0%"
  }

  measure: follower_lang_pt {
    label: "Portugese Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_pt;;
    value_format: "0.0%"
  }

  measure: follower_lang_de {
    label: "German Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_de;;
    value_format: "0.0%"
  }

  measure: follower_lang_ja {
    label: "Japanese Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_ja;;
    value_format: "0.0%"
  }

  measure: follower_lang_zh {
    label: "Chinese Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_zh;;
    value_format: "0.0%"
  }

  measure: follower_lang_id {
    label: "Indonesian Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_id;;
    value_format: "0.0%"
  }

  measure: follower_lang_ru {
    label: "Russian Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_ru;;
    value_format: "0.0%"
  }

  measure: follower_lang_fr {
    label: "French Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_fr;;
    value_format: "0.0%"
  }

  dimension: follower_interest_name_1 {
    label: "Follower Interest 1"
    type: string
    sql: ${TABLE}.FOLLOWER_INTEREST_NAME_1;;
  }

  measure: follower_interest_amount_1 {
    label: "Follower Interest 1 percentage"
    type: max
    sql: ${TABLE}.FOLLOWER_INTEREST_AMOUNT_1;;
    value_format: "0.0%"
  }

  dimension: follower_interest_name_2 {
    label: "Follower Interest 2"
    type: string
    sql: ${TABLE}.FOLLOWER_INTEREST_NAME_2;;
  }

  measure: follower_interest_amount_2 {
    label: "Follower Interest 2 percentage"
    type: max
    sql: ${TABLE}.FOLLOWER_INTEREST_AMOUNT_2;;
    value_format: "0.0%"
  }

  dimension: follower_interest_name_3 {
    label: "Follower Interest 3"
    type: string
    sql: ${TABLE}.FOLLOWER_INTEREST_NAME_3;;
  }

  measure: follower_interest_amount_3 {
    label: "Follower Interest 3 percentage"
    type: max
    sql: ${TABLE}.FOLLOWER_INTEREST_AMOUNT_3;;
    value_format: "0.0%"
  }

  dimension: follower_interest_name_4 {
    label: "Follower Interest 4"
    type: string
    sql: ${TABLE}.FOLLOWER_INTEREST_NAME_4;;
  }

  measure: follower_interest_amount_4 {
    label: "Follower Interest 4 percentage"
    type: max
    sql: ${TABLE}.FOLLOWER_INTEREST_AMOUNT_4;;
    value_format: "0.0%"
  }

  dimension: follower_interest_name_5 {
    label: "Follower Interest 5"
    type: string
    sql: ${TABLE}.FOLLOWER_INTEREST_NAME_5;;
  }

  measure: follower_interest_amount_5 {
    label: "Follower Interest 5 percentage"
    type: max
    sql: ${TABLE}.FOLLOWER_INTEREST_AMOUNT_5;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_1 {
    label: "Follower Country 1"
    type: string
    hidden: yes
    sql: ${TABLE}.FOLLOWER_COUNTRY_CODE_1;;
  }

  measure: follower_country_weight_1{
    label: "Follower Country 1 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_1;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_2 {
    label: "Follower Country 2"
    type: string
    hidden: yes
    sql: ${TABLE}.FOLLOWER_COUNTRY_CODE_2;;
  }

  measure: follower_country_weight_2{
    label: "Follower Country 2 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_2;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_3 {
    label: "Follower Country 3"
    type: string
    hidden: yes
    sql: ${TABLE}.FOLLOWER_COUNTRY_CODE_3;;
  }

  measure: follower_country_weight_3{
    label: "Follower Country 3 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_3;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_4 {
    label: "Follower Country 4"
    type: string
    hidden: yes
    sql: ${TABLE}.FOLLOWER_COUNTRY_CODE_4;;
  }

  measure: follower_country_weight_4{
    label: "Follower Country 4 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_4;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_5 {
    label: "Follower Country 5"
    type: string
    hidden: yes
    sql: ${TABLE}.FOLLOWER_COUNTRY_CODE_5;;
  }

  measure: follower_country_weight_5{
    label: "Follower Country 5 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_5;;
    value_format: "0.0%"
  }

}