Page Views

view: page_views {
  sql_table_name: bi_tables.page_views ;;

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

  dimension: email {
    hidden: yes
    sql: ${TABLE}.email ;;
  }

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

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

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

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

  dimension: country {
    hidden: yes
    sql: ${TABLE}.country ;;
  }

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

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

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

  dimension: ip {
    label: "IP Address"
    sql: ${TABLE}.ip ;;
  }

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

  dimension: latitude {
    type: number
    sql: ${TABLE}.lat ;;
  }

  dimension: longitude {
    type: number
    sql: ${TABLE}.lng ;;
  }

  dimension: lat_lng {
    type: location
  }

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

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

  dimension: percent_off {
    type: number
    sql: ${TABLE}.percentoff ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: weeks_since_registration {
    type: number
    sql: datediff('weeks', ${users.created_date}, ${view_date}) ;;
  }

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

  measure: count {
    type: count
  }
}

- view: page_views
  sql_table_name: bi_tables.page_views
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: email
    hidden: true
    sql: ${TABLE}.email
  - dimension: action_url
    sql: ${TABLE}.action_url
  - dimension: browser
    sql: ${TABLE}.browser
  - dimension: city
    sql: ${TABLE}.city
  - dimension: collection
    sql: ${TABLE}.collection
  - dimension: country
    hidden: true
    sql: ${TABLE}.country
  - dimension: device
    sql: ${TABLE}.device
  - dimension: domain
    sql: ${TABLE}.domain
  - dimension: img_url
    sql: ${TABLE}.img_url
  - dimension: ip
    label: IP Address
    sql: ${TABLE}.ip
  - dimension: language
    sql: ${TABLE}.language
  - dimension: latitude
    type: number
    sql: ${TABLE}.lat
  - dimension: longitude
    type: number
    sql: ${TABLE}.lng
  - dimension: lat_lng
    type: location
  - dimension: os
    sql: ${TABLE}.os
  - dimension: page_type
    sql: ${TABLE}.page_type
  - dimension: percent_off
    type: number
    sql: ${TABLE}.percentoff
  - dimension: price
    type: number
    sql: ${TABLE}.price
  - dimension: product
    sql: ${TABLE}.product
  - dimension: product_status
    sql: ${TABLE}.product_status
  - dimension: query
    sql: ${TABLE}.query
  - dimension: region
    sql: ${TABLE}.region
  - dimension: resolution
    sql: ${TABLE}.resolution
  - dimension: session_campaign
    sql: ${TABLE}.session_campaign
  - dimension: session_campaign_term
    sql: ${TABLE}.session_campaign_term
  - dimension: session_medium
    sql: ${TABLE}.session_medium
  - dimension: session_referrer
    sql: ${TABLE}.session_referrer
  - dimension: session_referring_domain
    sql: ${TABLE}.session_referring_domain
  - dimension: session_source
    sql: ${TABLE}.session_source
  - dimension: sku
    sql: ${TABLE}.sku
  - dimension: title
    sql: ${TABLE}.title
  - dimension: type
    sql: ${TABLE}.type
  - dimension: url
    sql: ${TABLE}.url
  - dimension: weeks_since_registration
    type: number
    sql: datediff('weeks', ${users.created_date}, ${view_date})
  - dimension_group: view
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.view_date
  - measure: count
    type: count