Chapter 4 of 7
20 min
Read the actual segment distribution and customer examples
Confirm the four segment counts and select a synthetic customer example to make each campaign action concrete.
Question for this chapter
Which groups actually exist, and which customer examples make their next action concrete?
Try it
Aggregate customer_analytics by segment, counting customers and summing total_spend.
| Segment | Customers | Total spend | Campaign role |
|---|---|---|---|
champion | 7 | $569.12 | Retention and recognition |
loyal | 11 | $439.18 | Repeat purchase and cross-sell |
new | 4 | $44.46 | Second-purchase onboarding |
at_risk | 0 | $0.00 | Do not launch for this sample |
The zero is not a calculation error. None of the 22 customers has both more than 30 days since their last order and at least two orders.
Read one customer from each group
| Customer | Segment | Orders | Total spend | Message draft |
|---|---|---|---|---|
| CUST-017 | champion | 7 | $106.44 | Recognition and early access for a frequent customer |
| CUST-025 | loyal | 4 | $62.47 | Suggest an item that complements the latest purchase |
| CUST-089 | new | 1 | $13.99 | Usage guidance and a second-order introduction |
These are workshop campaign hypotheses. Contact consent, channel eligibility, and frequency caps are not present in the scenario, so this table is not a send list.
Next decision
You selected three groups and customer examples. Next, confirm their scale on the dashboard and include the current purchase-graph limitation in the campaign draft.