Promotions

view: promotions {
  sql_table_name: public.promotions ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

  dimension: admin_id {
    type: int
    hidden: yes
    sql: ${TABLE}.admin_id ;;
  }

  dimension: affiliate_id {
    type: int
    hidden: yes
    sql: ${TABLE}.affiliate_id ;;
  }

  dimension: arbitrage {
    type: number
    sql: ${TABLE}.arbitrage ;;
  }

  dimension: industry_type {
    sql: ${TABLE}.industry_type ;;
  }

  dimension: commission_rate {
    type: int
    sql: ${TABLE}.commission_rate ;;
  }

  dimension: credit_quota {
    type: int
    sql: ${TABLE}.credit_quota ;;
  }

  dimension: credits_granted {
    type: int
    sql: ${TABLE}.credits_granted ;;
  }

  dimension: currency_code {
    sql: ${TABLE}.currency_code ;;
  }

  dimension: education_grant {
    type: int
    sql: ${TABLE}.education_grant ;;
  }

  dimension: promotion_length {
    label: "Promotion Length (days)"
    type: number
    sql: DATEDIFF('day',${starts_date},${ends_date}) ;;
  }

  dimension: promotion_length_tiered {
    label: "Promotion Length Tiered (days)"
    type: tier
    sql: ${promotion_length} ;;
  }

  dimension: front_page_message {
    sql: ${TABLE}.front_page_message ;;
  }

  dimension: full_length_credit_grant {
    type: int
    sql: ${TABLE}.full_length_credit_grant ;;
  }

  dimension: key {
    sql: ${TABLE}.key ;;
  }

  dimension: message {
    sql: ${TABLE}.message ;;
  }

  dimension: plus_grant {
    type: int
    sql: ${TABLE}.plus_grant ;;
  }

  dimension: plus_hd_grant {
    type: int
    sql: ${TABLE}.plus_hd_grant ;;
  }

  dimension: price_discount {
    type: int
    sql: ${TABLE}.price_discount ;;
  }

  dimension: pro_grant {
    type: int
    sql: ${TABLE}.pro_grant ;;
  }

  dimension: r480p_credit_grant {
    type: int
    sql: ${TABLE}.r480p_credit_grant ;;
  }

  dimension: r720p_credit_grant {
    type: int
    sql: ${TABLE}.r720p_credit_grant ;;
  }

  dimension: required_item_code {
    type: int
    sql: ${TABLE}.required_item_code ;;
  }

  dimension: required_subscription_type {
    sql: ${TABLE}.required_subscription_type ;;
  }

  dimension: reseller_grant {
    type: int
    sql: ${TABLE}.reseller_grant ;;
  }

  dimension: title {
    sql: ${TABLE}.title ;;
  }

  dimension: type {
    sql: ${TABLE}.type ;;
  }

  dimension: upgrade_only {
    type: yesno
    sql: ${TABLE}.upgrade_only ;;
  }

  dimension: user_quota {
    type: int
    sql: ${TABLE}.user_quota ;;
  }

  dimension: user_type {
    sql: ${TABLE}.user_type ;;
  }

  dimension: welcome_message {
    sql: ${TABLE}.welcome_message ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.created_at ;;
  }

  dimension_group: ends {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.ends_at ;;
  }

  dimension_group: starts {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.starts_at ;;
  }

  measure: count {
    type: count
  }

  measure: total_credits_granted {
    type: sum
    sql: ${credits_granted} ;;
  }
}

- view: promotions
  sql_table_name: public.promotions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: admin_id
    type: int
    hidden: true
    sql: ${TABLE}.admin_id
  - dimension: affiliate_id
    type: int
    hidden: true
    sql: ${TABLE}.affiliate_id
  - dimension: arbitrage
    type: number
    sql: ${TABLE}.arbitrage
  - dimension: industry_type
    sql: ${TABLE}.industry_type
  - dimension: commission_rate
    type: int
    sql: ${TABLE}.commission_rate
  - dimension: credit_quota
    type: int
    sql: ${TABLE}.credit_quota
  - dimension: credits_granted
    type: int
    sql: ${TABLE}.credits_granted
  - dimension: currency_code
    sql: ${TABLE}.currency_code
  - dimension: education_grant
    type: int
    sql: ${TABLE}.education_grant
  - dimension: promotion_length
    type: number
    label: Promotion Length (days)
    sql: DATEDIFF('day',${starts_date},${ends_date})
  - dimension: promotion_length_tiered
    type: tier
    label: Promotion Length Tiered (days)
    sql: ${promotion_length}
  - dimension: front_page_message
    sql: ${TABLE}.front_page_message
  - dimension: full_length_credit_grant
    type: int
    sql: ${TABLE}.full_length_credit_grant
  - dimension: key
    sql: ${TABLE}.key
  - dimension: message
    sql: ${TABLE}.message
  - dimension: plus_grant
    type: int
    sql: ${TABLE}.plus_grant
  - dimension: plus_hd_grant
    type: int
    sql: ${TABLE}.plus_hd_grant
  - dimension: price_discount
    type: int
    sql: ${TABLE}.price_discount
  - dimension: pro_grant
    type: int
    sql: ${TABLE}.pro_grant
  - dimension: r480p_credit_grant
    type: int
    sql: ${TABLE}.r480p_credit_grant
  - dimension: r720p_credit_grant
    type: int
    sql: ${TABLE}.r720p_credit_grant
  - dimension: required_item_code
    type: int
    sql: ${TABLE}.required_item_code
  - dimension: required_subscription_type
    sql: ${TABLE}.required_subscription_type
  - dimension: reseller_grant
    type: int
    sql: ${TABLE}.reseller_grant
  - dimension: title
    sql: ${TABLE}.title
  - dimension: type
    sql: ${TABLE}.type
  - dimension: upgrade_only
    type: yesno
    sql: ${TABLE}.upgrade_only
  - dimension: user_quota
    type: int
    sql: ${TABLE}.user_quota
  - dimension: user_type
    sql: ${TABLE}.user_type
  - dimension: welcome_message
    sql: ${TABLE}.welcome_message
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: ends
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.ends_at
  - dimension_group: starts
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.starts_at
  - measure: count
    type: count
  - measure: total_credits_granted
    type: sum
    sql: ${credits_granted}