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
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.
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,543 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.7x 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
$922
10,443 customers · 4.2 avg orders
$9.6M total revenue
POS Only
$1,244
4,235 customers · 8.9 avg orders
$5.3M total revenue
Omnichannel
$4,312
3,096 customers · 26.8 avg orders
$13.3M total revenue
4.7x 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.
28.1%
Champions
5,232 customers
VIP early access, Wine Wednesday previews, new arrival alerts
5.3%
At-Risk Champions
987 customers
Urgent reactivation. High value, fading engagement. Personal outreach.
8.5%
Loyal Mid-Value
1,582 customers
Premium tier upsell. Introduce $25-50 range products.
4.3%
Promising
805 customers
Nurture frequency. Category discovery, replenishment reminders.
17.6%
Hibernating
3,282 customers
Win-back sequence. Seasonal reactivation for holiday buyers.
36.1%
Lost
6,721 customers
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 $2,291, beating both value and luxury segments. The 4,662 customers currently in the $15-25 range represent the natural growth pipeline into this high-value tier.

When Customers Buy
Purchase timing reveals replenishment patterns that can trigger perfectly-timed outreach.

Repeat Purchase Intervals

40.7%
0-7d
11.0%
8-14d
14.0%
15-30d
13.0%
31-60d
6.1%
61-90d
7.8%
91-180d
7.8%
180d+

40.7% 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
3,653
Year-Round Buyers
4,914
Gift Message Orders
22,102
Pickup Appointments

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
🇨🇦

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.

Top Tasting Notes
Citrus Refreshing Smooth Herbal Fresh Bitter Crisp Baking Spice Clean Vanilla
Top Food Pairings by Revenue
Seafood
$5.93M · 10,784 cust
Cold Salads
$4.01M · 8,926 cust
Aperitif
$2.65M · 8,493 cust
Pork
$2.11M · 7,621 cust
Red Meat
$2.10M · 7,440 cust
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,543 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,543 one-time buyers · $180 avg first order value
High Impact
02

Get Customers Shopping Both Ways

4,235 customers only shop in-store and 10,443 only shop online. Customers who do both spend 4.7x more. Show in-store shoppers the 1,099 products only available online. Invite online shoppers to pickup and tasting events.

14,678 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,204 repeat customers with a known buying pattern
Retention
04

Win Back Your Best Customers

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

639 high-value customers · Urgent priority
Urgent
05

Holiday Gift Buyer Calendar

5,700 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.

5,700 gift buyers · Targeted seasonal outreach
Optimize
06

Move Customers Into Better Bottles

1,847 budget buyers are ready to try mid-range. 4,662 mid-range buyers are ready for premium ($25-50), where customers spend the most over time ($2,291 avg). Staff tasting notes on 5,167 products give you the credibility to make the recommendation.

4,662 mid-range buyers · Premium customers spend $2,291 avg
Growth
07

Recover Unfinished Orders

112,883 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 5,167 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.

5,167 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.