Target — Aug-26 (full month)
Actual — Month-to-date (with run-rate projection)
PIC Progress
Click a column header to sort (default: highest GMV target first). Green/amber/red on Actual-side metrics follow the same ahead/on-track/behind pace bands used in the gauges above; MKT/GMV% coloring is lower-is-better (more efficient than planned).
| PIC | GMV Target | GMV Actual | % Progress | Run-rate % | Remaining $ | MKT Target | MKT Actual | % Spent | Target MKT/GMV% | Current MKT/GMV% | Ads Budget | Ads Spent $ | Promo Budget | % Spent Promo |
|---|
Product Line Progress
Click a column header to sort (default: highest GMV target first) · Click a row to filter the SKU Breakdown table below to that Product Line. % STR (Sell-Through Rate) = Actual Units Sold ÷ (Actual Units Sold + current on-hand inventory) — a proxy since we don't keep a beginning-of-month inventory snapshot. MKT/GMV = Marketing fee (Ads + Promo) as a % of GMV; lower vs target is better.
| Product Line | Target GMV | Actual GMV | % Progress GMV | % Run-rate GMV | Target MKT/GMV | Actual MKT/GMV | % Progress MKT/GMV | % STR |
|---|
Daily Trends
Columns = GMV per day · Line = total Marketing fee (Ads + Promo) per day · Scroll horizontally on long months
Action Code Summary
Rule-based diagnostics across the filtered SKUs (same trend/DOC/ads data as the Product Performance tab). Click a code to filter the table below to those SKUs; open Product Performance for the full detail + suggested action per SKU.
SKU Breakdown
Click a column header to sort. Table reflects the filters above, plus the Inventory Health bucket and/or Action Code selected up top (if any). Inv = salable inventory units. DOC (Days of Cover) = (Inv Y4A + Inv AMZ) ÷ trailing 7-day avg units/day — hover a DOC badge for velocity + projected stockout date.
| PIC | Main PL | Sub PL | SKU | Product Name | Channel | Portfolio | DOC (days) | Inv Y4A | Inv AMZ | Target GMV | Actual GMV | GMV Run-rate | Target MKT $ | Actual MKT $ | MKT Run-rate | Target Units | Actual Units | Action gợi ý | Glance views | CR |
|---|
PIC Overview
KPI is always the full-month target. Actual reflects the date range above (defaults to all days loaded this month). Remain Daily = (KPI − Actual) ÷ Day Left.
| PIC | KPI | Actual | Remain Daily | % Achievement | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GMV | RS | Ads Spend | TACOS | GMV | RS | Ads Spend | Ads GMV | Ads RS | ACOS | TACOS | GMV | RS | Ads Spend | TACOS | GMV | RS | Ads Spend | TACOS | |
Detail — Main PL / Sub PL / SKU
Click ▸ to expand a Main PL into Sub PL, then into SKU.
| Product Line / SKU | PIC | KPI | Actual | % Achievement | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GMV | RS | Ads Spend | TACOS | GMV | RS | Ads Spend | ACOS | TACOS | %Ads/GMV | Ads CPU | GMV | RS | Ads Spend | TACOS | ||
Daily Breakdown
One row per day in the filtered range above (PIC / Product Line / Exclude SPT / Actual date range). Total Ordered Units = store-wide units that day (not just ads-attributed). ACOS = Ads Spend ÷ Ads-attributed GMV. TACOS = Ads Spend ÷ Total GMV.
| Date | Total GMV | Total Spend | Total Clicks | Total Impressions | Total Ordered Units | CTR | CR Ads | ACOS | TACOS |
|---|
Top Movers — GMV, trailing 7 days vs prior 7 days
Ranked by dollar change between the two most recent 7-day windows of sales history (reaches back into the prior month if needed, so this works from day 1 of a new month too). Shows N/A only for a SKU with no sales history at all yet.
▼ Biggest Decliners
| SKU | Product Name | PIC | Prior 7d | Last 7d | Δ $ | Δ % |
|---|
▲ Biggest Growers
| SKU | Product Name | PIC | Prior 7d | Last 7d | Δ $ | Δ % |
|---|
Product Performance Detail
Click a column header to sort. Reflects the filters above, plus the Product Health bucket selected up top (if any). Trend = trailing 7-day vs prior 7-day GMV. Suggested Action is a rule-based flag (stock risk first, then trend, then ads efficiency) — a starting point, not a final call.
| PIC | Main PL | SKU | Product Name | Trend (7d vs prior) | DOC | TACOS | Ads Spend (MTD) | GMV (MTD) | Suggested Action |
|---|
💾 Connected to Supabase — action plans are saved permanently and shared across sessions/devices.
Code legend: INV = Inventory · LIS = Listing · PRC = Price · MKT = Ads & Promotion · Others = miscellaneous. PIC defaults to the main owner of the selected product group but can be changed.
💾 Connected to Supabase — the full project update history is saved permanently and shared across sessions/devices.
Project Log
Each entry is timestamped MM/DD/YYYY, newest on top within each cell.
| Project | Progress | Issues |
|---|
