Skip to main content
Card class: 🦸 Hero * Category: Customers & Retention * Chart: gauge

​
At a glance

DISTINCT id_customer with >1 paid-state order / DISTINCT id_customer with >=1 paid-state order, over 90D date_add window.
What it measuresDISTINCT id_customer with >1 paid-state order / DISTINCT id_customer with >=1 paid-state order, over 90D date_add window.
Formatpercent
Time window90D
Alert trigger<25% (Tier-1 retention floor), driven by sentiment_key: repeat_rate
Sensitivity bandhigher is better - good at/above 25, bad at/below 10
Rolesowner, marketing, finance
Data typeDerived

​
Calculation

DISTINCT id_customer with >1 paid-state order / DISTINCT id_customer with >=1 paid-state order, over 90D date_add window.
PrestaShop order classification uses the order-state machine: paid = 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.

​
Why it matters

Repeat Customer Rate is part of the PrestaShop executive pulse in Vortex IQ Nerve Centre. Vortex Mind investigates automatically when this card breaches its sensitivity band, and Ask Viq can explain the movement in plain English with a citation back to this card.