data.ml
LKML Ecommerce furniture

Emails

Emails model for ecommerce furniture.

inferred

Blocks

emails.view.lkml · 72 lines
inferred 
view: emails {
  sql_table_name: bi_tables.emails ;;

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

  dimension: email {
    hidden: yes
    sql: ${TABLE}.email ;;
  }

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

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

  dimension_group: clicked {
    type: time
    timeframes: [yesno, time, date, week, month]
    sql: ${TABLE}.clicked_at ;;
  }

  dimension_group: opened {
    type: time
    timeframes: [yesno, time, date, week, month]
    sql: ${TABLE}.opened_at ;;
  }

  dimension_group: sent {
    type: time
    timeframes: [yesno, time, date, week, month]
    sql: ${TABLE}.sent_at ;;
  }

  dimension_group: email_type {
    type: string
    sql: ${TABLE}.email_type ;;
  }

  measure: count {
    type: count
  }

  measure: clicked_count {
    type: count
  }

  measure: opened_count {
    type: count
  }

  measure: sent_count {
    type: count
  }

  measure: open_rate {
    type: number
    sql: 100.00 * ${opened_count} / ${sent_count} ;;
  }

  measure: click_rate {
    type: number
    sql: 100.00 * ${clicked_count} / ${opened_count} ;;
  }
}
emails.view.lookml · 59 lines
source-preserved 
- view: emails
  sql_table_name: bi_tables.emails
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: email
    hidden: true
    sql: ${TABLE}.email
  - dimension: campaign_id
    type: int
    sql: ${TABLE}.campaign_id
  - dimension: campaign_name
    sql: ${TABLE}.campaign_name
  - dimension_group: clicked
    type: time
    timeframes:
    - yesno
    - time
    - date
    - week
    - month
    sql: ${TABLE}.clicked_at
  - dimension_group: opened
    type: time
    timeframes:
    - yesno
    - time
    - date
    - week
    - month
    sql: ${TABLE}.opened_at
  - dimension_group: sent
    type: time
    timeframes:
    - yesno
    - time
    - date
    - week
    - month
    sql: ${TABLE}.sent_at
  - dimension_group: email_type
    type: string
    sql: ${TABLE}.email_type
  - measure: count
    type: count
  - measure: clicked_count
    type: count
  - measure: opened_count
    type: count
  - measure: sent_count
    type: count
  - measure: open_rate
    type: number
    sql: 100.00 * ${opened_count} / ${sent_count}
  - measure: click_rate
    type: number
    sql: 100.00 * ${clicked_count} / ${opened_count}

Contents

  • emails.view.lkml
  • emails.view.lookml