Appendix C – Metrics Definition V2
A01 - Footfall Count IN
Input
Footfall Counting Raw Log RL01 - cameraSerial | RoiID | MetricID | ObjectTypeID | EventStartTime | EventEndTime | MetricID - 1
Business Description
The overall number of visitors entering an area through passing by the In and Out line within the predefined operating hour.
Description
A01 indicates the Footfall Count IN based on the summation of RL01 - Footfall Counting Raw Log for the selected Count_Mode of the selected Time_Aggregation_Level
Formula
A01 = Kid Visitor In + Adult Visitor In - Staff In IF Group Counting In > 0 THEN Group Counting In ELSE Non-group Counting In
Object_Aggregation_Level
Area, Area Group, Site, Site Group
Aggregation
Sum
Time Summary Level
Minutely, Hourly, Daily
Time_Mode
Within operation hours
Output Type
Integer
Applicable Device(s)
FootfallCam People Counter, FootfallCam Centroid, FootfallCam 3D Mini
A02 - Footfall Count OUT
Input
Footfall Counting Raw Log RL01 - cameraSerial | RoiID | MetricID | ObjectTypeID | EventStartTime | EventEndTime | MetricID - 1
Business Description
The overall number of visitors exiting an area through passing by the In and Out line within the predefined operating hour.
Description
A02 indicates the Footfall Count OUT based on the summation of RL01 - Footfall Counting Raw Log for the selected Count_Mode of the selected Time_Aggregation_Level
Formula
A02 = Kid Visitor Out + Adult Visitor Out - Staff Out IF Group Counting Out > 0 THEN Group Counting Out ELSE Non-group Counting Out
Object_Aggregation_Level
Area, Area Group, Site, Site Group
Aggregation
Sum
Time Summary Level
Minutely, Hourly, Daily
Time_Mode
Within operation hours
Output Type
Integer
Applicable Device(s)
FootfallCam People Counter, FootfallCam Centroid, FootfallCam 3D Mini
A03 - Occupancy
Business Description
The number of visitors in an area at any given time within the predefined operating hour.
Description
A03 indicates the number of Human captured by sensors at certain time.
Formula
A03 = [Summation of PFC01 - Summation of PFC02]
Object_Aggregation_Level
Area, Area Group, Site, Site Group
Aggregation
Avg
Time Summary Level
Minutely, Hourly, Daily
Count_Mode
1_People, 12_CarVehicle
Time_Mode
Within operation hours
Output Type
Integer
Applicable Device(s)
FootfallCam People Counter, Centroid, 3D Mini, Space Sense, 3D ProWave
A04 - Average Dwell Time
Input
DwellCountings Raw Log RL12 - CompanyID | BranchID | AreaID | ValueDateTime | TotalDwell | Count | IsOperating | OperateDate | IsWeekDay | IsSpecialOp
Business Description
The average visit duration of visitor based on their In and Out time in an area of predefined operating hour.
Description
A04 indicates the average visit duration (dwell time) of customer, identified via the duration between first in time and first out time
Formula
A04 = TotalDwell / Count
Object_Aggregation_Level
Area, Area Group, Site, Site Group
Roll Up
Average
Time Summary Level
Hourly, Daily
Time_Mode
Within operation hours
Output Type
Float
Applicable Device(s)
FootfallCam People Counter, FootfallCam Centroid, FootfallCam 3D Mini
A05 - Outside Traffic
Input
Raw Log RL03 - WiFi Raw Log cameraSerial | Mac | Timestamp | Signal | Type PFC01 - Footfall Count IN
Business Description
The amount of people who passed by the storefront area but did not end up visiting the store.
Description
A05 indicates Outside Traffic based on the unique MAC addresses detected by the relative devices from RL03 .
Formula
A05 = Count (DISTINCT Mac) - A01
Object_Aggregation_Level
Area
Aggregation
Sum
Time Summary Level
Hourly, Daily
Time_Mode
Within operation hours
Output Type
Integer
Applicable Device(s)
FootfallCam People Counter
A14 - Total Number of Customer
Description
Number of unique customers.
Aggregation
SUM
Object Aggregation Level
Site, Area
Time Summary Level
Daily
Time Mode
Within operation hours
Output Type
Integer
A15 - Total Transaction Count
Business Description
Total number of sales transactions.
Aggregation
SUM
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time Mode
Within operation hours
Output Type
Integer
A16 - Total Sales Revenue
Business Description
Total sales revenue in respective branch's local currency
Aggregation
SUM
Object Aggregation Level
Site,Area
Time Summary Level
Hourly, Daily
Time Mode
Within operation hours
Output Type
Decimal
A18 - Children Footfall IN
Business Description
Number of kids which contributes to A01
Aggregation
SUM
Object_Aggregation_Level
Site, Area
Time Summary Level
Hourly, Daily
Time_Mode
Within operation hours
Output Type
Integer
A19 - Total Number of Active Areas
Description
Total number of areas which are considered active.
Formula
AreaId
Aggregation
COUNT DISTINCT
Object Aggregation Level
Site, Area, Area Group
Time Summary Level
Minutely
Output Type
Integer
A20 - Total Number of Engaged Customers
Description
Number of visitors whose dwell time > PFH05_threshold value.
Formula
IF DwellTime > PFH05_threshold THEN 1
Aggregation
COUNT
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time_Mode
Within operation hours
Output Type
Integer
A21 - Total Number of Passerby
Description
Number of visitors whose dwell time <= PFH05_threshold value.
Formula
IF DwellTime <= PFH05_threshold THEN 1
Aggreagation
COUNT
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time_Mode
Within operation hours
Output Type
Integer
A22 - Average Engaged Duration
Description
Average engaged duration for engaged customers.
Formula
IF DwellTime <= PFH05_threshold THEN DwellTime
Aggregation
AVG
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time Mode
Within operation hours
Output Type
Integer
A53 - Number of Customers Served
Description
Total number of customers served
Formula
-
Aggregation
SUM
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time Mode
Within operation hours
Output Type
Integer
A54 - Average Serving Time
Description
Average time taken to serve a customer in seconds.
Formula
-
Aggregation
AVG
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time Mode
Within operation hours
Output Type
Decimal
A55 -Average Queue Wait Time
Description
Average time spent by customers waiting in queue in seconds.
Formula
-
Aggregation
AVG
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time Mode
Within operation hours
Output Type
Decimal
A61 - All Day Outside Traffic
Description
Total footfall detected at areas identified as outside.
Formula
-
Aggregation
SUM
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time Mode
All day
Output Type
Integer
A62 - Individual Footfall In
Description
Individual footfall.
Formula
Kid visitors In + Adults visitors In
Aggregation
SUM
Object Aggregation Level
Site, Area
Time Summary Level
Hourly, Daily
Time Mode
Within operation hours
Output Type
Integer
B01 - Turn In Rate
Business Description
Fraction of traffic which is footfall IN
Formula
A01 / (A01 + A05)
Aggregation
Follow A15
Object Aggregation Level
Follow A15
Time Summary Level
Follow A15
Time Mode
Follow A15
Output Type
Decimal
B03 - Last 14 Days Returning Rate
Business Description
Last 14 days Returning Rate
Formula
Unique customers seen in the past 14 days / Today unique customers
Aggregation
-
Object Aggregation Level
Site, Area
Time Summary Level
Daily
Time Mode
Within operation hours
Output Type
Decimal
B06 - Sales Conversion
Business Description
Fraction of footfall traffic that is converted to sale transactions.
Formula
A15 / A01
Aggregation
-
Object Aggregation Level
Follow A01
Time Summary Level
Follow A01
Time Mode
Follow A01
Output Type
Decimal
B07 - Engagement Rate
Business Description
Fraction of engaged customers to total visitors.
Formula
A20 / (A20 + A21)
Aggregation
-
Object Aggregation Level
Follow A20
Time Summary Level
Follow A20
Time Mode
Follow A20
Output Type
Decimal
B09 - Average Sales Amount
Business Description
Average revenue for each sales transaction.
Formula
A16 / A15
Aggregation
Follow A15
Object Aggregation Level
Follow A15
Time Summary Level
Follow A15
Time Mode
Follow A15
Output Type
Decimal
B10 - Units Per Transaction
Description
Average number of items per transaction.
Formula
Total Units / A15
Aggregation
-
Time Summary Level
Follows A15
Time_Mode
Follows A15
Output Type
Integer
B11 - Product Sales Conversion
Description
Fraction of number of passersby plus engaged customers to the number of transactions.
Formula
(A20 + A21) / A15
Aggregation
-
Time Summary Level
Follows A15
Time_Mode
Follows A15
Output Type
Decimal
B12 - Engagement Sales Conversion
Description
Fraction of number of engaged customers to the number of transactions.
Formula
A20 / A15
Aggregation
-
Time Summary Level
Follows A15
Time_Mode
Follows A15
Output Type
Decimal
B13 - Children Percentage
Description
Fraction of people who is identified as child (Age 0 to 7).
Formula
Total number of children / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B14 - Teenagers Percentage
Description
Fraction of people who is identified as teenager (Age 8 to 14).
Formula
Total number of teenagers / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B15 - Young Adults Percentage
Description
Fraction of people who is identified as young adult (Age 15 to 37).
Formula
Total number of young adults / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B16 - Middle-Aged Adults Percentage
Description
Fraction of people who is identified as middle-aged adult (Age 38 to 59).
Formula
Total number of middle-aged adults / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B17 - Elderly Percentage
Description
Fraction of people who is identified as elderly (Age 60 and above).
Formula
Total number of elderly / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B18 - Percentage of People with Neutral Emotion
Description
Fraction of people who shows neutral emotion.
Formula
Total number of neutral emotion faces / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B19 - Percentage of People with Positive Emotion
Description
Fraction of people who shows positive emotion.
Formula
Total number of positive emotion faces / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time Mode
Within operating hours
Output Type
Decimal
B20 - Percentage of People with Negative Emotion
Description
Fraction of people who shows negative emotion.
Formula
Total number of negative emotion faces / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B21 - Percentage of Male
Description
Fraction of people who is identified as male.
Formula
Total number of males / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
B22 - Percentage of Female
Description
Fraction of people who is identified as female.
Formula
Total number of females / Total footfall
Aggregation
-
Time Summary Level
Hourly, Daily
Time_Mode
Within operating hours
Output Type
Decimal
Updated on September 26, 2024