Sales Performance
Real ASM scorecards with KPI drill-down, not just a top-line dashboard.
I have aligned this module to the structure of your existing Sales KPI site: real ASM IDs, real key-SKU and clearstock targets, manager-entered soft inputs, and a detail view per ASM.
Tracking period: April 2026 · Live Supabase rows: 1 · Seeded fallback rows: 13
ASM scorecards
14 live
Current period
April 2026
ERP-fed KPIs
Revenue + SKU + Clearstock
Detail view
Per ASM
Total actual revenue
5,975M
ERP revenue feed
Average KPI
77 pts
Total score / 100
Above 80% revenue
10/14
Revenue threshold
Projected KPI payout
238.84M
Based on the original formula
ASM scorecards
Built around the real ASM roster
| ASM | Source | Revenue | ERP score | Manager KPI | Total | KPI payout | |
|---|---|---|---|---|---|---|---|
Ma Van Nam NV0494 · Phu Tho - Thai Nguyen - Vinh Phuc | Seeded | 510/500M 102% target | 95 pts | 5/5 | 100 pts | 20.5M | View detail |
Hoang Duc Khanh NV0378 · Hue - Da Nang - Quang Binh | Live | 0/500M 0% target | 0 pts | 0/5 | 0 pts | 0M | View detail |
Pham Van Loc NV0461 · Can Tho - Hau Giang - Soc Trang | Seeded | 476/500M 95% target | 82 pts | 5/5 | 87 pts | 19.47M | View detail |
Nguyen Trong Dong NV0487 · Nghe An - Ha Tinh - Thanh Hoa | Seeded | 395/500M 79% target | 59 pts | 3/5 | 62 pts | 15.38M | View detail |
Tran Van Trieu NV0484 · An Giang - Dong Thap - Kien Giang | Seeded | 438/500M 88% target | 65 pts | 5/5 | 70 pts | 17.43M | View detail |
Pham Huu Chat NV0486 · Ha Noi | Seeded | 548/500M 110% target | 95 pts | 5/5 | 100 pts | 20.5M | View detail |
Nguyen Minh Hoang NV0485 · Gia Lai - Binh Dinh - Phu Yen | Seeded | 362/500M 72% target | 54 pts | 3/5 | 57 pts | 15.38M | View detail |
Doan Nang Duan NV0491 · Hai Phong - Quang Ninh - Hai Duong | Seeded | 488/500M 98% target | 87 pts | 5/5 | 92 pts | 19.47M | View detail |
Nguyen Hong Vinh NV0493 · Ha Noi | Seeded | 420/500M 84% target | 75 pts | 5/5 | 80 pts | 17.43M | View detail |
Do Quy Phuong NV0492 · Ha Noi - Bac Ninh | Seeded | 505/500M 101% target | 95 pts | 5/5 | 100 pts | 20.5M | View detail |
Nguyen Bao Thanh Nha NV0495 · TP. Ho Chi Minh | Seeded | 470/500M 94% target | 87 pts | 5/5 | 92 pts | 19.47M | View detail |
Tran Thi Van NV0490 · TP. Ho Chi Minh | Seeded | 384/500M 77% target | 54 pts | 3/5 | 57 pts | 15.38M | View detail |
Tran Van Trinh NV0498 · Bac Ninh - Bac Giang - Lang Son | Seeded | 446/500M 89% target | 75 pts | 5/5 | 80 pts | 17.43M | View detail |
Nguyen Dinh Huan NV0499 · Hai Phong - Hai Duong - Ninh Binh | Seeded | 533/500M 107% target | 95 pts | 5/5 | 100 pts | 20.5M | View detail |
Manager inputs
Reporting and discipline overlay
Ma Van Nam
Manager: Tran Thi Thanh Trang · Seeded review copy
Performance on track across the northern cluster. Reporting is timely and exception handling is clean.
Hoang Duc Khanh
Manager: Tran Thi Thanh Trang · Live data
Revenue is healthy, but clearstock on Prenatal still needs tighter field follow-through.
Pham Van Loc
Manager: Tran Thi Thanh Trang · Seeded review copy
Southern territory is stable. Customer acquisition met threshold and team discipline is strong.
Nguyen Trong Dong
Manager: Tran Thi Thanh Trang · Seeded review copy
Coverage is acceptable, but Collagen sell-out is below the key-SKU threshold this cycle.
Tran Van Trieu
Manager: Tran Thi Thanh Trang · Seeded review copy
Execution is balanced, though the region still needs one more push on new-customer conversion.
Real SKU targets
Targets currently used in the legacy KPI site
HB006 · Gluta White C/30V
Target 229 · Threshold 80%
HB034 · HB Prenatal Support H/60V
Target 161 · Threshold 80%
HB031 · HB CoQ10 150mg C/30V
Target 243 · Threshold 50%
HB035 · HB Collagen 1,2&3 C/120V
Target 203 · Threshold 50%
ERP pipeline
Target integration flow
ERP pulls commercial data
Revenue, SKU, customer, and stock movement are fetched by ASM and period.
Scorecard engine normalizes data
Each metric is mapped into KPI scorecard items with targets, actuals, and calculation snapshots.
Manager reviews soft KPIs
The manager adds discipline, reporting quality, and context notes before finalization.
Dashboard publishes payout view
VP sees total score, payout estimate, underperformers, and review completion in one screen.
Scoring logic
Rule engine shell
3.1 Revenue achievement
65 ptsERP provides target vs actual revenue. Scoring follows the real ladder: 100%=65, 90%=62, 80%=55, 70%=49, 60%=39, 50%=33.
Source: ERP API
3.2 New customers
15 ptsPulled from ERP/CRM sales activity and mapped to ASM by period.
Source: ERP API
3.3 Key SKU sell-out
5 ptsRequires both key SKUs to reach at least 50 percent of target: HB031=243 and HB035=203.
Source: ERP API
3.4 Clearstock
10 ptsEvaluated on ERP sell-out/clearstock movement against threshold: HB006=229 and HB034=161, with 80 percent needed.
Source: ERP API
3.5 Discipline and reporting
5 pts + notesManager enters the discipline KPI and qualitative reporting review after the weekly check-in.
Source: Manager input