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
Product Intelligence Workspace
SKU DF-1270DF-1270 — Greek Yogurt Northgate Select Single

Greek Yogurt Northgate Select Single

Last 28 days revenue moved by $1,027 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $122 and margin improved.
Current scoped window: Oct 1, 2025 – Jul 5, 2026. Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07. · Refreshed 2026-08-15T20:28:11.096859+00:00
Posture: VolatileLifecycle: UnstableClassification: VariableProtein: Dairy & Frozen Target status: Materially below minimum Gross margin gates: min 18.0% · target 24.0% Meat Manager cost/lb: $3.27Effective cost/lb: $3.29Min price/lb: $5.03Target price/lb: $5.42ASP/lb: $2.93Top customer: Unknown · $804.62Lead region: Texas & Gulf · $2,461.47Cost coverage: 100.0%Last sold: Jul 1, 2026Data confidence: Medium
What is happening
Last 28 days revenue moved by $1,027 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $122 and margin improved.
Next: Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07.
Why it matters
100.0% of revenue sits below the target margin threshold.
Next: Use the risk, pricing, and customer sections to confirm whether the issue is concentration, margin, or demand quality.
What to do next
Cedar Park Depot offers up to $385 of margin uplift to target.
Next: Click any action card, customer row, margin-risk row, basket row, or chart point to inspect context without leaving the page.
Commercial outcome
$11,894.37
Gross margin -12.2% · Contribution 0.1%
Weight & movement
4,056 lb
Avg 47.7 lb/order · 102.1 lb/wk
Primary risk
Margin recovery needed
100.0% of revenue sits below the target margin threshold.
Best next move
Pricing recovery
Cedar Park Depot offers up to $385 of margin uplift to target.
Interactive detail
Context
Click a card, row, or chart point to inspect what changed, why it matters, and where to go next.

Executive Scorecard

Commercial outcome, demand movement, pricing quality, customer reach, and trust indicators for the active scoped window.

Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07. Use this layer to decide whether this SKU matters because of commercial scale, weight importance, pricing leakage, or customer dependency.
Export scorecard
Commercial Outcome
Revenue, gross margin, contribution, and recent movement.
Revenue$11,894.37
Gross Margin $$-1,447.74
Margin %-12.2%
Contribution Share0.1%
28D Revenue Δ$-1,026.67 / -43.1%
28D Weight Δ-351.1 / -43.6%
Demand & Movement
Units, shipped lb, cadence, movement efficiency, and stability.
Orders85
Customers58
Units294.0
Shipped lb4,056.4
Avg units / order3.46
Avg lb / order47.72
Avg lb / unit13.80
Demand stability30
Pricing & Margin
ASP/lb-first pricing view with price dispersion and margin exposure.
ASP/lb$2.93
Meat Manager cost / lb$3.27
Effective cost / lb$3.29
Minimum price / lb$5.03
Target price / lb$5.42
ASP/lb gap to minimum$-2.09
ASP/lb gap to target$-2.49
ASP/unit$40.46
Profit / lb$-0.36
Current gross margin %-12.2%
Minimum gross margin %18.0%
Target gross margin %24.0%
Target achievement54.1%
Price P10 / P50 / P90$2.82 / $3.00 / $3.05
Dispersion ratio1.08
Margin-risk exposure100.0%
Price-outlier revenue32.4%
Customer Reach & Planning
Penetration, repeat quality, lifecycle status, and planning confidence.
Repeat customer share36.2%
New customer share10.3%
Recent repeat revenue share58.3%
Customer cadence72.0 d
Lifecycle stageUnstable
Seasonality strength83
Forecastability24 · Low
Decision Layer
Immediate actions based on current risk, opportunity, and recent movement. Click a card to open the supporting context.
Address the primary risk
100.0% of revenue sits below the target margin threshold.
Pursue the highest-value opportunity
Cedar Park Depot offers up to $385 of margin uplift to target.
Reset the lifecycle plan
Unstable stage with 10 active months. Recent 3-month revenue is up 13.7% vs prior 3 months; customer adoption is stable.
Re-engage at-risk customers
Cedar Park Depot has not bought in 140 days.
Risk & Opportunity
Top enterprise signals across concentration, pricing, seasonality, lifecycle, and planning.
Primary risks
Margin recovery needed
100.0% of revenue sits below the target margin threshold.
Seasonality risk
Seasonality strength score is 83; demand planning should follow seasonal peaks and troughs.
Forecast uncertainty
Low forecast confidence using damped_ma with 10 history points.
Top opportunities
Pricing recovery
Cedar Park Depot offers up to $385 of margin uplift to target.
Basket expansion
FP-1123 — Apples Exclusive Brand 2-Pack shows lift 4.58 with paired revenue 1,661.
Performance Story
What changed in the last 28 days, which lever mattered most, and what to do next. Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07.
At risk

Last 28 days revenue moved by $1,027 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $122 and margin improved.

Recommended action: Review price execution, cadence, and at-risk customers before volume erosion deepens.
ASP/lb Effect
$20.99
LB Volume Effect
$-1,038.52
Mix / Interaction
$-9.15
Customer Movers
Largest 28-day revenue movers within this product’s customer base. Click a customer to inspect the change and open drilldown.
Top gainers
Top decliners

Trend, Lifecycle & Seasonality

Revenue, profit, weight, ASP/lb, lifecycle stage, and seasonal demand shape with clearer planning context.

Use this layer to separate sustained demand shifts from seasonality. Monthly charts show the active scoped history; seasonality uses the full available pattern for this SKU.
Export time series
Revenue, Profit & Shipped lb Trend
Monthly commercial outcome with weight context and rolling revenue average.
Outcome trend chart
Lifecycle & Price Quality
ASP/lb, margin quality, lifecycle stage, and planning confidence.
ASP/lb and margin trend
Lifecycle stage
Unstable
Trend direction
Volatile
Months active
10
Forecastability
24
Seasonality Heatmap
Year-over-year revenue intensity by month with shipped lb in hover context.
Seasonality heatmap
Seasonality Profile
Strength, best months, worst months, and normalized seasonal shape.
Seasonality profile
Seasonality strength83
Best monthsMay, Apr, Jan
Worst monthsOct, Jul, Nov
Seasonality is directional only; fewer than 12 months are available.

Weight Analytics

Weight is treated as a first-class commercial and operational signal, not a secondary diagnostic.

Use this section when the SKU matters because of shipped lb, pack economics, or heavy-account exposure. Protect high-weight strategic items even when units alone look flat.
Export weight series
Weight, Revenue/lb & Profit/lb Trend
How shipped lb and per-lb economics are moving over time, with pack intensity kept in summary diagnostics.
Weight analytics chart
Weight Summary
Operational weight profile, order concentration, and signal quality.
Revenue / lb$2.93
Profit / lb$-0.36
Avg lb / customer69.9
Top heavy-order share34.4%
Top-5 customer weight share28.4%
Weight intensity change0.8%
Order weight P10 / P50 / P9013.1 / 29.8 / 112.5
Weight and unit movement are moving together.
Top Customers by Weight
The accounts that matter most when the product is analyzed in shipped lb rather than units alone. Click a row to inspect dependence and open customer drilldown.
Export
CustomerWeight lbWeight shareRevenueASP/lbOrders
Cedar Park Depot304.57.5%$804.62$2.641
Fairview Depot241.76.0%$684.37$2.833
Silver Lake Junction217.75.4%$615.99$2.833
Oakmont Exchange 109204.35.0%$615.70$3.013
Harvest Point Pointe183.54.5%$552.89$3.012
Summit Market158.33.9%$476.21$3.012
Highland Center149.63.7%$423.60$2.832
Sunfield Landing144.63.6%$436.36$3.021
Harvest Point Exchange139.73.4%$419.03$3.002
Fox Run Exchange134.43.3%$405.04$3.011
Weight Relationship Diagnostics
How strongly weight ties to revenue, units, and pricing under this product’s order pattern.
Weight ↔ Revenue
1.00
Weight ↔ Units
1.00
ASP/lb ↔ Weight
-0.36
Avg lb / order
47.7
Use these diagnostics to separate volume quality from simple unit movement. If weight and units diverge, pack mix or order composition is shifting.

Pricing, Margin & Elasticity

ASP/lb-first diagnostics for distribution, demand response, margin risk, and recovery opportunity.

Use pricing diagnostics to separate broad price dispersion from specific below-target customers. Margin-risk rows rank recoverable uplift to the department-specific target inside the current scoped window.
Export pricing base
ASP/lb Distribution
Transaction-level ASP/lb with guardrails and price-outlier bounds.
ASP/lb distribution histogram
Guardrails: P10 $2.82, P50 $3.00, P90 $3.05 · Price-outlier revenue share 32.4%
Price vs Demand Relationship
Directional elasticity proxy using ASP/lb against the relevant demand basis.
Price vs demand scatter
Elasticity proxy on ASP/lb vs Shipped lb: slope -159.1914, correlation -0.36. Indicative only.
Margin at Risk by Customer
Below-target gross-margin accounts ranked by recoverable uplift and recency. Click a row to inspect the account and open customer drilldown.
Below-target customers
58
Target 24.0%
Revenue at risk
$11,894.37
Margin uplift to target
$4,302.39
CustomerRevenueWeight lbProfitMargin %Gap (pp)Uplift to TargetOrdersCadence (d)Last order
Cedar Park Depot$804.62304.5$-192.34-23.9%47.9$385.451Feb 11, 2026
Fairview Depot$684.37241.7$-108.81-15.9%39.9$273.06394Jun 16, 2026
Silver Lake Junction$615.99217.7$-98.48-16.0%40$246.32352.5Jun 26, 2026
Oakmont Exchange 109$615.7204.3$-54.99-8.9%32.9$202.76342Jul 1, 2026
Harvest Point Pointe$552.89183.5$-48.95-8.9%32.9$181.642177May 23, 2026
Highland Center$423.6149.6$-68.35-16.1%40.1$170.012127May 21, 2026
Summit Market$476.21158.3$-43.37-9.1%33.1$157.662134Apr 27, 2026
Redbud Pointe$377.26133.9$-61.56-16.3%40.3$152.11Jan 7, 2026
Sunfield Landing$436.36144.6$-37.43-8.6%32.6$142.161May 30, 2026
Fox Run Commons$341.85121.4$-58.68-17.2%41.2$140.72333.5Jan 25, 2026
Harvest Point Exchange$419.03139.7$-39.54-9.4%33.4$140.11272Mar 8, 2026
Clearwater Market$401.47133.6$-38.19-9.5%33.5$134.55340Apr 19, 2026
Fox Run Exchange$405.04134.4$-35.29-8.7%32.7$132.51May 7, 2026
Prairie View Galleria$243.7392.5$-60.42-24.8%48.8$118.91241Dec 30, 2025
Ridgeway Galleria$359.79119.5$-31.85-8.9%32.9$118.21Apr 15, 2026
Riverbend Station$301.1599.8$-27.04-9.0%33$99.312128Jul 1, 2026
Cedar Park Square$232.9177.1$-20.27-8.7%32.7$76.171Jun 8, 2026
Summit Village$204.8168.7$-21.47-10.5%34.5$70.632144Jun 25, 2026
Copper Ridge Junction$214.6970.6$-17.86-8.3%32.3$69.382232May 31, 2026
Vista Park Crossing$203.3967.5$-19.07-9.4%33.4$67.88224May 9, 2026
Oakmont Gateway$196.3765.6$-19.83-10.1%34.1$66.96221Dec 26, 2025
Copper Ridge Market 84$152.7354$-25.75-16.9%40.9$62.412178Apr 23, 2026
Clearwater Square$178.9660.1$-19.45-10.9%34.9$62.4281Mar 26, 2026
Meadowbrook Depot$160.5454.6$-20.52-12.8%36.8$59.05396Apr 26, 2026
Willow Creek Market$173.5757.7$-16.89-9.7%33.7$58.54218Mar 30, 2026
Westfield Village$170.8456.4$-14.41-8.4%32.4$55.411Jan 28, 2026
Maple Grove Exchange$164.8554.7$-14.88-9.0%33$54.441May 6, 2026
Stonegate Exchange$161.5953.6$-14.56-9.0%33$53.341May 11, 2026
Granite Falls Crossing$159.8453$-14.34-9.0%33$52.71May 19, 2026
Sunfield Town Center$137.1245.9$-13.96-10.2%34.2$46.871May 14, 2026
Trailside Center$134.3845$-13.54-10.1%34.1$45.791Nov 7, 2025
Vista Park Landing$128.5642.9$-12.49-9.7%33.7$43.341Jan 21, 2026
Lakeview Village$124.0541.5$-12.56-10.1%34.1$42.331Nov 8, 2025
Summit Supercenter$119.4939.9$-12.01-10.1%34.1$40.691Jun 26, 2026
Clearwater Plaza$93.3231$-8.92-9.6%33.6$31.321Apr 8, 2026
Kingsport Square$77.0527.2$-12.74-16.5%40.5$31.231May 7, 2026
Prairie View Gateway$88.7629.5$-8.56-9.6%33.6$29.861Apr 2, 2026
Harvest Point Town Center$83.4728.2$-9.55-11.4%35.4$29.581Dec 2, 2025
Redbud Marketplace$87.5729.1$-8.46-9.7%33.7$29.481Apr 1, 2026
Redbud Galleria$88.3628.9$-7.17-8.1%32.1$28.381Jun 30, 2026

Customer Dependence & Reach

Which customers drive the product, how concentrated the mix is, and where churn risk is emerging.

This layer shows whether the SKU is broadly adopted or overly dependent on a few accounts. Concentration risk matters even when topline revenue still looks healthy.
Export customers
Top Customers
Revenue, weight, pricing, cadence, and profitability in one scanning-friendly table. Click a row to inspect dependence and open customer drilldown.
CustomerRevenueWeight lbProfitMargin %ASP/lbOrdersCadenceLast orderStatus
Cedar Park Depot$804.62304.5$-192.34-23.9%$2.641 dFeb 11, 2026At risk
Fairview Depot$684.37241.7$-108.81-15.9%$2.83394.0 dJun 16, 2026Active
Silver Lake Junction$615.99217.7$-98.48-16.0%$2.83352.5 dJun 26, 2026Active
Oakmont Exchange 109$615.70204.3$-54.99-8.9%$3.01342.0 dJul 1, 2026Active
Harvest Point Pointe$552.89183.5$-48.95-8.9%$3.012177.0 dMay 23, 2026Active
Summit Market$476.21158.3$-43.37-9.1%$3.012134.0 dApr 27, 2026Active
Sunfield Landing$436.36144.6$-37.43-8.6%$3.021 dMay 30, 2026Active
Highland Center$423.60149.6$-68.35-16.1%$2.832127.0 dMay 21, 2026Active
Harvest Point Exchange$419.03139.7$-39.54-9.4%$3.00272.0 dMar 8, 2026At risk
Fox Run Exchange$405.04134.4$-35.29-8.7%$3.011 dMay 7, 2026At risk
Clearwater Market$401.47133.6$-38.19-9.5%$3.00340.0 dApr 19, 2026At risk
Redbud Pointe$377.26133.9$-61.56-16.3%$2.821 dJan 7, 2026At risk
Ridgeway Galleria$359.79119.5$-31.85-8.9%$3.011 dApr 15, 2026At risk
Fox Run Commons$341.85121.4$-58.68-17.2%$2.82333.5 dJan 25, 2026At risk
Riverbend Station$301.1599.8$-27.04-9.0%$3.022128.0 dJul 1, 2026Active
Prairie View Galleria$243.7392.5$-60.42-24.8%$2.64241.0 dDec 30, 2025At risk
Cedar Park Square$232.9177.1$-20.27-8.7%$3.021 dJun 8, 2026Active
Copper Ridge Junction$214.6970.6$-17.86-8.3%$3.042232.0 dMay 31, 2026Active
Summit Village$204.8168.7$-21.47-10.5%$2.982144.0 dJun 25, 2026Active
Vista Park Crossing$203.3967.5$-19.07-9.4%$3.01224.0 dMay 9, 2026At risk
Oakmont Gateway$196.3765.6$-19.83-10.1%$2.99221.0 dDec 26, 2025At risk
Clearwater Square$178.9660.1$-19.45-10.9%$2.98281.0 dMar 26, 2026Active
Willow Creek Market$173.5757.7$-16.89-9.7%$3.01218.0 dMar 30, 2026At risk
Westfield Village$170.8456.4$-14.41-8.4%$3.031 dJan 28, 2026At risk
Maple Grove Exchange$164.8554.7$-14.88-9.0%$3.011 dMay 6, 2026At risk
Customer Concentration
Revenue, weight, and repeat structure for the current customer base.
Top 1 revenue share
6.8%
Top 5 revenue share
27.5%
Top 5 weight share
28.4%
HHI (0-10k)
314
Repeat customer share
36.2%
New customer share
10.3%
Customer Activity & Churn Risk
Active customer trend with at-risk accounts requiring follow-up.
Customer activity chart
At-risk customers
  • 140 days since last order
  • 115 days since last order
  • 55 days since last order
  • 73 days since last order
  • 175 days since last order

Basket & Cross-Sell Intelligence

Associated products, lift, support, confidence, and a lightweight suggestion workflow for commercial follow-up.

Basket metrics are evidence, not guarantees. Prioritize pairs with both lift and meaningful paired revenue, then inspect the SKU and account context before you push a bundle.
Export basket
How to use this
Support is the share of scoped orders containing the pair. Confidence is the share of this SKU’s orders that also contain the paired item. Lift compares that confidence against the paired item’s usual prevalence.
Next: Select likely pairs, inspect the associated SKU, then build a commercial suggestion list for follow-up.
Basket lift chart
Base orders: 85 · Total scoped orders: 4,184
Support is the share of scoped orders containing the pair. Confidence is the share of this product’s orders that also contain the paired item. Lift compares that confidence against the paired item’s normal prevalence.
No associated products selected.
Associated productCo-ordersSupportConfidenceLiftPaired revenue
FP-1123 — Apples Exclusive Brand 2-Pack0.19%9.41%4.58$1,661.39
EL-1308 — Streaming Stick Premium Label Multipack0.14%7.06%3.69$5,261.62
DF-1246 — Eggs Northgate Select Value Bundle0.14%7.06%3.65$654.53
GR-1238 — Cooking Oil National Brand Travel Size0.14%7.06%4.22$592.21
HW-1148 — Razors Everyday Basics Travel Size0.12%5.88%2.97$4,008.89
MS-1224 — Deli Turkey Northgate Select Single0.12%5.88%3.42$1,983.83
MS-1240 — Rotisserie Chicken National Brand Club Pack0.12%5.88%2.80$1,256.38
GR-1203 — Condiments National Brand Multipack0.12%5.88%3.08$1,172.63
DF-1084 — Eggs Northgate Select Family Size0.12%5.88%2.97$914.37
GR-1154 — Rice Exclusive Brand Bulk0.12%5.88%2.83$718.45
FP-1022 — Potatoes Northgate Select 2-Pack0.12%5.88%2.83$375.01
DF-1309 — Frozen Pizza Everyday Basics Single0.12%5.88%2.97$340.17
HW-1141 — Skin Care Everyday Basics Multipack0.10%4.71%2.03$3,576.00
HW-1284 — Razors Everyday Basics Bulk0.10%4.71%1.99$1,995.73
HW-1193 — Skin Care Northgate Value Bulk0.10%4.71%2.21$1,931.28
HK-1066 — Cookware Set Premium Label Single0.10%4.71%2.26$1,879.74
HW-1023 — Cold & Flu Exclusive Brand Travel Size0.10%4.71%2.70$1,410.22
FP-1186 — Fresh Herbs Northgate Value Single0.10%4.71%2.19$982.22
DF-1272 — Shredded Cheese Northgate Value Family Size0.10%4.71%2.34$927.93
GR-1183 — Baby Formula Premium Label Value Bundle0.10%4.71%2.16$813.40
FP-1098 — Bananas Premium Label Bulk0.10%4.71%2.32$770.42
HW-1209 — Pain Relief Northgate Value Value Bundle0.10%4.71%2.26$580.14
FP-1223 — Fresh Herbs Northgate Value Multipack0.10%4.71%2.14$528.42
FP-1293 — Bananas Everyday Basics Travel Size0.10%4.71%2.46$248.13
GR-1303 — Soda 12pk Premium Label Single0.10%4.71%2.32$247.03

Forecast & Planning

Planning view with method labeling, confidence framing, weight-aware forecast output, and sparse-history safeguards.

Forecast is advisory, not autopilot. Confidence depends on usable history, repeatability, and noise in the active scoped series.
Export forecast
Revenue & Weight Forecast
Low forecast confidence using damped_ma with 10 history points.
Method
damped_ma
History points
10
Forecastability
24
Confidence
Low
Forecast chart
Method: damped_ma · History points: 10 · Revenue sMAPE: 102.6% · Weight sMAPE: 103.5% · Forecastability: 24