Spike in negative customer signals (refund reasons, low ratings, support escalations). Brand-health canary.
At a glance
A 24-hour rolling count of negative customer signals: refund reasons containing complaint keywords, low-rated review submissions (when product-review apps are connected), and support-ticket escalations tagged urgent. Brand-health canary; an early-warning of viral-grade complaints.
Calculation
Calculated automatically from your Shopify data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US food-and-beverage DTC brand on Shopify, ~800 orders/day. Wednesday 22 Apr 26, 14:00 PT. The alert fires: 11 negative signals in trailing 24h (vs 24h baseline of 1-2). Drill-down by signal type:
Five things to notice:
- The cause is concentrated. 7 of 11 signals mention damage/leaks; this is a packaging issue, not a quality issue. The brand received a new shipment of bottles 3 days ago; the new bottles may have a sealing defect.
- The signal is leading. At 14:00 PT, 11 signals have appeared. By tomorrow morning, social-media (Trustpilot, Reddit, Twitter) reviews will likely surface; today is the action window.
- Refund spike will follow. A 5-7× normal complaint volume on damage → expect Refund Rate to spike 2-3× over the next 7-10 days as customers process the experience and request refunds.
- The geographic clue. If the brand checks ZIP-code spread, complaints are concentrated in West Coast deliveries (which used a different carrier this week). Carrier or transit-route issue, not a product defect.
- Action: pause shipping ASAP. Hold all in-flight orders matching the same SKU + carrier combo. Re-package or re-ship via known-good carrier. The cost of holding orders is far less than the customer-trust cost of more damage complaints landing.
Sibling cards merchants should reference together
The negative-burst alert is the canary. The investigative cards:Reconciling against the vendor’s own dashboard
Where to look in Shopify Admin: Shopify itself doesn’t expose a “negative signal burst” widget; reconstruct from:- Orders → Filter by recent refunds: shows refund records; manual scan of the Reason column reveals complaint-flagged refunds.
- Inbox → Conversations: customer-service messages, not categorised by sentiment.
- Reviews app dashboard (Yotpo, Loox, Judge.me, Stamped): rating-bucket breakdown and recent-review feeds; manually count <=2-star reviews in 24h.
Cross-connector reconciliation:
Known limitations / merchant FAQs
Why is my threshold 5? Should I tune it? Yes, especially if your daily order volume is meaningfully different from a 1,000-order/day baseline:- <200 orders/day: 5 may be too high; even 2-3 in 24h is unusual. Set to 3.
- 200-1,000 orders/day: 5 works.
- >1,000 orders/day: 5 is too noisy; raise to 10-15.
- >10,000 orders/day: 5 fires constantly; raise to 30+.
- Discount-coupon redemption with the word “wrong” in custom note (e.g. “Customer entered wrong code”). Refine your refund-reason taxonomy.
- Test orders / staff training orders with playful complaint notes. Mark these as
Order.testor filter by tag. - Bulk customer migration / refund correction where you’re processing legitimate retroactive refunds. The note text triggers the regex even though the customer isn’t currently complaining.
- Damage cluster spike: ops issue, packaging or carrier problem.
- Late cluster spike: ops issue, fulfilment delay (cross-reference with Fulfilment Delay Alert).
- Quality cluster spike: product issue, batch or QC problem.
- Wrong-item cluster: pick error or PIM-mismatch.
- Read the actual signals in the drill-down. The text reveals the cause.
- Cluster by keyword theme: damage, late, quality, fit, billing.
- Find the common variable: SKU, batch, carrier, region, date. There’s almost always a common cause.
- Pause the cause if possible: hold shipments of suspect SKU, switch carriers, contact warehouse for QC review.
- Email affected customers proactively with apology and remedy. Don’t wait for them to ask.
- Add product/batch/carrier QA before incidents repeat. Document the cause and prevention in your ops playbook.