data.ml
LKML Digital journalism

Hit Data

Hit Data model for digital journalism.

inferred

Blocks

hit_data.view.lkml · 107 lines
inferred 
view: hit_data {
  sql_table_name: ${TABLE}.hit_data ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension_group: hit {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.dt ;;
  }

  measure: count {
    type: count
  }

  measure: total_page_views {
    type: sum
    sql: ${TABLE}.page_views ;;
  }

  measure: total_paywall_purchases {
    type: sum
    sql: ${TABLE}.paywall_purchases ;;
  }

  measure: total_sp_gift_purchases {
    type: sum
    sql: ${TABLE}.sp_gift_purchases ;;
  }

  measure: total_sp_purchases {
    type: sum
    sql: ${TABLE}.sp_purchases ;;
  }

  measure: total_video_starts {
    type: sum
    sql: ${TABLE}.video_starts ;;
  }

  measure: unique_visitors {
    type: count_distinct
    sql: ${TABLE}.s_vi ;;
  }

  measure: unique_logged_in_visitors {
    type: count_distinct
    sql: ${TABLE}.uuid ;;
  }
}
hit_data.view.lookml · 66 lines
source-preserved 
- view: hit_data
  sql_table_name: ${TABLE}.hit_data
  fields:
  - dimension: articleid
    sql: ${TABLE}.articleid
  - dimension: campaign
    sql: ${TABLE}.campaign
  - dimension: channel
    sql: ${TABLE}.channel
  - dimension: first_hit_page_url
    sql: ${TABLE}.first_hit_page_url
  - dimension: page_url
    sql: ${TABLE}.page_url
  - dimension: page_views
    type: number
    sql: ${TABLE}.page_views
  - dimension: paywall_purchases
    type: number
    sql: ${TABLE}.paywall_purchases
  - dimension: s_vi
    sql: ${TABLE}.s_vi
  - dimension: sp_gift_purchases
    type: number
    sql: ${TABLE}.sp_gift_purchases
  - dimension: sp_purchases
    type: number
    sql: ${TABLE}.sp_purchases
  - dimension: sp_users
    type: number
    sql: ${TABLE}.sp_users
  - dimension: uuid
    sql: ${TABLE}.uuid
  - dimension: video_starts
    type: number
    sql: ${TABLE}.video_starts
  - dimension_group: hit
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dt
  - measure: count
    type: count
  - measure: total_page_views
    type: sum
    sql: ${TABLE}.page_views
  - measure: total_paywall_purchases
    type: sum
    sql: ${TABLE}.paywall_purchases
  - measure: total_sp_gift_purchases
    type: sum
    sql: ${TABLE}.sp_gift_purchases
  - measure: total_sp_purchases
    type: sum
    sql: ${TABLE}.sp_purchases
  - measure: total_video_starts
    type: sum
    sql: ${TABLE}.video_starts
  - measure: unique_visitors
    type: count_distinct
    sql: ${TABLE}.s_vi
  - measure: unique_logged_in_visitors
    type: count_distinct
    sql: ${TABLE}.uuid

Contents

  • hit_data.view.lkml
  • hit_data.view.lookml