G3N Common Contract

Appearance

KPI Dictionary (Formulas and Alert Defaults) ​

This page defines formal KPI formulas, inclusion and exclusion rules, and default alert thresholds. Defaults are org-level policy settings and can be overridden by org or facility policies.

Notation and scope ​

  • All KPIs are facility-first; org-wide values are rollups.
  • Time buckets are configurable (hourly, daily, weekly, monthly, seasonal).
  • Unless noted, KPI thresholds are evaluated per facility and channel.
  • "Submitted" means an order, PO, or request that has passed approval gates.
  • "Cancelled" means fully voided and not fulfilled.
  • "Firmed" means a transaction that has posted and is immutable.

Profile selection and precedence ​

  • Each org selects a vertical profile (grocery, apparel, hardgoods) and a channel profile (ecom, wholesale, POS).
  • Vertical and channel defaults override the baseline thresholds; if both apply, use the stricter threshold.
  • If a KPI does not apply to a channel, do not evaluate it for that channel.
  • All thresholds are policy values and can be overridden per org or facility.

Seasonal and regional modifiers (applied after base profiles) ​

  • Seasonal and regional profiles apply as percentage adjustments to thresholds.
  • If multiple modifiers apply, use the stricter adjustment unless policy overrides.

Seasonal defaults:

  • Peak/holiday: tighten availability and SLA thresholds by 20% and stockout/backorder thresholds by 30%; relax lead-time variance thresholds by 10%.
  • Clearance: relax discount depth and realized price thresholds by 20% and tighten aging inventory exposure thresholds by 20%.
  • Back-to-school: tighten stockout and on-time thresholds by 15%.
  • Off-peak: use baseline thresholds.

Regional defaults:

  • Urban/dense: tighten SLA and order cycle time thresholds by 15%; tighten stockout thresholds by 10%.
  • Rural/remote: relax lead-time variance thresholds by 20% and on-time thresholds by 5%.
  • Cold-chain/hot-climate: tighten FEFO compliance thresholds by 2 points and tighten aging exposure thresholds by 20%.
  • Cross-border/regulatory: tighten tax variance thresholds by 25% and relax settlement lag thresholds by 20%.

Inventory and warehouse (ICS) ​

Stockout rate ​

  • Formula: stockout_order_lines / total_order_lines.
  • Include: submitted order lines that require inventory.
  • Exclude: cancelled orders, special orders that are procure-to-order.
  • Default alert: warn >2% over 24h; critical >5% over 24h.
  • Vertical defaults: Grocery warn >1% / critical >3%; Apparel warn >2.5% / critical >6%; Hardgoods warn >1.5% / critical >4%.
  • Channel defaults: Ecom warn >2% / critical >5%; Wholesale warn >3% / critical >7%; POS warn >1.5% / critical >4%.

Fill rate (line) ​

  • Formula: fulfilled_lines / submitted_lines.
  • Include: submitted order lines (including backorders once promised).
  • Exclude: cancelled lines, customer-initiated cancellations.
  • Default alert: warn <97% over 7d; critical <94% over 7d.
  • Vertical defaults: Grocery warn <98.5% / critical <96.5%; Apparel warn <97% / critical <94%; Hardgoods warn <96% / critical <92%.
  • Channel defaults: Ecom warn <97% / critical <94%; Wholesale warn <95% / critical <90%; POS warn <98% / critical <96%.

Inventory accuracy (count variance) ​

  • Formula: abs(counted_qty - recorded_qty) / recorded_qty.
  • Include: cycle counts and full physical counts.
  • Exclude: counts flagged as training or test runs.
  • Default alert: warn >1% over 30d; critical >3% over 30d.
  • Vertical defaults: Grocery warn >1.5% / critical >3.5%; Apparel warn >1% / critical >2.5%; Hardgoods warn >0.7% / critical >2%.
  • Channel defaults: Ecom warn >1% / critical >3%; Wholesale warn >1.2% / critical >3.5%; POS warn >0.8% / critical >2.5%.

Shrink rate ​

  • Formula: shrink_qty / (receipts_qty + adjustments_qty).
  • Include: damage, loss, and unexplained adjustments.
  • Exclude: approved disposals tied to returns or refurbishment.
  • Default alert: warn >0.5% over 30d; critical >1.5% over 30d.
  • Vertical defaults: Grocery warn >0.8% / critical >2%; Apparel warn >0.4% / critical >1.2%; Hardgoods warn >0.3% / critical >0.9%.
  • Channel defaults: Ecom warn >0.4% / critical >1.2%; Wholesale warn >0.5% / critical >1.5%; POS warn >0.6% / critical >1.8%.

Receiving cycle time ​

  • Formula: avg(receive_complete_time - receipt_start_time).
  • Include: receipts with complete timestamps.
  • Exclude: receipts in QC hold without release.
  • Default alert: warn p95 >4h over 7d; critical p95 >12h over 7d.
  • Vertical defaults: Grocery warn p95 >2h / critical >6h; Apparel warn p95 >6h / critical >18h; Hardgoods warn p95 >8h / critical >24h.
  • Channel defaults: Ecom warn p95 >4h / critical >12h; Wholesale warn p95 >6h / critical >18h; POS warn p95 >3h / critical >9h.

Putaway cycle time ​

  • Formula: avg(putaway_complete_time - receipt_complete_time).
  • Include: receipts with putaway events.
  • Exclude: quarantine holds and exceptions.
  • Default alert: warn p95 >6h over 7d; critical p95 >24h over 7d.
  • Vertical defaults: Grocery warn p95 >4h / critical >12h; Apparel warn p95 >8h / critical >24h; Hardgoods warn p95 >12h / critical >36h.
  • Channel defaults: Ecom warn p95 >6h / critical >24h; Wholesale warn p95 >8h / critical >24h; POS warn p95 >5h / critical >20h.

Pick accuracy ​

  • Formula: correct_picks / total_picks.
  • Include: picks that reached pack or ship.
  • Exclude: picks cancelled before pack.
  • Default alert: warn <99.5% over 7d; critical <98.5% over 7d.
  • Vertical defaults: Grocery warn <99.7% / critical <99%; Apparel warn <99.5% / critical <98.5%; Hardgoods warn <99.3% / critical <98%.
  • Channel defaults: Ecom warn <99.5% / critical <98.5%; Wholesale warn <99% / critical <98%; POS warn <99.7% / critical <99%.

Transfer on-time rate ​

  • Formula: on_time_transfers / total_transfers.
  • Include: completed transfers with target ETA.
  • Exclude: transfers cancelled before shipment.
  • Default alert: warn <95% over 30d; critical <90% over 30d.
  • Vertical defaults: Grocery warn <97% / critical <93%; Apparel warn <95% / critical <90%; Hardgoods warn <92% / critical <88%.
  • Channel defaults: Ecom warn <95% / critical <90%; Wholesale warn <93% / critical <88%; POS warn <96% / critical <92%.

Transfer lead time variance ​

  • Formula: abs(actual_lead_time - planned_lead_time) / planned_lead_time.
  • Include: completed transfers.
  • Exclude: transfers with force majeure exceptions.
  • Default alert: warn >20% over 30d; critical >35% over 30d.
  • Vertical defaults: Grocery warn >15% / critical >25%; Apparel warn >20% / critical >35%; Hardgoods warn >25% / critical >40%.
  • Channel defaults: Ecom warn >20% / critical >35%; Wholesale warn >25% / critical >40%; POS warn >18% / critical >30%.

Aging inventory exposure ​

  • Formula: units_older_than_threshold / total_units.
  • Include: on-hand units with age metadata.
  • Exclude: consignment-held unless owned by the org.
  • Default alert: warn >15% over 30d; critical >30% over 30d.
  • Vertical defaults: Grocery warn >8% / critical >15%; Apparel warn >25% / critical >40%; Hardgoods warn >20% / critical >35%.
  • Channel defaults: Ecom warn >15% / critical >30%; Wholesale warn >20% / critical >35%; POS warn >12% / critical >25%.

FEFO compliance ​

  • Formula: FEFO_compliant_picks / total_expiry_sensitive_picks.
  • Include: expiry-sensitive items.
  • Exclude: items without expiry data.
  • Default alert: warn <98% over 30d; critical <95% over 30d.
  • Vertical defaults: Grocery warn <99% / critical <97%; Apparel warn <98% / critical <95%; Hardgoods warn <97% / critical <94%.
  • Channel defaults: Ecom warn <98% / critical <95%; Wholesale warn <97% / critical <94%; POS warn <99% / critical <97%.

Sales and fulfillment (SCM) ​

Net sales ​

  • Formula: gross_sales - discounts - refunds.
  • Include: submitted orders and completed refunds.
  • Exclude: cancelled orders and voided payments.
  • Default alert: warn drop >15% vs trailing 4-week average; critical drop >25%.
  • Vertical defaults: Grocery warn drop >8% / critical >15%; Apparel warn drop >20% / critical >30%; Hardgoods warn drop >15% / critical >25%.
  • Channel defaults: Ecom warn drop >18% / critical >28%; Wholesale warn drop >25% / critical >35%; POS warn drop >10% / critical >20%.

Average order value (AOV) ​

  • Formula: net_sales / total_orders.
  • Include: submitted orders.
  • Exclude: cancelled orders.
  • Default alert: warn drop >15% vs trailing 4-week median; critical drop >25%.
  • Vertical defaults: Grocery warn drop >8% / critical >15%; Apparel warn drop >20% / critical >30%; Hardgoods warn drop >15% / critical >25%.
  • Channel defaults: Ecom warn drop >20% / critical >30%; Wholesale warn drop >25% / critical >35%; POS warn drop >10% / critical >20%.

Order cycle time ​

  • Formula: ship_time - order_submit_time.
  • Include: shipped or fulfilled orders.
  • Exclude: pickup-only orders if ship_time is not applicable.
  • Default alert: warn p95 >12h over 7d; critical p95 >24h over 7d.
  • Vertical defaults: Grocery warn p95 >6h / critical >12h; Apparel warn p95 >12h / critical >24h; Hardgoods warn p95 >18h / critical >36h.
  • Channel defaults: Ecom warn p95 >12h / critical >24h; Wholesale warn p95 >24h / critical >48h; POS warn p95 >1h / critical >3h.

On-time ship rate ​

  • Formula: on_time_shipments / total_shipments.
  • Include: shipped orders with promised ship date.
  • Exclude: customer-requested delays.
  • Default alert: warn <95% over 7d; critical <90% over 7d.
  • Vertical defaults: Grocery warn <97% / critical <93%; Apparel warn <95% / critical <90%; Hardgoods warn <94% / critical <88%.
  • Channel defaults: Ecom warn <95% / critical <90%; Wholesale warn <90% / critical <85%; POS warn <99% / critical <97%.

Cancellation rate ​

  • Formula: cancelled_orders / submitted_orders.
  • Include: cancelled orders with reason code.
  • Exclude: fraud-cancelled orders reversed before submission.
  • Default alert: warn >2% over 7d; critical >5% over 7d.
  • Vertical defaults: Grocery warn >1% / critical >3%; Apparel warn >3% / critical >6%; Hardgoods warn >2% / critical >4%.
  • Channel defaults: Ecom warn >3% / critical >6%; Wholesale warn >1% / critical >3%; POS warn >0.5% / critical >1.5%.

Return rate ​

  • Formula: returned_units / sold_units.
  • Include: completed returns.
  • Exclude: warranty repairs without inventory return.
  • Default alert: warn >8% over 30d; critical >15% over 30d.
  • Vertical defaults: Grocery warn >3% / critical >6%; Apparel warn >12% / critical >20%; Hardgoods warn >6% / critical >12%.
  • Channel defaults: Ecom warn >12% / critical >20%; Wholesale warn >4% / critical >8%; POS warn >5% / critical >10%.

Refund leakage ​

  • Formula: (refund_amount - expected_refund_amount) / expected_refund_amount.
  • Include: refunds with original order reference.
  • Exclude: goodwill credits explicitly flagged.
  • Default alert: warn >1% over 30d; critical >3% over 30d.
  • Vertical defaults: Grocery warn >1% / critical >2%; Apparel warn >1.5% / critical >3.5%; Hardgoods warn >1% / critical >3%.
  • Channel defaults: Ecom warn >1.5% / critical >3.5%; Wholesale warn >0.8% / critical >2.5%; POS warn >1% / critical >3%.

Substitution rate ​

  • Formula: substituted_lines / fulfilled_lines.
  • Include: fulfilled orders with substitutions.
  • Exclude: customer-requested replacements pre-fulfillment.
  • Default alert: warn >5% over 7d; critical >10% over 7d.
  • Vertical defaults: Grocery warn >8% / critical >15%; Apparel warn >3% / critical >6%; Hardgoods warn >4% / critical >8%.
  • Channel defaults: Ecom warn >2% / critical >5%; Wholesale warn >3% / critical >6%; POS warn >8% / critical >15%.

BOPIS no-show rate ​

  • Formula: no_show_orders / pickup_orders.
  • Include: pickup orders with window expiry.
  • Exclude: customer-cancelled orders prior to window end.
  • Default alert: warn >5% over 30d; critical >10% over 30d.
  • Vertical defaults: Grocery warn >3% / critical >6%; Apparel warn >6% / critical >12%; Hardgoods warn >4% / critical >8%.
  • Channel defaults: Ecom warn >5% / critical >10%; Wholesale use default only when pickup is enabled; POS use default only when pickup flows exist.

Backorder rate ​

  • Formula: backorder_lines / submitted_lines.
  • Include: submitted order lines.
  • Exclude: special orders and preorders.
  • Default alert: warn >5% over 7d; critical >10% over 7d.
  • Vertical defaults: Grocery warn >2% / critical >5%; Apparel warn >6% / critical >12%; Hardgoods warn >4% / critical >8%.
  • Channel defaults: Ecom warn >6% / critical >12%; Wholesale warn >3% / critical >7%; POS warn >2% / critical >5%.

Conversion rate (channel) ​

  • Formula: orders / visits.
  • Include: channels that provide traffic or visit counts.
  • Exclude: channels without traffic measurement.
  • Default alert: warn drop >15% vs trailing 4-week average; critical drop >25%.
  • Vertical defaults: Grocery warn drop >10% / critical >18%; Apparel warn drop >20% / critical >30%; Hardgoods warn drop >15% / critical >25%.
  • Channel defaults: Ecom warn drop >18% / critical >28%; Wholesale warn drop >25% / critical >35%; POS warn drop >10% / critical >20%.

Pricing and promotions (PPM) ​

Realized price index ​

  • Formula: net_unit_price / list_unit_price.
  • Include: sales with list and net price captured.
  • Exclude: clearance or liquidation channels if excluded by policy.
  • Default alert: warn <85% over 30d; critical <70% over 30d.
  • Vertical defaults: Grocery warn <90% / critical <80%; Apparel warn <80% / critical <65%; Hardgoods warn <85% / critical <70%.
  • Channel defaults: Ecom warn <85% / critical <70%; Wholesale warn <80% / critical <65%; POS warn <90% / critical <80%.

Discount depth ​

  • Formula: discount_amount / list_price_amount.
  • Include: discount-bearing sales.
  • Exclude: zero-discount sales.
  • Default alert: warn >20% outside active promos over 30d; critical >35%.
  • Vertical defaults: Grocery warn >15% / critical >25%; Apparel warn >30% / critical >45%; Hardgoods warn >20% / critical >35%.
  • Channel defaults: Ecom warn >25% / critical >40%; Wholesale warn >30% / critical >45%; POS warn >15% / critical >25%.

Promo lift ​

  • Formula: promo_sales / baseline_sales - 1.
  • Include: sales during promo windows.
  • Exclude: SKUs without baseline history.
  • Default alert: warn lift <5% for a campaign; critical lift <0%.
  • Vertical defaults: Grocery warn ❤️% / critical <0%; Apparel warn <8% / critical <0%; Hardgoods warn <5% / critical <0%.
  • Channel defaults: Ecom warn <5% / critical <0%; Wholesale warn ❤️% / critical <0%; POS warn <4% / critical <0%.

Markdown effectiveness ​

  • Formula: sell_through_after_markdown / sell_through_before.
  • Include: markdown campaigns with measured periods.
  • Exclude: new items without pre-markdown baseline.
  • Default alert: warn <20% over 30d; critical <10% over 30d.
  • Vertical defaults: Grocery warn <15% / critical <5%; Apparel warn <25% / critical <15%; Hardgoods warn <20% / critical <10%.
  • Channel defaults: Ecom warn <20% / critical <10%; Wholesale warn <15% / critical <5%; POS warn <20% / critical <10%.

Price override rate ​

  • Formula: override_transactions / total_transactions.
  • Include: transactions with manual override.
  • Exclude: approved automated price rules.
  • Default alert: warn >2% over 7d; critical >5% over 7d.
  • Vertical defaults: Grocery warn >1.5% / critical >4%; Apparel warn >3% / critical >6%; Hardgoods warn >2% / critical >5%.
  • Channel defaults: Ecom warn >2% / critical >5%; Wholesale warn >4% / critical >8%; POS warn >1% / critical >3%.

Price compliance (min price) ​

  • Formula: out_of_policy_sales / total_sales.
  • Include: sales with min price policies.
  • Exclude: categories with approved exceptions.
  • Default alert: warn >0.5% over 7d; critical >2% over 7d.
  • Vertical defaults: Grocery warn >0.3% / critical >1%; Apparel warn >0.7% / critical >2.5%; Hardgoods warn >0.5% / critical >2%.
  • Channel defaults: Ecom warn >0.5% / critical >2%; Wholesale warn >1% / critical >3%; POS warn >0.3% / critical >1%.

Surge pricing activation rate ​

  • Formula: surge_price_transactions / total_transactions.
  • Include: transactions with surge pricing applied.
  • Exclude: categories excluded by policy.
  • Default alert: warn >5% over 24h; critical >10% over 24h.
  • Vertical defaults: Grocery warn >2% / critical >5%; Apparel warn >6% / critical >12%; Hardgoods warn >5% / critical >10%.
  • Channel defaults: Ecom warn >5% / critical >10%; Wholesale warn >2% / critical >5%; POS warn >3% / critical >6%.

Coupon redemption rate ​

  • Formula: coupon_redemptions / eligible_orders.
  • Include: orders eligible for coupon use.
  • Exclude: orders in excluded categories.
  • Default alert: warn >2x or <0.5x trailing 8-week average.
  • Vertical defaults: Grocery warn >1.5x or <0.7x; Apparel warn >2.5x or <0.4x; Hardgoods warn >2x or <0.5x.
  • Channel defaults: Ecom warn >2x or <0.5x; Wholesale warn >1.5x or <0.7x; POS warn >1.8x or <0.6x.

Procurement (PCM) ​

OTB utilization ​

  • Formula: receipts_cost / OTB_budget.
  • Include: receipts within the time bucket.
  • Exclude: consignment receipts if excluded by policy.
  • Default alert: warn >95% with >2 weeks remaining; critical >105%.
  • Vertical defaults: Grocery warn >90% / critical >100%; Apparel warn >95% / critical >105%; Hardgoods warn >97% / critical >110%.
  • Channel defaults: Ecom warn >95% / critical >105%; Wholesale warn >90% / critical >100%; POS warn >95% / critical >105%.

Vendor lead time variance ​

  • Formula: abs(actual_lead_time - agreed_lead_time) / agreed_lead_time.
  • Include: completed POs with agreed lead time.
  • Exclude: POs with approved delay exceptions.
  • Default alert: warn >20% over 30d; critical >35% over 30d.
  • Vertical defaults: Grocery warn >15% / critical >25%; Apparel warn >25% / critical >40%; Hardgoods warn >20% / critical >35%.
  • Channel defaults: Ecom warn >20% / critical >35%; Wholesale warn >25% / critical >40%; POS warn >20% / critical >35%.

Vendor fill rate ​

  • Formula: received_qty / ordered_qty.
  • Include: completed or closed POs.
  • Exclude: POs cancelled before shipment.
  • Default alert: warn <95% over 30d; critical <90% over 30d.
  • Vertical defaults: Grocery warn <97% / critical <93%; Apparel warn <95% / critical <90%; Hardgoods warn <94% / critical <88%.
  • Channel defaults: Ecom warn <95% / critical <90%; Wholesale warn <93% / critical <88%; POS warn <96% / critical <92%.

PO cycle time ​

  • Formula: receipt_complete_time - PO_issued_time.
  • Include: POs with receipts.
  • Exclude: POs for services or non-inventory items.
  • Default alert: warn p95 >10d over 30d; critical p95 >20d over 30d.
  • Vertical defaults: Grocery warn p95 >7d / critical >14d; Apparel warn p95 >14d / critical >28d; Hardgoods warn p95 >12d / critical >24d.
  • Channel defaults: Ecom warn p95 >10d / critical >20d; Wholesale warn p95 >14d / critical >30d; POS warn p95 >8d / critical >16d.

Invoice match rate ​

  • Formula: matched_invoices / total_invoices.
  • Include: invoices eligible for matching.
  • Exclude: invoices under dispute hold.
  • Default alert: warn <97% over 30d; critical <94% over 30d.
  • Vertical defaults: Grocery warn <98% / critical <95%; Apparel warn <97% / critical <94%; Hardgoods warn <96% / critical <93%.
  • Channel defaults: Ecom warn <97% / critical <94%; Wholesale warn <96% / critical <93%; POS warn <97% / critical <94%.

Landed cost variance ​

  • Formula: (actual_landed_cost - planned_landed_cost) / planned_landed_cost.
  • Include: receipts with landed cost details.
  • Exclude: items without planned cost.
  • Default alert: warn >5% over 30d; critical >10% over 30d.
  • Vertical defaults: Grocery warn >4% / critical >8%; Apparel warn >6% / critical >12%; Hardgoods warn >5% / critical >10%.
  • Channel defaults: Ecom warn >5% / critical >10%; Wholesale warn >6% / critical >12%; POS warn >5% / critical >10%.

RTV rate ​

  • Formula: RTV_qty / received_qty.
  • Include: returns to vendor.
  • Exclude: customer returns not sent to vendor.
  • Default alert: warn >3% over 30d; critical >7% over 30d.
  • Vertical defaults: Grocery warn >4% / critical >9%; Apparel warn >3% / critical >7%; Hardgoods warn >2% / critical >5%.
  • Channel defaults: Ecom warn >3% / critical >7%; Wholesale warn >2% / critical >5%; POS warn >4% / critical >9%.

On-time delivery rate ​

  • Formula: on_time_POs / total_POs.
  • Include: completed POs with promised dates.
  • Exclude: POs with approved exceptions.
  • Default alert: warn <95% over 30d; critical <90% over 30d.
  • Vertical defaults: Grocery warn <97% / critical <93%; Apparel warn <95% / critical <90%; Hardgoods warn <93% / critical <88%.
  • Channel defaults: Ecom warn <95% / critical <90%; Wholesale warn <93% / critical <88%; POS warn <96% / critical <92%.

ASN accuracy ​

  • Formula: accurate_ASNs / total_ASNs.
  • Include: POs with ASNs.
  • Exclude: POs without ASN requirement.
  • Default alert: warn <98% over 30d; critical <95% over 30d.
  • Vertical defaults: Grocery warn <98.5% / critical <96%; Apparel warn <98% / critical <95%; Hardgoods warn <97% / critical <94%.
  • Channel defaults: Ecom warn <98% / critical <95%; Wholesale warn <97% / critical <94%; POS warn <98.5% / critical <96%.

CRM and loyalty ​

Active customer rate ​

  • Formula: active_customers / total_customers.
  • Include: customers with a purchase in last 12 months.
  • Exclude: suspended or merged customer records.
  • Default alert: warn drop >10% vs trailing 12-month average; critical drop >20%.
  • Vertical defaults: Grocery warn drop >8% / critical >15%; Apparel warn drop >12% / critical >20%; Hardgoods warn drop >10% / critical >18%.
  • Channel defaults: Ecom warn drop >12% / critical >20%; Wholesale warn drop >15% / critical >25%; POS warn drop >10% / critical >18%.

Retention rate ​

  • Formula: returning_customers / prior_period_customers.
  • Include: customers eligible for the period.
  • Exclude: new customers in the period.
  • Default alert: warn drop >10% vs trailing 12-month average; critical drop >20%.
  • Vertical defaults: Grocery warn drop >8% / critical >15%; Apparel warn drop >12% / critical >20%; Hardgoods warn drop >10% / critical >18%.
  • Channel defaults: Ecom warn drop >12% / critical >20%; Wholesale warn drop >15% / critical >25%; POS warn drop >10% / critical >18%.

Repeat rate ​

  • Formula: customers_with_2_plus_orders / customers_with_1_plus_orders.
  • Include: submitted orders.
  • Exclude: wholesale accounts if excluded by policy.
  • Default alert: warn drop >10% vs trailing 12-month average; critical drop >20%.
  • Vertical defaults: Grocery warn drop >8% / critical >15%; Apparel warn drop >12% / critical >20%; Hardgoods warn drop >10% / critical >18%.
  • Channel defaults: Ecom warn drop >12% / critical >20%; Wholesale warn drop >15% / critical >25%; POS warn drop >10% / critical >18%.

Loyalty liability ​

  • Formula: points_outstanding * point_value.
  • Include: unexpired points.
  • Exclude: expired or reversed points.
  • Default alert: warn growth >20% month-over-month; critical >35%.
  • Vertical defaults: Grocery warn growth >25% / critical >45%; Apparel warn growth >20% / critical >35%; Hardgoods warn growth >15% / critical >30%.
  • Channel defaults: Ecom warn growth >20% / critical >35%; Wholesale warn growth >10% / critical >20%; POS warn growth >25% / critical >40%.

Earn vs redeem ratio ​

  • Formula: points_earned / points_redeemed.
  • Include: posted loyalty events.
  • Exclude: reversed events.
  • Default alert: warn ratio <0.9 over 60d; critical <0.75 over 60d.
  • Vertical defaults: Grocery warn <0.85 / critical <0.7; Apparel warn <0.9 / critical <0.75; Hardgoods warn <0.92 / critical <0.8.
  • Channel defaults: Ecom warn <0.9 / critical <0.75; Wholesale warn <0.95 / critical <0.85; POS warn <0.85 / critical <0.7.

Breakage rate ​

  • Formula: expired_points / points_earned.
  • Include: expirations within the period.
  • Exclude: points revoked for fraud.
  • Default alert: warn >20% over 12 months; critical >30% over 12 months.
  • Vertical defaults: Grocery warn >15% / critical >25%; Apparel warn >25% / critical >35%; Hardgoods warn >20% / critical >30%.
  • Channel defaults: Ecom warn >20% / critical >30%; Wholesale warn >15% / critical >25%; POS warn >20% / critical >30%.

Gift card liability aging ​

  • Formula: liability_aged_over_12_months / total_gift_card_liability.
  • Include: outstanding gift card balances.
  • Exclude: zero-balance cards.
  • Default alert: warn >30% over 30d; critical >50% over 30d.
  • Vertical defaults: Grocery warn >25% / critical >45%; Apparel warn >35% / critical >55%; Hardgoods warn >30% / critical >50%.
  • Channel defaults: Ecom warn >35% / critical >55%; Wholesale warn >20% / critical >40%; POS warn >25% / critical >45%.
  • Formula: customers_with_consent / total_customers.
  • Include: customers with explicit consent state.
  • Exclude: inactive customers.
  • Default alert: warn <95% over 30d; critical <90% over 30d.
  • Vertical defaults: Grocery warn <96% / critical <92%; Apparel warn <95% / critical <90%; Hardgoods warn <95% / critical <90%.
  • Channel defaults: Ecom warn <95% / critical <90%; Wholesale warn <92% / critical <88%; POS warn <96% / critical <92%.

Influencer and affiliate ​

Attributed revenue ​

  • Formula: attributed_net_sales / total_net_sales.
  • Include: orders with valid attribution.
  • Exclude: orders outside attribution window.
  • Default alert: warn drop >20% vs trailing 8-week average; critical drop >35%.
  • Vertical defaults: Grocery warn drop >15% / critical >25%; Apparel warn drop >20% / critical >35%; Hardgoods warn drop >18% / critical >30%.
  • Channel defaults: Ecom warn drop >20% / critical >35%; Wholesale warn drop >25% / critical >40%; POS warn drop >15% / critical >25%.

Assisted conversion rate ​

  • Formula: attributed_orders / eligible_orders.
  • Include: orders in channels with attribution enabled.
  • Exclude: channels without attribution instrumentation.
  • Default alert: warn drop >20% vs trailing 8-week average; critical drop >35%.
  • Vertical defaults: Grocery warn drop >15% / critical >25%; Apparel warn drop >20% / critical >35%; Hardgoods warn drop >18% / critical >30%.
  • Channel defaults: Ecom warn drop >20% / critical >35%; Wholesale warn drop >25% / critical >40%; POS warn drop >15% / critical >25%.

Hold rate ​

  • Formula: held_earnings / total_earnings.
  • Include: earnings in pending or held states.
  • Exclude: paid earnings.
  • Default alert: warn >40% over 30d; critical >60% over 30d.
  • Vertical defaults: Grocery warn >35% / critical >55%; Apparel warn >40% / critical >60%; Hardgoods warn >45% / critical >65%.
  • Channel defaults: Ecom warn >40% / critical >60%; Wholesale warn >45% / critical >65%; POS warn >35% / critical >55%.

Clawback rate ​

  • Formula: clawback_amount / total_earnings.
  • Include: clawbacks tied to returns or fraud.
  • Exclude: manual corrections.
  • Default alert: warn >5% over 30d; critical >10% over 30d.
  • Vertical defaults: Grocery warn >4% / critical >8%; Apparel warn >6% / critical >12%; Hardgoods warn >5% / critical >10%.
  • Channel defaults: Ecom warn >6% / critical >12%; Wholesale warn >4% / critical >8%; POS warn >5% / critical >10%.

Payout cycle time ​

  • Formula: payout_time - payable_time.
  • Include: payouts that reached paid state.
  • Exclude: payouts on manual hold.
  • Default alert: warn p95 >7d over 30d; critical p95 >14d over 30d.
  • Vertical defaults: Grocery warn p95 >7d / critical >14d; Apparel warn p95 >7d / critical >14d; Hardgoods warn p95 >7d / critical >14d.
  • Channel defaults: Ecom warn p95 >7d / critical >14d; Wholesale warn p95 >10d / critical >20d; POS warn p95 >7d / critical >14d.

ROI by campaign ​

  • Formula: attributed_margin / campaign_cost.
  • Include: campaigns with cost tracked.
  • Exclude: campaigns without cost tracking.
  • Default alert: warn ROI <1.2 over 30d; critical ROI <1.0 over 30d.
  • Vertical defaults: Grocery warn <1.1 / critical <0.9; Apparel warn <1.2 / critical <1.0; Hardgoods warn <1.15 / critical <0.95.
  • Channel defaults: Ecom warn <1.2 / critical <1.0; Wholesale warn <1.1 / critical <0.9; POS warn <1.15 / critical <0.95.

Fraud flag rate ​

  • Formula: flagged_attributions / total_attributions.
  • Include: attributions with fraud rules enabled.
  • Exclude: manual test campaigns.
  • Default alert: warn >2% over 30d; critical >5% over 30d.
  • Vertical defaults: Grocery warn >2% / critical >4%; Apparel warn >2% / critical >5%; Hardgoods warn >2% / critical >5%.
  • Channel defaults: Ecom warn >3% / critical >6%; Wholesale warn >1% / critical >3%; POS warn >2% / critical >4%.

Discount code utilization ​

  • Formula: influencer_code_orders / total_orders.
  • Include: orders in channels with influencer codes.
  • Exclude: channels without code support.
  • Default alert: warn >3x or <0.5x trailing 8-week average.
  • Vertical defaults: Grocery warn >2x or <0.7x; Apparel warn >3x or <0.5x; Hardgoods warn >2.5x or <0.6x.
  • Channel defaults: Ecom warn >3x or <0.5x; Wholesale warn >2x or <0.7x; POS warn >2.5x or <0.6x.

Accounting readiness ​

Reconciliation coverage ​

  • Formula: events_with_source_reference / total_financial_events.
  • Include: sales, refunds, inventory, procurement, loyalty, influencer events.
  • Exclude: legacy events missing source references.
  • Default alert: warn <99% over 30d; critical <97% over 30d.
  • Vertical defaults: Grocery warn <99.5% / critical <98.5%; Apparel warn <99% / critical <97%; Hardgoods warn <99% / critical <97%.
  • Channel defaults: Ecom warn <99% / critical <97%; Wholesale warn <98% / critical <96%; POS warn <99.5% / critical <98.5%.

Export exception rate ​

  • Formula: export_errors / export_attempts.
  • Include: export runs with status.
  • Exclude: manual dry runs.
  • Default alert: warn >0.5% over 30d; critical >2% over 30d.
  • Vertical defaults: Grocery warn >0.5% / critical >2%; Apparel warn >0.7% / critical >2.5%; Hardgoods warn >0.5% / critical >2%.
  • Channel defaults: Ecom warn >0.5% / critical >2%; Wholesale warn >0.7% / critical >2.5%; POS warn >0.5% / critical >2%.

Settlement lag ​

  • Formula: settlement_complete_time - settlement_due_time.
  • Include: completed settlements.
  • Exclude: settlements on approved hold.
  • Default alert: warn p95 >2d over 30d; critical p95 >5d over 30d.
  • Vertical defaults: Grocery warn p95 >1d / critical >3d; Apparel warn p95 >2d / critical >5d; Hardgoods warn p95 >2d / critical >5d.
  • Channel defaults: Ecom warn p95 >2d / critical >5d; Wholesale warn p95 >5d / critical >10d; POS warn p95 >1d / critical >3d.

COGS variance ​

  • Formula: (actual_COGS - planned_COGS) / planned_COGS.
  • Include: periods with planned COGS.
  • Exclude: periods without plan.
  • Default alert: warn >5% over 30d; critical >10% over 30d.
  • Vertical defaults: Grocery warn >4% / critical >8%; Apparel warn >6% / critical >12%; Hardgoods warn >5% / critical >10%.
  • Channel defaults: Ecom warn >5% / critical >10%; Wholesale warn >6% / critical >12%; POS warn >4% / critical >8%.

Tax variance ​

  • Formula: abs(tax_collected - tax_expected) / tax_expected.
  • Include: jurisdictions with configured tax rules.
  • Exclude: tax-exempt orders.
  • Default alert: warn >1% over 30d; critical >3% over 30d.
  • Vertical defaults: Grocery warn >0.5% / critical >1.5%; Apparel warn >1% / critical >3%; Hardgoods warn >1% / critical >3%.
  • Channel defaults: Ecom warn >1% / critical >3%; Wholesale warn >0.5% / critical >1.5%; POS warn >0.5% / critical >1.5%.

Liability balance delta ​

  • Formula: abs(actual_liability - expected_liability) / expected_liability.
  • Include: gift cards, store credits, loyalty, influencer payouts.
  • Exclude: liabilities under dispute or manual hold.
  • Default alert: warn >5% over 30d; critical >10% over 30d.
  • Vertical defaults: Grocery warn >6% / critical >12%; Apparel warn >5% / critical >10%; Hardgoods warn >4% / critical >8%.
  • Channel defaults: Ecom warn >6% / critical >12%; Wholesale warn >4% / critical >8%; POS warn >5% / critical >10%.