A Metric is a statistic or summary measurement of one field (variable) of the data. There are three main categories of metrics: Totals, Rates, and Averages.
A Total is defined as the sum of the values of a particular variable. For example, Total Reservations is the sum of the number of reservations, and Total Pax is the sum of the number of people.
A Rate is defined as the percentage ratio of two sums. For example, Cancellation Rate is the sum of the number of cancellations divided by the sum of the number of reservations and multiplied by 100. Rates exclude walk-ins and deletions and are expressed as a percentage from 0% to 100%.
An Average is defined as a sum divided by a count and can take three forms (Per Period, Per Reservation, and Per Pax) depending on what count is used in the denominator of the average.
- Per Reservation averages use the number of reservations in the denominator. For example, Average Pax per Reservation is the average party size (number of people) divided by the number of reservations, and Average Booking Days in Advance per Reservation is the average number of days prior to the meal that a reservation is booked on a per reservation basis.
- Per Pax averages use the number of people in the denominator. For example, Average Pre-Orders Amount per Pax is the sum of the pre-ordered amount (in currency) divided by the sum of the number of people for reservations that have pre-orders.
- Per Period averages use the number of periods in the denominator. The Per Period averages always require a period that is day, week, month, or year. If the period is week, and the date range has 14 days, then the number of weeks is two (assuming the date range starts at the beginning of a week), and two is in the denominator for the Per Period averages for that query with a weekly period. If the period is month, and the date range is from February 5 to April 18, then the number of months in the denominator of the Per Period average is 3 (February, March, and April) even though the months are not complete.
Note: A Per Reservation or Per Pax average can be grouped by the period to see the average as a time series. However, Per Period averages cannot be grouped by a period because the period is part of the calculation for the metric itself. Therefore, Per Period averages can only be grouped by segment or shop, while Per Reservation and Per Pax averages can be grouped by segment, shop, and period. Furthermore, Per Period averages require a period, but Per Reservation and Per Pax averages do not.