data.ml
LKML Media publishing

Visitor

Visitor model for media publishing.

inferred

Blocks

visitor.view.lkml · 62 lines
inferred 
view: visitor {
  sql_table_name: sanitized_db.si_cs_visitor_recent ;;

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

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

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

  dimension: lifetime_number_of_visits {
    type: number
    sql: ${TABLE}.num_visits ;;
  }

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

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

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

  dimension_group: added {
    type: time
    timeframes: [date, month]
    sql: ${TABLE}.date_added ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [visitor_details*]
  }
}
visitor.view.lookml · 49 lines
source-preserved 
- view: visitor
  sql_table_name: sanitized_db.si_cs_visitor_recent
  fields:
  - dimension: visitor_id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.visitor_id
  - dimension: corporate_id
    hidden: true
    sql: ${TABLE}.corporate_id
  - dimension: external_id
    hidden: true
    sql: ${TABLE}.external_id
  - dimension: lifetime_number_of_visits
    type: number
    sql: ${TABLE}.num_visits
  - dimension: parent_org
    type: int
    hidden: true
    sql: ${TABLE}.parent_org
  - dimension: sites_visited
    sql: ${TABLE}.sites_visited
  - dimension: visitor_type
    sql: ${TABLE}.visitor_type
  - dimension_group: added
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.date_added
  - dimension_group: first_visit
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.first_visit_date
  - dimension_group: last_visit
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.last_visit_date
  - measure: count
    type: count
    drill_fields:
    - visitor_details*

Contents

  • visitor.view.lkml
  • visitor.view.lookml