1-- capability 01 — segmentation
2SELECT
3 rfm_score(id) AS rfm,
4 value_tier(rfm) AS tier,
5 churn_probability(id) AS p_churn
6FROM customers
7WHERE email_consent = true
8 AND last_order_at > now() - interval '400 days';
9
10-- 24 segments live · champions 2,114 · at-risk 312
Know exactly who they are
Segmentation
One customer file. Every customer treated like themselves.
RFM scoring — recency, frequency, monetary — fused with behavioral overlays: browse, cart, support, milestones. The file collapses into living value tiers: Champions, Loyal, At Risk, Hibernating, New. Refreshed nightly, synced to every channel, and owned by you — not held hostage in a vendor's audience tab.
What ships
- RFM scoring across the full customer file, nightly refresh
- Behavioral overlays: browse, cart, support, milestone events
- Cohort builds by acquisition source, product line and season
- Value tiers: Champions, Loyal, At Risk, Hibernating, New
- Synced to email, SMS, WhatsApp and paid — suppression included
How it feeds the machine
Segments are the ammunition. Every flow aims at a tier, every retention metric denominates against one. Without them, personalization is a first-name token.
24
RFM segments, nightly refresh