Skip to content

Dashboard templates

Retail · Operations

A retailer or store chain that buys ingredients, packaging and goods from suppliers, holds stock in warehouses or stores and runs its own deliveries. P&L by channel plus supplier on-time rate, inventory, stockouts, deliveries and days of inventory versus COGS.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For inventory and purchasing leads at shops and store chains that buy and ship their own stock. The "Inventory vs sales" dashboard shows days of inventory, inventory turnover and purchases as a share of cost of goods sold. The "Purchasing and inventory" and "Warehouse deliveries" dashboards track supplier on-time delivery, fill rate, stockout days, on-time delivery and failed deliveries, while the product dashboard shows which items sell fastest. Needs channel, product, order, order line and inventory snapshot data.

Use this template to

  • Know how many days current stock will last before placing a new order.
  • Cut stockout days for best sellers during sale season.
  • Replace carriers with a high failed delivery rate.

8 ready-made dashboards

Inventory vs sales

Average inventory next to COGS across retail channels; is purchasing outpacing demand?

  • Days of inventory
  • Inventory turnover
  • Purchases to COGS ratio
  • Average inventory value
  • Monthly days of inventory
  • Monthly purchases vs COGS
  • Average inventory by item group

Purchasing and inventory

Purchase orders, supplier on-time and in-full delivery, lead time, average inventory and stockouts.

  • Purchase order value
  • Supplier on-time rate
  • Average inventory value
  • Stockout item-days
  • Results by supplier
  • Average inventory by item group
  • Stockout days by item group
  • Weekly average inventory by warehouse

Warehouse deliveries

Deliveries, on-time and failed delivery rates by warehouse and carrier.

  • Shipments
  • On-time delivery rate
  • Failed delivery rate
  • Failed shipments
  • Delivery results by warehouse
  • Failed delivery rate by carrier
  • Weekly failed delivery rate by warehouse

Profit and loss overview

Actual revenue down to profit after marketplace fees, returns and ads.

  • Net revenue
  • Contribution margin
  • Net profit after fees and ads
  • Net margin
  • From revenue to profit
  • Weekly profit after fees by channel
  • Weekly orders by channel

Sales channels

Compare channels by revenue, fees, return rate, profit and margin.

  • Profit and loss by channel
  • Return rate by channel
  • Profit after fees and ads by channel
  • Cancellation rate by channel
  • Weekly net revenue

Products

SKUs ranked by profit; loss-making SKUs in red; COGS coverage shows which SKUs have no cost yet.

  • Profit by SKU (biggest losses first)
  • Gross profit after fees by category
  • Units sold by SKU
  • Monthly COGS by SKU

Advertising

Spend by platform and campaign, platform-reported ROAS, and the gap between reported and actual revenue by channel.

  • Ad spend
  • Blended ROAS
  • Platform-reported ROAS
  • Ad-reported vs actual revenue gap
  • Ad platform reported vs actual revenue by channel
  • Campaigns
  • Spend by ad platform
  • Monthly platform ROAS by campaign

Data health

Quality test results with row numbers in the Excel file; COGS coverage and unsettled fees.

  • COGS coverage
  • Provisional fee rate
  • Data quality checks
  • COGS coverage by SKU

Ask Si as soon as the build finishes

  • “How did days of inventory change compared with last month?”
  • “What is driving inventory turnover this quarter?”
  • “Show purchases to COGS ratio by month for the last six months.”
  • “Where is average inventory value highest this month, and why?”

37 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Days of inventoryAverage inventory divided by average daily cost of goods sold. With daily inventory snapshots, this equals the sum of snapshot values divided by COGS for the period.= ops_inventory_value_total / Cost of goods soldNumber
Inventory turnoverCost of goods sold in the period divided by average inventory value in the period. Not annualized: for a one-month period it is the monthly turnover.= Cost of goods sold / Average inventory valueNumber
Purchases to COGS ratioValue of purchase orders placed in the period divided by cost of goods sold in the period. Above 1 means buying more than selling (building stock); below 1 means clearing stock.= Purchase order value / Cost of goods soldRatio (%)
Average inventory valueAverage end-of-day inventory value in the period = sum of snapshot values divided by the number of days with a snapshot.= ops_inventory_value_total / ops_snapshot_daysCurrency
Average supplier lead time (days)Average days from order to receipt for purchase orders received in the period.= ops_lead_days_total / Received purchase ordersNumber
Failed delivery rateFailed or returned shipments divided by all outbound shipments in the period.= Failed shipments / ShipmentsRatio (%)
Failed shipmentsOutbound shipments in the period that failed delivery or were returned to the warehouse.Count
On-time delivery rateOn-time deliveries divided by all outbound shipments in the period (by ship date).= ops_on_time_deliveries / ShipmentsRatio (%)
Purchase ordersPurchase orders placed in the period (by order date), excluding cancelled orders.Count
Purchase order valueTotal ordered value (ordered quantity times unit price) of purchase orders placed in the period, excluding cancelled orders.Currency
Received purchase ordersPurchase orders received in the period (by receipt date), including partial receipts.Count
Received goods valueTotal received quantity times unit price for purchase orders received in the period (by receipt date).Currency
ShipmentsOutbound shipments from the warehouse in the period (by ship date), any outcome.Count
Stockout item-daysInventory snapshots with zero (or negative) quantity in the period: each item out of stock at one warehouse on one day counts as 1.Count
Supplier fill rateReceived value divided by ordered value of purchase orders received in the period. 100% means delivered in full; lower means the supplier short-shipped.= Received goods value / ops_closed_po_valueRatio (%)
Supplier on-time rateOn-time PO receipts divided by received purchase orders in the period (by receipt date).= ops_on_time_receipts / Received purchase ordersRatio (%)
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
Cost of goods soldQuantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS.Currency
COGS coverageShare of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_totalRatio (%)
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Net marginProfit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenueRatio (%)
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
Ad-reported vs actual revenue gapAd-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenueCurrency
Provisional fee rateShare of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost)Ratio (%)
Return costReturn shipping cost borne by the shop. Does NOT include refunds to buyers (already deducted in net revenue).Currency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Seller-paid shipping costOutbound shipping cost paid by the shop, allocated to lines by line revenue.Currency
Units soldTotal quantity of products in the order lines of valid orders.Count

Data you need

Required

channel, product, order, order_line, ops_inventory_snapshot

Add if you have it (unlocks more metrics)

product_cost, customer, cost, return, ad_performance_daily, ops_supplier, ops_item, ops_purchase_order, ops_purchase_order_line, ops_shipment

Available variants: F&B restaurant chain (demo)

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: channel, product, order, order_line, ops_inventory_snapshot.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 8 dashboards and 37 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Retail · Operations with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes