Customer Intelligence Report

Data-driven insights from 138,784 orders across 18,609 customers to unlock targeted campaign opportunities.

18.6K
Unique Customers
$22.3M
Total Revenue
138.8K
Orders Analyzed
$161
Avg Order Value
Bishop's Cellar
The Power Law of Customer Value
The top 7.1% of customers generate 59.9% of all revenue. Meanwhile, 42.5% of customers never make a second purchase. This concentration creates both a vulnerability and an opportunity.
Lifetime Value (LTV) = total revenue from all completed orders per customer. Higher tiers reflect both larger and more frequent purchases.
Purchase Tier
Share of Revenue
Customers
Avg LTV
50+ orders
38.5%
482 (2.7%)
$20,373
26-50 orders
21.4%
787 (4.4%)
$6,946
11-25 orders
22.1%
1,795 (10.1%)
$3,139
6-10 orders
11.0%
1,819 (10.2%)
$1,548
3-5 orders
8.8%
2,962 (16.7%)
$757
2 orders
3.5%
2,386 (13.4%)
$379
1 order
5.3%
7,543 (42.5%)
$180

The Second Purchase Problem

7,620 customers made exactly one purchase and never returned. Of customers who DO convert to a second purchase, 32.3% do so within 30 days. That first month is the critical conversion window. A category-specific post-first-purchase sequence can target that window directly.

Omnichannel Customers Are Worth 4.4x More
Customers who shop both online and in-store spend dramatically more than single-channel buyers. The gap between single-channel and omnichannel LTV suggests significant upside from cross-channel engagement.
Web Only
$852
11,204 customers · 3.8 avg orders
$9.5M total revenue
POS Only
$1,066
4,371 customers · 7.8 avg orders
$4.7M total revenue
Omnichannel
$3,711
3,034 customers · 20.3 avg orders
$11.3M total revenue
4.4x vs Web Only
RFM Behavioral Segments
Each customer scored on Recency, Frequency, and Monetary value. These six segments enable precision targeting with distinct messaging strategies.
Scoring: each customer gets a 1-5 score on Recency (days since last order), Frequency (total orders), and Monetary (total spend) based on quintiles. Segments are assigned by combining these three scores.
28.1%
Champions
5,232 customers
Recent buyers, high frequency, high spend
VIP early access, Wine Wednesday previews, new arrival alerts
5.3%
At-Risk Champions
987 customers
High frequency and spend, but haven't ordered recently
Urgent reactivation. High value, fading engagement. Personal outreach.
8.5%
Loyal Mid-Value
1,582 customers
Consistent order frequency, moderate spend per order
Premium tier upsell. Introduce $25-50 range products.
4.3%
Promising
805 customers
Bought recently but still building order frequency
Nurture frequency. Category discovery, replenishment reminders.
17.6%
Hibernating
3,282 customers
Inactive for a long period, low order frequency
Win-back sequence. Seasonal reactivation for holiday buyers.
36.1%
Lost
6,721 customers
Longest time since last order, single purchase only
Low-cost re-engagement or suppress. Don't waste spend here.

Price Tier Sweet Spot

Premium buyers ($25-50/item) have the highest average LTV at $1,566, beating both value and luxury segments. The 5,816 customers currently in the $15-25 range represent the natural growth pipeline into this high-value tier.

Under $15/item
$625
Budget
2,827 customers
$15 - $25/item
$1,470
Mid-Range
5,816 customers
$25 - $50/item
$1,566
Premium
5,725 customers
Over $50/item
$698
Luxury
4,234 customers
When Customers Buy
Purchase timing reveals replenishment patterns that can trigger perfectly-timed outreach.

Repeat Purchase Intervals

24.2%
0-7d
13.9%
8-14d
17.8%
15-30d
16.5%
31-60d
7.7%
61-90d
9.8%
91-180d
9.9%
180d+

24.2% of repeat purchases happen within 7 days. Customer-specific replenishment reminders timed to individual cadence can capture this high-frequency behavior.

Seasonal Buyer Breakdown

4,792
OND-Only Buyers
13,001
Year-Round Buyers
2,690
Gift Message Orders
22,102
Pickup Orders

4,792 customers have ONLY ever purchased Oct-Dec. These are gift/holiday buyers, not lapsed customers. They should be excluded from standard win-back campaigns and instead receive a dedicated gift-buyer calendar starting in September.

Taste Profile Intelligence
With 2,834 taxonomy terms loaded across 48 countries, 266 regions, and 252 varietals, we can now map every customer's palate and personalize at the product-attribute level.
Top Countries by Revenue
Italy
$6.80M · 11,544 cust
France
$4.02M · 9,110 cust
Spain
$2.12M · 6,988 cust
USA
$2.10M · 6,392 cust
Canada
$1.46M · 7,316 cust
Argentina
$1.33M · 5,269 cust
New Zealand
$1.28M · 4,311 cust
Chile
$1.28M · 5,377 cust
South Africa
$582K · 3,414 cust
Australia
$569K · 3,279 cust
Top 10 Grape Varietals
1
Cabernet Sauvignon
$2.44M
7,569 customers
2
Sauvignon Blanc
$2.09M
6,178 customers
3
Pinot Grigio
$2.09M
5,581 customers
4
Chardonnay
$1.59M
5,346 customers
5
Pinot Noir
$1.05M
4,860 customers
6
Sangiovese
$869K
4,224 customers
7
Merlot
$699K
4,267 customers
8
Red Blend
$667K
2,945 customers
9
Malbec
$651K
4,198 customers
10
Syrah
$609K
4,300 customers
Wine Type Breakdown
51.3%
Red Wine
$9.77M revenue
12,818 customers
36.2%
White Wine
$6.90M revenue
11,053 customers
7.8%
Sparkling
$1.49M revenue
6,132 customers
4.1%
Rosé Wine
$775K revenue
4,333 customers

Cross-Sell Insights

Customers who buy one category often buy another at a rate higher than average. These patterns, ranked by lift (how much more likely than chance), point to concrete bundling and email opportunities.

Italian Red $25+
also buy
Spanish Tempranillo
1.98x more likely
42.8% co-purchase rate
5,803 trigger customers
Recommend as a bold alternative in red wine emails
Italian Red $25+
also buy
Argentine Malbec
1.79x more likely
38.7% co-purchase rate
5,803 trigger customers
Feature in 'If you liked this...' product recs
Australia buyers
also buy
South Africa
3.12x more likely
59.3% co-purchase rate
3,244 trigger customers
Introduce SA wines to Aussie wine fans
Chile buyers
also buy
South Africa
2.58x more likely
49.0% co-purchase rate
5,270 trigger customers
Pair SA wines with Chilean favourites
NZ Sauvignon Blanc
also buy
French Rosé
2.28x more likely
37.6% co-purchase rate
3,472 trigger customers
Suggest rosé as a seasonal pivot for SB lovers
🇨🇦

Local is Big Business

7,316 customers buy Canadian products, generating $1.46M in revenue. Nova Scotia alone accounts for $1.03M across 6,429 customers. Beer buyers are particularly loyal to local: 4,319 craft beer customers also buy Canadian wine.

10 Data-Backed Campaign Ideas
Each idea comes directly from patterns in the data. We've included audience sizes and what we know about each group to help with planning.
01

Bring First-Time Buyers Back

7,620 customers bought once and never returned. Of those who do come back, 32.3% do so within 30 days. A well-timed follow-up email in that first month, featuring products they'd like, targets that window.

7,620 one-time buyers · $158 avg first order value
High Impact
02

Get Customers Shopping Both Ways

4,371 customers only shop in-store and 11,204 only shop online. Customers who do both spend 4.4x more. Show in-store shoppers the 1,099 products only available online. Invite online shoppers to pickup and tasting events.

15,575 single-channel customers to reach
Growth
03

Reorder Reminders

Each repeat customer has their own buying rhythm. Someone who reorders every two weeks gets a reminder on day 12. A monthly buyer gets one on day 25. "Time for more [product name]?" timed to when they're actually running low.

10,154 repeat customers with a known buying pattern
A pattern requires 3+ orders. Cadence = average days between consecutive purchases. Median reorder interval across all patterned customers is ~100 days.
Retention
04

Win Back Your Best Customers

1,021 of your highest-spending customers are starting to drift away. The top 200 ($5K+ lifetime spend) warrant a personal phone call. The next tier ($1K-5K) gets a personalized email. The rest get a targeted offer.

1,021 high-value customers · Urgent priority
High-value = top 20% by lifetime spend ($1,441+). "Drifting" = modeled probability of being active is below 50%, based on each customer's personal purchase frequency. Typically means their last order is more than 2x their usual interval.
Urgent
05

Holiday Gift Buyer Calendar

4,792 customers only buy around the holidays, likely as gifts. Give them their own email calendar: gift guide in October, curated bundles in November, personalized picks mid-November, gift cards in December. Don't email them the rest of the year.

4,792 gift buyers · Targeted seasonal outreach
Optimize
06

Move Customers Into Better Bottles

2,827 budget buyers are ready to try mid-range. 5,816 mid-range buyers are ready for premium ($25-50), where premium customers average $1,566 lifetime spend (LTV). Staff tasting notes on 1,050 products give you the credibility to make the recommendation.

5,816 mid-range buyers · Premium customers average $1,566 LTV
Growth
07

Recover Unfinished Orders

138,784 orders came from customers who started checkout but didn't finish, so the reminder emails are already working. Opportunity: tailor the timing and message by what was in the cart. Orders over $200 may be worth a personal follow-up.

Already working · Room to improve
Optimize
08

Staff Picks Email Series

You have hand-written tasting notes on 1,050 products and now we can match them to individual taste profiles. A customer who buys Pinot Grigio from Veneto gets recommendations for similar Italian whites. A Cabernet Sauvignon loyalist gets alerts when new Bordeaux or Napa bottles arrive. 252 varietals, 48 countries, and 266 regions give you the vocabulary for truly personalized picks.

1,050 products with tasting notes · 252 varietals · 48 countries
Retention
09

Introduce New Categories

Beer buyers also spend heavily on wine — 4,319 craft beer customers generated $2.76M in Italian wine purchases alone. Spirit buyers who start with whiskey often explore rum and gin next. After a purchase, suggest a category the customer hasn't explored yet, matched to their taste profile: a customer who likes bold, spicy tasting notes in red wine would love a smoky Scotch.

4,319 beer-to-wine crossover customers · Attribute-level matching
Growth
10

Make More of In-Store Pickup

22,102 orders were picked up in-store. These customers chose to walk through the door. Suggest an add-on when they're on the way, follow up after the visit, invite them to tastings, and remind them when it's time to reorder.

22,102 pickup orders · Face-to-face opportunity
Retention
What We Can Unlock Next
Many enrichment variables are derivable from existing data. Others require external integrations to fully activate.

Available Now

Individual purchase cadence for replenishment timing
Price tier trend (moving up or down over time)
Category concentration (specialist vs explorer)
Channel preference (web / POS / pickup / omni)
Gift buyer classification from address + comment + season
Day-of-week preference for send time optimization
Product repurchase rate for "reorder your favorite" triggers
Brand loyalty for new vintage / producer alerts
Country / Region / Varietal / Tasting Notes / Food Pairing — 2,834 taxonomy terms loaded

Requires Additional Data

Email open/click behavior — HubSpot integration
Browse-but-didn't-buy — WooCommerce site analytics
Licensee account flag — manual tagging or account metadata
Acquisition source — UTM parameters / referral data
Wine club / subscription — if/when launched

Next Step: HubSpot Integration

Connecting email engagement data (opens, clicks, unsubscribes) to purchase behavior will unlock send-time optimization, content personalization by engagement level, and suppression of disengaged customers from campaign spend.