This analysis transformed raw transaction data from 1,000 Wellpath customers into a complete picture of customer behavior, demographic composition, and financial impact by segment. The findings reveal a business that is highly dependent on a single high-value segment, with significant revenue at risk from lapsing customers and meaningful margin leakage from a small but operationally costly group of return abusers.
The Strata Method begins with your raw transaction data — whatever format it lives in — and transforms it into a complete customer intelligence picture. No proprietary systems required. No months-long implementation. Just your data, our methodology, and a deliverable in two weeks.
Starting from raw transaction-level data — customer IDs, purchase dates, products, prices, and zip codes — we identify natural behavioral groups using a hybrid clustering methodology, then apply rule-based flags to surface financially critical outliers that pure clustering would miss. Every customer is assigned to exactly one primary segment.
Using a hybrid clustering methodology, we identify natural behavioral groups in your customer base — then apply rule-based flags to surface financially critical outliers that pure clustering would miss. Every customer is assigned to exactly one primary segment.
Each segment is mapped to a specific business lever — acquisition, retention, suppression, or policy — with a dollar estimate attached to the opportunity or risk. The output is a prioritized action plan tied directly to your P&L, written for the people who will execute it.
The Strata Method · Proprietary customer intelligence framework
| Segment | Tier | Max CAC | Primary Targeting Profile | Geographic Signal |
|---|---|---|---|---|
| Brand Loyalists | Invest | Up to $965 | High Income Urban Single · Walkable Urban | NYC, Seattle, LA, Chicago |
| Core Loyalists at Risk | Invest — Winback | Up to $815 | High Income Urban Single (57%) · same profile as Brand Loyalists | Same top metros |
| Fitness Enthusiasts | Maintain | Up to $390 | Mixed · skews Urban Family and Moderate Income Urban | Broad urban & suburban |
| Promo Dependents | Suppress | $0 — exclude | Price Sensitive Urban · General Suburban | Deprioritize low-income density zips |
| Revenue Destroyers | Suppress | $0 — exclude | No dominant profile — behavioral flag, not demographic | Policy intervention only |
Your transaction data contains rows. The Strata Method transforms those rows into a complete picture of who your customers are, what they’re worth, and exactly what to do about each group. Below is what that transformation looks like for a single customer — the same process applied to every record in your database.
| customer_id | txn_id | date | product | list_price | discount | status | net_rev |
|---|---|---|---|---|---|---|---|
| WP-0047 | TXN-00312 | 2023-03-14 | Supplements | $71.20 | $0 | Completed | $71.20 |
| WP-0047 | TXN-00589 | 2023-06-02 | Skincare | $98.50 | $0 | Completed | $98.50 |
| WP-0047 | TXN-00814 | 2023-09-18 | Supplements | $71.20 | $0 | Completed | $71.20 |
| WP-0047 | TXN-01203 | 2024-01-07 | Skincare | $112.00 | $0 | Completed | $112.00 |
| WP-0047 | TXN-01544 | 2024-04-22 | Supplements | $71.20 | $0 | Completed | $71.20 |
| WP-0048 | TXN-01545 | 2024-04-22 | Fitness Gear | $32.00 | $12.80 | Returned | -$9.40 |
| WP-0049 | TXN-01546 | 2024-04-23 | Supplements | $45.00 | $18.00 | Completed | $27.00 |
| ⋮ 8,734 more rows … | |||||||
“Any analyst can tell you what your customers bought. We can tell you who they are.”
Most segmentation stops at behavior. You get clusters named things like “high frequency buyers” and “lapsed customers.” These labels tell you what happened. They don’t tell you why it happened, who these people are in the real world, or where to find more of them.
A high frequency buyer in a Price Sensitive Urban zip code and a high frequency buyer in a High Income Urban Single zip code look identical in your transaction data. They are not the same customer. Their acquisition cost tolerance is different. Their churn triggers are different. Their product preferences are different. Treating them the same is how acquisition budgets get wasted.
We enrich every customer record with zip-code level demographic intelligence — income, age, household composition, life stage classification, and a proprietary Wellness Propensity Index built specifically for consumer health and wellness businesses.
This turns a behavioral segment into a real-world profile. Not just “Brand Loyalists” — but “Brand Loyalists are 86% High Income Urban Single, concentrated in Walkable Urban zip codes, with a median household income of $104K and a wellness propensity index of 7.5 out of 10.” Now you know who to go find more of.
Nine distinct customer segments emerged from the Wellpath analysis. Four were identified through behavioral clustering — representing the natural groupings in purchasing behavior. Five were identified through rule-based flags — surfacing financially critical patterns that clustering alone would miss.
| Segment | Customers | % Total | Total LNR | Avg LTV | Avg AOV | Return Rate | Promo Rate | Days Inactive |
|---|---|---|---|---|---|---|---|---|
Brand Loyalists |
300 | 30.0% | $357,057 | $1,190 | $73 | 5.2% | 15.3% | 32 |
Core Loyalists at Risk |
177 | 17.7% | $144,309 | $815 | $73 | 5.5% | 18.7% | 176 |
Promo Seeker |
29 | 2.9% | $16,054 | $554 | $56 | 10.4% | 71.9% | 87 |
Fitness Enthusiasts |
216 | 21.6% | $84,249 | $390 | $53 | 9.8% | 21.3% | 106 |
High Return Risk |
45 | 4.5% | $16,175 | $359 | $61 | 38.6% | 35.7% | 93 |
Skincare Browsers |
154 | 15.4% | $12,943 | $84 | $66 | 0.1% | 1.1% | 501 |
Promo Dependents |
55 | 5.5% | $2,896 | $53 | $51 | 0.6% | 95.9% | 574 |
New Customer |
10 | 1.0% | $511 | $51 | $58 | 10.0% | 30.0% | 23 |
Revenue Destroyer |
14 | 1.4% | -$186 | -$13 | $0 | 100.0% | 32.1% | 648 |
The Strata Method produced six specific actions Wellpath can take immediately. Each recommendation is tied directly to a segment finding and quantified where possible.
| Initiative | Segment | Basis | Conservative Est. | Upside Est. |
|---|---|---|---|---|
| Redirect acquisition spend toward Brand Loyalist zip profile | Brand Loyalists | 20% budget reallocation toward HIUS zip codes at $965 max CAC | $47,500 | $71,000 |
| Winback campaign — Core Loyalists at Risk | Core Loyalists at Risk | $144K at risk · 25% reactivation = conservative · 40% = upside | $36,100 | $57,700 |
| Suppress Revenue Destroyers from acquisition | Revenue Destroyers | Eliminate ongoing return processing losses + redirect promo spend | $2,500 | $5,000 |
| Tighten return policy — High Return Risk | High Return Risk | Reduce return rate from 38.6% to 20% on 45 customers | $6,200 | $8,500 |
| Remove Promo Dependents from paid campaigns | Promo Dependents | Reallocate discount spend to Brand Loyalists (4–6× higher ROI) | $8,000 | $14,000 |
| Replenishment sequence — Skincare Browsers | Skincare Browsers | 20% reactivation on 154 customers at $66 AOV | $2,030 | $4,060 |
| Total Projected Revenue Opportunity | — | All six initiatives combined | $102,330 | $160,260 |
Brand Loyalists are nearly homogeneous — 86% High Income Urban Single, concentrated in NYC, Seattle, and Santa Monica. They buy at full price, they rarely return, and they keep coming back. Mean household income of $104K. Mean wellness spend index of 7.5. This is not a broad demographic profile. It is a narrow, repeatable acquisition target with $1,190 average lifetime value and a max justifiable CAC of $965.
Build a lookalike audience from the Brand Loyalist life stage profile — High Income Urban Single, Walkable Urban, $104K median income, Wellness Propensity Index 7.5+ — and redirect acquisition spend toward it. For geo-targeted channels, concentrate on NYC, Seattle, and LA. These customers justify a CAC of up to $965 based on expected lifetime value.
Shifting 20% of acquisition budget toward this demographic profile could generate an estimated $71,000 in incremental LNR annually based on current Brand Loyalist LTV.
These 177 customers share the same demographic DNA as Brand Loyalists — 57.6% High Income Urban Single, similar AOV, similar product mix. The difference is recency. They averaged a purchase every 47 days at their peak. Now it has been 176 days. $144,309 in lifetime net revenue sits dormant in a group that has already proven they will buy at full price. This is not a churn problem. It is a lapse problem, and lapse problems have known solutions.
Deploy a personalized winback sequence within 30 days targeting these 177 customers with a time-limited offer. Prioritize the top 50 by LTV — they represent over $80K in at-risk revenue.
A 25% reactivation rate recovers approximately $36,000 in LNR. A 40% rate recovers $57,700.
14 customers have a 100% return rate and negative lifetime net revenue of -$186 total. Every transaction they make results in a net loss after return processing fees.
Identify the acquisition source of these 14 customers and immediately suppress that channel or audience. Add these customers to a suppression list for all future promotional campaigns.
Eliminates ongoing margin leakage and redirects promotional spend toward segments with positive LTV.
45 customers have a 38.6% return rate — nearly 4x the brand average of 10%. Despite positive LTV of $359, their return behavior is eroding margin. They skew heavily toward Fitness Gear purchases.
Implement a stricter return window (14 days vs 30 days) for Fitness Gear. Consider a restocking fee for customers with more than 3 returns in 12 months. Flag these 45 customers for manual review.
Reducing return rate from 38.6% to 20% recovers an estimated $8,500 in annual return processing costs.
55 customers have a 95.9% promotional attach rate and a mean LTV of only $53. These customers exist almost entirely because of discounts and show no signs of migrating to organic buying behavior.
Remove Promo Dependents from all future promotional campaigns. Reallocate the discount budget currently spent on this segment toward Brand Loyalists where promotional spend would be additive rather than substitutive.
Reallocation toward Brand Loyalists is estimated to generate 4–6x higher return on promotional investment.
154 customers bought Skincare products and almost never returned them — 0.1% return rate against a brand average of 9.5%. They liked what they received. They then disappeared for an average of 501 days. The product works. The replenishment trigger does not exist. Skincare has a natural repurchase cycle of 60–90 days. These customers missed that window with no prompt, and inertia did the rest.
Implement an automated replenishment email triggered at 60 and 90 days post-purchase for Skincare customers. The near-zero return rate indicates product satisfaction — the barrier to repurchase is awareness, not dissatisfaction.
Converting 20% of Skincare Browsers to a second purchase generates approximately $2,030 in incremental revenue from a fully automated sequence.
| Starter $3,500 | Growth $6,500 | Partner $14,500 | |
|---|---|---|---|
| Unique customers segmentedTotal unique customers in your transaction data | Up to 50K | Up to 250K | 250K+ |
| Data sources | Single | Single | Multiple |
| Behavioral segmentationCustom clusters built from your transaction data | ✓ | ✓ | ✓ |
| Demographic enrichmentLife stage, income, Wellness Propensity Index | ✓ | ✓ | ✓ |
| Segment definitions | Standard | Custom | Custom |
| Acquisition tier recommendationsMax CAC thresholds + life stage targeting profiles | ✓ | ✓ | ✓ |
| Written strategic recommendationsWith dollar quantification per initiative | ✓ | ✓ | ✓ |
| Interactive Customer Intelligence Explorer | ✓ | ✓ | ✓ |
| 60-min findings presentationLive walkthrough with finance & marketing teams | — | ✓ | ✓ |
| Growth campaign integrationMap segments to paid channels · suppression lists · CAC bid guidance · working session with growth team | — | — | ✓ |
| Dedicated comms channel90-day Slack access for live questions and input | — | — | ✓ |
| Data refreshesRe-analysis to track segment movement over time | — | — | Up to 3 within 12 months |
| Follow-up support | 30 days | 30 days | 90 days |
| Delivery | 2 weeks | 3 weeks | 3–4 weeks |
| All tiers include the full Strata Method analytical framework and demographic enrichment layer. | |||
“Every insight, every segment, and every recommendation in this document is the direct output of The Strata Method — the same framework I apply to your real customer data.”
Note: this analysis was conducted on a synthetic dataset built to demonstrate the methodology.