LKML Ecommerce marketplace

Marketing Action

Marketing Action model for ecommerce marketplace.

inferred

Blocks

LKML LookML

marketing_action.view.lkml · 134 lines

inferred

view: marketing_action {
  sql_table_name: javaprod.marketing_action ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}

marketing_action.view.lookml · 92 lines

source-preserved

- view: marketing_action
  sql_table_name: javaprod.marketing_action
  fields:
  - dimension: marketing_action_id
    type: int
    primary_key: true
    sql: ${TABLE}.marketing_action_id
  - dimension: campaign_id
    type: int
    hidden: true
    sql: ${TABLE}.campaign_id
  - dimension: category_id
    type: int
    hidden: true
    sql: ${TABLE}.category_id
  - dimension: created_by_user_id
    type: int
    sql: ${TABLE}.created_by_user_id
  - dimension: description
    sql: ${TABLE}.description
  - dimension: marketing_action_actual_size
    type: number
    sql: ${TABLE}.marketing_action_actual_size
  - dimension: marketing_action_content_url
    sql: ${TABLE}.marketing_action_content_url
  - dimension: marketing_action_cost
    type: number
    sql: ${TABLE}.marketing_action_cost
  - dimension: marketing_action_name
    sql: ${TABLE}.marketing_action_name
  - dimension: marketing_action_order_size
    type: number
    sql: ${TABLE}.marketing_action_order_size
  - dimension: marketing_ad_type_id
    type: int
    hidden: true
    sql: ${TABLE}.marketing_ad_type_id
  - dimension: marketing_audience_id
    type: int
    hidden: true
    sql: ${TABLE}.marketing_audience_id
  - dimension: marketing_channel_id
    type: int
    hidden: true
    sql: ${TABLE}.marketing_channel_id
  - dimension: marketing_goal_id
    type: int
    hidden: true
    sql: ${TABLE}.marketing_goal_id
  - dimension: marketing_promotional_cost_id
    type: int
    sql: ${TABLE}.marketing_promotional_cost_id
  - dimension: marketing_publisher_id
    type: int
    hidden: true
    sql: ${TABLE}.marketing_publisher_id
  - dimension: marketing_send_list_id
    type: int
    sql: ${TABLE}.marketing_send_list_id
  - dimension: marketing_test_id
    type: int
    sql: ${TABLE}.marketing_test_id
  - dimension: marketing_venue_id
    type: int
    hidden: true
    sql: ${TABLE}.marketing_venue_id
  - dimension: redemption_value
    type: number
    sql: ${TABLE}.redemption_value
  - dimension: revenue_share
    type: number
    sql: ${TABLE}.revenue_share
  - dimension: url_forward_dotd
    sql: ${TABLE}.url_forward_dotd
  - dimension_group: action
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.action_date
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created
  - measure: count
    type: count

marketing_action.view.lkml
marketing_action.view.lookml

Marketing Action

Blocks

Contents