All Collections
Retail Analytics
General Help for Retail Analytics
Retail Analytics Glossary for the Latest Version of Treez
Retail Analytics Glossary for the Latest Version of Treez
T
Written by Treez Admin
Updated over a week ago

Please Note: This article pertains to functionality in the Latest Version of Treez.

Avg Basket Size: Average count of units purchased on all orders. This is calculated by dividing the total number of units sold over the count of transactions.

Avg Cost w/o Excise: Avg cost without adding excise tax.

Avg Customer Time in Store: Average time between customer check-in and completed sales. This should equal the Customer Wait Time plus the transaction time.

Avg Customer Wait Time: Average time customer spends waiting to be helped (from waiting room to the sales floor) or check into selected.

Avg Daily Velocity: (Discount Analysis) - Total number of units sold divided by the number of days this product was on the sales floor.

Avg Discount Percent: Discounts divided by gross sales.

Avg Order Value: Average Order Value is the average gross receipt, which is calculated by taking the sum of gross receipts and divide that by the total number of transactions.

Gross Receipts is the value of gross sales plus taxes, minus the discounts.

Avg Order Profit: Gross income per ticket, where gross income equals the Net Sales minus Cogs.

Avg sales amount: Total sales amount (gross receipts) completed by the budtender divided by the number of sales completed.

Avg sale time: Total transaction times (from when the ticket opens to the ticket closes) of the budtender’s all sales, divided by the number of sales completed by the budtender.

Avg Transaction Time: Average time spent with the customer building out the basket and completing the sale.

Cashless Payment %: Gross receipts paid via cashless payment method over the total amount of gross receipts over the selected period of time.

Cost of Goods Sold: Cost of goods sold, EXCLUDING excise tax paid to distributors.

Cost of Inventory on Hand: Total of inventory.

Cost Percent: Total cost of goods sold EXCLUDING excise divided by net sales.

Customer Count: Customers are defined as people that complete a transaction. (People that entered the store without purchasing are not counted).

Custom Discounts: Custom discount created by the retailer.

Discount %: Average percent discounted from gross sales amount.

Discount Active Date: What discounts are active on the selected date.

Discount Active Days: Number of consecutive days this discount has been active.

Distinct SKUs Carried: Number of unique SKUs carried.

Gross Income: Gross income made on sales EXCLUDING the excise tax paid to distributors.

Gross Margin: Net sales less the cost of goods sold (COGS).

Gross Margin Percent (Gross Margin %): Margin percentage of net sales EXCLUDING excise taxes paid to distributors.

Gross Receipts: Total amount of revenue generated from this transaction.

Gross Receipts Percent (%): This metric in the Sales Dashboard indicates the percentage of the brands’ sales over the amount of revenue metric of your choice (Gross Receipt, Gross Sales, Net Sales).

Gross Sales: Gross merchandise value of sale items, this does not include discounts, returns, or taxes.

Inventory Turnover Rate: Cost of goods sold over the average amount of inventory during the selected period of time.

Invoice #: This is the same as the Invoice # shown in your SellTreez instance, Reports, Inventory, Invoice Reports.

New Customers: (Discount Analysis) - Customers that purchased for the first time in this location using the selected discount.

New Customer Repeat Rate: New customer repeat is calculated as how many New Customers that have made another transaction after the first date of sales in the same location store.

Net Sales: Gross sales minus returns and discounts.

Order Channel: Order channel is one of the following: delivery, express, in store, pickup.

Payment Utilization %: See which payment types lead to larger order values.

Payment Types: All Payment Types, All Card Payments, Cash or Check, Rewards, Cash, ACH, Debit Card, Credit Card, Cashless ATM, Integrated Pin/Debit, Integrated ATM, Check. [[[ All Payment Types x 2 in the Sales Dashboard ]]]

Parameter: Parameter offers several metrics to choose from as a value shown in the graphs and/or tables. For instance, in the Sales Dashboard, you can select a measure (Gross Receipts, Gross Sales, Net Sales) to analyze the revenue by time, brand, and product type.

Percent Funded (%Funded): Amount of net sales over the total cost of this invoice.

Percent of Units Sellable (% of Units Sellable): Amount of sellable units over the total amount of goods on hand.

Redemptions: Number of tickets completed with the selected discount.

Revenue Source: In store, online order by Iheartjane, or online order by other source.

Sample Inventory: Sample Inventory refers to any product with keywords like sample or promo in the product name. We use keywords to filter the samples out of the regular inventory, and you can find the filtered words below. The same Sample Inventory definition applies to all inventory related dashboards.

PROMO
SAMPLE
*P
*S
DISPLAY
BOGO
DEMO

Sales per Day (Budtender Dashboard): Budtender’s total sales of the month divided by the number of days this employee worked (with at least 1 sales that day).

Sell Through Rate: Total units sold divided by the total units received.

Sellable Location: A location is sellable if it’s marked as sellable in inventory management. A few examples of the common Sellable Locations: Active Sales Floor, Retail Floor, retail, Front of House. Non Sellable Location; You can set the locations non-sellable in your inventory management. A few examples for the non sellable locations include: back of house, quarantine, awaiting transfer, display, vault.

Sellable Units Left: Total amount of the products left that are in the sellable location.

Sellable Velocity: How many units of this product did I sell in the number of days I have it sellable (aka not in the vault, or quarantine, etc.) during this period of time (set in Control). For instance, you have received a new batch of flower product HOUSE WEED delivery from the distributor for 11 days, and there was 1 unsellable day. The sellable days would be 10, and you sold 4 units in this period; hence the Sellable Velocity is 0.4 units.

SKUs Carried: Count the distinct amount of SKUs in your inventory.

Stock-to-Sale Ratio: Average of your inventory value in the given period of time, divided by the gross sales amount in the same given period of time.

  • Average of the inventory value is the sum of your beginning inventory value and the ending inventory, and then divide that sum by 2.

  • The higher the Stock-to-Sale Ratio is, the org is incurring more storage and holding cost.

  • The lower the Stock-to-Sale Ratio is, the org is operating efficiently and has more capitals not tied up in the inventory.

Taxes: Taxes collected on sales.

Terms: (Invoice dashboard) - This is where you can find Cash on Delivery (COD), Net x, and other payment terms information.

Ticket Count: Completed transactions would count towards the ticket count. Abandoned tickets are not included.

Tier Pricing Discounts: Any discounts labeled as Tier in SellTreez, or the discounts named “Tier”, for instance, if your stores implement Gold Tier discount, or Platinum Tier discount, these discounts will be categorized as Tier Discounts.

Total Customer Redemptions: Number of customers that made purchases with the selected discount applied.

Total Discounts: Gross sales value of discounts applied to receipts.

Total Discount Redemptions: Total number of discount used in the transactions

Total Redemptions: Number of transactions (tickets) with the selected discount applied,

Total Returns: Total gross receipt values of returned products.

Total Sales: (Employee total sales in the Budtender Dashboard) - Total gross receipts amount transacted by the selected cashier.

Total Sales Count: Total number of transactions completed by the selected cashier.

Total Transaction: Count of orders.

Total Quantity on Hand: Total number of the product units remaining in all locations.

Units Remaining: On the product/SKU level, how many units do I have on hand (total qty on hand) for that specific product/SKU.

Batch Units Remaining: Example - I have a gummy 100mg SKU, and I split it into multiple batches: batch1, batch2, batch3 - how many units do I have left for each of those batches? You will only see this term when there is a Batch ID associated.

Units Sold: total product units sold.

Did this answer your question?