Pipeline Velocity
Confirmed (bars) vs Placed (line) per day tracks daily performance
Pieces Funnel
How many pieces make it through each stage
Sellthrough & Inbound
Total Purchases vs Total Delivered vs Sellthrough % — every month this year
Avg Placed Pcs
Placed pieces ÷ days with placed activity
Category Demand Breakdown
Total demand by product category (Confirmed)
Inventory & Products Performance
Comprehensive SKU metrics: Stock, Profit, Conversion, & Demand Projections
| # | SKU ID | SKU Name | Stock | DOH | Category | Availability | Price | Profit | ASP | CR% | DR% | NDR% | Total CM3 | Avg Placed/Day | Placed YDay | Conf YDay | Avg Conf 3D | Avg Conf 15D | Trend | Top Merch (5D) | Contr% (5D) |
|---|
Account Manager Comprehensive Performance
All Time | Targets vs Actuals & Final KPIs Weight
| # | Account Manager | Final Weight % | Target GMV | Delivered GMV | GMV Achieved % | Run Rate (EOM) | Target NDR% | Actual NDR% | Target CM3% | Actual CM3% | Target Retention | Actual Retention | Placed | Confirmed | Delivered |
|---|
Overall Merchant Performance (With Targets)
Detailed performance for all merchants (Targets, Run Rate, CM3, etc.)
| # | ID | Merchant Name | ACM | Target GMV | Delivered GMV | Run Rate (EOM) | Achieved % | Target Placed | Placed | Confirmed | Delivered | Total CM3 | CM3 % | CR% | DR% | NDR% |
|---|
Merchant Segmentation & Projections
Current segment vs projected EOM segment based on Confirmed Orders Run Rate (Confirmed Orders read from the Merchant Segmentation sheet)
| # | ID | Merchant Name | ACM | Current Segment | Confirmed Orders | RR Confirmed (EOM) | Projected Segment |
|---|
Targets Commercial — Grand Total
Targets Category vs Actual (CM3/rate cut-off Rules)
| Metric | Target | Actual | Achievement % | Status |
|---|
Placed — Status
SKUs grouped by Placed Ach% vs Target MTD
| Status | Placed Count | Total Placed Daily Target | Total Placed AVG | Total Placed Target MTD | Total Placed MTD | AVG ACH |
|---|
Confirmed — Status
SKUs grouped by Confirmed Ach% vs Target MTD
| Status | Confirmed Count | Total Confirmed Daily Target | Total Confirmed AVG | Total Confirmed Target MTD | Total Confirmed MTD | AVG ACH |
|---|
Commercial Plan
SKU demand (Bundle) — Placed / Confirmed / Delivered Pieces / GMV, each with Target MTD, Run Rate & Achievement%
| Product_ID | Product_Name | Category | Placed Daily | Stock | DOH | Active Days | Placed Pieces | Confirmed Pieces | Delivered Pieces | Delivered GMV | CR% | DR% | NDR% | Expected Returns | LAST ASP PLACED | Total CM3 | CM3/Piece | Total PPM | PPM/Piece | CM3% | Status | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MTD Target | Actual | Run Rate | Ach% | MTD Target | Actual | Run Rate | Ach% | MTD Target | Actual | Run Rate | Ach% | MTD Target | Actual | Run Rate | Ach% | ||||||||||||||||||
Purchase Plan
Per Single SKU — how much to buy and its value, based on this month's Need vs. what's Delivered and already Available (Stock + Repack + Expected Returns). Only Singles in the plan are shown, plus any Single that's out of the plan but still used as a component inside a bundle.
| Product_ID | Product_Name | Category | Need Pcs | Delivered Pcs | CR% | DR% | Returns | Begin Stock | Repack | Available | Cost | Qty To Buy | Purchase Value | Avg 3D | DOH | DOH After Qty Buy |
|---|
Pipeline & Insights
Automatic read on this period's movers and PPM risk (Placed Pieces ≥ 10 to qualify)
Products Breakdown
Current period vs previous period
| SKU | SKU Name | Category | Placed Pcs | Confirmed Pcs | Delivered Pcs | CR% | DR% | NDR% | Delivered ASP | Delivered GMV | CM3 | CM3% | Δ vs Prev Period | Total PPM | PPM/Piece | Target PPM | PPM Actual% | PPM/GMV% | Status |
|---|
Top Movers
Top 4 CM3% gainers vs top 4 drops this period (Placed Pieces ≥ 10 to qualify)
CM3 Positive vs Negative
Total qualifying CM3 per period (Placed Pieces >= 10)
CONTR% -VE Trend
Negative contribution vs the 15% target line
CM3 Target Overall Performance
Period-over-period status transitions rows with Placed Pieces < 10 are excluded
Match Details
| Merchant | SKU | Category | CM3 (Previous Period) | CM3 (This Period) |
|---|
Deep Dive CM3 Analysis & Targets
Detailed performance and profitability status mapped with category targets.
Analyst / Products
All SKUs (every product, not only active ones) — this month's PPM & CM3, sorted by Delivered GMV, with Stock/DOH from Recommended Tracker's debundled logic
| SKU ID | SKU NAME | CATEGORY | STOCK | DOH | Selling Price | Profit | ASP | LAST ASP PLACED | Delivered GMV | CONTR GMV% | CR% | DR% | NDR% | PPM/Piece | PPM% | TOTAL DELIVERED PPM | TOTAL CM3 | CM3/PER PIECE | CM3% | TOTAL DELIVERED PCS | TOTAL PLACED PCS | TOTAL CONFIRMED PCS | AVG LAST 3D | AVG LAST 7D | AVG 15D | CONTR PPM% |
|---|
Analyst / Single
Single SKU level (all its bundles combined) — every Single SKU from the debundle map (all singles, even with no activity) with Single/Analyst's demand, inbound & PPM columns — this month's PPM & CM3 (CM3 respects the standard lag cutoff)
| SKU ID | SKU NAME | CATEGORY | LAST INBOUND DATE | ACTIVE DAYS | TOTAL PLACED PCS | TOTAL CONFIRMED PCS | DELIVERED PCS | AVG LAST 3D | AVG LAST 7D | DEMAND (2D) | AVG CONFIRMED DAILY (2D) | AVG CONFIRMED DAILY (5D) | AVG CONFIRMED DAILY (15D) | DEMAND CONFIRMED (3M) | AVG CONFIRMED DAILY (3M) | CR% | DR% | NDR% | STOCK | DOH | SELLING PRICE | PROFIT | ASP | ASP DELIVERED (10D) | LAST ASP PLACED | COGS | DELIVERED GMV | CONTR GMV% | Priceing_PPM | PPM% | PPM SUGGEST Priceing_PPM | TOTAL DELIVERED PPM | PPM/PIECE | CM3 | CM3/PCS | CM3% | CONTR PPM% |
|---|
Matches / Single
Every Merchant working on a Single SKU this month — even via a Bundle, apportioned down to Single SKU level (same debundle logic as Products / Analyst). Status compares this match's activity to last month over the same date range.
| SKU ID | SKU NAME | CATEGORY | MERCHANT ID | MERCHANT | ACM | STATUS | PLACED PCS | CONFIRMED PCS | DELIVERED PCS | AVG DAILY CONFIRMED | PREV AVG DAILY CONFIRMED | MoM TREND | CR% | DR% | NDR% | PPM/PCS | PPM% | CM3 | CM3/PCS | CM3% |
|---|
ACM Sales Plan Tracking
Placed / Confirmed / Delivered / GMV — Target MTD, Run Rate & Achievement% Per SKU, with Owner (ACM)
| Product ID | Product Name | Merchant ID | Merchant Name | Category | ACM (Owner) | Placed Pieces | Confirmed Pieces | Delivered Pieces | Delivered GMV | CR% | DR% | NDR% | ASP | WoW (Confirmed) | Status | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MTD Target | Actual | Run Rate | Ach% | MTD Target | Actual | Run Rate | Ach% | MTD Target | Actual | Run Rate | Ach% | MTD Target | Actual | Run Rate | Ach% | ||||||||||||
Sales Plan - Feedback
Matches under 70% Placed Ach%. Add your feedback and save.
| Product ID | Product Name | Merchant ID | Merchant Name | Category | ACM (Owner) | Daily Target | Placed - MTD Target | Placed - Actual | Placed - Run Rate | Placed - Ach% | Avg Placed Daily | Gap Plan | New Target Placed Daily | Feedback | Adjusted Target (Existing Merchant) | No. of New Merchants | New Merchant ID & Target | Comment (Reason) | Save |
|---|
Outside Sales Plan-ACM Coverage
Matches (Merchant × Product) with no target in the Sales Plan-ACM — their share of the totals above
Performance-Matches
All Merchant x Product matches — CM3 & CM3% (Cutoff D-4)
| Product ID | Product Name | Category | Merchant ID | Merchant Name | ACM | In Plan | Availability | Locked | Stock | DOH | Active Months | Placed Orders | Confirmed Orders | Delivered Orders | Total Placed | Total Confirmed | Total Delivered | CR% | DR% | NDR% | Placed GMV | Confirmed GMV | Delivered GMV | CONTR% | Placed ASP | Delivered ASP | CM3 | CM3/Per Piece | CM3% | PPM | PPM% |
|---|
New Matches
Matches (Merchant × SKU) with activity this month (or in the selected date filter) and no activity at all last month, with more than 5 Placed Pcs
New Matches by Category
Count of new matches per category (This month, or the selected date filter)
New Matches
SKU × Merchant details (This month, or the selected date filter, CM3 at Cutoff D-4)
| SKU ID | SKU Name | Category | Merchant ID | Merchant Name | Total Placed Pcs | Total Confirmed Pcs | Total Delivered Pcs | CR% | DR% | NDR% | CM3/Pieces | CM3 | CM3% | Placed ASP | PPM% | Match Start |
|---|
Decline Matches
Top 20 matches (Merchant × SKU) that pulled Placed down yesterday vs. their previous 4-day average (DAY2–DAY5)
Decline Matches
Top 20 declining matches with stock, locked qty, likely cause and your feedback. Use the ACM filter at the top to see your merchants only.
| # | SKU ID / Name | Merchant ID / Name | ACM | 4D Avg | Yesterday | Drop | Drop % | Impact on SKU | Contr% | Lost GMV | GMV Contr% | Stock | Locked Qty | Likely Cause | Feedback |
|---|
Incentive Merchants
Monthly Confirmed Orders target & bonus per merchant — Actual (MTD) vs. Run Rate for this month
Incentive Merchants — Detail
Target Confirmed Orders vs. Actual (MTD) & Run Rate, with bonus earned/projected per merchant
| Merchant ID | Merchant Name | ACM | Tier | Target Confirmed | Target Confirmed MTD | Confirmed (MTD) | Run Rate (EOM) | Attainment % (Actual) | Attainment % (Run Rate) | Status | Bonus/Per Order | Extra Orders (MTD) | Earned Bonus (MTD) | Bonus (Target) | Total Bonus |
|---|
Good vs Bad Matches
Bad = match NDR% is more than 3pts below the rest of its Sub-Category (cutoff D-4) — vs last month
| Status | Count | Current Period | Same Days Last Month | ||||
|---|---|---|---|---|---|---|---|
| Placed Pieces | Total NDR% | Contribution% | Placed Pieces | Total NDR% | Δ NDR | ||
Poor Matches
Bad matches only, ranked by Impact Pieces — Merchant × SKU combos dragging NDR% down vs their Sub-Category
| Merchant ID | Merchant Name | SKU ID | Product Name | Category | Sub-Category | ACM | Placed Pieces | NDR% | Benchmark NDR% | Impact Pieces | Status |
|---|
Availability Locking — by Category
Single SKU demand (Bundle) vs current stock locks, Placed Yesterday
| Category | IN Stock SKUs | Total AVB SKUs | locked SKUs | solo locked SKUs | Placed Yesterday | locked demand | solo locked demand | Stock at Risk% |
|---|
Active Locks
Every active lock (Merchant × SKU) — allocation, usage, remaining pieces & expiry
| SKU ID | SKU Name | Category | Merchant ID | Merchant Name | Locking Type | Allocated Qty | Used Qty | Remaining Pieces | Stock | Placed Yesterday | Placed Yesterday per Merchant | Expiry Date | Days to Expiry | Status |
|---|
Allocation Locking
Every merchant with real confirmed demand on a SKU currently under Allocation Locking.
| SKU ID | SKU Name | Type | Lock Status | Category | Merchant ID | Merchant Name | Stock | Merchant Avg Confirmed (3D) | Single Overall Avg Confirmed (3D) | CONTR% | CR% | Suggested Allocation | Allocated Qty | Used Qty | Remaining Pieces | Min Bundle Allocation | Last Avg Confirmed 3D | Final Action (Qty to Lock) | Final Action DOH |
|---|
Healthy Locking — by Category
Lock health breakdown per category — where idle stock is stuck vs performing well
| Category | Active Locks | Healthy | At Risk | Unhealthy | Avg Utilization% | Locked Pieces | Idle Pieces |
|---|
Healthy Locking — by Merchant
Lock health breakdown per merchant — who's actually using their locked stock
| Merchant ID | Merchant Name | Active Locks | Healthy | At Risk | Unhealthy | Avg Utilization% | Locked Pieces | Idle Pieces |
|---|
Healthy Locking — Matches
Every active lock (Merchant × SKU) with a Health Status — Healthy, At Risk, or Unhealthy
| SKU ID | SKU Name | Category | Merchant ID | Merchant Name | Locking Type | Allocated Qty | Used Qty | Utilization% | Remaining Pieces | Placed Yesterday | Days to Expiry | Health Status |
|---|
Recommended: Release Candidates
Unhealthy locks (no usage, no recent demand) tying up the most stock — good candidates to release back to open availability
| SKU ID | SKU Name | Category | Merchant | Allocated Qty | Used Qty | Utilization% | Remaining Pieces | Days to Expiry |
|---|
Recommended: Renew Candidates
Top by CONTR% of Delivered GMV combined with lowest DOH
| SKU ID | SKU Name | Category | Merchant ID | Merchant | CONTR% (Delivered GMV) | Remaining Pieces | Allocated Qty | Placed Yesterday (Pieces) | DOH | Days to Expiry | Stock | Reason |
|---|
Unlocking Action's — Matches
Active locks with weak demand (Avg Last 6D Confirmed < 5) — release candidates.
| SKU_ID | SKU_NAME | CATEGORY | AVAILABILITY | LAST INBOUND DATE | MERCHANT NAME | MERCHANT ID | ACM | ALLOCATED QTY | USED QTY | REMAINING PIECES | STOCK | DOH | TOTAL PLACED PCS | TOTAL CONFIRMED PCS | TOTAL DELIVERED PCS | AVG LAST 3D | AVG LAST 6D | AVG LAST 10D | AVG LAST 15D | CR% | DR% | NDR% | SELLING PRICE | PROFIT | LAST ASP PLACED | COGS | Priceing_PPM | PPM% | DELIVERED GMV | CM3 | CM/PCS | CM3% |
|---|
Segmentation Panel — EGY
Target vs Actual and Achievement % per merchant segment.
Loading Data...
Sellthrough Rate Filters
Apply filters to update the Sellthrough data
Confirmed
Category Breakdown Analysis
| CAT | CONFIRMED_PIECES | BEGINNING_INVENTORY | BEGINNING_SALES | RETURNS | RETURN_SALES | TOTAL_PURCHASES | PURCHASES_SALES | OVERFLOW | SELLTHROUGH% | INBOUND VS SOLD |
|---|
Delivered
Category Breakdown Analysis
| CAT | DELIVERED_PIECES | BEGINNING_INVENTORY | BEGINNING_SALES | RETURNS | RETURN_SALES | TOTAL_PURCHASES | PURCHASES_SALES | OVERFLOW | SELLTHROUGH% | INBOUND VS SOLD |
|---|
Sellthrough Trend (This Year)
Total Purchases vs Total Delivered vs Sellthrough % — every month this year
Sellthrough % & Inbound vs Sold — by Category
Last 4 months, ending this month — Delivered basis
Sellthrough & Inbound
Tracking Sales Performance and Inbound Inventory
| SKU | NAME | CAT | Last receiving date | Last Inbound Status | CNF_QTY | DLV_QTY | Beginning_Inventory | BEGINNING_SALES | Remaining from beginning | RTOS | RETURN_SALES | Remaining from purchase sales | TOTAL_PURCHASES | PURCHASES_SALES | SELLTHROUGH_RATE | SELLTHROUGH_RATE (Confirmed) | SOLD_FROM_INBOUND | SOLD_FROM_INBOUND (Confirmed) | First buy? | STOCK | DOH | Availability | Is_Locked | CR% | DR% | NDR% | Cogs | AVG 3D | AVG 15D | DOH(15D) | Selling Price | Profit | Cogs | Priceing_PPM |
|---|
Inventory & Inbound Filters
Pick a month, then a week (Sunday–Saturday) — defaults to the current week. Optionally narrow the purchase/sale window below (pick both dates in a pair to activate it) — leave them empty to keep reading the full selected week as usual.
Weekly Inventory Trend (This Year)
Total Beginning Inventory vs Total Purchases vs Inbound vs Sold % — every week this year
Purchase Cohort Tracker
Total Purchases vs Cumulative Sold (as of today) vs Inbound vs Sold % — every week this year, tracked FIFO on real stock (not just each week's own 7 days). Set a Purchase Start/End above to add its own point (◆ purple) with performance for that exact custom range.
| Week | Total Purchases | Sold So Far | Inbound vs Sold % |
|---|
Week of —
Single SKUs that had an inbound during the selected week
| SKU_ID | SKU_NAME | Category | Availability | Current Stock | DOH | Cogs | Beginning Inventory | Inbound Qty (7d) | Inbound Date | Confirmed Qty (7d) | Beginning Sales | Remaining from Beginning | Confirmed From Purchase | Over Confirmed | Inbound vs Sold | Overachieve | Purchases Sold Out On |
|---|
Building Forecast…
Forecast Model
SKU-level monthly demand forecast — Confirmed pieces, debundled to Single SKUs.
GMV Target — Delivered
What the forecast is worth in money, and what closing the gap to your target actually takes. Delivered basis: forecast pieces × delivery rate × selling price, each SKU on its own numbers.
How Much to Trust This
The same forecast is accurate at some levels and useless at others. These are measured results on past months, not claims — read the level you're actually deciding at.
Method by SKU Size
Each size segment is forecast differently, because different things work at different volumes. The accuracy here is the real result on past months — the final number after every step, not the score of any single method.
| Segment | SKUs | Forecast | How It's Built | Error Correction | Measured Accuracy | vs Last 30d |
|---|
By Behavior
Forecast split by demand behavior for the selected month.
Accuracy Trend
Every past month, forecast only from the data before it, then compared to what actually happened.
| Month | Hit Rate | Accuracy | Naive | Lift | Bias |
|---|
SKU Forecast
Click any column header to sort.
How this forecast works View pipeline diagram
Planner DOH — Single SKUs
Single SKUs (bundles debundled) placed yesterday, with stock and Days-on-Hand worked out two ways.
| SKU | Name | Category | Stock | Placed Yesterday | Avg 3D Confirmed | CR% | DR% | NDR% | CR% Used | Placed × CR | Diff (Placed×CR − Avg 3D) | DOH (Placed × CR) | DOH (Avg 3D) |
|---|