Prerendered snapshot. Every figure below was computed at build time from the synthetic dataset. Open the live app for filter combinations outside the presets, the returns workflow, and admin — it runs on a free instance and can take ~20s to wake.
Prerendered snapshot · no server request

Customer Clearwater Square (ID: C20072)

Back to Customers
Lifetime value
$111,836.11
Orders 85 AOV $1,315.72
Revenue / month $18,639.35 • Orders / month 14.2
Profit $22,896.56 Margin 20.5%
Recent momentum
$11,854.64
Last 30d $1,353.96 n/a
Orders 90d 5
Avg ticket $2,370.93 • Profit $202.45 ( 1.7% )
Customer health
Churn risk
Low
Days since last order 14 days
Cadence avg 12.8 d • median 8.0 d
Range 1.0 d - 167.0 d
Best weekday Monday ( $25,599.09 )
Account profile
Segment Growing
Revenue is up more than 10% vs prior window.
First order
2023-10-09T00:00:00
Last order
2026-06-21T00:00:00
Months active 27 • Span 986 days
Primary region Mountain West
Ship method DC Ambient
Unique products 261
Opportunity highlights
  • Top product Tablet Everyday Basics 2-Pack $23,723.36
  • Top weight mover Tablet Everyday Basics 2-Pack 244.80 lb
  • Top profit product Kids Hoodie Northgate Select Family Size $952.98 ( 35.4% )
  • Pricing spread $0.00 / $121.31
  • Cross-sell ideas 5
Action center
  • Orders last 30d 2
  • Orders last 90d 5
  • Days since last order 14
  • Cadence range 1.0 - 167.0 d
Profit snapshot
Lifetime profit $22,896.56
Margin 20.5%

90d profit $202.45
90d margin 1.7%
Use profit trends to prioritize outreach and pricing adjustments.
Monthly profit & margin
Track contribution by month
Monthly profit & margin
Top profit mix
Top profit mix
Product profitability table
Revenue, cost, profit, and margin (top 25 products)
ProductRevenueCostProfitMargin %
Baby Onesie Everyday Basics 2-Pack $1,034.91 $637.31 $397.61 38.4%
Kids Hoodie Northgate Select Family Size $824.78 $521.85 $302.94 36.7%
Cold & Flu Exclusive Brand Single $1,149.28 $895.05 $254.23 22.1%
Skin Care Northgate Value 2-Pack $568.43 $384.77 $183.66 32.3%
Pork Chops Everyday Basics Club Pack $596.97 $422.29 $174.68 29.3%
Allergy Relief Everyday Basics 2-Pack $509.00 $346.02 $162.99 32.0%
String Lights Northgate Select Multipack $483.53 $334.67 $148.86 30.8%
Air Freshener Exclusive Brand Club Pack $403.28 $259.13 $144.15 35.7%
Vitamins National Brand Club Pack $377.88 $252.83 $125.05 33.1%
Allergy Relief National Brand Value Bundle $306.77 $194.51 $112.26 36.6%
Bacon Northgate Select Multipack $347.35 $243.04 $104.31 30.0%
Activewear Legging Premium Label Value Bundle $245.54 $145.24 $100.29 40.8%
Shrimp National Brand 2-Pack $438.64 $339.01 $99.62 22.7%
Vitamins National Brand Travel Size $310.16 $215.08 $95.09 30.7%
Surface Cleaner Premium Label Family Size $418.21 $326.19 $92.02 22.0%
Razors Everyday Basics Bulk $369.92 $278.78 $91.14 24.6%
Pasta Northgate Value Travel Size $231.80 $154.81 $76.99 33.2%
Pork Chops Northgate Value Multipack $309.99 $233.31 $76.68 24.7%
Rice Northgate Select 2-Pack $326.10 $251.72 $74.38 22.8%
Tomatoes Everyday Basics Travel Size $182.23 $109.64 $72.59 39.8%
Canned Soup Northgate Value Single $359.21 $289.46 $69.75 19.4%
Pain Relief Northgate Value Value Bundle $195.14 $130.03 $65.11 33.4%
Condiments Northgate Select Value Bundle $282.60 $218.45 $64.15 22.7%
Ground Beef Exclusive Brand Value Bundle $237.00 $173.08 $63.92 27.0%
Coffee National Brand Bulk $262.03 $201.19 $60.84 23.2%
Monthly Revenue & Orders
Monthly Revenue & Orders
Top Products (Spend)
Top Products (Spend)
Top Products (Weight)
Top Products (Weight)
Revenue by Weekday
Revenue by Weekday
Buying Cadence (days between orders)
Buying Cadence (days between orders)
Seasonality Heatmap (YoY by Month)
Sum of monthly revenue
Seasonality Heatmap (YoY by Month)
Average Basket
  • Orders analyzed 16
  • Avg lines / order 7.0
  • Avg weight (lb) / order 153.71
  • Avg items / order 13.8
  • Avg ticket $1,315.72
Price Intelligence (vs peer median)
Region-aware where available
ProductCustomer UnitPeer MedianΔ vs PeerSuggested
Baby Onesie Everyday Basics 2-Pack $22.40 $23.56 -4.9% $23.56
Kids Hoodie Northgate Select Family Size $15.68 $13.78 13.8% $13.78
Cold & Flu Exclusive Brand Single $14.05 $12.06 16.6% $12.06
Skin Care Northgate Value 2-Pack $13.59 $13.02 4.4% $13.02
Pork Chops Everyday Basics Club Pack $11.05 $11.22 -1.5% $11.22
Allergy Relief Everyday Basics 2-Pack $9.25 $8.99 2.9% $8.99
String Lights Northgate Select Multipack $11.88 $12.02 -1.2% $12.02
Shrimp National Brand 2-Pack $17.08 $17.20 -0.7% $17.20
Suggestion is the peer median realized unit price. Adjust with margin guardrails as needed.
Cross-sell Suggestions
  • Bath Tissue Northgate Value SingleMountain West
  • Condiments Everyday Basics 2-PackMountain West
  • Coffee Exclusive Brand 2-PackMountain West
  • Laundry Detergent Northgate Value MultipackMountain West
  • Rotisserie Chicken National Brand Club PackMountain West