The challenge
Shoppers, club members, independent sellers, event hosts and tasting-room visitors all sat in one base and got the same treatment.
Many club members had cancelled, and the team could not see which active members were next.
The largest pool of lifetime revenue belonged to customers who were about to go dormant.
A large share of the independent seller network showed little activity, with no way to spot who could be won back.
What we did
Structure first, then scoring, then action. Each step maps to a stage of The Profit Loop.
- 1 · Plan
Mapped the CRM around the four things customers do: shop, join the club, visit and host. Each got a list, department, segment and tag structure the team could keep up to date.
- 2 · Measure
Applied our Value × Intent (RFMB) model: an 11-cluster RFM matrix from Champions to Lost, extended with a behavior score from view, add-to-cart, checkout and purchase events, and clustered with K-Means.
- 3 · Retain: segments and scoring
Built 47 dynamic lists in HubSpot across shopping, gifting, the wine club, sellers, hosts and visitors, plus five lead-scoring models with positive and negative criteria.
- 4 · Retain: priority and playbooks
Turned scores into four priority levels, from Very High to Low, that set customer-service response times through workflow rules, and wrote a personalization playbook for each segment with the metrics to watch.
The results
This project delivered the segmentation and scoring system. Figures describe what it revealed in the client's existing HubSpot base at a point in time, not revenue generated after launch. Ratios compare segment averages.
What made the difference
Segment by relationship before value
A club member, a seller and a one-time gift buyer need different journeys. Value scoring works best inside each relationship, not across all of them.
Priority is a service level
Scores only matter if they change what happens next. Here they set how fast each contact gets a reply.
Value is concentrated
The top priority tier was worth several times the middle one. Protecting it comes before chasing new contacts.
The first order is big; the second is the work
First-time shoppers placed larger orders than repeat ones. Repeat value comes from frequency, so the second order needs its own journey.