data.ml
LookML Health marketing

Registration Page

Registration Page model for health marketing.

source-preserved

Blocks

registration_page.view.lkml · 90 lines
inferred 
view: registration_page {
  sql_table_name: data_warehouse.DWIMP_REGISTRATION_PAGE ;;

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

  dimension: algorithm {
    sql: ${TABLE}.ALGORITHM ;;
  }

  dimension: algorithm_id {
    type: int
    sql: ${TABLE}.ALGORITHM_ID ;;
  }

  dimension: brand_id {
    type: int
    sql: ${TABLE}.BRAND_ID ;;
  }

  dimension: brand_name {
    sql: ${TABLE}.BRAND_NAME ;;
  }

  dimension: creative_type {
    sql: ${TABLE}.CREATIVE_TYPE ;;
  }

  dimension: creative_type_detail {
    sql: ${TABLE}.CREATIVE_TYPE_DETAIL ;;
  }

  dimension: creative_type_detail_id {
    type: int
    sql: ${TABLE}.CREATIVE_TYPE_DETAIL_ID ;;
  }

  dimension: creative_type_id {
    type: int
    sql: ${TABLE}.CREATIVE_TYPE_ID ;;
  }

  dimension: end_of_flow_redirect_url {
    sql: ${TABLE}.END_OF_FLOW_REDIRECT_URL ;;
  }

  dimension: registration_form_type {
    sql: ${TABLE}.REGISTRATION_FORM_TYPE ;;
  }

  dimension: registration_form_type_id {
    type: int
    sql: ${TABLE}.REGISTRATION_FORM_TYPE_ID ;;
  }

  dimension: registration_page_name {
    sql: ${TABLE}.REGISTRATION_PAGE_NAME ;;
  }

  dimension: registration_template {
    sql: ${TABLE}.REGISTRATION_TEMPLATE ;;
  }

  dimension: registration_template_id {
    type: int
    sql: ${TABLE}.REGISTRATION_TEMPLATE_ID ;;
  }

  dimension: use_alternate_page {
    type: int
    sql: ${TABLE}.USE_ALTERNATE_PAGE ;;
  }

  dimension: award_id {
    type: int
    sql: ${TABLE}.AWARD_ID ;;
  }

  dimension: award_name {
    sql: ${TABLE}.AWARD_NAME ;;
  }

  measure: count {
    type: count
    drill_fields: [registration_page_id, brand_name, registration_page_name, takes.count]
  }
}
registration_page.view.lookml · 56 lines
source-preserved 
- view: registration_page
  sql_table_name: data_warehouse.DWIMP_REGISTRATION_PAGE
  fields:
  - dimension: registration_page_id
    type: int
    primary_key: true
    sql: ${TABLE}.REGISTRATION_PAGE_ID
  - dimension: algorithm
    sql: ${TABLE}.ALGORITHM
  - dimension: algorithm_id
    type: int
    sql: ${TABLE}.ALGORITHM_ID
  - dimension: brand_id
    type: int
    sql: ${TABLE}.BRAND_ID
  - dimension: brand_name
    sql: ${TABLE}.BRAND_NAME
  - dimension: creative_type
    sql: ${TABLE}.CREATIVE_TYPE
  - dimension: creative_type_detail
    sql: ${TABLE}.CREATIVE_TYPE_DETAIL
  - dimension: creative_type_detail_id
    type: int
    sql: ${TABLE}.CREATIVE_TYPE_DETAIL_ID
  - dimension: creative_type_id
    type: int
    sql: ${TABLE}.CREATIVE_TYPE_ID
  - dimension: end_of_flow_redirect_url
    sql: ${TABLE}.END_OF_FLOW_REDIRECT_URL
  - dimension: registration_form_type
    sql: ${TABLE}.REGISTRATION_FORM_TYPE
  - dimension: registration_form_type_id
    type: int
    sql: ${TABLE}.REGISTRATION_FORM_TYPE_ID
  - dimension: registration_page_name
    sql: ${TABLE}.REGISTRATION_PAGE_NAME
  - dimension: registration_template
    sql: ${TABLE}.REGISTRATION_TEMPLATE
  - dimension: registration_template_id
    type: int
    sql: ${TABLE}.REGISTRATION_TEMPLATE_ID
  - dimension: use_alternate_page
    type: int
    sql: ${TABLE}.USE_ALTERNATE_PAGE
  - dimension: award_id
    type: int
    sql: ${TABLE}.AWARD_ID
  - dimension: award_name
    sql: ${TABLE}.AWARD_NAME
  - measure: count
    type: count
    drill_fields:
    - registration_page_id
    - brand_name
    - registration_page_name
    - takes.count

Contents

  • registration_page.view.lkml
  • registration_page.view.lookml