> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # Cart Abandonment During 5xx Spikes, New Relic > Cart Abandonment During 5xx Spikes for New Relic stores. Tracked live in Vortex IQ Nerve Centre. How to read it, why it matters, and how to act on it. **Metrics type:** [Cross-Platform Metrics](/nerve-centre/overview#metrics-types-explained) • **Category:** [Monitoring](/nerve-centre/connectors#connectors-by-type) ## 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](https://api.newrelic.com/graphql): `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) | **Reading the relationship.** The scatter for these 11 minutes shows a clear positive correlation: every additional 1% of 5xx rate adds roughly **3% to the abandonment rate**. This **sensitivity coefficient of 3.0** is the actionable number, it tells the merchant exactly how much customer behaviour responds to server errors. Stores with strong brand loyalty might show 1.5; stores in highly competitive niches show 4, 5. **Conversion impact translation.** Over the 9-minute spike (13:14, 13:22), 234 carts were created and only 44 checkouts started. Baseline expectation: 234 x 32% completion = 75 checkouts. Lost: 75 - 44 = **31 checkouts**, at AOV of £85 = **£2,635 of GMV impact** in 9 minutes. **Apdex calibration interaction.** During the worst-spike minute (13:17), Apdex on the storefront was 0.46, well below the 0.5 frustrated boundary. Errors automatically count as *frustrated* in Apdex math regardless of duration, so the 5xx spike directly drove Apdex into the frustrated zone. The sensitivity coefficient (3.0 abandonment-points per 1% error rate) is roughly consistent with the conversion-loss-per-100ms-latency rule of thumb extrapolated to the error case. **Why the 30-day scatter matters.** The sensitivity coefficient is calibrated over 30 days, not just one incident, because individual incidents have noise. With \~43,200 minute-tuples over 30 days, the regression line is statistically robust. A merchant whose coefficient moves from 3.0 to 4.5 over a quarter has lost some brand loyalty and customers are now more likely to walk away when something goes wrong, that's a strategic signal worth a conversation. ## Sibling cards merchants should reference together | Card | Why pair it with Cart Abandonment During 5xx Spikes | | ----------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------ | | [5xx Response Rate](/nerve-centre/kpi-cards/newrelic/5xx-response-rate) | The error-rate input. Open for the raw 5xx series. | | [Error Rate](/nerve-centre/kpi-cards/newrelic/error-rate) | Broader view (all errors, not just 5xx). The relationship to abandonment is weaker for non-5xx errors. | | [Errors by Transaction](/nerve-centre/kpi-cards/newrelic/errors-by-transaction) | The drill-down. Tells you which endpoints contributed to the 5xx spike. | | [Conversion Drop During Incidents](/nerve-centre/kpi-cards/newrelic/conversion-drop-during-incidents) | Sister cross-platform card focusing on conversion rate (whole funnel) instead of cart abandonment (single funnel step). | | [Revenue Lost / Min](/nerve-centre/kpi-cards/newrelic/revenue-lost-min) | Dollar-impact view of the same relationship. | | [Datadog Cart Abandonment on 5xx](/nerve-centre/kpi-cards/datadog/cart-abandonment-during-5xx-spikes) | Cross-connector peer. | | [Shopify Cart Abandonment Rate](/nerve-centre/shopify/cart_abandonment) | The cart-abandonment input. Open for the raw rate series. | | [GA4 Checkout Funnel](/nerve-centre/google_analytics/ga_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-platform correlation. The closest equivalent screens for the input signals: * [APM > Service > Error analytics](https://one.newrelic.com/nr1-core?filters=%28domain%3D%27APM%27%29) for the 5xx-rate series. * [Dashboards](https://one.newrelic.com/dashboards) > custom dashboard if the merchant has piped commerce events into NR via Custom Events API. For the cart-abandonment input, compare against the merchant's commerce platform's funnel report (Shopify Analytics > Behavior > Funnel; BigCommerce Reports > Abandonment). **Why our number may legitimately differ from the vendor's:** | 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 | **Cross-connector reconciliation:** NR APM 5xx and Datadog APM 5xx should agree within 0.3% on healthy days; during incidents the gap can widen to 1, 2% as one platform sees errors the other doesn't. The cart-abandonment rate is identical because both platforms read from the same commerce sibling. Cross-connector disagreements on this card therefore trace back to the 5xx series, audit instrumentation parity if it matters. NR APM 5xx vs Browser-observed 5xx (RUM): RUM captures 5xx that happen *after* the page loads (typically API calls); APM captures 5xx at the server boundary. Some 5xx never reach the browser (the customer's request was queued and timed out before getting a response); some Browser 5xx never reach APM (third-party API failures called from the browser). The two views are complementary, not redundant.
Same-metric peers on other connectors | Connector | Card | Notes | | --------- | ------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------- | | Datadog | [`dd_xc_abandonment_on_5xx`](/nerve-centre/kpi-cards/datadog/cart-abandonment-during-5xx-spikes) | Same correlation composite using DD APM 5xx. Cart-abandonment input is identical. |
## Known limitations / merchant FAQs **NR vs Datadog: should the abandonment-sensitivity coefficient match across both platforms?** Yes, within \~0.3 of the slope value. Both pull cart-abandonment from the same commerce sibling, so the y-axis is identical. Differences come from the x-axis (5xx rate); if NR and DD have different APM coverage, the 5xx series differs and the regression slope can shift slightly. A persistent slope-difference of >0.5 indicates real coverage drift worth auditing. **Apdex math: why isn't Apdex on this chart?** This card is specifically about *errors* and abandonment, not latency and abandonment. Apdex bundles latency and errors into a single satisfaction score; using it on this card would muddy the error-specific signal. For the latency-and-conversion view, use [Checkout App Health x Sales](/nerve-centre/kpi-cards/newrelic/checkout-app-health-x-sales). **NRQL retention: 30-day window is on the boundary of retention, is that a problem?** On standard NR plans (8-day full-resolution retention), the 30-day window uses rolled aggregates for the older 22 days. Rate-vs-rate correlation is sample-stable so the slope of the relationship stays valid, but minute-by-minute scatter detail past day 8 reads at hourly resolution. For full 30-day minute-resolution, upgrade to NR Data Plus (13-month retention). **NR and Datadog disagree on the slope by 0.4, who's right?** Almost certainly the platform with broader 5xx coverage is reading the higher slope (it sees more errors, so the regression line picks up more points and weights them more heavily). Audit which platform is missing instrumentation; once aligned, slopes typically converge within 0.2. **Sampling: can sampling break this card?** Rate-vs-rate correlation is sample-stable. NR's high-cardinality event sampling does not affect the slope or the alert. Cart-abandonment is unsampled. **Multi-account: my US and EU stores have different abandonment baselines, can the card handle both?** Yes. Connect each pair (NR account + commerce sibling) as a separate integration; each gets its own card with its own sensitivity coefficient. The Nerve Centre stack panel can render both side-by-side; combined slope analysis is not currently supported (would require careful weighting by traffic). **Ingest cost vs visibility: can I sample down 5xx events?** No, never sample errors. Errors are rare enough that the cost of keeping 100% of them is small (typically \<5% of total ingest), and sampling errors breaks alert sensitivity for low-volume failure modes. Sample down successful Transaction events freely; keep errors at 100%. **Alert tuning: my alert fires every Black Friday because abandonment naturally rises with traffic, what should I tune?** Two fixes: (a) use NR's *adaptive baseline* condition type, which compares against the same time-of-day on prior weeks rather than a fixed +5% threshold; (b) require a co-incident 5xx spike to gate the abandonment alert ("abandonment +5% AND 5xx rate >1%"), which prevents firing during traffic-only abandonment surges. Adaptive baselining is generally preferred. **My sensitivity coefficient is 5.5, is that bad?** It's high but not unprecedented. A coefficient of 5.5 means every 1% of 5xx rate produces 5.5% additional abandonment. Industry-typical for non-luxury commerce is 2.5, 3.5; coefficients of 5+ usually indicate one of: (a) low brand loyalty (customers don't retry), (b) high-competition niche (alternatives are one click away), (c) unusually error-sensitive customer segment (B2B buyers, premium customers). The actionable response is to invest in error-recovery UX (helpful error pages, automated retry on the client) which can typically pull the coefficient down by 1, 2 points. *** ### Tracked live in Vortex IQ Nerve Centre *Cart Abandonment During 5xx Spikes* is one of hundreds of KPI pulses Vortex IQ tracks across New Relic and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. [Start for free](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.