← Blog/Customers

How to Find Your Top 10 Customers by Total Spend in Shopify

A small group of customers drives most of your revenue. Here's how to find exactly who they are — and reward them — in one message.

June 18, 2026·3 min read

In most stores, a small fraction of customers account for a large share of revenue. Knowing exactly who they are is one of the highest-leverage things you can do — these are the people worth rewarding, protecting, and keeping happy. Yet most owners couldn't name their top 10 spenders off the top of their head.

Why this is buried in Shopify

Shopify tracks customer spend, but surfacing a clean "top 10 by lifetime value" ranking means sorting the customer list, and the default views don't make total spend, order count, and recency easy to see together. So the insight exists in your data — you just never look at it.

Ask for the ranking directly

With Claude MCP Connector, one question gives you the full picture:

Claude
Who are my top 10 customers by total lifetime spend? Show their spend, order count, and last order date.
C
Your top customers — they drive 38% of revenue:
JLJames L.14 orders$2,180
SKSarah K.11 orders$1,940
MRMia R.9 orders$1,610
+7 more · combined lifetime spend $14,200.
Idea: Tag these 10 as VIP and send a private thank-you — repeat buyers respond best.
Tag all 10 as VIP →

Claude ranks them by lifetime spend and shows order count and last order date alongside — so you can see not just who spends the most, but who's still active and who might be drifting away.

What to do once you know

Tag your top spenders as VIP automatically
Export them for a private email or early access
Send a thank-you discount just to this group
See what share of revenue your top 10 drive

Turn the insight into loyalty

Identifying your best customers is only useful if you act on it. Because Claude can tag, export, and message them in the same conversation, "who are my VIPs?" turns straight into a thank-you, an early-access invite, or a private perk — the kind of touch that keeps high-value customers coming back.

Try it free

Do this in 30 seconds with Claude.

Launching soon on the Shopify App Store. Join the early list to be first in.

Get early access →

Related articles

← Previous

How to Create a Manual Order in Shopify for a Phone Customer

Next →

How to Tag VIP Customers Based on Total Spend in Shopify