Customer segmentation analysis: groups that change the next offer
Work through twelve fictional customer records, reconstruct transparent group rules and summaries, inspect a cutoff change, and decide what the account team should investigate next.
Customer segmentation analysis groups customers using relevant evidence, checks how those groups differ in a decision that matters, and defines how to assign customers before tailoring an offer.
For a subscription business, an account team may need to help customers place another order or make replenishment easier for active buyers. The analysis must identify customers before the intervention and explain why the offers should differ. The twelve illustrative records below let you inspect assignment and evaluation separately.
Assignment uses information available at the cutoff
The twelve customer records below and copyable CSV record orders completed in the previous 90 days, average order value in dollars and whether the customer renewed in the subsequent period. Use the values to reconstruct the analysis, not to forecast renewals.
All twelve customer records
Renewal is coded 1 for renewed and 0 for did not renew. Every row has example_status=fictional. Retain renewal separately from the past-order inputs used to assign the group.
Customer | Recorded values |
|---|---|
F01 | Orders in previous 90 days: 1 Average order value, USD: 20 Renewed in subsequent period: 0 |
F02 | Orders in previous 90 days: 1 Average order value, USD: 30 Renewed in subsequent period: 0 |
F03 | Orders in previous 90 days: 1 Average order value, USD: 40 Renewed in subsequent period: 1 |
F04 | Orders in previous 90 days: 1 Average order value, USD: 30 Renewed in subsequent period: 0 |
F05 | Orders in previous 90 days: 2 Average order value, USD: 25 Renewed in subsequent period: 1 |
F06 | Orders in previous 90 days: 2 Average order value, USD: 35 Renewed in subsequent period: 0 |
F07 | Orders in previous 90 days: 3 Average order value, USD: 45 Renewed in subsequent period: 1 |
F08 | Orders in previous 90 days: 3 Average order value, USD: 35 Renewed in subsequent period: 0 |
F09 | Orders in previous 90 days: 4 Average order value, USD: 30 Renewed in subsequent period: 1 |
F10 | Orders in previous 90 days: 4 Average order value, USD: 40 Renewed in subsequent period: 1 |
F11 | Orders in previous 90 days: 5 Average order value, USD: 50 Renewed in subsequent period: 1 |
F12 | Orders in previous 90 days: 6 Average order value, USD: 40 Renewed in subsequent period: 0 |
Copy the complete customer CSV
customer_id,orders_last_90_days,average_order_value_usd,renewed_next_period,example_status
F01,1,20,0,fictional
F02,1,30,0,fictional
F03,1,40,1,fictional
F04,1,30,0,fictional
F05,2,25,1,fictional
F06,2,35,0,fictional
F07,3,45,1,fictional
F08,3,35,0,fictional
F09,4,30,1,fictional
F10,4,40,1,fictional
F11,5,50,1,fictional
F12,6,40,0,fictional
The business question is whether an account team should offer replenishment convenience or investigate an obstacle to the next order. Define the groups using recorded past orders only:
- Starter: one order in 90 days.
- Occasional: two or three orders.
- Frequent: four or more orders.
Average order value describes the groups. Later renewal is a held-out outcome; it is never an input to these rules.
Group | Details |
|---|---|
Starter | Customers: 4 Mean order value: $30 Subsequent renewals: 1 of 4 |
Occasional | Customers: 4 Mean order value: $35 Subsequent renewals: 2 of 4 |
Frequent | Customers: 4 Mean order value: $40 Subsequent renewals: 3 of 4 |
For Starter, the mean is ($20 + $30 + $40 + $30) ÷ 4 = $30. The renewal pattern is a property of this example dataset. Four customers per group cannot establish a dependable commercial response.
Order count is an assignment variable, average order value describes the resulting groups, and later renewal is an evaluation outcome. If you create “loyal” customers by including future renewal, then show that loyal customers renew more, the apparent validation is circular.
Keep an input cutoff and a reproducible customer-level record. A group should be assignable when the business needs to act. One recorded order in 90 days does not establish a first-ever purchase. If guest or marketplace purchases are absent, mark that coverage issue; otherwise Starter may describe tracking rather than activity. Our behavioral segmentation guide develops ordered account rules and record checks.
The Starter label needs an explanation
Assignment: one completed order in the prior 90 days; four accounts. Profile: mean order value USD 30; one later renewal. Question: what happened after the most recent delivery and before the next order opportunity?
Offer choice: compare replenishment help with usage support after investigating timing, unused stock and the product experience. Owner: the account team, using reachable customer identifiers. Evaluation: subsequent repeat orders in a new period with intervention exposure and comparison conditions recorded. The historical 1/4 renewal count motivates the question; it does not select a proven intervention.
One previous order can mean several different situations: the product has not run out, usage was difficult, the buyer bought elsewhere, or the first occasion was not recurring. These are hypotheses to investigate, not findings from the twelve rows. A replenishment reminder serves only some of them.
Ask about the time between the most recent delivery and the next order opportunity, then map the explanation to a feasible intervention. Usage support may be more useful than a reminder when unused stock remains. The analysis makes the recruiting rule explicit; the needs work explains the offer difference.
Keep the existing rule while investigating. Redefining Starter after seeing which people like a reminder would turn the group into the desired result. When you decide to change the rule, save a new version and explain why the information improves assignment.
Evaluate the grouping in a future period
The order-count rule is simple enough to assign without looking at renewal. Save the 90-day input cutoff, each customer’s order count and the group version. The subsequent renewal period must begin after that cutoff; using future information to revise the original assignment would leak the outcome into the grouping.
Analysis stage | Details |
|---|---|
Define | Input allowed: Past orders and intended business decision Output to retain: Starter/Occasional/Frequent cutoffs |
Assign | Input allowed: Records available at the cutoff Output to retain: Customer-level group and unknown cases |
Describe | Input allowed: Order value and source coverage Output to retain: Group distributions and actual bases |
Evaluate | Input allowed: Later outcomes or new evidence Output to retain: Differences with uncertainty and context |
Activate | Input allowed: Feasible reach and candidate action Output to retain: Delivered intervention and future comparison |
The renewal gradient of one, two and three renewals out of four does not prove that differentiated offers cause renewal. It describes the later outcome of these groups. To evaluate the intervention, record its exposure and an appropriate comparison among eligible customers.
A segment can be analytically stable but operationally useless if the team cannot reach its members or deliver a meaningful difference. Conversely, a modest rule can earn its place when it helps the account team identify a real task and consistently supply the right support.
A boundary change needs a complete assignment rule
Raising the Frequent cutoff from four to five orders removes F09 and F10 from that group, shrinking it from four customers to two. This is a sensitivity check, not an adopted replacement rule: the revised scheme leaves four-order accounts unresolved until their assignment is specified. Inspect whether their needs differ from the remaining frequent buyers or the label is responding to an arbitrary count. Keep full distributions and the buying cycle in view.
An offer that changes every time an order crosses a cutoff may create a worse customer experience than a stable rule. Consider the purchase window and update cadence the business can operate. A name should describe what the rule measures: “four-plus completed orders” is more defensible than “high-value loyalists” when loyalty has not been defined.
Choose the least complicated rule that supports the action. Complexity is valuable when it adds a need or reachability distinction that a simpler scheme misses. Our segmentation guide explains how that difference should change the offer or strategy.
When clustering is worth commissioning
Use clustering when multiple relevant variables resist a simple rule. Decide how to scale variables, handle missingness and compare alternative group counts. K-means, for example, groups numeric observations around centroids and favors certain geometries; it is not a universal fit for mixed survey and transaction data. See the official scikit-learn clustering documentation for algorithm assumptions.
Fit the grouping on one dataset, document it and inspect a separate period or sample. Do not select the version solely because it tells the most attractive story. A statistical separation score also does not prove that customers need different offers.
Ask the analyst what variables the model uses and why those variables belong to the decision. Review how the variables were scaled and why that treatment fits the decision. Missing values need a declared treatment. Group count and algorithm choice should be inspected against the business task as well as mathematical separation.
Review examples from each group, boundary cases and a later period or held-out sample. Then ask whether the groups can be assigned from data available before the action. A statistical cluster is a starting point for interpretation, not proof that its members need the same message.
The acceptance test for the account team
A usable handoff names the assignment rule or model version and the real source base. Include the defining variables, needs evidence, unknown cases and reachable identifiers, followed by the proposed action and next evaluation. For Starter, the brief points to a next-order investigation. For frequent buyers, the question is whether replenishment fits how they already buy.
Accept the grouping when another person can reproduce it, the business can identify members in time and the proposed offer difference has a reason beyond the label. Reject or simplify it when those conditions fail. This is what the analysis must deliver before activation.
A Vensia study can compare modeled responses to replenishment help and usage support across the buying situations suggested by the Starter investigation. Bring the declared membership rule, complete offers, known record coverage and the new-period outcome the account team will use.
