Appendix C – Metrics Definition V2

Module - Footfall Counting and WiFi Analytics

A01 - Footfall Count IN

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 adult visitor in and child visitor in exclude the staff in for non-group counting in, and number of groups in for group counting in.
Formula	A01 = IF Group Counting In > 0 THEN Group Counting In ELSE Non-group Counting IN (Kid Visitor In + Adult Visitor In - Staff 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

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 adult visitor out and child visitor out exclude the staff out for non-group counting out, and number of groups out for group counting out.
Formula	A02 = IF Group Counting Out > 0 THEN Group Counting Out ELSE Non-group Counting Out (Kid Visitor Out + Adult Visitor Out - Staff 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 A01 - Summation of A02] OR A03 = Occupancy
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	Avg
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, FootfallCam Space Sense, Footfallcam 3D ProWave

A04 - Average Dwell Time

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 end time - start time, in second
Formula	A04 = TotalDwell / Count
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	Average
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double
Applicable Device(s)	FootfallCam People Counter, FootfallCam Centroid, FootfallCam 3D Mini

A05 - Outside Traffic

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.
Formula	A05 = Count (DISTINCT Mac) - A01
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	Sum
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam People Counter

A14 - Total Unique Customer

Business Description	The number of unique customer visited the store based on the MAC address detected.
Description	A14 indicates the Total Unique Customer visiting the store based on the unique MAC addresses detected by the relative devices
Formula	A14 = Count (DISTINCT Mac) with 2 peaks of strong WiFi Signal Strength
Object_Aggregation_Level	Area, Site
Aggregation	SUM
Time Summary Level	Daily
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam People Counter

A18 - Children Footfall IN

Business Description	The number of kids entering an area through passing by the In and Out line within the predefined operating hour.
Description	A18 indicates the number of kids with height lower than 1.3m which contributes to A01
Formula	A18 = [Summation of PFC01_3011]
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

A30 - Group Size Distribution 1

Business Description	Total number of people groups with size equals to 1.
Description	Total number of people groups with size equals to 1.
Formula	-
Object_Aggregation_Level	Area, Site
Aggregation	SUM
Time Summary Level	Daily, Hourly
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam ProWave, FootfallCam Centroid

A31 - Group Size Distribution 2

Business Description	Total number of people groups with size within A31_interval.
Description	Total number of people groups with size within A31_interval.
Formula	A31_interval_lower_bound <= Group Size < A31_interval_upper_bound
Object_Aggregation_Level	Area, Site
Aggregation	SUM
Time Summary Level	Daily, Hourly
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam ProWave, FootfallCam Centroid

A32 - Group Size Distribution 3

Business Description	Total number of people groups with size within A32_interval.
Description	Total number of people groups with size within A32_interval.
Formula	A32_interval_lower_bound <= Group Size < A32_interval_upper_bound
Object_Aggregation_Level	Area, Site
Aggregation	SUM
Time Summary Level	Daily, Hourly
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam ProWave, FootfallCam Centroid

A61 - All Day Outside Traffic

Business Description	The visitors pass by the outside the entrances of the stores.
Description	A61 indicates the total footfall detected at areas identified as outside.
Formula	A61 = Summation of Footfall
Object_Aggregation_Level	Area, Site
Aggregation	SUM
Time Summary Level	Hourly, Daily
Time_Mode	All day
Output Type	Integer
Applicable Device(s)	FootfallCam People Counter

A62 - Individual Footfall In

Business Description	The individual visitor entering an area through passing by the In and Out line within the predefined operating hour.
Description	A62 indicates the Individual Footfall Count IN based on the summation of adult visitor in and child visitor in exclude the staff in.
Formula	A62 = Kid Visitor In (A18) + Adult Visitor In - Staff 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

A63 - Group Footfall In

Business Description	Group of visitors entering an area through passing by the In and Out line within the predefined operating hour.
Description	A63 indicates the Group Footfall Count IN based on the summation of adult visitor in and child visitor in exclude the staff in.
Formula	-
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

B01 - Turn In Rate

Business Description	The percentage of outside traffic that was converted into actual visits to the store.
Description	B01 indicates the Turn-In Rate based on the proportion of A01 to the summation of A01 and A05.
Formula	B01 = A01 / (A01 + A05)
Object_Aggregation_Level	Follow A05
Aggregation	-
Time Summary Level	Follow A05
Time_Mode	Within operation hours
Output Type	Double

B02 - Returning Rate

Business Description	The percentage of visitors who had previously made a visit to the same store within the past 60 days.
Description	B02 indicates the Returning Rate for each site who appeared in the last 60 days
Formula	B03 = Unique customer seen in the past 60 days / A14
Object_Aggregation_Level	Follow A14
Aggregation	-
Time Summary Level	Follow A14
Time_Mode	Within operation hours
Output Type	Double

Module - Sales Conversions

A15 - Total Transaction Count

Business Description	The number of sales transaction performed in the store of the operating date.
Description	A15 indicates the Total Transaction Count of the store imported into the portal.
Formula	A15 = [Summation of Transaction Count within the same operate date]
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	SUM
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	-

A16 - Total Sales Revenue

Business Description	The total sales revenue performed in the store of the operating date
Description	A16 indicates the Total Sales Revenue of the store imported into the portal.
Formula	A16 = [Summation of Transaction Value within the same operate date]
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	SUM
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double
Applicable Device(s)	-

B06 - Sales Conversion

Business Description	The percentage of visitors that was converted to a customer and making purchase in the store.
Description	B06 indicates the Sales Conversion based on Footfall In A01 and Total Transaction Count A15
Formula	B06 = A15 / A01
Object_Aggregation_Level	Follow A15
Aggregation	-
Time Summary Level	Follow A15
Time_Mode	Within operation hours
Output Type	Double

B09 - Average Sales Amount

Business Description	The average sales revenue per transaction purchased by the customer of the selected date range.
Description	B09 indicates the Average Sales Amount per transaction by averaging the total sales revenue A16 over total transaction A15
Formula	B09 = A16 / A15
Object_Aggregation_Level	Follow A15
Aggregation	-
Time Summary Level	Follow A15
Time_Mode	Within operation hours
Output Type	Double

B10 - Units Per Transaction

Business Description	The average number of items per transaction purchased by the customer of the selected date range.
Description	B10 indicates the Unit per Transaction based on the proportion of total unit over total transaction count A15
Formula	B10 = Total Units / A15
Object_Aggregation_Level	Follow A15
Aggregation	-
Time Summary Level	Follow A15
Time_Mode	Within operation hours
Output Type	Double

B11 - Product Sales Conversion

Business Description	The average duration a customer needs to stay in queue before being serve.
Description	A55 indicates the average queue wait time required to wait in queue, in second
Formula	A55 = AVG(Queue Wait Time)
Object_Aggregation_Level	Area, Site
Aggregation	AVG
Time Summary Level	Hourly, Daily
Time_Mode	Within operating hours
Output Type	Double
Applicable Device(s)	FootfallCam People Counter

B12 - Engagement Sales Conversion

Business Description	The percentage of engaged customer is actually making a purchase in the store.
Description	B12 indicates the Engagement Sales Conversion based on the proportion of engaged customer A20 to the total transaction count A15
Formula	B12 = A20 / A15
Object_Aggregation_Level	Follow A15
Aggregation	-
Time Summary Level	Follow A15
Time_Mode	Within operation hours
Output Type	Double

Module - Visitors Engagement

A20 - Total Number of Engaged Customers

Business Description	The customer stays in front of a product in longer period, engaging the product details.
Description	A20 indicates the number of engaged visitors whose dwell time > PFH05_threshold set
Formula	A20 = Count(1) IF DwellTime > PFH05_threshold THEN 1
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	SUM
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam ProWave, FootfallCam Centroid

A21 - Total Number of Passerby

Business Description	The visitor who walks past the product without engaging it.
Description	A21 indicates the number of passerby whose dwell time <= PFC05_threshold set
Formula	A21 = Count(0) IF DwellTime > PFH05_threshold THEN 1
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	SUM
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam ProWave, FootfallCam Centroid

A22 - Average Engaged Duration

Business Description	Average duration of the engaged customer engaging the product.
Description	A22 indicates the average dwell time which dwell time > PFH05_threshold, in second
Formula	A22 = Average(DwellTime > PFH05_threshold) IF DwellTime > PFH05_threshold THEN DwellTime
Object_Aggregation_Level	Area, Site
Aggregation	AVG
Time Summary Level	Daily
Time_Mode	Within operation hours
Output Type	Double
Applicable Device(s)	FootfallCam ProWave, FootfallCam Centroid

B07 - Engagement Rate

Business Description	The percentage of visitors that engaged a product within the predefined area.
Description	B07 indicates the Engagement Rate by comparing the proportion of A20 to the summation of A20 and A21
Formula	B07 = A20 / (A20 + A21)
Object_Aggregation_Level	Follow A20
Aggregation	-
Time Summary Level	Follow A20
Time_Mode	Within operation hours
Output Type	Double

Module - Queue Management

A53 - Number of Customers Served

Business Description	The number of visitors making transactions at the cashier or counter.
Description	A53 indicates the number of visitors being served by staying at the serve zone for a longer period before leaving the store.
Formula	A53 = Summation of PeopleServed
Object_Aggregation_Level	Area, Area Group, Site, Site Group
Aggregation	SUM
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Integer
Applicable Device(s)	FootfallCam People Counter

A54 - Average Serving Time

Business Description	The average duration spent by the cashier to serve a customer.
Description	A54 indicates the average serving time required to serve a customer, in second
Formula	A54 = AVG(Serving Time)
Object_Aggregation_Level	Area, Site
Aggregation	AVG
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double
Applicable Device(s)	FootfallCam People Counter

A55 -Average Queue Wait Time

Business Description	The percentage of passerby and engaged customer actually making purchases.
Description	B11 indicates the Product Sales Conversion based on the proportion of total number of passerby A21 and engaged customers A20 to the total transaction count A15
Formula	B11 = (A20 + A21) / A15
Object_Aggregation_Level	Follow A15
Aggregation	-
Time Summary Level	Follow A15
Time_Mode	Within operation hours
Output Type	Double

Module - Demographics

B13 - Children Percentage

Business Description	The percentage of people who identified as a child (Age 0 to 7).
Description	B13 indicates the Children Percentage based on the proportion of total number of children over total footfall
Formula	B13 = Total number of children / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B14 - Teenagers Percentage

Business Description	The percentage of people who identified as teenagers (Age 8 to 14).
Description	B14 indicates the Teenagers Percentage based on the proportion of total number of teenagers over total footfall
Formula	B14 = Total number of teenagers / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B15 - Young Adults Percentage

Business Description	The percentage of people who identified as young adults (Age 15 to 37).
Description	B15 indicates the Young Adults Percentage based on the proportion of total number of young adults over total footfall
Formula	B15 = Total number of young adults / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B16 - Middle-Aged Adults Percentage

Business Description	The percentage of people who identified as middle-aged adults (Age 38 to 59).
Description	B16 indicates the Middle-Aged Adults Percentage based on the proportion of total number of middle-aged adults over total footfall
Formula	B16 = Total number of middle-aged adults / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B17 - Elderly Percentage

Business Description	The percentage of people who identified as elderly (Age 60 and above).
Description	B17 indicates the Elderly Percentage based on the proportion of total number of elderly over total footfall
Formula	B17 = Total number of elderly / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B18 - Percentage of People with Neutral Emotion

Business Description	The percentage of people who identified showing a neutral emotion on face.
Description	B18 indicates the Neutral Emotion Percentage based on the proportion of total number of faces with neutral emotions over total footfall
Formula	B18 = Total number of faces with neutral emotions / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B19 - Percentage of People with Positive Emotion

Business Description	The percentage of people who identified showing a positive emotion on face.
Description	B19 indicates the Positive Emotion Percentage based on the proportion of total number of faces with positive emotions over total footfall
Formula	B19 = Total number of faces with positive emotions / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B20 - Percentage of People with Negative Emotion

Business Description	The percentage of people who identified showing a negative emotion on face.
Description	B20 indicates the Negative Emotion Percentage based on the proportion of total number of faces with negative emotions over total footfall
Formula	B20 = Total number of faces with negative emotions / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B21 - Percentage of Male

Business Description	The percentage of people who identified as male.
Description	B21 indicates the Percentage of Male based on the proportion of total number of males over total footfall
Formula	B21 = Total number of males / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

B22 - Percentage of Female

Business Description	The percentage of people who identified as female.
Description	B22 indicates the Percentage of Female based on the proportion of total number of females over total footfall
Formula	B22 = Total number of females / Total footfall
Object_Aggregation_Level	Area, Site
Aggregation	-
Time Summary Level	Hourly, Daily
Time_Mode	Within operation hours
Output Type	Double

Module - Device Health Check

H10 - Total Memory Usage

Business Description	Total RAM memory usage in Bytes.
Description	Total RAM memory usage in Bytes.
Formula	-
Object_Aggregation_Level	Device
Aggregation	SUM
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

H11 - Average Memory Usage

Business Description	Average RAM memory usage in Bytes.
Description	Average RAM memory usage in Bytes.
Formula	-
Object_Aggregation_Level	Device
Aggregation	AVG
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

H12 - Total Main Storage Usage

Business Description	Total main storage usage in Bytes.
Description	Total main storage usage in Bytes.
Formula	-
Object_Aggregation_Level	Device
Aggregation	SUM
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

H13 - Average Main Storage Usage

Business Description	Average main storage usage in Bytes.
Description	Average main storage usage in Bytes.
Formula	-
Object_Aggregation_Level	Device
Aggregation	AVG
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

H14 - Total D Storage Usage

Business Description	Total D drive storage usage in Bytes.
Description	Total D drive storage usage in Bytes.
Formula	-
Object_Aggregation_Level	Device
Aggregation	SUM
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

H15 - Average D Drive Storage Usage

Business Description	Average D drive storage usage in Bytes.
Description	Average D drive storage usage in Bytes.
Formula	-
Object_Aggregation_Level	Device
Aggregation	AVG
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

H16 - Maximum Device Temperature

Business Description	Maximum device temperature in degree Celsius.
Description	Maximum device temperature in degree Celsius.
Formula	-
Object_Aggregation_Level	Device
Aggregation	MAX
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Decimal
Applicable Device(s)	-

H17 - Total Raspicam Run Count

Business Description	Total run count for Raspicam devices.
Description	Total run count for Raspicam devices.
Formula	-
Object_Aggregation_Level	Device
Aggregation	SUM
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

H18 - Total Raspicam No Run Count

Business Description	Total no run count for Raspicam devices.
Description	Total no run count for Raspicam devices.
Formula	-
Object_Aggregation_Level	Device
Aggregation	SUM
Time Summary Level	15 Minutes
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-

Module - Others

A19 - Total Number of Active Areas

Business Description	The number of areas that are operating as usual.
Description	A19 indicates the number of active areas which are not deleted
Formula	A19 = [Count (Distinct Areaid)]
Object_Aggregation_Level	Area Group, Site, Site Group
Aggregation	SUM
Time Summary Level	Minutely
Time_Mode	-
Output Type	Integer
Applicable Device(s)	-