kpi
At a glance
COUNT(orders) WHERE current_state IN (2,3,4,5,9,11), windowed on date_add.
| What it measures | COUNT(orders) WHERE current_state IN (2,3,4,5,9,11), windowed on date_add. |
| Format | number |
| Time window | T/7D/30D vsP |
| Alert trigger | drop >20% vsP, driven by sentiment_key: order_count_trend |
| Sensitivity band | trend-based - good when change >= 0%, bad when <= -10% |
| Roles | owner, finance, operations |
| Data type | Native |
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.