data.ml
LookML Analytics shopping

Usrb Historical Benchmarks

Usrb Historical Benchmarks model for analytics shopping.

source-preserved

Blocks

usrb_historical_benchmarks.view.lkml · 52 lines
inferred 
view: usrb_historical_benchmarks {
  sql_table_name: public.usrb_historical_benchmarks ;;

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
usrb_historical_benchmarks.view.lookml · 36 lines
source-preserved 
- view: usrb_historical_benchmarks
  sql_table_name: public.usrb_historical_benchmarks
  fields:
  - dimension: bounce_rate
    type: number
    sql: ${TABLE}.bounce_rate
  - dimension: duration_minutes_per_visitor
    type: number
    sql: ${TABLE}.duration_minutes_per_visitor
  - dimension: engagement_rate
    type: number
    sql: ${TABLE}.engagement_rate
  - dimension: month_of_report
    sql: ${TABLE}.month_of_report
  - dimension: outside_traffic
    type: number
    sql: ${TABLE}.outside_traffic
  - dimension: repeat_visitor_ratio
    type: number
    sql: ${TABLE}.repeat_visitor_ratio
  - dimension: visits
    type: number
    sql: ${TABLE}.visits
  - dimension: window_conversion_rate
    type: number
    sql: ${TABLE}.window_conversion_rate
  - dimension_group: execution_datetime
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.execution_datetime
  - measure: count
    type: count

Contents

  • usrb_historical_benchmarks.view.lkml
  • usrb_historical_benchmarks.view.lookml