Order Count Trend, BigCommerce

​

At a glance

Percentage change in number of orders placed versus the previous period. Order volume is the clearest signal of demand, declining orders usually precede revenue drops by 7-30 days. Order count strips out price and discount effects and shows the underlying transaction volume. A rising order count with falling AOV is a different story than a falling order count with rising AOV, and this card decomposes the picture so the merchant knows which of the two levers needs work.

​

Calculation

order_count_trend (%) = (current_period_order_count - previous_period_order_count)
                        ÷ previous_period_order_count × 100

current_period_order_count  = COUNT(orders) WHERE order_date IN [today - 30d, today)
                              AND payment_status IN ('paid', 'captured', 'completed')
previous_period_order_count = COUNT(orders) WHERE order_date IN [today - 60d, today - 30d)
                              AND payment_status IN ('paid', 'captured', 'completed')

​

Worked example

1. The headline order count drop is severe enough to trigger alert. -12.7% over 30 days, sustained, compounds to roughly -80% over a year. The card is in red and should be the morning-review priority.
2. Year-over-year context softens the picture. Compared to the same period in May 25, order count is up +7.8%. The merchant is growing year-over-year but contracting period-over-period. This is typical for stores that ran an unusually large promotional campaign in the immediately prior period: the comparison base is artificially inflated.
3. Decomposing the volume drop:
   • Sessions fell -7.2% (traffic issue: ad spend cut, organic erosion, or seasonality)
   • Conversion rate fell -6.3% (conversion issue: site speed regression, checkout problem, or pricing change)
   • The two compound to roughly -13% in expected orders, matching the -12.7% headline
4. Likely causes, in priority of investigation:
   • Paid traffic cut: cross-reference gads_total_spend for the prior period vs current. If spend dropped, expect proportional traffic and order drops.
   • Site speed regression: cross-reference crux_lcp_p75 and psi_perf_score_summary. A 200ms LCP regression typically reduces conversion by 1-2 percentage points.
   • Checkout regression: cross-reference ga_cart_abandonment and ga_checkout_completion. A new checkout app or PSP integration could break the flow.
   • Seasonality: confirm against year-over-year and the prior-year same period.
   • Competitive pricing: if a major competitor cut prices in the period, basket-replacement may explain the drop.
5. Recommended response:
   • Day 1: Decompose using the diagnostic flow above. Identify the primary driver (traffic, conversion, or competitive).
   • Day 1-3: If traffic-driven, restore ad spend or investigate organic erosion via gsc_clicks_trend.
   • Day 1-3: If conversion-driven, run a checkout flow test in incognito on mobile + desktop, validate payment gateway, validate site speed.
   • Day 7: Confirm trend slope has flattened. If still -10%+, escalate to founder review.
   • Day 14: Post-mortem on the cause with documented root cause + preventive control.
6. What “good order count trend” looks like: order count rises 5-15%, sessions rise proportionally, conversion rate stable or rising, AOV stable. Order count growth without traffic growth means conversion improvement, the rarest and most valuable kind.

1. Read order count trend %. Below -10% triggers alert.
2. Decompose into traffic × conversion (sessions × conversion rate ≈ orders).
3. Identify which leg is moving and target the specific upstream card.
4. Confirm against year-over-year to control for seasonality.

​

Sibling cards merchants should reference together

​

Reconciling against the vendor’s own dashboard

• shopify.order_count_trend, adobe_commerce.order_count_trend: same metric on other platforms.
• ga_purchase_count: GA-recorded purchases; should be within ±3% of BC orders. Larger gaps indicate tracking issues.

​

Known limitations / merchant FAQs

​

Tracked live in Vortex IQ Nerve Centre