Reference

Retail data model

Each module maps to source tables from the master data template and unlocks a specific KPI family.

Product Master

Product

PRODUCT_MASTER
  • ·SKU profitability
  • ·Assortment mix
Not loadedDisabled

Sales / POS

Sales

SALES_TRANSACTION
  • ·Net sales
  • ·AOV
  • ·UPT
  • ·Gross margin
  • ·Channel mix
Not loadedDisabled

Inventory Snapshot

Inventory

INVENTORY_DAILY_SNAPSHOT
  • ·Inventory turns
  • ·GMROI
  • ·Dead stock
  • ·Stockout rate
Not loadedDisabled

Purchasing & Suppliers

Procurement

PURCHASE_ORDERSUPPLIER_MASTERGOODS_RECEIPT
  • ·Fill rate
  • ·Lead-time variance
  • ·PPV
  • ·Defect rate
Not loadedDisabled

Pricing & Markdowns

Pricing

PRICE_HISTORY
  • ·Price realization
  • ·Markdown dependency
Not loadedDisabled

Promotions

Promotion

PROMOTION
  • ·Promotion ROI
  • ·Promo lift
  • ·Margin impact
Not loadedDisabled

Finance & Accounting

Finance

FINANCIAL_DAILY_MONTHLY
  • ·EBITDA
  • ·Operating margin
  • ·Working capital
Not loadedDisabled

Budget & Forecast

Finance

BUDGET_FORECAST
  • ·Budget variance
  • ·Forecast accuracy
Not loadedDisabled

Store Network

Store

STORE_LOCATION_MASTER
  • ·Sales per sq ft
  • ·Store benchmarking
Not loadedDisabled

Customer & Loyalty

Customer

CUSTOMER_MASTERCUSTOMER_ACTIVITY
  • ·CLV
  • ·Retention
  • ·Loyalty ROI
Not loadedDisabled

WGS Intelligence

WGS

WGS_KPI_DAILYWGS_SLIPPAGE_SIGNALWGS_SLIPPAGE_OUTCOME
  • ·Slippage exposure
  • ·Loss avoided
  • ·WGS ROI
Not loadedDisabled

Returns & Refunds

Returns / Fraud

RETURN_REFUND
  • ·Return rate
  • ·Refund leakage
  • ·Return fraud
Not loadedDisabled

POS Override / Void

Returns / Fraud

POS_OVERRIDE_VOID
  • ·Override rate
  • ·Void anomalies
Not loadedDisabled

Inventory Adjustments

Inventory

INVENTORY_ADJUSTMENT
  • ·Shrinkage
  • ·Inventory accuracy
Not loadedDisabled

Labor & Scheduling

Labor

EMPLOYEE_MASTERLABOR_SCHEDULE
  • ·Labor cost %
  • ·Sales per labor hour
  • ·Overtime leakage
Not loadedDisabled

Order Fulfillment

Warehouse

ORDER_FULFILLMENT
  • ·Order accuracy
  • ·Cycle time
  • ·Cost per order
Not loadedDisabled

Warehouse Activity

Warehouse

WAREHOUSE_ACTIVITY
  • ·Pick productivity
  • ·Error rate
Not loadedDisabled

Marketing Campaigns

Marketing

MARKETING_CAMPAIGN
  • ·ROMI
  • ·ROAS
  • ·CAC
Not loadedDisabled

Ecommerce Sessions

Ecommerce

ECOMMERCE_SESSION
  • ·Conversion
  • ·Cart abandonment
Not loadedDisabled