Catches a broken checkout / disconnected gateway / regional outage before the merchant notices the dashboard going quiet.
At a glance
Real-time alarm that fires when the rolling-hour total_inc_tax drops more than 25% versus the same hour over the prior 7 days. Catches a broken checkout, a disconnected gateway, or a regional outage before the merchant notices the dashboard going quiet.
| What it counts | Live SUM(total_inc_tax) for the most recent rolling 60-minute window, compared against the average SUM(total_inc_tax) for the same wall-clock hour across the prior 7 days. Fires when current ≤ 75% of expected. |
| VAT / tax treatment | Tax-inclusive. Both sides of the comparison use total_inc_tax. |
| Shipping | Included. Standard total_inc_tax semantics. |
| Discounts | Already deducted, post-discount customer-billed total. |
| Refunds | Not deducted. Refunds happen post-fact and are not part of the live comparison. |
Incomplete orders | Included. The alert measures gross total_inc_tax regardless of payment-capture state. This is intentional, a sudden drop in Incomplete-creation also signals a broken checkout (no orders even being attempted). |
| Cancelled / declined orders | Included. Same rationale, the alert measures whether orders are being created at all, not whether they’re succeeding. Order creation stopping is a louder signal than success rate moving. |
| Currency | Multi-currency without FX. The comparison is per-store-total, so a multi-currency store sees an aggregated alert. The alert still fires correctly because the comparison is current-week-vs-current-week (no period mismatch). |
| Channels / sources | Not filtered. All channel_id values contribute. A drop concentrated in one channel is masked by healthy traffic on others; pair with BC Alert Channel Revenue Drop for the per-channel version. |
| 7-day baseline | The “expected” value uses the same wall-clock hour from each of the prior 7 days, then averages. This handles weekly seasonality (Tuesday 11am traffic is compared to other Tuesdays, not weekends). It does NOT handle holidays, expect false positives on Bank Holidays, Black Friday recovery weeks, and similar calendar anomalies. |
| Time window | RT (real-time, evaluated each minute over a rolling 60-minute window) |
| Alert trigger | rolling-1h revenue drop >25% vs same hour last 7d |
| Sentiment key | revenue_trend |
| Roles | owner, finance, marketing |
Calculation
Calculated automatically from your BigCommerce 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 homewares brand on BigCommerce Enterprise. The 7-day rolling baseline for the 11:00-12:00 UTC hour averages 1,580. Alert fires.| Hour | Day | Same-hour revenue | Notes |
|---|---|---|---|
| 11:00 UTC | Tue 7 Apr 26 | $4,180 | Normal |
| 11:00 UTC | Wed 8 Apr 26 | $4,420 | Normal |
| 11:00 UTC | Thu 9 Apr 26 | $4,090 | Normal |
| 11:00 UTC | Fri 10 Apr 26 | $4,540 | Normal |
| 11:00 UTC | Sat 11 Apr 26 | $3,980 | Normal |
| 11:00 UTC | Sun 12 Apr 26 | $4,210 | Normal |
| 11:00 UTC | Mon 13 Apr 26 | $4,180 | Normal |
| 7-day avg | $4,229 | Baseline | |
| 11:00 UTC Tue 14 Apr 26 | $1,580 | 62.6% drop, alert FIRES |
- The alert fires at 4,229). Anything below that triggers the notification. $1,580 is well below, so the alert escalates to high-severity.
- Investigation sequence in the first 5 minutes: (a) Open the BC storefront yourself in an incognito browser, can you reach checkout? (b) Try to place a test order. (c) Check BC’s status page for incidents. (d) Check the payment-processor status pages (Stripe, PayPal). (e) Check BC Decline Rate and BC Incomplete Rate, if either spiked, the funnel is the cause.
- Common false-positive scenarios: holidays, hour-of-day shifts due to daylight saving, scheduled maintenance windows the merchant forgot to silence, competitor sales pulling traffic away. Roughly 60% of fires are real, 40% are explainable noise. Don’t treat each fire as a five-alarm event; first-pass diagnosis is fast.
- High-severity escalations: a 90%+ drop ($420 in this example) almost always means a broken checkout or a payment-vendor outage. Skip the diagnostic dance and just verify checkout works; if it doesn’t, file a P1 with BC support and the affected gateway simultaneously.
- Verify the storefront loads. If it doesn’t, BC has an outage, call BC support.
- Verify checkout completes with a test card. If it doesn’t, the gateway is the issue.
- Check payment-processor status pages (status.stripe.com, status.paypal.com). External outages take all merchants down simultaneously; you’re rarely alone.
- Check fraud-rule recent changes, sudden tightening can decline meaningful traffic in minutes. Roll back any recent changes.
- Notify the team via the existing #incidents Slack / Teams channel. Even false positives benefit from being acknowledged out loud.
Sibling cards merchants should reference together
| Card | Why pair it with Revenue Drop Alert |
|---|---|
| Total Revenue | The full daily / weekly trend that this alert is the real-time guardian of. |
| BC Alert Channel Revenue Drop | Per-channel version. Catches drops concentrated in one channel that this store-wide alert masks. |
| BC Decline Rate | If revenue dropped and decline rate spiked, the gateway is the cause. |
| BC Incomplete Rate | If revenue dropped and incomplete rate spiked, the checkout iframe is the cause. |
| BC Failed Orders Count | The combined failure pulse, useful for the first-5-minutes diagnostic. |
| BC Alert Fulfilment Delay | Often co-fires; an outage that breaks orders also delays whatever fulfilment was queued. |
| Order Count | The volume side. A revenue drop with stable order count means AOV moved (a discount went live unexpectedly). |
| BC Alert OOS Spike | A revenue drop concurrent with an OOS spike often means a top SKU went out of stock and customers abandoned. Different fix than a checkout outage. |
Reconciling against the vendor’s own dashboard
Where to look in BigCommerce Control Panel: BigCommerce does not surface real-time revenue alerts natively. The BC Sales dashboard is daily-aggregation; it cannot tell you that the last hour was 60% below normal. To partially diagnose:- Analytics → Sales shows the daily trend; today’s bar will be obviously short if the alert fired earlier in the day.
- Orders → All orders sorted by date descending shows the most recent orders; gaps in the timestamp sequence reveal when ordering stopped.
- BC Status for known platform issues.
- Settings → Payments shows current gateway health.
- Storefront → Themes → Visit store: lets you sanity-check the storefront loads.
- Webhooks → Recent activity: webhook delivery health, useful when a third-party integration is the cause.
| Reason | Direction |
|---|---|
| Holidays not on the 7-day baseline. Bank Holidays, US holidays not yet present in the 7-day rolling window cause false fires. | False positive |
| Daylight saving transitions. The “same hour” calculation shifts by 1 hour twice a year; the 1-2 days after a DST flip are noisy. | False positive |
| Promotional cycles. The day after a flash sale, hourly volume drops below the 7-day baseline (which now includes the sale spike). | False positive |
| Indexer lag. If BC’s API rate-limited during the comparison hour, our index may be undercounting. | False positive (resolves at next sync) |
| Genuine outage / broken checkout. The intended trigger. | True positive |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
stripe.stripe_total_revenue | Stripe-side hourly revenue should drop in lockstep if Stripe is the BC processor | Stripe sees only successfully captured charges; this card includes Incomplete and Declined gross. A 25% drop here may show as a 35% drop on Stripe if declines spiked. |
google_analytics.ga_revenue_trend | GA4 hourly revenue should drop in lockstep, modulo tracking gap | GA4 misses 10-25% of orders; the GA4 number is noisier than this card. |
paypal.pp_total_volume | PayPal-side hourly should drop in lockstep if PayPal is the affected gateway | PayPal-only outages show as drops on PayPal but not on Stripe; cross-checking pinpoints the broken processor. |