gauge
At a glance
COUNT(orders WHERE current_state IN (4,5)) / COUNT(orders in paid states 2,3,4,5,9,11) over date_add window.
| What it measures | COUNT(orders WHERE current_state IN (4,5)) / COUNT(orders in paid states 2,3,4,5,9,11) over date_add window. |
| Format | percent |
| Time window | 30D vsP |
| Alert trigger | <92% (industry baseline), driven by sentiment_key: fulfillment_rate |
| Sensitivity band | higher is better - good at/above 95, bad at/below 90 |
| Roles | owner, operations |
| Data type | API-derived |
Calculation
current_state in (2 Payment accepted, 3 Processing, 4 Shipped, 5 Delivered, 9 Backorder paid, 11 Remote payment accepted); shipped/fulfilled = (4, 5); refunded = (7, 15); cancelled = (6); payment error = (8). Read live from the PrestaShop Webservice API and snapshotted nightly into the Nerve Centre KPI store.