Explain the campaign decision with evidence
Return to the re-engagement question and explain both the audiences with campaign drafts and the work to hold.
Question for this chapter
Which customers should you re-engage, and what should not happen yet?
Complete the solution
| Initial problem | Applied solution | Verified result or limitation | What changed |
|---|---|---|---|
| Source orders contained missing values. | Removed seven missing amounts and five missing customer IDs, then assigned the temporary PRD-UNKNOWN identifier to two rows missing product IDs. | 88 clean rows, 2 PRD-UNKNOWN rows | Valid purchases and unknown products are distinct. |
| Customer state was too vague. | Classified with recency, frequency, and monetary value (RFM) metrics. | 22 customer rows | Each label has an explainable rule. |
| All four groups were assumed to exist. | Counted the actual 7, 11, 4, and 0 distribution. | Zero at_risk customers | The at_risk campaign draft is on hold because there is no current audience. |
| Personalization with purchased products was desired. | Materialized the purchase graph and isolated unknown products in one node. | 22 customers, 88 orders, 9 products | Only known products become relationship evidence. |
State the final decision
JaffleMart will prepare recognition and retention for seven
championcustomers, repeat-purchase suggestions for elevenloyalcustomers, and second-purchase onboarding for fournewcustomers. It will not prepare anat_riskcampaign draft because that group is empty. Known-product purchase paths can support personalization, whilePRD-UNKNOWNrelations remain excluded until resolved.
Completion criteria
- Reduced 100 source orders to 88 cleaned rows.
- Can explain when to remove a missing value and when to assign the temporary
PRD-UNKNOWNidentifier. - Can explain recency, frequency, and monetary value (RFM) in plain language.
- Confirmed the 7, 11, 4, and 0 segment distribution.
- Drafted campaigns for the three groups that exist and held back
at_risk. - Confirmed seven purchase paths for CUST-017.
- Excluded unknown-product relations from product personalization.
Apply next
A real campaign also needs customer consent, reachable channels, recent-contact frequency, margin, and experiment groups. When that data is unavailable, record it as a prerequisite for the next decision instead of filling the gap with an estimate.