Course contents
Practitioner · Course 4: Customer Data, CRM and Loyalty · Lesson 2 of 5

Segmenting customers by real purchase behaviour, not by guesswork

Level: PractitionerTime: 45 minutesOrder used: A (the T-shirt, bought by Delta Garments' own export buyer accounts)Tool: Customer data and loyalty worksheet
For a factory-side merchandiser or account manager who has more than one buyer account and needs to group them by what they actually order, not by an assumption about which account matters most. Lesson 4.1 is useful preparation, though not required. Figures are teaching figures.
FactoryDelta Garments (10th of Ramadan, Egypt)
Buyer account, high-frequencyNorthline Apparel
ProductOrder A, the T-shirt
Construction180 GSM single jersey, Ne 30/1 combed cotton
Quantity15,000 pieces per confirmed order
Business modelMade to Order, export, buyer accounts placed as separate confirmed orders
02Opening

This page teaches a factory-side merchandiser how to group its own buyer accounts by real order behaviour, rather than by which account happens to feel most important

This page teaches how to segment customers, in a factory's own case its buyer accounts, using real order data rather than guesswork, for a merchandiser, an account manager, or a domestic retail buyer building segments for the first time. This lesson mainly teaches the information flow: it shows how to group accounts by order frequency and order value so a factory's own staffing and follow-up effort go where the real numbers say they should, not where an assumption points. A merchandiser who segments accounts by memory or by which contact calls most often risks under-serving a large, quiet buyer account and over-serving a small, vocal one, without ever checking the underlying order data to see which grouping actually reflects reality.

03Before you start

You need: an understanding of which customer data fields a scheme actually needs, covered in Lesson 4.1, and access to a factory's own order history by buyer account.

By the end of this lesson you can:

  • explain why customers should be segmented by real order behaviour rather than by assumption;
  • calculate order frequency and order value for a stated buyer account, from its own order history;
  • assign a buyer account to a segment using its own frequency and value figures, not a guess about its importance;
  • decide which segment a newly reviewed buyer account belongs to, given its own order history.

Not covered here: which customer data fields a loyalty programme actually needs (Lesson 1), calculating the value of a repeat customer against the cost of acquiring a new one (Lesson 3), deciding whether a reward actually changes behaviour (Lesson 4), and building a complete customer data and loyalty worksheet (Lesson 5).

04Key terms

Words you will meet in this lesson

TermMeaning
Purchase-behaviour segmentA group of customers, or buyer accounts, sharing a similar real pattern of order frequency and order value, used to decide where follow-up effort goes.
Order frequencyHow often a specific customer or buyer account places a confirmed order, over a stated period.
Order valueThe total value of the orders a specific customer or buyer account has actually placed, over a stated period.
Repeat accountA buyer account that has placed more than one confirmed order with the same factory over time.
One-off accountA buyer account that has placed a single confirmed order and has not returned with a further order since.
Guesswork segmentationGrouping customers by assumption, memory or which contact is most vocal, rather than by their own recorded order data.
05Teaching
The rule

A customer or buyer account should be segmented by its own real order frequency and order value, never by an assumption about which account feels most important

Segmenting customers means grouping them so that a business can decide where to put its own limited follow-up effort. Order frequency and order value, both taken from a customer's own actual order history, are the two figures a real segmentation is built from. A segmentation built instead on guesswork, whichever buyer account calls most often, or whichever name a merchandiser remembers best, usually does not match the real pattern in the order data, and a business acting on it can misallocate its own attention.

Segmentation from real order dataOrder frequency, from order historyOrder value, from order historySegmentation from guessworkWhich account calls most oftenWhich name a merchandiser remembers
A segmentation built on order frequency and order value reflects the actual accounts; a segmentation built on memory or contact frequency does not. The two figures on the left come from recorded order history; the two on the right do not, however confident they feel.
What you meet in real life

Segmenting by real order behaviour differs by whether the customer is a wholesale buyer account, a shop customer, a factory or a mill

What can differThe shapes you meetWhy it matters
A factory segmenting its own buyer accounts vs. a retailer segmenting its own shop customersA factory such as Delta Garments segments a small number of large, named buyer accounts by their own order history; a retailer such as Fairway Stores segments thousands of individual shop customers by their own purchase historyA factory's segmentation can be reviewed account by account; a retailer's segmentation usually needs the accounts grouped automatically, since no person reviews thousands of customers one at a time
Export MTO buyer accounts vs. domestic MTS/hybrid customersAn export MTO buyer account places full, separate confirmed orders with no reorder inside a season; a domestic hybrid customer buys smaller, more frequent amounts and can reorder mid-seasonOrder frequency looks different by design between the two; a segmentation must compare accounts of the same shape against each other, not an MTO account against a hybrid one on frequency alone
A buyer account with high value but low frequencyA buyer account that places one very large confirmed order a year has high order value and low order frequency at the same timeOrder value and order frequency are two separate figures; a segment built on only one of them can misjudge an account that is strong on the other
A newly won buyer account with no order history yetA first-time buyer account has no order history to segment by, since it has not yet placed a confirmed orderA newly won account is provisionally placed pending its first order, then re-segmented once real order data exists, never assigned to a segment on assumption alone
Product familiesThe same segmentation method, real order frequency and order value, applies whether the accounts buy apparel, socks and hosiery, knit-to-garment, terry and towels, or home textiles and beddingA factory serving more than one product family should segment each buyer account on its own combined order history, not by product family alone
The case we follow

Delta Garments reviews its own order history for three export buyer accounts to decide how its account management team should split its attention

Delta Garments, a garment factory at the 10th of Ramadan, Egypt, that makes Order A's own T-shirt style along with other styles, reviews the order history of three of its own export buyer accounts over the past two years: Northline Apparel, which has placed four confirmed orders of about 15,000 pieces each; a second, smaller European buyer account that has placed two confirmed orders of about 6,000 pieces each; and a third buyer account that placed one confirmed order of about 4,000 pieces and has not returned since.

Delta Garments' own account management team currently splits its attention roughly equally across the three accounts, since all three currently have an active named contact. Before the next planning cycle, Delta Garments' own merchandising manager wants to check whether that even split matches what the order history actually shows.

The worked number

Northline Apparel's own order history shows four times the order frequency and more than double the order value of the smaller repeat account

Northline Apparel: 4 confirmed orders over 2 years, about 15,000 pieces each at USD 3.20 FOB
Order frequency = 4 orders ÷ 2 years = 2 orders per year
Value per order = 15,000 × 3.20 = USD 48,000
Order value = 48,000 × 4 = USD 192,000 over 2 years
Second buyer account: 2 confirmed orders over 2 years, about 6,000 pieces each at USD 3.20 FOB
Order frequency = 2 orders ÷ 2 years = 1 order per year
Value per order = 6,000 × 3.20 = USD 19,200
Order value = 19,200 × 2 = USD 38,400 over 2 years
Third buyer account: 1 confirmed order, about 4,000 pieces at USD 3.20 FOB, no repeat since
Order frequency = 1 order ÷ 2 years = 0.5 orders per year
Order value = 4,000 × 3.20 = USD 12,800 over 2 years

The order history shows Northline Apparel placing orders twice as often as the second account and four times as often as the third, and an order value five times larger than the second account and fifteen times larger than the third, over the same two years. Splitting account management attention roughly equally across all three, as Delta Garments' own team currently does, does not match this pattern.

Northline Apparel: order value USD 192,000 over 2 years, 4 ordersSecond account: order value USD 38,400 over 2 years, 2 ordersThird account: order value USD 12,800 over 2 years, 1 order, no repeat
Northline Apparel's own bar is far longer than the other two accounts' own bars. Order value and order frequency, both taken from real order history, show a clear difference in scale between the three accounts that an equal split of attention does not reflect.
The method

Four steps to segment a customer or buyer account by its own real order behaviour

  1. Pull each account's own order history over a stated period, not a memory of how often it seems to order.
  2. Calculate order frequency and order value separately for each account, since a strong figure on one does not guarantee a strong figure on the other.
  3. Compare accounts of the same shape against each other, export against export or domestic against domestic, rather than mixing shapes in one comparison.
  4. Assign each account to a segment, such as repeat high-value, repeat lower-value, or one-off, based on where its own two figures place it.
The trap

A common mistake is segmenting customers by which one calls most often or feels most familiar, rather than by their own recorded order data

A common mistake is letting the loudest or most familiar buyer account shape a factory's own view of which customer matters most, without checking the order history that would confirm or correct that impression. If Delta Garments continued splitting its account management attention equally across all three accounts based on how familiar each contact feels, rather than on the order history above, it would risk under-serving Northline Apparel, the account actually driving the largest share of order value and frequency, while spending equal effort on an account that has not placed a repeat order in two years.

06In plain words

Grouping customers by what they have actually ordered, how often and for how much, gives a business a real picture of where its attention should go. Grouping them instead by memory, by which contact calls most, or by which name feels most important, often does not match that real picture. On Delta Garments' own three export buyer accounts, Northline Apparel orders twice as often and for far more value than the second account, and four times as often as the third account, which has not placed a repeat order at all; an equal split of attention across the three does not reflect any of this.

07Quick check
  • Segment customers by real order frequency and order value, taken from their own order history.
  • Order frequency and order value are two separate figures; a strong one does not guarantee a strong other.
  • Compare accounts of the same shape, export against export or domestic against domestic, not mixed together.
  • A newly won account with no order history is placed provisionally, then re-segmented once real data exists.
  • Guesswork segmentation, built on memory or which contact is loudest, often does not match the real order data.
  • A factory usually reviews a small number of named accounts by hand; a retailer usually needs its many shop customers grouped automatically.
08Workplace scenario

Delta Garments' account management team proposes keeping its equal three-way split of attention for the coming year, before reviewing the order history above

Delta Garments' own merchandising manager has received the account management team's proposal for the coming year's staffing plan. The facts in front of the merchandising manager:

  • The proposal splits account management attention roughly equally across Northline Apparel, the second buyer account, and the third buyer account.
  • The order history shows Northline Apparel with four times the order frequency and fifteen times the order value of the third account over the past two years.
  • The third account has not placed a repeat order since its single confirmed order two years ago.

The note attached to the account management team's own proposal:

Delta Garments, internal account management note. "Recommend continuing the current equal split of account management time across all three export buyer accounts for the coming year, based on each account's active named contact."

Should the merchandising manager approve the equal three-way split as proposed? Decide before you open the decision.

Show decision

No. The merchandising manager should re-split account management attention to match the real order history, weighting it toward Northline Apparel.

Two facts decide this. First, this lesson's own rule states that segmentation should follow real order frequency and order value, and the worked number shows Northline Apparel far ahead of the other two accounts on both figures. Second, this lesson's own trap warns exactly against letting an equally familiar contact on each account justify an equal split of attention; the third account's own order history shows no repeat order in two years, a clear signal an equal split does not reflect.

Approving the equal split as proposed risks under-serving Northline Apparel, the account actually driving the largest share of Delta Garments' own export order value, while spending unjustified equal effort on an account that has not returned.

09What it costs

An equal three-way split of attention gives Northline Apparel the same share of account management time as an account worth 15 times less

Northline Apparel's own share of the three accounts' combined order value = 192,000 ÷ (192,000 + 38,400 + 12,800) = 79%
Third account's own share of the three accounts' combined order value = 12,800 ÷ 243,200 = 5%
Equal split gives each account 33% of account management attention, regardless of its own 79% or 5% share of value

Under the proposed equal split, the account responsible for 79% of the combined order value receives the same account management attention as the account responsible for only 5%. This mismatch does not show up as a single lost dollar figure the way a markdown does, but it is a real misallocation of a scarce resource, the account management team's own time, away from where the order history says it should go.

10Working template

Customer data and loyalty worksheet: calculate order frequency and order value for each account and assign it to a segment

Use the T23-C04 Customer data and loyalty worksheet. For Delta Garments' own three buyer accounts, enter each account's own order count, quantity and FOB price over the review period, and the sheet calculates order frequency and order value and flags which segment each account falls into, so the split of attention can follow the real data rather than a guess.

[Download the Customer data and loyalty worksheet](../../templates/T23-C04-customer-data-and-loyalty-worksheet.xlsx)

Download the Customer data and loyalty worksheet (Excel)

11Check yourself

1. Why should a factory segment its own buyer accounts by real order frequency and order value, rather than by which contact calls most often?

2. A buyer account places one very large confirmed order a year and no other orders. How should its order frequency and order value be read?

3. A fourth account: 3 orders over 1 year, each worth USD 20,000. How does it compare with the third account above, 1 order worth USD 12,800, no repeat in 2 years?

12Glossary
ENARFRTRMeaning
Purchase-behaviour segmentشريحة السلوك الشرائيSegment de comportement d'achatSatın alma davranışı segmentiA group of customers, or buyer accounts, sharing a similar real pattern of order frequency and order value, used to decide where follow-up effort goes.
Order frequencyتكرار الطلبFréquence de commandeSipariş sıklığıHow often a specific customer or buyer account places a confirmed order, over a stated period.
Order valueقيمة الطلبValeur de commandeSipariş değeriThe total value of the orders a specific customer or buyer account has actually placed, over a stated period.
Repeat accountحساب متكررCompte récurrentTekrarlayan hesapA buyer account that has placed more than one confirmed order with the same factory over time.
One-off accountحساب لمرة واحدةCompte ponctuelTek seferlik hesapA buyer account that has placed a single confirmed order and has not returned with a further order since.
Guesswork segmentationالتقسيم بالتخمينSegmentation par suppositionTahmine dayalı segmentasyonGrouping customers by assumption, memory or which contact is most vocal, rather than by their own recorded order data.
13Next

Lesson 4.3: Calculating the value of a repeat customer against the cost of acquiring a new one

You now know how to group customers, or buyer accounts, by their own real order behaviour rather than by guesswork. The next lesson uses that same real-behaviour thinking on a domestic retail customer, calculating what a repeat customer is worth against what it costs to win a new one. Back to the course map

14Ladder

RecognizeName order frequency and order value as the two figures a real segmentation is built from.
ConnectSee why guesswork segmentation often does not match a factory's own real order history.
CompareTell a repeat account apart from a one-off account using its own recorded orders.
DecideJudge which segment a reviewed buyer account belongs to, based on its own order history.