Turn this view into work. Preserve the current source, assign an owner, and measure the outcome.Create action from this view
Customer Trailside Square (ID: C20107)
Back to CustomersLifetime value
$381,708.38
Orders
82
AOV
$4,654.98
Revenue / month
$54,529.77
•
Orders / month
11.7
Profit
$53,359.82
Margin
14.0%
Recent momentum
$25,457.05
Last 30d
$22,402.67
n/a
Orders 90d
6
Avg ticket
$4,242.84
• Profit
$806.09
(
3.2%
)
Customer health
Churn risk
Low
Days since last order
13 days
Cadence avg
12.7
d •
median
9.0
d
Range
1.0
d -
108.0
d
Best weekday Tuesday
(
$95,203.31
)
Account profile
Segment Stable
Recent activity and revenue are broadly stable.
First order
2023-10-07T00:00:00
Last order
2026-06-21T00:00:00
Months active
29
•
Span
988
days
Primary region Northeast
Ship method DC Ambient
Unique products
276
Opportunity highlights
- Top product Tablet Everyday Basics 2-Pack $25,638.89
- Top weight mover Baby Formula Everyday Basics Club Pack 876.61 lb
- Top profit product Storage Bin Exclusive Brand Multipack $4,338.27 ( 33.7% )
- Pricing spread $1.44 / $87.83
- Cross-sell ideas 5
Action center
- Orders last 30d 5
- Orders last 90d 6
- Days since last order 13
- Cadence range 1.0 - 108.0 d
Profit snapshot
Lifetime profit
$53,359.82
Margin
14.0%
90d profit
$806.09
90d margin
3.2%
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 % |
|---|---|---|---|---|
| Coffee Maker Northgate Value Family Size | $4,110.74 | $3,091.45 | $1,019.28 | 24.8% |
| Bed Sheet Set Northgate Select Value Bundle | $4,060.42 | $3,195.77 | $864.65 | 21.3% |
| Bacon Northgate Select Multipack | $2,870.71 | $2,248.14 | $622.57 | 21.7% |
| String Lights Everyday Basics Club Pack | $2,564.83 | $1,957.94 | $606.89 | 23.7% |
| Shrimp Premium Label Single | $2,473.39 | $2,096.09 | $377.30 | 15.3% |
| Kids Hoodie Exclusive Brand Travel Size | $1,013.37 | $646.68 | $366.69 | 36.2% |
| Coffee Maker National Brand Family Size | $1,454.75 | $1,092.10 | $362.65 | 24.9% |
| Allergy Relief Premium Label Bulk | $1,263.68 | $927.64 | $336.04 | 26.6% |
| Cookware Set Exclusive Brand Family Size | $1,281.94 | $948.45 | $333.49 | 26.0% |
| Condiments National Brand Multipack | $1,382.35 | $1,096.47 | $285.89 | 20.7% |
| Skin Care Everyday Basics Multipack | $891.69 | $627.53 | $264.16 | 29.6% |
| Vitamins Exclusive Brand Family Size | $892.33 | $636.07 | $256.26 | 28.7% |
| Chicken Breast Northgate Value Value Bundle | $812.94 | $602.50 | $210.45 | 25.9% |
| Vitamins National Brand Travel Size | $831.51 | $645.23 | $186.28 | 22.4% |
| Shrimp Northgate Value Family Size | $926.29 | $743.32 | $182.97 | 19.8% |
| Sleepwear Set Northgate Value Travel Size | $476.08 | $301.03 | $175.04 | 36.8% |
| Chicken Breast Everyday Basics Multipack | $820.50 | $672.78 | $147.72 | 18.0% |
| Kids Hoodie Northgate Select Family Size | $489.13 | $347.90 | $141.24 | 28.9% |
| Baby Formula Everyday Basics Club Pack | $1,337.74 | $1,200.00 | $137.75 | 10.3% |
| Ground Beef Northgate Select Travel Size | $743.78 | $619.30 | $124.48 | 16.7% |
| Dish Soap National Brand Multipack | $776.08 | $656.95 | $119.13 | 15.4% |
| Fresh Herbs Northgate Value Multipack | $458.80 | $348.45 | $110.35 | 24.1% |
| Deli Turkey Northgate Value Value Bundle | $1,118.50 | $1,010.89 | $107.61 | 9.6% |
| Ground Beef Everyday Basics Single | $434.28 | $329.68 | $104.59 | 24.1% |
| Baking Mix Northgate Select Club Pack | $596.25 | $492.69 | $103.57 | 17.4% |
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 14
- Avg lines / order 8.2
- Avg weight (lb) / order 591.57
- Avg items / order 54.4
- Avg ticket $4,654.98
Price Intelligence (vs peer median)
Region-aware where available
| Product | Customer Unit | Peer Median | Δ vs Peer | Suggested |
|---|---|---|---|---|
| Coffee Maker Northgate Value Family Size | $30.35 | $32.78 | -7.4% | $32.78 |
| Bed Sheet Set Northgate Select Value Bundle | $23.21 | $25.97 | -10.6% | $25.97 |
| Bacon Northgate Select Multipack | $9.97 | $11.34 | -12.1% | $11.34 |
| String Lights Everyday Basics Club Pack | $12.60 | $15.51 | -18.8% | $15.51 |
| Shrimp Premium Label Single | $7.31 | $8.28 | -11.7% | $8.28 |
| Coffee Maker National Brand Family Size | $16.70 | $20.76 | -19.6% | $20.76 |
| Condiments National Brand Multipack | $3.62 | $4.29 | -15.8% | $4.29 |
| Baby Formula Everyday Basics Club Pack | $3.32 | $3.78 | -12.3% | $3.78 |
Suggestion is the peer median realized unit price. Adjust with margin guardrails as needed.
Cross-sell Suggestions
- Bananas Northgate Select Travel SizeNortheast
- Condiments Northgate Select Value BundleNortheast
- String Lights Northgate Select MultipackNortheast
- Pasta Everyday Basics MultipackNortheast
- Breakfast Cereal Exclusive Brand Club PackNortheast