data.ml
LookML Call center

Campaign

Campaign model for call center.

source-preserved

Blocks

campaign.view.lkml · 65 lines
inferred 
view: campaign {
  sql_table_name: Campaign ;;

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

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

  dimension: xid {
    type: int
    sql: ${TABLE}.campaignXID ;;
  }

  dimension: name {
    sql: ${TABLE}.campaignName ;;
  }

  dimension: weight {
    type: number
    sql: ${TABLE}.campaignWeight ;;
  }

  dimension: type {
  }

  dimension: focus {
  }

  dimension: timeout {
    type: int
    sql: ${TABLE}.campaignTimeout ;;
  }

  dimension: updated_time {
    type: date_time
    sql: ${TABLE}.campaignUpdatedOn ;;
  }

  dimension: suspended {
    type: yesno
    sql: ${TABLE}.campaignSuspended = 'Y' ;;
  }

  dimension: active {
    type: yesno
    sql: ${TABLE}.campaignActive = 'Y' ;;
  }

  dimension_group: created_time {
    type: date_time
    sql: ${TABLE}.campaignCreatedOn ;;
  }

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }
}
campaign.view.lookml · 39 lines
source-preserved 
- view: campaign
  sql_table_name: Campaign
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.campaignId
  - dimension: program_id
    type: int
    hidden: true
    sql: ${TABLE}.campaignProgramId
  - dimension: xid
    type: int
    sql: ${TABLE}.campaignXID
  - dimension: name
    sql: ${TABLE}.campaignName
  - dimension: weight
    type: number
    sql: ${TABLE}.campaignWeight
  - dimension: type
  - dimension: focus
  - dimension: timeout
    type: int
    sql: ${TABLE}.campaignTimeout
  - dimension: updated_time
    type: date_time
    sql: ${TABLE}.campaignUpdatedOn
  - dimension: suspended
    type: yesno
    sql: ${TABLE}.campaignSuspended = 'Y'
  - dimension: active
    type: yesno
    sql: ${TABLE}.campaignActive = 'Y'
  - dimension_group: created_time
    type: date_time
    sql: ${TABLE}.campaignCreatedOn
  - measure: count
    type: count_distinct
    sql: ${id}

Contents

  • campaign.view.lkml
  • campaign.view.lookml