data.ml
LookML Media publishing

Campaign Affect

Campaign Affect model for media publishing.

source-preserved

Blocks

campaign_affect.view.lkml · 43 lines
inferred 
view: campaign_affect {
  sql_table_name: sanitized_db.si_cs_visit_campaign_affect ;;

  dimension: period_id {
    type: number
    hidden: yes
    sql: ${TABLE}.affected_by ;;
  }

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
campaign_affect.view.lookml · 27 lines
source-preserved 
- view: campaign_affect
  sql_table_name: sanitized_db.si_cs_visit_campaign_affect
  fields:
  - dimension: period_id
    type: number
    hidden: true
    sql: ${TABLE}.affected_by
  - dimension: campaign_creative
    type: number
    sql: ${TABLE}.campaign_creative
  - dimension: days_since_attraction
    type: number
    sql: ${TABLE}.days_since_attraction
  - dimension: is_direct_attract
    type: yesno
    sql: ${TABLE}.is_direct_attract
  - dimension: is_return_attract
    type: yesno
    sql: ${TABLE}.is_return_attract
  - dimension: recipient_id
    sql: ${TABLE}.recipient_id
  - dimension: visit_id
    type: int
    primary_key: true
    sql: ${TABLE}.visit_id
  - measure: count
    type: count

Contents

  • campaign_affect.view.lkml
  • campaign_affect.view.lookml