data.ml
LKML Advertising email

Campaign

Campaign model for advertising email.

inferred

Blocks

campaign.view.lkml · 39 lines
inferred 
view: campaign {
  sql_table_name: campaign ;;

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

  dimension: market_id {
    type: number
    sql: ${TABLE}.market_id ;;
  }

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

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

  dimension: administrative_entity_id {
    type: number
    sql: ${TABLE}.administrative_entity_id ;;
  }

  dimension: subcategory_id {
    type: number
    sql: ${TABLE}.subcategory_id ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
campaign.view.lookml · 26 lines
source-preserved 
- view: campaign
  sql_table_name: campaign
  fields:
  - dimension: id
    type: number
    primary_key: true
    hidden: true
    sql: ${TABLE}.id
  - dimension: market_id
    type: number
    sql: ${TABLE}.market_id
  - dimension: label
    sql: ${TABLE}.label
  - dimension: is_active
    type: yesno
    sql: ${TABLE}.is_active
  - dimension: administrative_entity_id
    type: number
    sql: ${TABLE}.administrative_entity_id
  - dimension: subcategory_id
    type: number
    sql: ${TABLE}.subcategory_id
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

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