view: int_dev_awalspotify {
  sql_table_name: INTELLIGENCE.DEV_AWALSPOTIFY.AWALDATAUNIQUE ;;


    dimension: TRACK_NAME {
      view_label: "Track"
      label: "Track Name"
      type:  string
      sql: ${TABLE}.TRACK_NAME ;;
    }

    dimension: ARTIST_NAME {
      view_label: "Track"
      label: "Artist Name"
      type:  string
      sql: ${TABLE}.ARTIST_NAME ;;
    }

    dimension_group: CAMPAIGN_START {
      view_label: "Date"
      label: "Campaign Start Date"
      type:  time
      sql: ${TABLE}.CAMPAIGN_START ;;
      timeframes: [year,
        quarter,
        month,
        week,
        date,
        day_of_year,
        day_of_week,
        week_of_year,
        month_name,
        month_num,
        fiscal_month_num,
        fiscal_quarter,
        fiscal_quarter_of_year,
        fiscal_year]
    }

    dimension_group: CAMPAIGN_END {
      view_label: "Date"
      label: "Campaign End Date"
      type:  time
      sql: ${TABLE}.CAMPAIGN_END ;;
      timeframes: [year,
        quarter,
        month,
        week,
        date,
        day_of_year,
        day_of_week,
        week_of_year,
        month_name,
        month_num,
        fiscal_month_num,
        fiscal_quarter,
        fiscal_quarter_of_year,
        fiscal_year]
    }

    dimension_group: TRACK_RELEASE_DATE {
      view_label: "Date"
      label: "Track Release Date"
      type:  time
      sql: ${TABLE}.TRACK_RELEASE_DATE ;;
      timeframes: [year,
        quarter,
        month,
        week,
        date,
        day_of_year,
        day_of_week,
        week_of_year,
        month_name,
        month_num,
        fiscal_month_num,
        fiscal_quarter,
        fiscal_quarter_of_year,
        fiscal_year]
    }

    dimension: CAMPAIGN_DURATION_MONTHS {
      view_label: "Campaign"
      label: "Campaign Duration Months"
      type:  string
      sql: ${TABLE}.CAMPAIGN_DURATION_MONTHS ;;
    }

    measure: RA_STREAMS {
      view_label: "Streams"
      label: "RA Streams"
      type:  number
      sql: ${TABLE}.RA_STREAMS ;;
    }

    measure: RA_STREAMS_PCT_LIFT {
      view_label: "Streams"
      label: "RA Streams PCT lift"
      type:  number
      sql: ${TABLE}.RA_STREAMS_PCT_LIFT ;;
    }

    measure: MONTH_TO_DATE_LISTENERS {
      view_label: "User"
      label: "Months to Date Listeners"
      type:  number
      sql: ${TABLE}.MONTH_TO_DATE_LISTENERS ;;
    }

    measure: LISTENERS_PCT_LIFT {
      view_label: "User"
      label: "Listeners PCT lift"
      type:  number
      sql: ${TABLE}.LISTENERS_PCT_LIFT ;;
    }

    measure: SAVES {
      view_label: "Track"
      label: "Saves"
      type:  number
      sql: ${TABLE}.SAVES ;;
    }

    measure: PLAYLIST_ADDS {
      view_label: "Track"
      label: "Playlist Adds"
      type:  number
      sql: ${TABLE}.PLAYLIST_ADDS ;;
    }

    measure: INTENT_RATE {
      view_label: "User"
      label: "Intent Rate"
      type:  number
      sql: ${TABLE}.INTENT_RATE ;;
    }

    dimension: ISRC {
      view_label: "Track"
      label: "ISRC"
      type:  string
      sql: ${TABLE}.ISRC ;;
    }

    dimension: CALC_DURATIONMONTHS {
      view_label: "Campaign"
      label: "Duration Month"
      type:  string
      sql: ${TABLE}.CALC_DURATIONMONTHS ;;
    }

    dimension: ROWCOUNT {
      view_label: ""
      label: "Row count"
      type:  string
      sql: ${TABLE}.ROWCOUNT ;;
    }


  }