data.ml
LookML Ecommerce marketplace

Marketing Channel

Marketing Channel model for ecommerce marketplace.

source-preserved

Blocks

marketing_channel.view.lkml · 42 lines
inferred 
view: marketing_channel {
  sql_table_name: javaprod.marketing_channel ;;

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

  dimension: created_by_user_id {
    type: int
    sql: ${TABLE}.created_by_user_id ;;
  }

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

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

  dimension: summary_full {
    hidden: yes
    sql: ${TABLE}.summary ;;
  }

  dimension: summary {
    sql: CASE WHEN ${TABLE}.summary IN ('App', 'Public Relations', 'Print', 'Legacy', 'Events') OR ${TABLE}.summary IS NULL THEN 'Other'
ELSE ${TABLE}.summary END ;;
  }

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

  measure: count {
    type: count
  }
}
marketing_channel.view.lookml · 30 lines
source-preserved 
- view: marketing_channel
  sql_table_name: javaprod.marketing_channel
  fields:
  - dimension: marketing_channel_id
    type: int
    primary_key: true
    sql: ${TABLE}.marketing_channel_id
  - dimension: created_by_user_id
    type: int
    sql: ${TABLE}.created_by_user_id
  - dimension: exec_summary
    sql: ${TABLE}.exec_summary
  - dimension: marketing_channel_name
    sql: ${TABLE}.marketing_channel_name
  - dimension: summary_full
    hidden: true
    sql: ${TABLE}.summary
  - dimension: summary
    sql: CASE WHEN ${TABLE}.summary IN ('App', 'Public Relations', 'Print', 'Legacy', 'Events') OR ${TABLE}.summary IS NULL THEN 'Other'
ELSE ${TABLE}.summary END
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created
  - measure: count
    type: count

Contents

  • marketing_channel.view.lkml
  • marketing_channel.view.lookml