Turn this view into work. Preserve the current source, assign an owner, and measure the outcome.Create action from this view
Customer Prairie View Supercenter (ID: C20054)
Back to CustomersLifetime value
$413,249.38
Orders
170
AOV
$2,430.88
Revenue / month
$41,324.94
•
Orders / month
17.0
Profit
$102,085.10
Margin
24.7%
Recent momentum
$36,121.92
Last 30d
$16,754.26
n/a
Orders 90d
14
Avg ticket
$2,580.14
• Profit
$7,862.09
(
21.8%
)
Customer health
Churn risk
Low
Days since last order
2 days
Cadence avg
6.4
d •
median
5.0
d
Range
1.0
d -
34.0
d
Best weekday Tuesday
(
$81,456.92
)
Account profile
Segment Stable
Recent activity and revenue are broadly stable.
First order
2023-10-06T00:00:00
Last order
2026-07-02T00:00:00
Months active
33
•
Span
1,000
days
Primary region Midwest
Ship method DC Ambient
Unique products
310
Opportunity highlights
- Top product Tablet Everyday Basics Value Bundle $22,931.58
- Top weight mover Baking Mix Everyday Basics Value Bundle 795.33 lb
- Top profit product Kids Hoodie Exclusive Brand Travel Size $7,290.60 ( 42.9% )
- Pricing spread $1.64 / $131.26
- Cross-sell ideas 5
Action center
- Orders last 30d 7
- Orders last 90d 14
- Days since last order 2
- Cadence range 1.0 - 34.0 d
Profit snapshot
Lifetime profit
$102,085.10
Margin
24.7%
90d profit
$7,862.09
90d margin
21.8%
Use profit trends to prioritize outreach and pricing adjustments.
Monthly profit & margin
Track contribution by month
Top profit mix
Product profitability table
Revenue, cost, profit, and margin (top 25 products)
| Product | Revenue | Cost | Profit | Margin % |
|---|---|---|---|---|
| Kids Hoodie Exclusive Brand Travel Size | $6,624.00 | $3,718.44 | $2,905.56 | 43.9% |
| Streaming Stick National Brand 2-Pack | $15,912.23 | $14,652.61 | $1,259.62 | 7.9% |
| Toothpaste Exclusive Brand Bulk | $2,200.43 | $1,566.81 | $633.63 | 28.8% |
| Pain Relief National Brand Multipack | $2,004.53 | $1,385.16 | $619.37 | 30.9% |
| Storage Bin Exclusive Brand Multipack | $1,228.43 | $692.90 | $535.53 | 43.6% |
| Chicken Breast Everyday Basics Multipack | $1,871.03 | $1,345.56 | $525.47 | 28.1% |
| Bluetooth Headphones Northgate Value 2-Pack | $9,417.09 | $8,901.34 | $515.75 | 5.5% |
| Artificial Tree Premium Label Travel Size | $1,250.72 | $736.26 | $514.46 | 41.1% |
| Baby Onesie Everyday Basics 2-Pack | $1,306.30 | $796.63 | $509.66 | 39.0% |
| Cooler Everyday Basics Travel Size | $1,499.67 | $999.71 | $499.96 | 33.3% |
| Streaming Stick Premium Label Multipack | $2,275.46 | $1,798.72 | $476.73 | 21.0% |
| Shampoo National Brand Travel Size | $1,554.09 | $1,082.85 | $471.25 | 30.3% |
| Razors Northgate Value Single | $1,298.82 | $849.81 | $449.01 | 34.6% |
| String Lights Everyday Basics Club Pack | $1,321.60 | $889.97 | $431.63 | 32.7% |
| Bed Sheet Set Northgate Value Family Size | $1,166.71 | $735.66 | $431.05 | 36.9% |
| Baking Mix Everyday Basics Value Bundle | $1,273.58 | $890.14 | $383.44 | 30.1% |
| Skin Care Northgate Value Bulk | $1,057.16 | $681.07 | $376.08 | 35.6% |
| Vitamins Exclusive Brand Family Size | $1,006.73 | $636.07 | $370.66 | 36.8% |
| First Aid Premium Label Single | $987.69 | $678.05 | $309.65 | 31.4% |
| Deli Turkey Northgate Select Single | $1,216.79 | $930.96 | $285.82 | 23.5% |
| Bacon Northgate Select Multipack | $858.54 | $589.57 | $268.97 | 31.3% |
| Food Storage National Brand Club Pack | $879.26 | $631.56 | $247.71 | 28.2% |
| Shrimp Northgate Select Single | $702.57 | $463.80 | $238.77 | 34.0% |
| Chicken Breast Northgate Value Value Bundle | $671.18 | $439.63 | $231.55 | 34.5% |
| Allergy Relief Premium Label Bulk | $651.10 | $421.66 | $229.45 | 35.2% |
Monthly Revenue & Orders
Top Products (Spend)
Top Products (Weight)
Revenue by Weekday
Buying Cadence (days between orders)
Seasonality Heatmap (YoY by Month)
Sum of monthly revenue
Average Basket
- Orders analyzed 39
- Avg lines / order 6.8
- Avg weight (lb) / order 263.71
- Avg items / order 23.9
- Avg ticket $2,430.88
Price Intelligence (vs peer median)
Region-aware where available
| Product | Customer Unit | Peer Median | Δ vs Peer | Suggested |
|---|---|---|---|---|
| Kids Hoodie Exclusive Brand Travel Size | $22.55 | $21.63 | 4.3% | $21.63 |
| Streaming Stick National Brand 2-Pack | $78.64 | $79.99 | -1.7% | $79.99 |
| Toothpaste Exclusive Brand Bulk | $18.72 | $16.19 | 15.6% | $16.19 |
| Pain Relief National Brand Multipack | $12.41 | $11.37 | 9.2% | $11.37 |
| Chicken Breast Everyday Basics Multipack | $8.41 | $8.39 | 0.1% | $8.39 |
| Bluetooth Headphones Northgate Value 2-Pack | $132.23 | $118.96 | 11.2% | $118.96 |
| Streaming Stick Premium Label Multipack | $64.71 | $58.22 | 11.1% | $58.22 |
| Shampoo National Brand Travel Size | $13.61 | $15.56 | -12.5% | $15.56 |
Suggestion is the peer median realized unit price. Adjust with margin guardrails as needed.
Cross-sell Suggestions
- Baby Formula Northgate Select Club PackMidwest
- String Lights Northgate Select MultipackMidwest
- Activewear Legging Premium Label Value BundleMidwest
- Baking Mix Northgate Value Family SizeMidwest
- Tablet Premium Label SingleMidwest