This page teaches how to assemble a complete customer data and loyalty worksheet, for a domestic retail buyer, a brand-side contact, or anyone about to launch or review a loyalty programme. This lesson mainly teaches the decision flow: it draws the data-field check from Lesson 1, the segmentation from Lesson 2, the repeat-customer-value comparison from Lesson 3, and the reward test from Lesson 4 into one working sheet, so a single programme decision can be checked against all four tools at once rather than one at a time in isolation. A buyer who applies these tools separately, on different documents, at different times, can lose track of how they connect, and can approve a programme that passes one check while failing another.
You need: the tools from Lessons 1 to 4 of this course: which data fields a loyalty programme needs, purchase-behaviour segmentation, repeat-customer value against acquisition cost, and the behaviour-change test for a reward.
By the end of this lesson you can:
Not covered here: each individual tool in full depth; Lessons 1 to 4 of this course cover the data-field check, segmentation, repeat-customer value, and the reward test in detail.
| Term | Meaning |
|---|---|
| Combined loyalty check | Reviewing a proposed loyalty programme against all four of this course's own tools together, rather than checking only one. |
| Linked worksheet | A workbook where one sheet's own output feeds into another sheet's own calculation, so a change in one place updates the whole picture. |
| Programme decision | The single approve, adjust, or reject choice a business makes about a loyalty programme, informed by every check that applies to it. |
| Data-field check | Confirming a proposed loyalty programme collects only the customer data fields it actually uses, from Lesson 1. |
| Segment fit | Whether a proposed loyalty programme's own reward and messaging suit the real purchase-behaviour segment it targets, from Lesson 2. |
| Value gap | The difference between a repeat customer's own calculated value and a reward's own net cost, once acquisition cost and reward testing are both accounted for. |
Each of the first four lessons in this course teaches one check on its own: what data to collect, how to segment customers, what a repeat customer is worth against acquisition cost, and whether a reward actually changes behaviour. A combined loyalty check brings all four together in one linked worksheet, so a single programme decision reflects every check that applies, rather than approving a programme that passes one test while quietly failing another that nobody looked at.
| What can differ | The shapes you meet | Why it matters |
|---|---|---|
| A brand-new programme vs. a programme already running | A brand-new programme, like Fairway Stores' own launch in Lesson 1, needs the data-field check applied before any data is collected; a programme already running, like the reward tested in Lesson 4, needs the reward test applied to real results | A running programme can still fail the data-field check retroactively if it collects fields it never uses, which is worth reviewing periodically, not only at launch |
| Domestic hybrid retailer vs. export MTO/agent-managed programme | A domestic hybrid retailer such as Cedar & Co. reviews its whole programme itself on one combined worksheet; an export MTO business working through an agent such as Meridian Sourcing may run separate reward tests per market before combining results centrally | An export business combining results across markets should confirm each market's own comparison group was genuinely comparable before combining figures |
| A programme failing only one of the four checks | A programme can pass the data-field check and segment fit but fail the reward test, showing a real cost with no behaviour change | A single failing check is enough reason to adjust a programme, even if the other three checks pass cleanly |
| A programme reviewed only once, at launch | A business checks a programme against all four tools once, then never revisits it as customer behaviour, costs or competition change | Repeat-customer value, acquisition cost and reward effectiveness can all shift over time; a one-time check at launch does not stay valid indefinitely |
| Product families | The same four checks apply whether the loyalty programme covers apparel, socks and hosiery, knit-to-garment, terry and towels, or home textiles and bedding | A retailer building its first combined worksheet should enter its own real figures for whichever product family the programme covers, not assume another family's figures apply |
Cedar & Co., a domestic brand with 12 shops selling a style equivalent in value to Order A at USD 19.90 per piece, cost USD 8.00, has drafted a loyalty programme: a sign-up form collecting purchase history, a loyalty card number, and an email address; segments built from real order data into repeat and occasional shopper groups; a calculated repeat-customer value of USD 214.20 over three years against a USD 300 acquisition cost; and a proposed 10% next-purchase reward, not yet tested against a comparison group.
Before launch, Omar wants to see all four checks on one sheet, rather than reviewing four separate documents, to judge whether the whole programme is ready.
The worked numberThree of the four checks give Cedar & Co. a clear answer; the fourth cannot be answered at all yet, since the reward has not been tested against any comparison group. A combined worksheet makes this gap visible in one place, rather than letting an untested reward slip through because the other three checks looked fine on their own.
A common mistake is launching a programme because most of its own checks passed, treating an untested or caution-flagged check as a minor gap rather than an open question. If Cedar & Co. launched its reward at full scale because the data-field check, segment fit, and repeat-customer-value caution all looked broadly acceptable, without first running the comparison-group test Lesson 4 requires, it would be committing to a reward's own cost without knowing whether that reward changes any behaviour at all.
Bringing every tool from this course onto one sheet means a business can see, at a glance, whether a proposed loyalty programme collects the right data, groups customers sensibly, is worth its own cost against acquisition, and actually changes behaviour, rather than checking each one on a separate document and losing track of how they fit together. On Cedar & Co.'s own proposed programme, three checks pass, one shows a value gap worth watching, and one, the reward test, has not been run at all; a combined worksheet makes all four visible at once, so none of them gets missed before launch.
Cedar & Co.'s own marketing team has submitted a launch recommendation, noting that the data-field check, segment fit, and repeat-customer-value review are complete, and proposing to launch the 10% reward at full scale across all 12 shops without first running a smaller comparison-group test. The facts in front of Omar:
The note attached to the marketing team's own recommendation:
Should Omar approve the full-scale launch based on three completed checks, treating the untested reward as ready? Decide before you open the decision.
No. Omar should hold the reward for a smaller comparison-group test before any full-scale launch, regardless of the other three checks passing.
Two facts decide this. First, this lesson's own rule states a combined decision checks all four tools together, and the worked number shows check 4 has not been completed at all, not merely flagged with a caution like check 3. Second, this lesson's own trap warns exactly against treating an untested check as ready because the others passed; Lesson 4's own method requires a genuine comparison group before crediting a reward with any behaviour change, and that step has not yet happened.
Approving a full-scale launch now would commit Cedar & Co. to the reward's own full cost across all 12 shops before knowing whether the reward changes any customer's own behaviour at all, the exact risk this course's own fourth lesson was built to catch.
The exact cost at stake depends on how many of Cedar & Co.'s own 12 shops' customers receive the reward and how many purchases they make, figures the worksheet's own reward-test sheet is built to capture once the comparison-group test runs. What matters before launch is not the exact number, but the fact that it is currently unknown, since check 4 has not been completed.
Use the T23-C04 Customer data and loyalty worksheet. Enter the proposed programme's own data fields, segment figures, repeat-customer value and acquisition cost, and reward-test results into the sheet's own four linked pages; the combined view shows all four results together, so a launch decision reflects every check this course teaches, not just the ones already completed.
[Download the Customer data and loyalty worksheet](../../templates/T23-C04-customer-data-and-loyalty-worksheet.xlsx)
1. Why does a combined worksheet check a proposed programme against all four tools together, rather than one at a time?
2. Cedar & Co.'s reward test has not been run against any comparison group. How should this be marked?
3. A retailer's combined worksheet shows all four checks passing at launch. Six months later, acquisition cost has risen sharply. What should the retailer do?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Combined loyalty check | فحص الولاء المُجمَّع | Vérification combinée de la fidélité | Birleşik sadakat kontrolü | Reviewing a proposed loyalty programme against all four of this course's own tools together, rather than checking only one. |
| Linked worksheet | ورقة عمل مترابطة | Fiche de travail liée | Bağlantılı çalışma sayfası | A workbook where one sheet's own output feeds into another sheet's own calculation, so a change in one place updates the whole picture. |
| Programme decision | قرار البرنامج | Décision de programme | Program kararı | The single approve, adjust, or reject choice a business makes about a loyalty programme, informed by every check that applies to it. |
| Data-field check | فحص حقول البيانات | Vérification des champs de données | Veri alanı kontrolü | Confirming a proposed loyalty programme collects only the customer data fields it actually uses, from Lesson 1. |
| Segment fit | ملاءمة الشريحة | Adéquation du segment | Segment uyumu | Whether a proposed loyalty programme's own reward and messaging suit the real purchase-behaviour segment it targets, from Lesson 2. |
| Value gap | فجوة القيمة | Écart de valeur | Değer farkı | The difference between a repeat customer's own calculated value and a reward's own net cost, once acquisition cost and reward testing are both accounted for. |
This is the final lesson of Course 4, Customer Data, CRM and Loyalty. You have now covered which customer data a loyalty programme actually needs, segmenting customers by real behaviour, calculating repeat-customer value against acquisition cost, and testing whether a reward changes behaviour, brought together into one complete worksheet. Back to the course map