data.ml
LKML Saas analytics

User Rewards

User Rewards model for saas analytics.

inferred

Blocks

user_rewards.view.lkml · 51 lines
inferred 
view: user_rewards {
  sql_table_name: v2.user_rewards ;;

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id]
  }

  measure: suggestions_count {
    label: "Suggestions over time"
    type: count
  }
}
user_rewards.view.lookml · 36 lines
source-preserved 
- view: user_rewards
  sql_table_name: v2.user_rewards
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: experiment_code
    sql: ${TABLE}.experiment_code
  - dimension: redeemed
    type: yesno
    sql: ${TABLE}.redeemed
  - dimension: reward_token
    sql: ${TABLE}.reward_token
  - dimension: user_id
    sql: ${TABLE}.user_id
  - dimension: variant_code
    sql: ${TABLE}.variant_code
  - dimension: verified
    type: yesno
    sql: ${TABLE}.verified
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - measure: count
    type: count
    drill_fields:
    - id
  - measure: suggestions_count
    type: count
    label: Suggestions over time

Contents

  • user_rewards.view.lkml
  • user_rewards.view.lookml