Skip to content
MergeGuard
Install free

Guide

How to set a VIP threshold on Shopify

Choose a share of your own customers by spend over a stated window, turn it into a dollar figure, and check that the VIP count is a sensible size. Shopify’s own VIP-like groups, RFM Champions and Loyal and the High spend tier, are relative to your store and not fixed amounts.

By MergeGuard team

Last updated

4 min read

On this page

A VIP threshold is one number, and it decides who gets perks. A figure that is too high leaves loyal customers out. One that is too low gives perks to half the store. This guide shows how to build the number from your own customers’ spend, and what Shopify provides along the way.

Key insight

A VIP threshold is your choice, anchored to your own spend distribution. A benchmark from another store can’t tell you where your customers’ spend falls.

What Shopify gives you

The Shopify pages we read describe no single VIP setting. They describe pieces you can build one from.

  • Customer segments. Shopify calls them “dynamic, rule-based customer lists”, and customers are “automatically added or removed to the segment list” as they meet the criteria (Customer segments). The segment query reference lists the amount_spent filter as “The total amount spent (all time).” (reference).
  • RFM groups. Shopify scores customers from 1 to 5 on recency, frequency and spend, and says “RFM scores are based only on data from your store, and not on industry standards or third-party data.” Champions are “Customers with very recent purchases, many orders, and the most spend”, and Loyal are “Customers with recent purchases, many orders, and the most spend” (Customers reports).
  • Predicted spend tier. Customers are sorted into High, Medium and Low tiers from how often they buy, their order value against the store average, their order count and how recently they ordered. Your store must have made more than a hundred sales, and Shopify doesn’t publish where the tiers start (Predicted spend tier).

The RFM groups and the High tier are measured against your own customers. None of them is a fixed dollar amount. A dollar threshold needs a segment of your own. Our reading: amount_spent is a field of the customer record, so it counts one profile.

Pick a window

The window is the period spend is added over. All-time spend rewards tenure. A recent window, such as the last 12 months, rewards current buying. Lifetime or 12-month spend sets out when each fits. Whichever you choose, write it down. A threshold with no window attached has no clear meaning.

Use a share of your own spend

Set the threshold from where your customers’ spend actually falls. This is our suggested method, a reasoning step rather than a published rule.

  1. Add up spend per person over your window.
  2. Sort from highest to lowest.
  3. Choose the share you want as VIPs.
  4. Read off the spend of the last person inside that share.

Here is an invented example of those steps.

Worked example (made up)

A store has 2,000 customers who have ordered. Sorted by spend, the 100th customer from the top has spent $380. A threshold of $380 gives about 100 VIPs, the top 5 percent of customers.

Worked example (made up)

2,000 customers, highest spend first. The 100th customer from the top has spent $380, so a threshold of $380 gives the top 5% of customers. The bars are a schematic.2,000 customers, highest spend firstThreshold: $380Top 5%Schematic of a typical drop-off in spend
The spend of the last customer inside your chosen share is the threshold.

Practitioners give similar advice. A loyalty-app vendor article suggests you “look for natural clusters — where does the top 20% of customers start?” (Tenten, a vendor’s opinion and not research). The share is your choice. A small share keeps the perks scarce, and a large one costs more to serve.

Check the count

Count the people at or above your threshold and compare the number with what you can give. A VIP group the size of a third of your customers is a big group to serve, and a group of a handful can feel like nothing. Adjust the share and read off a new figure until the count suits the perks you plan.

Count people, not profiles

Every Shopify spend field belongs to a profile. A customer whose orders sit on two profiles can fall under the threshold on both, though together they would clear it. In MergeGuard’s demo store: 18 VIPs on single profiles → 27 VIPs as people Demo store (Northsail Supply). Why split profiles hide your VIPs works through the arithmetic.

Review on a schedule

A threshold set once drifts as prices and order volume change. The same vendor article calls “a monthly or quarterly batch update” the standard practice for recalculating tier status, and says monthly suits stores with more frequent purchases and quarterly suits categories where customers buy a few times a year. That is a vendor’s view. Our suggestion: review whenever your prices or product range change, and at least once a year.

Spend can change for reasons other than loyalty, such as a price rise that lifts everyone’s spend. Re-run the steps with fresh data each time, so the threshold keeps its meaning.

Step by step

  1. Pick the window

    Decide the period spend is added over, such as all time or the last 12 months, and write it down.

  2. Add up spend per person

    Total each person’s spend over the window, joining profiles that clearly belong to one person.

  3. Sort and choose a share

    Sort people from highest to lowest spend and choose the share you want as VIPs, for example the top 1 in 20.

  4. Read off the dollar figure

    The spend of the last person inside that share is your threshold.

  5. Check the count

    Count the people at or above the threshold. Compare that number with what you can afford to give perks to.

Self-assessment

Four questions about how you set VIPs today. Each answer is worth 0, 1 or 2 points. This is a self-check: nothing is stored or sent.

1. How did you set your VIP threshold?
2. Do you state the spend window?
3. Do you count spend per person?
4. How often do you review the threshold?

Add up the points beside your answers (the highest total is 8) and find your total in the list below.

0 to 2: Start with your spend distribution

Sort your customers by spend and see where the top group begins. That gives you a threshold based on your store.

See MergeGuard’s VIP audience

3 to 5: Add the window and the people count

State the period spend is added over, and add up spend across each customer’s profiles.

See how split profiles hide your VIPs

6 to 8: Put the review on a schedule

You have the method. A regular review keeps the threshold matched to your store as it changes.

Compare lifetime and 12-month windows

Sources