At a glance
A scatter / line chart that pairs each minute’s 5xx response rate against the same minute’s cart-abandonment rate from the connected commerce sibling. Visually answers “do my server errors translate into customers walking away from carts?” The slope of the relationship is the merchant’s abandonment sensitivity coefficient.
| What it counts | Two minute-aligned series joined by timestamp: 5xx_rate = percentage(count(*), WHERE httpResponseCode >= 500) FROM Transaction from NR; cart_abandonment_rate = (carts_created - checkouts_started) / carts_created from the commerce sibling. The chart shows correlation over rolling 30 days. |
| NerdGraph endpoint | NR side via NerdGraph: SELECT percentage(count(*), WHERE httpResponseCode >= 500) FROM Transaction WHERE appName IN (...) SINCE 30 DAYS AGO TIMESERIES 1 minute. Commerce side: cart and checkout events from Shopify (CartCreate + CheckoutCreate webhooks), BigCommerce equivalent, or GA4 funnel events. |
| Metric basis | Rate-vs-rate correlation. The card returns: (a) live overlay timeseries; (b) scatter plot of (5xx_rate, abandonment_rate) tuples with regression line; (c) the sensitivity coefficient (slope). |
| Aggregation window | 1-minute resolution joined on timestamp. The sensitivity coefficient updates daily on the rolling 30-day window. |
| Browser vs APM scope | NR side: APM-only by default (server-side 5xx), can extend to Browser-observed 5xx if the merchant has Browser RUM. Cart-abandonment side: commerce-platform events, all sessions regardless of browser. |
| Severity threshold | The “5% above baseline” alert fires when the abandonment rate during a 5xx spike window is more than 5 percentage points above the abandonment-rate baseline for the same time-of-day, indicating a real link from server errors to customer drop-off. |
| Filtered hosts / services | NR scope: storefront and checkout APM apps. Commerce scope: full-funnel events (cart creation through checkout-start). Background jobs and admin tools excluded. |
| Sample basis | NRQL rates are sample-corrected; cart events are unsampled. |
| Time zone | Account timezone for chart axes; UTC for raw timestamps. Baseline computation uses merchant local timezone for “same time-of-day” alignment. |
| Time window | 30D (rolling 30-day window for correlation; 24-hour live overlay for incident view) |
| Alert trigger | >5% above baseline (abandonment-rate excess during a 5xx spike) |
| Roles | owner, marketing |
Calculation
Calculated automatically from your New Relic 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 Shopify Plus brand with NR APM. Baseline cart-abandonment rate (during healthy operations) sits at 68% (industry-typical for non-luxury commerce). 5xx rate baseline is 0.05%. A 5xx spike occurs at 13:14, 13:23 on 02 May 26:| Minute | 5xx rate | Carts created | Checkouts started | Abandonment rate |
|---|---|---|---|---|
| 13:13 | 0.04% | 24 | 8 | 67% (baseline) |
| 13:14 | 1.8% | 26 | 6 | 77% (+9%) |
| 13:15 | 4.1% | 28 | 4 | 86% (+18%) |
| 13:16 | 6.7% | 25 | 2 | 92% (+24%) |
| 13:17 | 8.4% | 27 | 2 | 93% (+25%) |
| 13:18 | 7.1% | 24 | 3 | 88% (+20%) |
| 13:19 | 4.4% | 26 | 5 | 81% (+13%) |
| 13:20 | 2.1% | 25 | 6 | 76% (+8%) |
| 13:21 | 0.8% | 27 | 8 | 70% (+2%) |
| 13:22 | 0.1% | 26 | 8 | 69% (+1%) |
| 13:23 | 0.04% | 25 | 8 | 68% (baseline) |
Sibling cards merchants should reference together
| Card | Why pair it with Cart Abandonment During 5xx Spikes |
|---|---|
| 5xx Response Rate | The error-rate input. Open for the raw 5xx series. |
| Error Rate | Broader view (all errors, not just 5xx). The relationship to abandonment is weaker for non-5xx errors. |
| Errors by Transaction | The drill-down. Tells you which endpoints contributed to the 5xx spike. |
| Conversion Drop During Incidents | Sister cross-channel card focusing on conversion rate (whole funnel) instead of cart abandonment (single funnel step). |
| Revenue Lost / Min | Dollar-impact view of the same relationship. |
| Datadog Cart Abandonment on 5xx | Cross-connector peer. |
| Shopify Cart Abandonment Rate | The cart-abandonment input. Open for the raw rate series. |
| GA4 Checkout Funnel | Whole-funnel view from real user telemetry. Pair to confirm the abandonment is observed customer-side as well as via webhook events. |
Reconciling against the vendor’s own dashboard
Where to look in New Relic: NR doesn’t natively render this cross-channel correlation. The closest equivalent screens for the input signals:- APM > Service > Error analytics for the 5xx-rate series.
- Dashboards > custom dashboard if the merchant has piped commerce events into NR via Custom Events API.
| Reason | Direction of divergence |
|---|---|
| Account timezone vs UTC. NR APM follows account timezone; commerce events use the merchant’s commerce timezone (often the same, but not always for global stores). Boundary-period evaluation can drift the abandonment rate by 1, 3% on the most recent minute. | Either direction at boundaries |
| NRQL retention. 30-day window is on the boundary of standard plans’ 8-day full-resolution retention. Older minutes use rolled aggregates; the regression-line slope can drift 0.1, 0.3 over a quarter as old data ages out. | Slope drifts slowly |
Cart event lag. CartCreate webhooks arrive 200ms, 4s after the customer adds to cart; the live overlay can show a 5, 10% optimistic abandonment-rate reading on the most recent minute until events catch up. | Card understates abandonment in real-time |
| Shopify Cart vs Checkout semantics. Shopify counts a cart as “abandoned” when a customer adds to cart but doesn’t reach the checkout page within the session. The card uses the same definition. Stores using a custom multi-step checkout may need a manifest override to include intermediate steps. | Either direction depending on definition |
| Ingest sampling. NR rates are sample-corrected; commerce-side events are unsampled. The relationship stays valid but absolute counts differ from raw logs. | None for the rate-vs-rate correlation |