data.ml
LKML Mobile ticketing

Event Summary

Event Summary model for mobile ticketing.

inferred

Blocks

event_summary.view.lkml · 265 lines
inferred 
view: event_summary {
  sql_table_name: game_summary ;;

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

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

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

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

  dimension: gross_sales {
    type: number
    sql: 1.0*${TABLE}.gross_sales/100 ;;
  }

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

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

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

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

  dimension: estimated_capacity {
    hidden: yes
    sql: ${venue.avg_attendance} ;;
  }

  dimension: max_capacity {
    hidden: yes
    sql: ${venue.max_attendance} ;;
  }

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

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

  measure: total_fans_upgraded {
    type: sum
    sql: ${event_summary.fans_upgraded} ;;
  }

  measure: min_fans_upgraded {
    type: min
    sql: ${event_summary.fans_upgraded} ;;
  }

  measure: max_fans_upgraded {
    type: max
    sql: ${event_summary.fans_upgraded} ;;
  }

  measure: average_fans_upgraded {
    type: avg
    sql: ${event_summary.fans_upgraded} ;;
  }

  measure: total_fans_active {
    type: sum
    sql: ${event_summary.fans_active} ;;
  }

  measure: average_fans_active {
    type: avg
    sql: ${event_summary.fans_active} ;;
  }

  measure: min_fans_active {
    type: min
    sql: ${event_summary.fans_active} ;;
  }

  measure: max_fans_active {
    type: max
    sql: ${event_summary.fans_active} ;;
  }

  measure: total_gross_sales {
    type: sum
    sql: ${event_summary.gross_sales} ;;
  }

  measure: max_gross_sales {
    type: max
    sql: ${event_summary.gross_sales} ;;
  }

  measure: average_gross_sales {
    type: avg
    sql: ${event_summary.gross_sales} ;;
  }

  measure: min_gross_sales {
    type: min
    sql: NULLIF(${event_summary.gross_sales},0) ;;
  }

  measure: total_memories_redeemed {
    type: sum
    sql: ${event_summary.memories_redeemed} ;;
  }

  measure: total_passes_sold {
    type: sum
    sql: ${event_summary.passes_sold} ;;
  }

  measure: total_transactions {
    type: sum
    sql: ${event_summary.transactions} ;;
  }

  measure: min_transactions {
    type: min
    sql: ${event_summary.transactions} ;;
  }

  measure: max_transactions {
    type: max
    sql: ${event_summary.transactions} ;;
  }

  measure: average_transactions {
    type: avg
    sql: ${event_summary.transactions} ;;
  }

  measure: total_registered_emails {
    type: sum
    sql: ${event_summary.registered_emails} ;;
  }

  measure: min_registered_emails {
    type: min
    sql: ${event_summary.registered_emails} ;;
  }

  measure: max_registered_emails {
    type: max
    sql: ${event_summary.registered_emails} ;;
  }

  measure: average_registered_emails {
    type: avg
    sql: ${event_summary.registered_emails} ;;
  }

  measure: total_conversion {
    type: number
    sql: ${total_transactions} *100.0 / nullif(${total_fans_active},0) ;;
  }

  measure: total_fans_impacted {
    type: number
    sql: ${total_fans_upgraded} + ${total_memories_redeemed} + ${total_passes_sold} ;;
  }

  measure: total_fans_impacted_over_registrations {
    type: number
    sql: ${total_fans_impacted} *100.0 / nullif(${total_registered_emails},0) ;;
  }

  measure: total_gross_sales_per_registrations {
    type: number
    sql: ${total_gross_sales} / nullif(${total_registered_emails},0) ;;
  }

  measure: transactions_memories_passes_total {
    type: number
    sql: ${total_transactions} + ${total_memories_redeemed} + ${total_passes_sold} ;;
  }

  measure: average_upgrade_price {
    type: number
    sql: ${total_gross_sales} / nullif(${total_fans_upgraded},0) ;;
  }

  measure: memories_passes_total_percent_of_previous {
    type: percent_of_previous
    sql: ${transactions_memories_passes_total} ;;
  }

  measure: total_registered_emails_percent_of_previous {
    label: "Total Registered Emails (Percent of Previous)"
    type: percent_of_previous
    sql: ${total_registered_emails} ;;
  }

  measure: total_fans_impacted_percent_of_previous {
    label: "Total Fans Impacted (Percent of Previous)"
    type: percent_of_previous
    sql: ${total_fans_impacted} ;;
  }

  measure: fans_impacted_over_reg_percent_of_previous {
    label: "Fans Impacted over Registrations (Percent of Previous)"
    type: percent_of_previous
    sql: ${total_fans_impacted_over_registrations} ;;
  }

  measure: average_estimated_capacity {
    type: avg
    sql: ${estimated_capacity} ;;
  }

  measure: average_max_capacity {
    type: avg
    sql: ${max_capacity} ;;
  }

  measure: total_estimated_capacity {
    type: sum
    sql: ${estimated_capacity} ;;
  }

  measure: total_max_capacity {
    type: sum
    sql: ${max_capacity} ;;
  }

  measure: registrations_to_estimated_attendance {
    type: number
    sql: 100.0 * ${total_registered_emails} / nullif(${total_estimated_capacity},0) ;;
  }

  measure: fans_impacted_to_estimated_attendance {
    type: number
    sql: 100.0 * ${total_fans_impacted} / nullif(${total_estimated_capacity},0) ;;
  }
}
event_summary.view.lookml · 171 lines
source-preserved 
- view: event_summary
  sql_table_name: game_summary
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: fans_active
    type: int
    sql: ${TABLE}.fans_active
  - dimension: fans_upgraded
    type: int
    sql: ${TABLE}.fans_upgraded
  - dimension: game_id
    type: int
    hidden: true
    sql: ${TABLE}.game_id
  - dimension: gross_sales
    type: number
    sql: 1.0*${TABLE}.gross_sales/100
  - dimension: memories_redeemed
    type: int
    sql: ${TABLE}.memories_redeemed
  - dimension: passes_sold
    type: int
    sql: ${TABLE}.passes_sold
  - dimension: registered_emails
    type: int
    sql: ${TABLE}.registered_emails
  - dimension: transactions
    type: int
    sql: ${TABLE}.transactions
  - dimension: estimated_capacity
    hidden: true
    sql: ${venue.avg_attendance}
  - dimension: max_capacity
    hidden: true
    sql: ${venue.max_attendance}
  - dimension_group: date_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.date_created
  - dimension_group: last_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_updated
  - measure: total_fans_upgraded
    type: sum
    sql: ${event_summary.fans_upgraded}
  - measure: min_fans_upgraded
    type: min
    sql: ${event_summary.fans_upgraded}
  - measure: max_fans_upgraded
    type: max
    sql: ${event_summary.fans_upgraded}
  - measure: average_fans_upgraded
    type: avg
    sql: ${event_summary.fans_upgraded}
  - measure: total_fans_active
    type: sum
    sql: ${event_summary.fans_active}
  - measure: average_fans_active
    type: avg
    sql: ${event_summary.fans_active}
  - measure: min_fans_active
    type: min
    sql: ${event_summary.fans_active}
  - measure: max_fans_active
    type: max
    sql: ${event_summary.fans_active}
  - measure: total_gross_sales
    type: sum
    sql: ${event_summary.gross_sales}
  - measure: max_gross_sales
    type: max
    sql: ${event_summary.gross_sales}
  - measure: average_gross_sales
    type: avg
    sql: ${event_summary.gross_sales}
  - measure: min_gross_sales
    type: min
    sql: NULLIF(${event_summary.gross_sales},0)
  - measure: total_memories_redeemed
    type: sum
    sql: ${event_summary.memories_redeemed}
  - measure: total_passes_sold
    type: sum
    sql: ${event_summary.passes_sold}
  - measure: total_transactions
    type: sum
    sql: ${event_summary.transactions}
  - measure: min_transactions
    type: min
    sql: ${event_summary.transactions}
  - measure: max_transactions
    type: max
    sql: ${event_summary.transactions}
  - measure: average_transactions
    type: avg
    sql: ${event_summary.transactions}
  - measure: total_registered_emails
    type: sum
    sql: ${event_summary.registered_emails}
  - measure: min_registered_emails
    type: min
    sql: ${event_summary.registered_emails}
  - measure: max_registered_emails
    type: max
    sql: ${event_summary.registered_emails}
  - measure: average_registered_emails
    type: avg
    sql: ${event_summary.registered_emails}
  - measure: total_conversion
    type: number
    sql: ${total_transactions} *100.0 / nullif(${total_fans_active},0)
  - measure: total_fans_impacted
    type: number
    sql: ${total_fans_upgraded} + ${total_memories_redeemed} + ${total_passes_sold}
  - measure: total_fans_impacted_over_registrations
    type: number
    sql: ${total_fans_impacted} *100.0 / nullif(${total_registered_emails},0)
  - measure: total_gross_sales_per_registrations
    type: number
    sql: ${total_gross_sales} / nullif(${total_registered_emails},0)
  - measure: transactions_memories_passes_total
    type: number
    sql: ${total_transactions} + ${total_memories_redeemed} + ${total_passes_sold}
  - measure: average_upgrade_price
    type: number
    sql: ${total_gross_sales} / nullif(${total_fans_upgraded},0)
  - measure: memories_passes_total_percent_of_previous
    type: percent_of_previous
    sql: ${transactions_memories_passes_total}
  - measure: total_registered_emails_percent_of_previous
    type: percent_of_previous
    label: Total Registered Emails (Percent of Previous)
    sql: ${total_registered_emails}
  - measure: total_fans_impacted_percent_of_previous
    type: percent_of_previous
    label: Total Fans Impacted (Percent of Previous)
    sql: ${total_fans_impacted}
  - measure: fans_impacted_over_reg_percent_of_previous
    type: percent_of_previous
    label: Fans Impacted over Registrations (Percent of Previous)
    sql: ${total_fans_impacted_over_registrations}
  - measure: average_estimated_capacity
    type: avg
    sql: ${estimated_capacity}
  - measure: average_max_capacity
    type: avg
    sql: ${max_capacity}
  - measure: total_estimated_capacity
    type: sum
    sql: ${estimated_capacity}
  - measure: total_max_capacity
    type: sum
    sql: ${max_capacity}
  - measure: registrations_to_estimated_attendance
    type: number
    sql: 100.0 * ${total_registered_emails} / nullif(${total_estimated_capacity},0)
  - measure: fans_impacted_to_estimated_attendance
    type: number
    sql: 100.0 * ${total_fans_impacted} / nullif(${total_estimated_capacity},0)

Contents

  • event_summary.view.lkml
  • event_summary.view.lookml