🎯 Smart Segmentation Engine
Smart Audience Segmentation
Target the right people with the right message at the right time. Reach high-value VIPs, re-engage lapsed buyers, and convert prospects into loyal customers using RFM scoring, lifecycle stages, and geographic precision.
Total Segments
16
Across RFM, lifecycle & geo
Largest Segment
4,227
Silver Growing
Avg Segment Size
1,445
Across RFM tiers
RFM Segments Active
4
Platinum, Gold, Silver, Bronze
Pre-built Segments
RFM-powered audiences pulled from WooCommerce order data
RFM Value Tiers
Platinum
Spend €500+, 2+ orders. Avg spend €605.88 | Projected 12m CLV: €1,031. Top buyers — Mark Tyrrell, Niall Farrell, Peter Williamson.
Gold
Spend €200–€499, avg 1.6 orders. Avg spend €278.55 | Projected 12m CLV: €494. High-loyalty repeat buyers worth nurturing to Platinum.
Silver
Spend €75–€199, avg 1.0 orders. Total segment revenue €363,800. Largest buyer group — ideal for upsell and cross-sell sequences to lift into Gold tier.
Bronze
1 order, spend under €75. Avg spend €53.21 | Projected 12m CLV €79.81. First purchase made — focus on second-order conversion with targeted follow-up sequences.
Pre-purchase
Subscribed but no purchase recorded. Warm leads with Irish identity or diaspora interest. First-purchase incentive sequences — discount codes, social proof, bestsellers.
AOV €150+
US and Australian buyers with AOV over €150. Diaspora gifting segment — high spend per order, often purchasing GAA merchandise and heritage items for family.
Lifecycle Stages
Active
Ordered within the last 90 days. Highest engagement window — ideal for upsells, complementary products, loyalty programme invitations.
Lapsed
90–365 days since last order. At-risk of churn — deploy win-back sequences: personalised offers, "We miss you" messages, best-seller highlights.
Dormant
365+ days since last order, never re-engaged. Final win-back attempt before list suppression. Aggressive offer, final goodbye email, or sunset flow.
New
Subscribed in the last 30 days, never purchased. Critical 30-day welcome window — send onboarding sequence, brand story, bestsellers, first-purchase incentive.
Geographic Audiences
US-based Irish diaspora. High AOV, gifting intent. Best segment for premium GAA and heritage product campaigns.
UK and Northern Ireland buyers. Post-Brexit shipping considerations. Strong market for GAA club merchandise.
AU, CA, and rest-of-world diaspora. Long lead times — plan shipping windows. Australian market shows strong GAA interest.
Sport Interest
GAA
Subscribers who purchased GAA merchandise — county jerseys, training gear, accessories. Core HubIrish audience segment.
Rugby
Subscribers with rugby product purchases — Ireland jerseys, provincial gear. Strong overlap with diaspora and Six Nations campaign windows.
Soccer
League of Ireland and Irish national team product buyers. Growing segment — target around Irish international fixtures and LOI season.
SQL Segment Builder
Copy these Listmonk SQL conditions directly into List → Advanced Segment Query
Gold Tier — Lapsed 60–180 days
Win-back high-value customers before they go fully dormant
-- Gold tier: spend €200-499, last order 60-180 days ago subscribers.attribs->>'rfm_segment' = 'gold' AND ( NOW() - (subscribers.attribs->>'last_order_date')::TIMESTAMPTZ ) BETWEEN INTERVAL '60 days' AND INTERVAL '180 days'
US Buyers — Spend >€150
High-AOV diaspora buyers in North America
-- US subscribers with average order value above €150 subscribers.attribs->>'country' = 'US' AND (subscribers.attribs->>'aov')::NUMERIC > 150
Never Purchased — Subscribed >30 Days
Warm leads past the welcome window — push to first purchase
-- Subscribed over 30 days ago, zero orders placed (subscribers.attribs->>'total_orders')::INT = 0 AND subscribers.created_at < NOW() - INTERVAL '30 days'
Platinum VIPs — All Active
Your highest-value customers for VIP-only campaigns
-- Platinum: spend €500+, 2+ orders subscribers.attribs->>'rfm_segment' = 'platinum' AND (subscribers.attribs->>'total_spend')::NUMERIC >= 500 AND (subscribers.attribs->>'total_orders')::INT >= 2
Lapsed Bronze — First-time buyers, 90–365 days
Encourage a second purchase before they go dormant
-- Bronze: 1 order, lapsed 90-365 days — second purchase push subscribers.attribs->>'rfm_segment' = 'bronze' AND (subscribers.attribs->>'total_orders')::INT = 1 AND ( NOW() - (subscribers.attribs->>'last_order_date')::TIMESTAMPTZ ) BETWEEN INTERVAL '90 days' AND INTERVAL '365 days'
Silver — GAA Sport Buyers
Mid-tier customers with GAA product interest
-- Silver tier buyers with GAA category purchases subscribers.attribs->>'rfm_segment' = 'silver' AND (subscribers.attribs->>'categories')::jsonb ? 'gaa'
Segment Performance
Revenue attribution and engagement metrics by RFM tier
| Segment | Size | Avg Spend | Total Revenue | Revenue Share | Proj. 12m CLV | Avg Orders | Status | Actions |
|---|---|---|---|---|---|---|---|---|
|
💎
Platinum VIPs
RFM Score: 9.8
|
40 | €605.88 |
€24,235
|
€1,031 | 2.1 | Platinum | Campaign | |
|
🥇
Gold Loyalists
RFM Score: 8.1
|
373 | €278.55 |
€103,899
|
€494 | 1.6 | Gold | Campaign | |
|
🥈
Silver Growing
RFM Score: 6.5
|
4,227 | €86.07 |
€363,801
|
€130 | 1.0 | Active | Campaign | |
|
🥉
Bronze First-timers
RFM Score: 4.9
|
1,140 | €53.21 |
€60,663
|
€80 | 1.0 | Growth | Campaign |
Total Attributed Revenue
€552,598.79