Case studyWine DTCHubSpot CRMU.S.

How a wine brand turned a flat CRM into 47 live segments

A large customer base, five ways to buy and no segmentation the team could act on. We mapped each customer relationship, scored every contact on value and buying behavior in HubSpot, and gave each segment a priority level and a playbook.

47Dynamic CRM segmentsAcross five business lines
5Lead-scoring modelsOne per business line
8×Lifetime value, top vs middle priorityVery High vs Medium priority shoppers

The challenge

One list, many relationships

Shoppers, club members, independent sellers, event hosts and tasting-room visitors all sat in one base and got the same treatment.

Wine club churn

Many club members had cancelled, and the team could not see which active members were next.

Valuable customers drifting

The largest pool of lifetime revenue belonged to customers who were about to go dormant.

Quiet sellers

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. 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.

    Commerce Advisory
  2. 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.

    Data Foundations
  3. 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.

    Lifecycle Retention · Data Foundations
  4. 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.

    Lifecycle Retention

The results

Average lifetime value by priority level, indexedMedium priority = 100 (shopping base)
Low14
Medium100
High172
Very High802
4.2×Lifetime value, top vs middle priorityWine club members, Very High vs Medium
+146%Average order of first-time shoppersvs shoppers past their first order
11RFM clustersFrom Champions to Lost
4Priority levelsEach with its own response time

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

1

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.

2

Priority is a service level

Scores only matter if they change what happens next. Here they set how fast each contact gets a reply.

3

Value is concentrated

The top priority tier was worth several times the middle one. Protecting it comes before chasing new contacts.

4

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.

Do you know which customers carry your margin?

Run the free Profit Audit: a store scan, your biggest profit leaks in dollars and a 90-day plan, in about four minutes.

Free Profit Audit