At a glance
Day-by-day revenue (SUM(grand_total)) over the last 90 days. The headline time-series card. Plotted with a 7-day moving average overlay to smooth weekly seasonality and a year-over-year overlay for stores with sufficient history.
Calculation
Worked example
A B2B+DTC homewares merchant on Adobe Commerce 2.4.7. UK base, GBP. Snapshot 13 May 26, 90-day rolling. Aggregate stats:
Notable events on the chart:
Insight pattern:
- Mean ≈ median (£31,556 vs £30,200). Distribution roughly symmetric over the 90 days. Mean would be much higher than median if a single huge promotion dominated; here it’s balanced.
- The 14 Mar 502 outage is the canary; cross-link with Revenue Drop Alert which fired at 11:00. £18,200 day vs £30,200 median = £12,000 lost. Recovery the following day was complete.
- The 28 Apr to 5 May sustained dip is the most concerning. Eight days below the 7-day moving average, with the average itself trending down. £19k average per day vs £30k median = £88,000 cumulative shortfall over the 8 days. Cross-link with Refunds Over Time for the parallel uniform-line return wave. Recovery began 6 May after the merchant’s PR team posted corrections.
- Compare to Orders Over Time: order count dropped less proportionally during the 28 Apr-5 May dip (~12% drop in orders vs 35% drop in revenue). That means AOV dropped during the dip, customers were cautious, ordering low-value test purchases rather than full baskets. Healthy sign that demand wasn’t lost; just AOV.
- YoY overlay: when 365-day data is available, year-over-year overlay reveals seasonality (Black Friday peak, January post-Christmas dip). The card supports the overlay automatically once history exists.
- Cancelled orders included. The card includes ~1-3% canceled revenue. Toggle to exclude for true cash-flow signal; minor difference but matters for finance.
Sibling cards merchants should reference together
Reconciling against the vendor’s own dashboard
Where to look in Adobe Commerce Admin:Reports > Sales > Orders with “Show By” set to “Day”, date range matching this card. The chart and revenue column should approximately match.
Dashboard > Sales > Revenue Chart is a built-in chart on the Admin dashboard. Limited to 30 days and uses base currency. Useful for sanity-checking the most-recent month.Why our number may legitimately differ from Adobe Commerce Admin:
Cross-connector reconciliation (when these connectors are connected for this merchant):
Known limitations / merchant FAQs
Why does today’s last data point look low? Because today is incomplete. The trailing point is in-progress; mentally exclude or wait for the day to close. Why is mixed-currency the default? For trend visualisation, mixed-currency works because the shape doesn’t depend on FX. For absolute reconciliation against finance, switch tobase_grand_total (FX-converted to store base currency at order time).
My multi-store revenue per Store View doesn’t sum to the headline, why?
Currency mixing is the most common cause. Switch to base currency for both views. Otherwise: orders without an assigned Store View (rare), or sync-lag making the per-Store-View totals slightly out of sync with the combined.
Cancelled orders are included by default. Why?
For the headline trend, cancelled orders represent demand that almost-converted; including them gives a fuller customer-intent picture. For “actual cash received” view, exclude cancelled. The sentiment trend uses the included version.
A long horizontal line near zero, what’s that?
Either an outage that wiped a day, or a Store View was disabled for that period. Cross-check against deployment logs and the Order State Distribution for that day.
Why doesn’t Stripe agree?
Stripe is a subset (Stripe-paid orders only). PayPal, Authorize.Net, manual bank transfer revenue is in this card but not in Stripe. Sum (Stripe + PayPal + manual) should approximately match this card.
Year-over-year overlay isn’t showing, why?
Need at least 365 days of order history. The card auto-disables YoY if data is shorter than that.
Net-of-tax view, when do I use it?
For Finance dashboards reconciling to GL revenue lines (which are net of VAT). For marketing dashboards (gross is the impressed-on-customer figure), keep the default.
Net-of-refund view, when?
For finance “true cash” dashboards. The Vortex IQ workspace can compute net-of-refund automatically when Refunds Over Time is on the same dashboard.
Why does my Black Friday spike not appear?
Either the 90-day window doesn’t reach back to Black Friday, or you toggled off the year-over-year overlay. Extend the window to 180D or 365D.