How to create and target average order value based segments

Last updated: July 22, 2025

Overview

Your business serves multiple "tiers" of customers who fall into different groups of average order values. Some customers consistently spend more than others, and these groups require unique messaging and content.

This article explains how to determine your brand's average order value bands and how to target each group.


Step One: Identify your brand's average order value quartiles

Before creating average order value (AOV) based segments you'll need to determine your brand's AOV quartiles, or the four "buckets" that encompass your customers' average order ranges.

Shopify users can use the following procedures to determine AOV bands:

  1. Make a copy of the AOV segment band calculator

  2. Generate the returning customers report and download the file to your desktop. This report pulls a list of customers and their AOV.

  3. In the AOV segment calculator, delete the example data in columns A and G (make sure you do not delete anything in the gray cells, I1:J4)

  4. Paste your returning customer report data

Your quartile bands are calculated in the gray cells to the right of your report data.

Make sure you update the formulas in column J

The AOV segment band calculator contains one hundred rows of example data. You need to update the formulas in cells J2-J5 to account for the rows in your export.

For example, if your export contains one thousand rows, you'll change $G$101 in each formula to $G$1000.

In the sample data from the AOV segment band calculator, the quartile bands are:

  1. Customers with $0.00 to $61.97 AOV

  2. Customers with $61.98 to $76.19 AOV

  3. Customers with $76.20 to $92.18 AOV

  4. Customers with greater than $92.19 AOV

In the next step, we'll create segments for each quartile band.

Step Two: Create segments for quartile bands

Create a segment for each quartile band using your eCommerce integration's Average Order Value condition.

Here's how our sample bands from step one look as segments:

Band 1: eCommerce integration > Customer > Average Order Value > is less than > 61.98 > all time

Screenshot 2025-07-22 at 3.12.18 PM.png

Band 2: eCommerce integration > Customer > Average Order Value > is greater than > 61.97 > all time, AND eCommerce integration > Customer > Average Order Value > is less than > 76.20 > all time

Screenshot 2025-07-22 at 3.17.44 PM.png

Band 3: eCommerce integration > Customer > Average Order Value > is greater than > 76.19 > all time, AND eCommerce integration > Customer > Average Order Value > is less than > 92.19 > all time

Screenshot 2025-07-22 at 3.18.51 PM.png

Band 4: eCommerce integration > Customer > Average Order Value > is greater than > 92.18 > all time

Screenshot 2025-07-22 at 3.19.41 PM.png

Step Three: Develop campaigns for your AOV bands

Tailor your SMS and email campaigns to strategies that are best for each band:

Quartile

Description

Strategy

Avoid

Quartile 1

New or low-spending customers

Promote low-cost items, entry-level bundles, and onboarding content. Encourage minimum spend thresholds.

High-priced products, complex catalogs

Quartile 2

Early loyalty, modest spend

Use bundle or volume incentives, simple urgency (limited-time or low-stock), reinforce value.

Over-personalized content, VIP-tier messaging

Quartile 3

Consistent mid-to-high spenders

Offer early access, cross-category recommendations, and preview loyalty benefits.

Generic campaigns, irrelevant product suggestions

Quartile 4

Top spenders, highly engaged

Prioritize exclusivity, SMS for urgency, and curated high-value product selections.

Broad promotional content, discount-heavy messaging