At a glance
Customers split by 90-day spend tier: One-time, Casual (2-3 orders), Regular (4-9 orders), VIP (10+ orders or top-spend cohort). Plus a separate New vs Returning split based on first-order timing. The card the marketing team uses to segment campaigns, set loyalty-program tiers, and prioritise retention investment.
Calculation
Worked example
A US homewares brand on BigCommerce Pro, 90-day window 14 Feb 26 to 14 May 26.
What’s interesting:
- VIPs at 4.8% of customers drive 34.3% of revenue. Classic Pareto, the top tier deserves disproportionate retention investment. White-glove customer service, exclusive access, dedicated account manager (if budget allows). Cross-reference BC Top Customers for the named VIP list.
- Regular tier (13.5% of customers / 37.6% revenue) is the hidden growth engine. These customers are demonstrably loyal but not yet VIP. Loyalty-program tier upgrade for high-Regular customers (those at 8-9 orders trending toward 10+) creates VIP-aspiration motivation; many will upgrade themselves with the right incentives.
- One-time at 58% of customers / 30.4% of revenue is the conversion target. Half of these will never come back; the other half can be converted to Casual with the right post-purchase flow (welcome series, replenishment reminder, “you might also like” emails). Even a 10% one-time-to-casual conversion adds 290 new Casual customers.
- Returning customers carry 68.5% of revenue at 52% of count. This is the retention-economy reality: returning customers spend roughly 1.6× more than new customers in the period. Retention investment ROI is structurally higher than acquisition.
- 48% new customer share is balanced. Above 60% suggests acquisition heavy / leaky retention; below 30% suggests stagnant base / weak acquisition. 40-55% is healthy growth dynamic.
- Loyalty-program tier definitions match this card’s tier structure; make tier benefits visible to encourage upgrade.
- Post-purchase flow for one-time customers automated email sequence to convert one-time to Casual; biggest absolute opportunity by customer count.
- VIP retention program identify the 480 VIPs by name; assign account-management attention; quarterly check-ins.
- Regular-tier upgrade incentive “spend $X more this quarter and unlock VIP” creates aspiration without giving away margin.
- Quarterly: review tier thresholds customer behaviour drifts; tier definitions may need adjustment to maintain meaningful segmentation.
Sibling cards merchants should reference together
Reconciling against the vendor’s own dashboard
Where to look in BigCommerce Control Panel: Customers → Customer Groups lets you define groups (typically used for B2B / wholesale tiers, not RFM-style spend tiers). Analytics → Customer Reports on Plus / Pro / Enterprise plans includes a “Top Customers” view but no native RFM-tier view. The spend-tier segmentation is Vortex IQ’s contribution; BC has the data but doesn’t surface it as tiers. Why our number may legitimately differ from any BC native view:
Cross-connector reconciliation (when CRM and email integrations are connected):
The customer-segment view is BC-aligned with Shopify and Adobe Commerce; semantics broadly equivalent though tier definitions vary.