At a glance
The top N customers ranked by gross spend in the 90D window. Surfaces the VIP tier; the people whose churn would hurt most.
Calculation
Calculated automatically from your Shopify 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 UK gifting / homewares brand on Shopify, ~12,000 customer base. 90D window 12 Feb 26 to 12 May 26.
Six things to notice:
- Power-law distribution. Top 50 customers (0.42% of base) drive ~15.5% of revenue. The shape is consistent; almost every Shopify store sees a similar concentration. The top 5% of customers usually drive 30-50% of revenue.
- VIPs are heterogeneous. Sarah (corporate gifting) buys infrequently but in bulk; Marcus (subscriber) buys often in smaller amounts. They need different retention strategies. A “VIP” segment that lumps them together over-simplifies.
- Single-customer concentration risk. Sarah at £4,820 is 7% of the top-50’s revenue alone. If she churns or her employer changes vendors, the top-of-list shrinks meaningfully. Customer-success outreach pre-empts this.
- The 50th customer is the threshold. Below £680 in 90D, customers don’t appear. Most “loyal” customers sit between £200-£680. Worth segmenting that “near-VIP” tier separately for nurture campaigns.
- Anonymous customers (POS walk-ins) are missing. A walk-in at the pop-up store who paid £500 cash with no email-capture doesn’t appear here. Hybrid-retail brands under-count VIPs unless POS staff capture email aggressively.
- Refunders may be inflated VIPs. A customer with £3k spend and £2k refunds ranks here at £3k. Pair with Top Refunding Customers to find net-VIPs (gross spend minus refunds). Some apparent VIPs are net-loss customers.
Sibling cards merchants should reference together
Top Customers is the VIP list. The companions:Reconciling against the vendor’s own dashboard
Where to look in Shopify Admin:Shopify Admin → Customers → Sort by Total spent (descending)The most direct equivalent. Switch the time-frame manually (Shopify’s customer total-spent is lifetime by default; for 90D, run a custom segment with
total_spent filter and date-range).
Other Shopify Admin views:
- Analytics → Reports → “Customers by total spent”: ranks all customers by lifetime spend. Different time window than this card.
- Customer segments (Plus): build a “high-value” segment with custom criteria.
- Apps like Loyalty Lion, Smile.io, Klaviyo: their VIP tiers are usually based on lifetime spend or custom logic.
Cross-connector reconciliation:
Known limitations / merchant FAQs
Why is my #1 customer a name I don’t recognise? Three usual causes:- Corporate / wholesale account using personal email at checkout. Sarah from Acme Corp may show as “Sarah J.” with a personal address.
- Repeat purchaser using throwaway / aliased email for privacy.
- Resellers / arbitrage buyers. Some categories attract resellers who buy bulk for resale on Amazon or eBay; they appear high on this list and have a specific behaviour pattern (small-window high-volume).
- Refund happened: pair with Top Refunding Customers. The customer’s net spend may be unchanged.
- Buying cycle shift: corporate gifting buyers often cluster around quarterly cycles; a quiet month is normal.
- Real churn: customer found a competitor or stopped needing the product. Reach out via account manager or customer-success channel.
- Mass-market consumer brands (broad audience): top 50 = 5-10% of revenue. Healthy diversification.
- Niche / specialist brands: top 50 = 15-25%. Loyal core with broader long tail.
- B2B-leaning DTC: top 50 = 25-40%. Concentration is the business model.
- Subscription-heavy: top 50 = 5-15%. Subscribers are spread across the long tail.
- VIP-only early access (new collections, restocks): high-perceived-value, low-cost.
- VIP-only product or limited editions: builds emotional loyalty.
- Discount codes: can be perceived as devaluation; offer service or product perks instead.
- Personal outreach / handwritten notes: high-touch, low-scale, high-impact.
- Healthy churn-and-replace at the lower ranks: ranks 30-50 naturally swap as customers buy at irregular intervals. Top 5-10 should be stable.
- Low-loyalty business: if even top 5-10 churn frequently, your retention model has a problem. Pair with Repeat Customer Rate.
- Personal acknowledgement: top 10 should know they’re recognised. A handwritten note, a check-in email, or a call from the founder.
- Account management for top 5: especially if they’re B2B-style; assign a named contact.
- Predictive churn watch: pair with Churn Risk. VIPs about to churn are the highest-priority retention.
- Lookalike acquisition: feed top-customer profiles to Meta / Google Ads as lookalike seeds.
- Product feedback: top customers know your product best; survey them for new-product or experience feedback.
- Privacy and discretion: don’t expose this list publicly or use customer names externally without consent.