product_family_label | Family | text | read-only | Model family |
trend_label | Trend | status | read-only | LOW_VOLUME = under 8 family units in 28 days · RISING = momentum ≥ 130 · FALLING = momentum ≤ 70 · STABLE = in between |
momentum_pct | Momentum % | number | read-only | 100 × (season-removed family rate over 28d) ÷ (season-removed family rate over 90d). 100 = same pace as the 90-day average, 150 = 1.5× (+50 %), 70 = 0.7× (−30 %). A ratio, not a growth delta. Empty below 8 units in 28 days |
units_28d | Units 28d | number | read-only | Family units sold, last 28 days |
units_90d | Units 90d | number | read-only | Family units sold, last 90 days |
units_180d | — | number | API only | Family units sold, last 180 days (not a registered app column, but returned by queries) |
units_365d | Units 365d | number | read-only | Family units sold, last 365 days |
sku_count | SKUs | number | read-only | Number of variants in the family |
trend_confidence | Trend confidence | text | read-only | From units_28d alone: high = 30 or more family units in 28 days · medium = 15 to 29 · low = under 15 |
momentum_delta_pct | Momentum Δ vs 90d % | number | read-only | momentum_pct − 100, the same momentum as a growth delta (+52 = 52 % above the 90-day pace) |
units_28d_py / units_90d_py | Units 28d / 90d (prior year) | number | read-only | Family units in the same windows one year earlier |
yoy_pct | YoY % (28d vs prior year) | number | read-only | 100 × (units_28d − units_28d_py) ÷ units_28d_py, a growth delta; empty below 5 prior-year units |
yoy_90d_pct | YoY % (90d vs prior year) | number | read-only | Same delta on 90 days; empty below 15 prior-year units |
units_next90d_py | Units next 90d (prior year) | number | read-only | Family units sold in the 90 days that followed today’s date last year |
units_forecast_next90d | Units next 90d (forecast) | number | read-only | units_next90d_py × (100 + yoy_pct) ÷ 100 — assumes the growth rate holds; empty when yoy_pct is empty |
forecast_daily_demand | Demand/day | number | read-only | Planned family demand per day |
deseasonalized_daily_demand | Adjusted/day | number | read-only | Family rate with the seasonal swing taken out |
calculated_at | Calculated | datetime | read-only | When the view was computed |
