← All analytics projects
05
Project 05 · RFM, clustering & campaign design

Customer Segmentation

Build transparent RFM audiences, validate a clustering challenger, and turn segments into measurable campaign tests.

RFMK-meansPower BI
Identified customers4,338
Gross revenue£8.9M
Repeat customer rate65.6%
Selected silhouette0.3175 clusters
Sales value coverage83.5%
Executive view

Transparent RFM audiences with a clustering challenger

Monthly identified-customer revenue

£390.0K£804.5K£1.2MDec 2010Jun 2011Dec 2011
Revenue (GBP)

RFM segment summary

SegmentCustomersRevenueMedian recencyRevenue shareObjective
Champions946£5.8M11 days64.6%Protect loyalty and advocacy
At Risk908£1.2M139 days13.1%Reactivate previously valuable customers
Loyal499£916.7K39 days10.3%Deepen category breadth and order value
Potential Loyalists456£495.4K19 days5.6%Build a repeat-purchase habit
New Customers67£23.4K8 days0.3%Convert the first purchase into a second
Occasional635£362.2K51 days4.1%Increase purchase cadence efficiently
Hibernating827£190.6K237 days2.1%Test low-cost reactivation or suppress
Audience explorer

Filter anonymized customers and export the result

Filters run entirely in your browser. The table previews the 100 highest-value matches; CSV includes every match.

Audience filters

Matching customers4,338Current filter denominator
Historical value£8.9M
Median recency51 days
Median customer value£674.49

Customer preview · 100 shown

4,338 matching customers
CustomerCountrySegmentRecencyFrequencyValueCluster
14646NetherlandsChampions273£280.2KHigh-Value Loyal
18102United KingdomChampions160£259.7KHigh-Value Loyal
17450United KingdomChampions946£194.6KHigh-Value Loyal
16446United KingdomPotential Loyalists12£168.5KCore Regulars
14911EIREChampions2201£143.8KHigh-Value Loyal
12415AustraliaChampions2521£124.9KHigh-Value Loyal
14156EIREChampions1055£117.4KHigh-Value Loyal
17511United KingdomChampions331£91.1KHigh-Value Loyal
16029United KingdomLoyal3963£81.0KHigh-Value Loyal
12346United KingdomAt Risk3261£77.2KGrowth Potential
16684United KingdomChampions528£66.7KHigh-Value Loyal
14096United KingdomChampions517£65.2KHigh-Value Loyal
13694United KingdomChampions450£65.0KHigh-Value Loyal
15311United KingdomChampions191£60.8KHigh-Value Loyal
13089United KingdomChampions397£58.8KHigh-Value Loyal
17949United KingdomChampions245£58.5KHigh-Value Loyal
15769United KingdomChampions826£56.3KHigh-Value Loyal
15061United KingdomChampions448£54.5KHigh-Value Loyal
14298United KingdomChampions944£51.5KHigh-Value Loyal
14088United KingdomChampions1113£50.5KHigh-Value Loyal
15749United KingdomAt Risk2363£44.5KGrowth Potential
12931United KingdomChampions2215£42.1KHigh-Value Loyal
17841United KingdomChampions2124£41.0KHigh-Value Loyal
15098United KingdomAt Risk1833£39.9KGrowth Potential
13798United KingdomChampions257£37.2KHigh-Value Loyal
16013United KingdomChampions447£37.1KHigh-Value Loyal
16422United KingdomChampions1851£34.7KHigh-Value Loyal
12748United KingdomChampions1209£33.7KHigh-Value Loyal
15838United KingdomChampions1219£33.6KHigh-Value Loyal
17404SwedenChampions515£31.9KHigh-Value Loyal
17389United KingdomChampions134£31.8KHigh-Value Loyal
13098United KingdomChampions228£28.9KHigh-Value Loyal
14680United KingdomChampions2616£28.8KHigh-Value Loyal
13081United KingdomChampions1211£28.3KHigh-Value Loyal
13408United KingdomChampions262£28.1KHigh-Value Loyal
17857United KingdomChampions523£26.9KHigh-Value Loyal
16333United KingdomChampions822£26.6KHigh-Value Loyal
13777United KingdomChampions133£26.0KHigh-Value Loyal
12753JapanChampions236£21.4KHigh-Value Loyal
12744SingaporeLoyal527£21.3KHigh-Value Loyal
16210United KingdomChampions218£21.1KHigh-Value Loyal
17675United KingdomChampions231£20.4KHigh-Value Loyal
17381United KingdomChampions929£20.3KHigh-Value Loyal
15039United KingdomChampions1047£19.9KHigh-Value Loyal
12471GermanyChampions330£19.8KHigh-Value Loyal
12731FranceChampions2412£18.9KHigh-Value Loyal
15159United KingdomChampions230£18.6KHigh-Value Loyal
12901United KingdomChampions928£17.7KHigh-Value Loyal
12678FranceLoyal4312£17.6KHigh-Value Loyal
14031United KingdomChampions819£17.3KHigh-Value Loyal
17428United KingdomChampions128£17.3KHigh-Value Loyal
13767United KingdomChampions337£17.2KHigh-Value Loyal
13881United KingdomChampions420£17.2KHigh-Value Loyal
16839United KingdomChampions934£16.6KHigh-Value Loyal
12921United KingdomChampions1037£16.6KHigh-Value Loyal
14607United KingdomChampions1614£16.6KHigh-Value Loyal
15856United KingdomChampions527£16.4KHigh-Value Loyal
17677United KingdomChampions230£16.4KHigh-Value Loyal
15189United KingdomChampions241£16.2KHigh-Value Loyal
14051United KingdomChampions123£15.6KHigh-Value Loyal
15513United KingdomLoyal3419£14.8KHigh-Value Loyal
16133United KingdomChampions433£14.6KHigh-Value Loyal
14866United KingdomChampions1112£14.4KHigh-Value Loyal
16705United KingdomChampions120£14.0KHigh-Value Loyal
12681FranceChampions1522£13.8KHigh-Value Loyal
12621GermanyChampions220£13.7KHigh-Value Loyal
12540SpainChampions2017£13.4KHigh-Value Loyal
12433NorwayChampions17£13.4KHigh-Value Loyal
15498United KingdomChampions327£13.3KHigh-Value Loyal
12477GermanyChampions236£13.2KHigh-Value Loyal
17735United KingdomChampions319£13.1KHigh-Value Loyal
16525United KingdomChampions326£13.0KHigh-Value Loyal
14258United KingdomChampions109£12.7KHigh-Value Loyal
13078United KingdomChampions426£12.6KHigh-Value Loyal
12536FranceOccasional443£12.6KCore Regulars
15640United KingdomChampions515£12.5KHigh-Value Loyal
16000United KingdomChampions33£12.4KCore Regulars
17340United KingdomChampions3011£12.4KHigh-Value Loyal
12682FranceChampions431£12.3KHigh-Value Loyal
13113United KingdomChampions124£12.2KHigh-Value Loyal
14606United KingdomChampions293£12.2KHigh-Value Loyal
12557SpainChampions175£12.0KHigh-Value Loyal
12939United KingdomLoyal658£11.6KHigh-Value Loyal
15125United KingdomChampions2615£11.5KHigh-Value Loyal
14194United KingdomChampions521£11.3KHigh-Value Loyal
12971United KingdomChampions486£11.2KHigh-Value Loyal
14895United KingdomChampions820£11.1KHigh-Value Loyal
12409SwitzerlandAt Risk793£11.1KGrowth Potential
15482United KingdomChampions1612£11.1KHigh-Value Loyal
17581United KingdomChampions125£11.0KHigh-Value Loyal
13319United KingdomChampions626£10.8KHigh-Value Loyal
17107United KingdomLoyal346£10.8KHigh-Value Loyal
13340United KingdomLoyal467£10.7KHigh-Value Loyal
14769United KingdomChampions38£10.7KHigh-Value Loyal
17139United KingdomChampions1612£10.7KHigh-Value Loyal
16779United KingdomChampions322£10.6KHigh-Value Loyal
17865United KingdomChampions3120£10.5KHigh-Value Loyal
17706United KingdomChampions517£10.5KHigh-Value Loyal
15251United KingdomChampions1011£10.5KHigh-Value Loyal
14062United KingdomChampions1012£10.5KHigh-Value Loyal
Model validation

Evaluate the clustering challenger, not just its labels

Silhouette by cluster count

2 clusters0.435
Seed stability ARI 0.999
3 clusters0.336
Seed stability ARI 0.974
4 clusters0.335
Seed stability ARI 0.985
5 clusters · selected0.317
Seed stability ARI 0.992
6 clusters0.314
Seed stability ARI 0.998
7 clusters0.307
Seed stability ARI 0.986
8 clusters0.304
Seed stability ARI 0.768

Top countries by revenue

United Kingdom£7.3M
Netherlands£285.4K
EIRE£265.5K
Germany£228.9K
France£209.0K
Australia£138.5K
Spain£61.6K
Switzerland£56.4K
Campaign design

Turn a segment into a measurable test

At Risk · 908 customers

ObjectiveReactivate previously valuable customers
Primary KPIIncremental repeat-purchase rate
ChannelEmail + paid retargeting

Experiment: Randomized offer test with a 10% no-contact holdout

Power BI companion

Desktop-ready model, DAX, theme, and validation guide

Customer segmentation Power BI executive page layout target
Power BI companion layout target; not a claim of a hosted report.

The PBIX authoring and Service refresh remain separate manual steps.