Promotions

view: promotions {
  sql_table_name: promotions ;;

  dimension: automatic {
    type: yesno
  }

  dimension: bounty_credits {
    type: int
  }

  dimension: bounty_id {
    type: int
  }

  dimension: campaign_id {
    type: int
  }

  dimension: code {
  }

  dimension: company_id {
    type: int
  }

  dimension: description {
  }

  dimension: email_notification {
    type: yesno
  }

  dimension: enabled {
    type: yesno
  }

  dimension: id {
    type: int
  }

  dimension: invisible {
    type: yesno
  }

  dimension: message {
  }

  dimension: number_available {
    type: int
  }

  dimension: number_per_user {
    type: int
  }

  dimension: number_used {
    type: int
  }

  dimension: price_in_cents {
    type: int
  }

  dimension: redeem_credits {
    type: int
  }

  dimension: stipend_credits {
    type: int
  }

  dimension: task_allowance_per_month {
    type: int
  }

  dimension: task_credits {
    type: int
  }

  dimension: task_number {
    type: int
  }

  dimension: task_number_is_per_month {
    type: yesno
  }

  dimension: task_percent_off {
    type: int
  }

  dimension: tasks_per_month {
    type: int
  }

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

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

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }
}

- view: promotions
  sql_table_name: promotions
  fields:
  - dimension: automatic
    type: yesno
  - dimension: bounty_credits
    type: int
  - dimension: bounty_id
    type: int
  - dimension: campaign_id
    type: int
  - dimension: code
  - dimension: company_id
    type: int
  - dimension: description
  - dimension: email_notification
    type: yesno
  - dimension: enabled
    type: yesno
  - dimension: id
    type: int
  - dimension: invisible
    type: yesno
  - dimension: message
  - dimension: number_available
    type: int
  - dimension: number_per_user
    type: int
  - dimension: number_used
    type: int
  - dimension: price_in_cents
    type: int
  - dimension: redeem_credits
    type: int
  - dimension: stipend_credits
    type: int
  - dimension: task_allowance_per_month
    type: int
  - dimension: task_credits
    type: int
  - dimension: task_number
    type: int
  - dimension: task_number_is_per_month
    type: yesno
  - dimension: task_percent_off
    type: int
  - dimension: tasks_per_month
    type: int
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count_distinct
    sql: ${id}