Metrics Glossary

RetailNext offers a number of metrics that are derived and calculated based on data from several different sources. Values for these metrics can be found in Dashboards, Analytics, Reports, etc. The full set of available metrics is described here.

 

Metrics

Name

API Identifier

Description

Format

Formula

Available Group By Options

Source

Name

API Identifier

Description

Format

Formula

Available Group By Options

Source

Traffic and Exposure

Traffic In

traffic_in

Number of shoppers who walk into the store

Integer

n/a

Location, Date, Time, DOW, Staff Member

Video

Traffic Out

traffic_out

Number of shoppers who walk out of the store

Integer

n/a

Location, Date, Time, DOW, Staff Member

Video

Exposure Rate

exposure_rate

Percentage of shoppers who walk by a specific location as compared to the total store traffic

Percent

100% * Traffic OUT for the selected location / Traffic OUT for the Store

NOTE: Exposure Rate is calculated using Traffic Out by default, however this can be changed to Traffic In on the Admin > Metrics page.

Location, Date, Time, DOW

Video

Direction Map

directional_traffic_0 directional_traffic_1 directional_traffic_2

Number of shoppers that cross the entry traffic line and walk in a certain direction

Note 0, 1, and 2 correspond to left, middle, and right respectively

Integer

n/a

Location, Date, Time, DOW

Video

Video Passby

Video Passby Traffic

passby_traffic_in

Number of people who walk by the store, including those who enter

Integer

n/a

Location, Date, Time, DOW

Video

Video Capture Rate

video_passby_capture_rate

Percentage of people passing by the store who enter the store

Percent

100% * Traffic IN (from video) / Video Passby Traffic

Location, Date, Time, DOW

Video

Occupancy

Occupancy

total_occupancy

Snapshot of total occupants in the store at the end of each group by period

Inclusive of Occupancy Adjustments

Integer

Cumulative Traffic In - cumulative Traffic Out + Occupancy Adjustment during

NOTE: This metric presents a snapshot of occupancy at the end of each selected group-by bucket

Location, Date, Time, DOW

Video

Occupancy Rate

total_occupancy_rate

Percentage of Occupancy as compared to the store occupancy limit

Percent

100% * Occupancy / Occupancy Limit

Location, Date, Time, DOW

Video

Occupancy Adjustment

occupancy_adjustment

Net total of occupancy adjustments

Integer

NOTE: This metric represents the cumulative total of adjustments made in each group-by bucket

Location, Date, Time, DOW

Manual adjustment

Engagement

Dwells

dwell_count

Number of shoppers who stand in a specified dwell zone for longer than a defined minimum amount of time

Integer

n/a

Location, Date, Time, DOW

Video

Avg Dwell Time

avg_dwell_duration

Average amount of time shoppers stand in a specified dwell zone

Time period

Sum of Dwell Times / Dwells

Location, Date, Time, DOW

Video

Engagement Rate

engagement_rate

Percentage of shoppers walking by a location who stop at that location

Percent

100% * Dwells for Location / Traffic OUT for Location (traffic from dwell or FPA zones only)

Location, Date, Time, DOW

Video

Display vs Store

Engagement Rate - Store

store_engagement_rate

Percentage of shoppers who stop at a specific location as compared to the total store traffic

Percent

100% * Dwells for Location / Traffic OUT for Store

Location, Date, Time, DOW

Video

Store Conversion Rate - SKU

store_sku_conversion_rate

Percentage of shoppers visiting the store who purchase something from the selected location

Percent

100% * Sales Transactions / Traffic Out for Store

NOTE: By default Conversion Rate is calculated using Traffic Out, however this can be changed to Traffic In on the Admin > Metrics page.

Returns are excluded.

Location, Date, Time, DOW

Video + Product Locations + POS (from products/SKUs in selected location)

Conversion and Sales

Conversion Rate

conversion_rate

Percentage of shoppers visiting the store who make a purchase

Percent

100% * Sales Transactions / Traffic Out
Returns are excluded.


NOTE: Conversion Rate is calculated using Traffic Out by default, however this can be changed to Traffic In on the Admin > Metrics page.

Location, Date, Time, DOW, Staff Member

Video + POS (from POS terminals in selected location)

Shopper Yield

shopper_yield

Average net sale amount for each shopper visiting the store within a specified period

Currency

Net Sales / Traffic Out

NOTE: Shopper Yield is calculated using Traffic Out by default, however this can be changed to Traffic In by updating the Conversion Rate setting on the Admin > Metrics page.

Location, Date, Time, DOW, Staff Member

Video + POS (from POS terminals in selected location)

Sales

net_sales

Net sales for a specified period

Currency rounded (Currency for CSV export)

Sales Amount - Return Amount

where

Sales Amount = amount from all Sales Transactions excluding tax, including discounts

Return Amount = amount from all Return Transactions excluding tax, including discounts

NOTE: There is an option on the Admin > Metrics page to use the sum of the line items totals instead of transaction total minus tax for sales metrics.

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Return Amount

return_amount

Total of all returns

Currency rounded (Currency for CSV export)

Amount from all Return Transactions excluding tax, including discounts

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Sales Transactions

sales_transactions_count

Total number of sales transactions for a specified period

Integer

n/a

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Return Transactions

return_transactions_count

Total number of return transactions for a specified period

Integer

n/a

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

All Transactions

total_transactions_count

Total number of sales and return transactions for a specified period

Integer

Sales Transactions + Return Transactions

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Avg Transaction Value (ATV)

avg_transaction_value

Average net sales amount spent per transaction

Currency

Net Sales / Total Transactions

NOTE: there is an option on Admin > Metrics to exclude returns from the transactions number so that the formula is: Net Sales / Sales Transactions

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Avg Units Per Transaction (UPT)

avg_items_per_transaction

Average number of items purchased per transaction

Decimal

Net Items / Total Transactions

NOTE: there is an option on Admin > Metrics to exclude returns from the transactions number so that the formula is: Net Items / Sales Transactions

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Sales per Sq Unit

net_sales_per_sq_unit

Net sales per square unit of space

Currency

Net Sales / Area

Location, Date, Time, DOW

POS (from POS terminals in selected location)

Transactions per Sq Unit

sales_transactions_count_per_sq_unit

Total number of sales transactions per square unit of space

Decimal

Sales Transactions / Area

Location, Date, Time, DOW

POS (from POS terminals in selected location)

Avg Unit Retail (AUR)

avg_unit_retail

Average net sale amount per item sold

Currency

Net Sales / Net Items

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Net Items

net_items_count

Number of items sold after subtracting returns for a specified period

Integer

Items sold - Items returned

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Sales Items

sales_items_count

Number of items sold

Integer

n/a

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

Return Items

return_items_count

Number of items returned

Integer

n/a

Location, Date, Time, DOW, Staff Member

POS (from POS terminals in selected location)

SKU Sales

Dwell Conversion Rate

dwell_conversion_rate

Percentage of shoppers dwelling in a location who purchase an item from that location

Percent

100% * Sales Transactions containing SKUs from specified dwell zone / Dwells in specified zone

NOTE: SKU mapping is required

Location, Date, Time, DOW

Video + Product Locations + POS (from products/SKUs in selected location)

Conversion Rate - SKU

sku_conversion_rate

Percentage of shoppers visiting the selected location who purchase something from that location

Percent

100% * Sales Transactions / Traffic Out (from selected location)

NOTE: By default Conversion Rate is calculated using Traffic Out, however this can be changed to Traffic In on the Admin > Metrics page.

Returns are excluded.

Location, Date, Time, DOW

Video + Product Locations + POS (from products/SKUs in selected location)

Shopper Yield - SKU

sku_shopper_yield

Average net sale amount for each shopper visiting the store within a specified period

Currency

Net Sales / Traffic Out

NOTE: By default Shopper Yield is calculated using Traffic Out, however this can be changed to Traffic In by updating the Conversion Rate setting on the Admin > Metrics page.

Location, Date, Time, DOW

Video + Product Locations + POS (from products/SKUs in selected location)

Sales - SKU

sku_net_sales

Net sales for a specified period

Currency rounded (Currency for CSV export)

Sales Amount - Return Amount

where

Sales Amount = amount from all Sales Transactions excluding tax, including discounts

Return Amount = amount from all Return Transactions excluding tax, including discounts

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Return Amount - SKU

sku_return_amount

Total of all returns

Currency rounded (Currency for CSV export)

Amount from all Return Transactions excluding tax, including discounts

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Sales Transactions - SKU

sku_sales_transactions_count

Total number of sales transactions for a specified period

Integer

n/a

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Return Transactions - SKU

sku_return_transactions_count

Total number of return transactions for a specified period

Integer

n/a

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

All Transactions - SKU

sku_total_transactions_count

Total number of sales and return transactions for a specified period

Integer

Sales Transactions + Return Transactions

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Avg Transaction Value (ATV) - SKU

sku_avg_transaction_value

Average net sales amount spent per transaction

Currency

Net Sales / Total Transactions

NOTE: there is an option on Admin > Metrics to exclude returns from the transactions number so that the formula is: Net Sales / Sales Transactions

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Avg Units Per Transaction (UPT) - SKU

sku_avg_items_per_transaction

Average number of items purchased per transaction

Decimal

Net Items / Total Transactions

NOTE: there is an option on Admin > Metrics to exclude returns from the transactions number so that the formula is: Net Items / Sales Transactions

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Sales per Sq Unit - SKU

sku_net_sales_per_sq_unit





Net sales per square unit of space

Currency

Net Sales / Area

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Transactions per Sq Unit - SKU

sku_sales_transactions_count_per_sq_unit





Total number of sales transactions per square unit of space

Decimal

Sales Transactions / Area

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Avg Unit Retail (AUR) - SKU

sku_avg_unit_retail

Average net sale amount per item sold

Currency

Net Sales / Net Items

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Net Items - SKU

sku_net_items_count

Number of items sold after subtracting returns for a specified period

Integer

Items sold - Items returned

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Sales Items - SKU

sku_sales_items_count

Number of items sold

Integer

n/a

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Return Items - SKU

sku_return_items_count

Number of items returned

Integer

n/a

Location, Date, Time, DOW

Product Locations + POS (from products/SKUs in selected location)

Staffing

(See https://retailnext.atlassian.net/wiki/spaces/KB/pages/143884295 for more details and examples of how the staffing metrics are calculated)

Staff per Hour

staff_count

Number of staff members present in the store per hour

Decimal

n/a

NOTE: this is measured in 15 min increments, so for a 1-hour period, we take the average Staff Count for the 4 15-minute periods; also if looking at multiple locations, such as all stores in a district, we take the average (not total) across the locations.

See Staffing Metrics for more details.

Location, Date, Time (data shows for 15 min increments), DOW

Staffing

Labor Hours

labor_hours

Total number of hours worked by staff members

Decimal

n/a

See Staffing Metrics for more details.

Location, Date, Time (data shows for 15 min increments), DOW, Staff Member

Staffing

Shoppers per Labor Hour

shopper_per_labor_hour

Ratio of shoppers who entered the store to labor hours

Decimal

Traffic In / Labor Hours

See Staffing Metrics for more details.

Location, Date, Time (data shows for 15 min increments), DOW

Video + Staffing

Staff Productivity

staff_productivity

Net sales per staff hour

Currency

Net Sales / Labor Hours

Location, Date, Time (data shows for 15 min increments), DOW, Staff Member

POS + Staffing

Staff Activity

Staff Traffic In

staff_traffic_in

Number of staff members who walk into the store

Integer

n/a

Location, Date, Time, DOW

Video + BLE tags OR FPA

Staff Traffic Out

staff_traffic_out

Number of staff members who walk out of the store

Integer

n/a

Location, Date, Time, DOW

Video + BLE tags OR FPA

Staff Dwells

staff_dwell_count

Number of staff members who stand in a specified dwell zone for longer than a defined minimum amount of time

Integer

n/a

Location, Date, Time, DOW

Video + BLE tags OR FPA

Staff Avg Dwell Time

staff_avg_dwell_duration

Average amount of time staff members stand in a specified dwell zone

Time period

Sum of Staff Dwell Times / Staff Dwells

Location, Date, Time, DOW

Video + BLE tags OR FPA

Staff Engagement Rate

staff_engagement_rate

Percentage of staff members walking by a location who stop at that location

Percent

100% * Staff Dwells for Location / Staff Traffic OUT for Location (traffic from dwell or FPA zones only)

Location, Date, Time, DOW

Video + BLE tags OR FPA

Interactions

Shopper and Staff Interactions

shopper_staff_interaction_count

The number of shopper and staff interactions that took place in the selected location

Integer

n/a

Location, Date, Time, DOW

FPA + Video

% of Store Shopper/Staff Interactions

shopper_staff_zone_interaction_rate

The percentage of all shopper and staff interactions that took place in the selected location

Percent

100% * Shopper and Staff Interactions for Location / Shopper and Staff Interactions for Floorplan

Location, Date, Time, DOW

FPA + Video

% of Shoppers Interacted

shopper_staff_interaction_rate

The percentage of shoppers that had an interaction with staff out of all shoppers that dwelled in the selected location

Percent

100% * Shopper and Staff Interactions for Location / Dwells for Location

Location, Date, Time, DOW

FPA + Video

Non-Zone Interactions

shopper_staff_non_zone_interactions

The number of shopper and staff interactions that took place outside of any FPA zones

Integer

n/a

Location, Date, Time, DOW

FPA + Video

Purchasers

(See https://retailnext.atlassian.net/wiki/spaces/KB/pages/1537376257 for more information)

Purchaser Traffic In

purchaser_traffic_in

Number of purchasers who walk into the location

Integer

n/a

Location, Date, Time, DOW

FPA + Video + POS

Purchaser Traffic Out

purchaser_traffic_out

Number of purchasers who walk out of the location

Integer

n/a

Location, Date, Time, DOW

FPA + Video + POS

Purchaser Dwells

purchaser_dwell_count

Number of purchasers who stand in a specified zone for longer than a defined minimum amount of time

Integer

n/a

Location, Date, Time, DOW

FPA + Video + POS

Purchaser Avg Dwell Time

purchaser_avg_dwell_duration

Average amount of time purchasers stand in a specified dwell zone

Time period

Sum of Purchaser Dwell Times / Purchaser Dwells

Location, Date, Time, DOW

FPA + Video + POS

Purchaser Engagement Rate

purchaser_engagement_rate

Percentage of purchasers walking by a location who stop at that location

Percent

100% * Zone’s Purchaser Dwells / Zone’s Purchaser Traffic OUT

Location, Date, Time, DOW

FPA + Video + POS

Purchaser Exposure Rate

purchaser_exposure_rate

Percentage of purchasers who walk by a specific location as compared to the total store traffic

Percent

100% * Zone's Purchaser Traffic Out / Store's Purchaser Traffic Out

NOTE: Exposure Rate is calculated using Traffic Out by default, however this can be changed to Traffic In on the Admin > Metrics page.

Location, Date, Time, DOW

FPA + Video + POS

Non-Purchaser Traffic In

non_purchaser_traffic_in

Number of non-purchasers who walk into the location

Integer

n/a

Location, Date, Time, DOW

FPA + Video + POS

Non-Purchaser Traffic Out

non_purchaser_traffic_out

Number of non-purchasers who walk out of the location

Integer

n/a

Location, Date, Time, DOW

FPA + Video + POS

Non-Purchaser Dwells

non_purchaser_dwell_count

Number of non-purchasers who stand in a specified zone for longer than a defined minimum amount of time

Integer

n/a

Location, Date, Time, DOW

FPA + Video + POS

Non-Purchaser Avg Dwell Time

non_purchaser_avg_dwell_duration

Average amount of time non-purchasers stand in a specified dwell zone

Time period

Sum of Non-Purchaser Dwell Times / Non-Purchaser Dwells

Location, Date, Time, DOW

FPA + Video + POS

Non-Purchaser Engagement Rate

non_purchaser_engagement_rate

Percentage of non-purchasers walking by a location who stop at that location

Percent

100% * Zone’s Non-Purchaser Dwells / Zone’s Non-Purchaser Traffic OUT

Location, Date, Time, DOW

FPA + Video + POS

Non-Purchaser Exposure Rate

non_purchaser_exposure_rate

Percentage of non-purchasers who walk by a specific location as compared to the total store traffic

Percent

100% * Zone's Non-Purchaser Traffic Out / Store's Non-Purchaser Traffic Out

NOTE: Exposure Rate is calculated using Traffic Out by default, however this can be changed to Traffic In on the Admin > Metrics page.

Location, Date, Time, DOW

FPA + Video + POS

Mobile Device Detection

MDD Capture Rate

mdd_passby_capture_rate

Percentage of people passing by the store who enter the store

Percent

100% * Traffic IN (from video) / Passby WTraffic

where

Passby WTraffic = the count of OUTSIDE events that started in the period

Location, Date, Time, DOW

Video + Wi-Fi sensors

Visit Duration

wireless_visit_duration

Average amount of time shoppers spend inside the store

Time period (seconds for CSV export)

(Sum of duration of all INSIDE events that ended in the period) / (Count of INSIDE events that ended in the period)

Location, Date, Time, DOW

Wi-Fi sensors

New Shopper %

new_visitors_rate

Percentage of shoppers visiting the store for the first time

Percent

100% - Repeat Visitor %

Location, Date, DOW (the data cannot be broken into increments smaller than 1 day)

Video + Wi-Fi sensors

Repeat Shopper %

repeat_visitors_rate

Percentage of shoppers who have visited the store before today

Percent

Within a given time period, Repeat Visitor Rate = 100% * (Repeat WVisitors) / (Unique WTraffic)

where

Repeat WVisitors = the number of INSIDE events that started in that period, associated with unique devices that have previously been detected inside the store.

Unique WTraffic = the number of unique devices that generated INSIDE events that started in the period.

Location, Date, DOW (the data cannot be broken into increments smaller than 1 day)

Video + Wi-Fi sensors

Visit Frequency

visit_frequency

Average number of times a shopper enters the store within a specified time period

Decimal

Total # of visits / Total unique visitors

Location, Date, DOW (the data cannot be broken into increments smaller than 1 day)

Wi-Fi sensors

Demographics

Male Percentage

male_rate

Percentage of shoppers who are male

Percent

100% x Number of Males / Number of Identified Shoppers

Location, Date, Time, DOW

Video

Female Percentage

female_rate

Percentage of shoppers who are female

Percent

100% x Number of Females / Number of Identified Shoppers

Location, Date, Time, DOW

Video

Average Age

avg_age

Average age of shoppers who enter the store

Decimal

Sum of Ages / Number of Identified Shoppers

Location, Date, Time, DOW

Video

Male Average Age

male_avg_age

Average age of male shoppers who enter the store

Decimal

Sum of Male Ages / Number of Identified Male Shoppers

Location, Date, Time, DOW

Video

Female Average Age

female_avg_age

Average age of female shoppers who enter the store

Decimal

Sum of Female Ages / Number of Identified Female Shoppers

Location, Date, Time, DOW

Video

Age Range Percentage

1to12_rate, 13to17_rate, 18to24_rate, etc.

Percentage of shoppers who are within a specified age range

Percent

100% x Number of People within Age Range / Number of Identified Shoppers

Location, Date, Time, DOW

Video

Male In Age Range Percentage

male_1to12_rate, male_13to17_rate, male_18to24_rate, etc.

Percentage of male shoppers who are within a specified age range

Percent

100% x Number of Males in Age Range / Number of Males

Location, Date, Time, DOW

Video

Female In Age Range Percentage

female_1to12_rate, female_13to17_rate, female_18to24_rate, etc.

Percentage of female shoppers who are within a specified age range

Percent

100% x Number of Females in Age Range / Number of Females

Location, Date, Time, DOW

Video

Guest Wi-Fi

Total Guest Wi-Fi Users

total_wifi_users

Number of unique Wi-Fi users for a specified period

Integer



Location, Date, Time, DOW

Wi-Fi sensors, Guest Wi-Fi

New Guest Wi-Fi Users

new_wifi_users

Number of Wi-Fi users enrolling for the first time during a specified period

Integer



Location, Date, Time, DOW

Wi-Fi sensors, Guest Wi-Fi

Repeat Guest Wi-Fi Users

repeat_wifi_users

Number of unique Wi-Fi users who did not enroll for the first time during a specified period

Integer



Location, Date, Time, DOW

Wi-Fi sensors, Guest Wi-Fi

Guest Wi-Fi Uptake

wifi_uptake

The ratio of Wi-Fi users to devices detected inside

Percentage



Location, Date, Time, DOW

Wi-Fi sensors, Guest Wi-Fi

API Only Metrics

The following metrics are also available through the API only:

Metric

Meaning

Metric

Meaning

Traffic + MDD (Video + Wi-Fi)



unique_traffic

Number of individual shoppers who enter the store (each person is counted only once for the date range selected).

passby_traffic

Number of people who walk by the store, including those who enter.

unique_passby_traffic

Number of individual shoppers who walk by the store (each person is counted only once for the date range selected).

mobile_device_detection_rate

Percentage of shoppers who enter the store with a detected mobile device.

total_occupancy

Number of occupants currently within the store (inclusive of shopper and employee traffic)

MDD Only (Wi-Fi)



new_visitors

New Shoppers

repeat_visitors

Repeat Shoppers

wireless_passby_capture_rate

Percentage of Unique Wireless Passby Events

wireless_new_visitors

Number of New Wireless Devices

wireless_new_visitors_rate

Percentage of New Wireless Devices

wireless_repeat_visitors

Number of Repeat Wireless Devices

wireless_repeat_visitors_rate

Percentage of Repeat Wireless Devices

wireless_visit_frequency

Wireless Visit Frequency

wireless_mdd_enter

Number of Visits (non-unique)

wireless_unique_mdd_enter

Unique Wireless Events Detected Inside

wireless_mdd_passby

Wireless Passby Events

wireless_unique_mdd_passby

Unique Wireless Passby Events

POS Only



sales_amount

Amount from all Sales Transactions

sku_sales_amount

Amount from all Sales Transactions from SKUs in selected location (requires Product Locations data)

FPA



fpa_valid_start_rate

Percent of valid starting tracks = count of tracks that start in track start zones / total count of tracks

fpa_complete_rate

Percent of complete tracks = count of tracks that start AND end in track start zones / count of tracks that start in track start zones

Format Reference

  • Integer: Number with 0 decimal places; e.g. 1

  • Decimal: Number rounded to 1 decimal place; e.g. 1.3

  • Percent: Percentage rounded to 1 decimal place; e.g. 125.3%

  • Currency: Currency rounded to 2 decimal places; e.g. $1.25

  • Currency rounded: Currency rounded to 0 decimal places; e.g. $1

  • Time period: Time period formatted as h/m/s; e.g. 1h25m3s