Executive Dashboard Marketplace

Channel health → SKU treatment → promo efficiency → profitability. Promo ROI mengukur GMV dari order promo terhadap promo spend yang benar-benar terpakai.

Marketplace v2Project, Task Execution, Timeline, dan Weekly Review tetap mengikuti Universal Core yang sudah LOCK. Area yang dioptimalkan di versi ini adalah Executive, Performance, Budget, dan Data Source Marketplace.
s/d
PERIODE UTAMA08 Agu 2026 — 14 Agu 2026
VS
COMPARISON01 Agu 2026 — 07 Agu 2026
GMVRp148.920.000▲ 13,6%
Revenue NetRp126.840.000▲ 12,8%
Paid Orders3.126▲ 9,4%
Conversion Rate2,36%▲ 0,22 pt
Promo SpendRp10.300.000Discount + Voucher + Flash Sale
Promo ROI4,73xPromo GMV ÷ Promo Spend
Cancel Rate8,7%▼ 1,8 pt
Return Rate1,18%37 return orders

GMV Trend + Metric Compare

GMV menjadi base trend. Klik metrik pembanding untuk membaca perubahan outcome dan efficiency.

GMV BASE
08 Agu09 Agu10 Agu11 Agu12 Agu13 Agu14 Agu

Marketplace Metric Funnel

Funnel langsung dari metrik bisnis. Semua angka dikunci di safe area chart.

FUNNEL
VisitorsTraffic toko / PDP
176.840
Product Views132.480 views
74,91%
Paid OrdersCR 2,36%
3.126
GMVAOV GMV Rp47.639
Rp148.920.000
Revenue Net85,17% of GMV
Rp126.840.000
Leak utama: Product View → Paid Order. Product Performance menjadi halaman diagnosis utama untuk treatment CR per SKU.

Promo Efficiency

Biaya promo yang benar-benar terpakai.

PROMO
Discount
Rp4.800.000
Voucher
Rp3.100.000
Flash Sale
Rp2.400.000
Total Promo Spend: Rp10.300.000 · Promo ROI 4,73x

Profitability Health

MASTER SKU memasok HPP untuk menjaga promo tidak hanya mengejar GMV.

MARGIN
Revenue NetRp126.840.000
COGS / HPPRp65.420.000
Promo SpendRp10.300.000
ContributionRp51.120.000Before marketplace fee
Contribution After Promo = Revenue Net − HPP − Promo Spend

BOD Attention

Signal yang membutuhkan keputusan.

ACTION
CRSakata 1,79%

Traffic tinggi, CR di bawah benchmark → treatment conversion.

Stock4 Hero SKU Risk

Jangan membaca sales drop sebagai demand issue jika availability terbatas.

PromoVoucher ROI 6,12x

Layak scale dengan guardrail margin.

TrafficVegas CR 2,61%

CR sehat, traffic rendah → tingkatkan exposure.

Product Performance

Evaluasi produk tersedia dalam dua level: Keseluruhan untuk membaca performa produk lintas channel berdasarkan MASTER SKU, lalu tab channel untuk diagnosis menggunakan SKU native masing-masing marketplace.

Product GrainKeseluruhan = agregasi berdasarkan MASTER SKU / Product Name setelah mapping. Shopee, TikTok Shop, Lazada, dan Website tetap memakai SKU channel masing-masing saat masuk ke tab channel. Jadi raw SKU tidak dicampur langsung.
Master Product Active86Mapped products
Channel SKU Mapped240Across 4 channels
Mapping Coverage98,7%Healthy
Avg Product CR2,31%Weighted overall
Winning20Scale
Potential23High traffic · low CR
Stock Limited4Availability risk
ContributionRp51.120.000After HPP + promo

Product Performance Keseluruhan

Produk yang sama digabung hanya setelah Channel SKU berhasil dimapping ke MASTER SKU. Gunakan tab channel untuk melihat SKU asli dan diagnosis granular.

MASTER PRODUCT
Master SKU / ProductActive ChannelChannel SKUViewsOrdersCRGMVRevenue NetHPP SoldPromo SpendContributionDiagnosisRecommended Action
RSL-HB-26-032-BK-BOX
Dominus Pro Basic		44 SKU22.3106182,77%Rp42.500.000Rp36.900.000Rp13.972.000Rp2.100.000Rp20.828.000WinningScale channel dengan CR & margin sehat
RSL-HB-25-026-ULT-BK
Sakata Ultimate Basic		44 SKU26.3804681,77%Rp31.110.000Rp26.580.000Rp10.915.000Rp1.850.000Rp13.815.000PotentialPrioritaskan perbaikan CR per channel
RSL-HB-23-009-BK
Nano Ultimate Black		11 SKU9.8402192,23%Rp12.710.000Rp11.020.000Rp5.083.000Rp720.000Rp5.217.000Stock LimitedSecure stock sebelum scale
MASTER SKU
Vegas Polo		11 SKU4.9801372,75%Rp10.120.000Rp8.860.000Rp4.288.000Rp420.000Rp4.152.000Hidden PotentialTambah exposure pada channel aktif
Rule: Product Performance Keseluruhan tidak menjumlahkan raw SKU secara buta. Data hanya dikonsolidasi saat Channel SKU → MASTER SKU sudah valid. Treatment final tetap dapat dibuka per channel.
Active Shopee SKU72Raw Shopee SKU
Avg Product CR2,41%Weighted
Winning17Scale
Potential19High traffic, low CR
Hidden Potential11Low traffic, high CR
Weak21Evaluate
Stock Limited4Availability risk
ContributionRp29.840.000After HPP + promo

Shopee SKU Treatment

Primary key = Shopee SKU. MASTER SKU hanya ditampilkan sebagai mapped reference untuk HPP dan product identity.

SHOPEE SKU
Shopee SKU / ProductMapped Master SKUViewsOrdersCRGMVRevenue NetHPPPromo SpendContributionStockDiagnosisRecommended Action
SHP-DOMPRO-BLK-01
Dominus Pro Basic		RSL-HB-26-032-BK-BOX11.8203412,89%Rp22.840.000Rp19.920.000Rp7.706.000Rp1.350.000Rp10.864.000HealthyWinningScale exposure
SHP-SAKULT-BLK-01
Sakata Ultimate Basic		RSL-HB-25-026-ULT-BK14.9602661,78%Rp17.540.000Rp15.180.000Rp6.204.000Rp1.240.000Rp7.736.000HealthyPotentialImprove CR before traffic
SHP-NANOULT-BLK-01
Nano Ultimate Black		RSL-HB-23-009-BK9.8402192,23%Rp12.710.000Rp11.020.000Rp5.083.000Rp720.000Rp5.217.000Low StockStock LimitedSecure stock first
Active TikTok SKU64Raw TikTok SKU
Avg Product CR2,19%Weighted
Winning14Scale
Potential18Need conversion
Hidden Potential9Need exposure
Weak20Evaluate
Stock Limited3Availability risk
ContributionRp16.420.000After HPP + promo

TikTok Shop SKU Treatment

Primary key = TikTok Shop SKU dari report product performance TikTok.

TIKTOK SKU
TikTok SKU / ProductMapped Master SKUViewsOrdersCRGMVRevenue NetHPPPromo SpendContributionStockDiagnosisRecommended Action
TT-DOMPRO-BLK-A
Dominus Pro Basic		RSL-HB-26-032-BK-BOX6.6001872,83%Rp13.360.000Rp11.920.000Rp4.230.000Rp750.000Rp6.940.000HealthyWinningScale creator/live exposure
TT-VEGAS-POLO-A
Vegas Polo		Mapped to MASTER SKU4.9801372,75%Rp10.120.000Rp8.860.000Rp4.288.000Rp420.000Rp4.152.000HealthyHidden PotentialIncrease exposure
TT-SAKULT-BLK-A
Sakata Ultimate Basic		RSL-HB-25-026-ULT-BK6.8801251,82%Rp8.340.000Rp7.240.000Rp2.915.000Rp610.000Rp3.715.000HealthyPotentialImprove offer / PDP
Active Lazada SKU46Raw Lazada SKU
Avg Product CR2,02%Weighted
Winning8Scale
Potential13Need conversion
Hidden Potential7Need exposure
Weak17Evaluate
Stock Limited1Availability risk
ContributionRp3.120.000After HPP

Lazada SKU Treatment

Primary key = Lazada SKU. Promo spend hanya dihitung jika raw promo Lazada tersedia.

LAZADA SKU
Lazada SKU / ProductMapped Master SKUViewsOrdersCRGMVRevenue NetHPPPromo SpendContributionStockDiagnosisRecommended Action
LZD-DOMPRO-BLK-01
Dominus Pro Basic		RSL-HB-26-032-BK-BOX2.110512,42%Rp3.580.000Rp3.040.000Rp1.154.000—Rp1.886.000HealthyWinningMaintain
LZD-SAKULT-BLK-01
Sakata Ultimate Basic		RSL-HB-25-026-ULT-BK2.460431,75%Rp2.920.000Rp2.430.000Rp1.003.000—Rp1.427.000HealthyPotentialImprove conversion
Active Website SKU58Website catalog SKU
Avg Product CR1,86%Weighted
Winning9Scale
Potential14Need conversion
Hidden Potential8Need exposure
Weak25Evaluate
Stock Limited2Availability risk
ContributionRp1.740.000After HPP

Website SKU Treatment

Primary key = Website SKU / catalog SKU dari ecommerce backend.

WEBSITE SKU
Website SKU / ProductMapped Master SKUViewsOrdersCRGMVRevenue NetHPPPromo SpendContributionStockDiagnosisRecommended Action
WEB-DOMPRO-BLK
Dominus Pro Basic		RSL-HB-26-032-BK-BOX1.780392,19%Rp2.720.000Rp2.020.000Rp882.000—Rp1.138.000HealthyMaintainImprove traffic quality
WEB-SAKULT-BLK
Sakata Ultimate Basic		RSL-HB-25-026-ULT-BK2.080341,63%Rp2.310.000Rp1.730.000Rp793.000—Rp937.000HealthyWeakFix PDP funnel

SKU Treatment Logic

Diagnosis tetap sama di semua channel, tetapi source SKU dan hasil treatment tidak digabung lintas channel.

DIAGNOSIS
WinningTraffic ↑ + CR ↑

Maintain / scale dengan guardrail margin.

PotentialTraffic ↑ + CR ↓

Treatment PDP, price, voucher, offer.

Hidden PotentialTraffic ↓ + CR ↑

Tambah exposure / placement.

Stock LimitedDemand sehat + stock risk

Secure availability sebelum scale traffic.

Mapping backend: Channel SKU → MASTER SKU → Product Name → Total HPP. Contribution After Promo = Revenue Net − Total HPP Sold − Promo Spend.

Promotion & Activation

Monitor promo yang sedang berjalan dan evaluasi promo yang sudah selesai. Fokus pada Shopee dan TikTok Shop: Discount, Voucher, dan Flash Sale berdasarkan biaya yang benar-benar terpakai.

Discount UsedRp3.100.000Actual discount cost
Voucher UsedRp1.900.000Redeemed value only
Flash Sale UsedRp800.000Sold qty × price gap
Promo SpendRp5.800.000Used cost
Promo GMVRp30.220.000Attributed
Promo ROI5,21xHealthy
Incremental ROI1,84xvs baseline GMV
Discount UsedRp1.700.000Actual discount cost
Voucher UsedRp1.200.000Redeemed value only
Flash Sale UsedRp1.600.000Sold qty × price gap
Promo SpendRp4.500.000Used cost
Promo GMVRp18.540.000Attributed
Promo ROI4,12xMonitor
Incremental ROI1,31xvs baseline GMV
Active Promo4Promo live di channel terpilih
Spend Used To DateRp3.860.000Actual cost berjalan
Promo GMV To DateRp21.540.000Running result
Running Promo ROI5,58xGMV ÷ spend used

Active Promotion Monitor

Menjawab promo apa yang sedang aktif, berapa biaya yang sudah terpakai, dan apakah perlu dijaga / ditreatment sebelum periodenya selesai.

LIVE
PromotionChannelTypePeriodSKU ScopePromo MechanicSpend UsedPromo GMVRunning ROIStatusAction
Independence VoucherShopeeVoucher14–17 Aug12 SKUVoucher up to Rp25.000Rp1.280.000Rp10.420.0008,14xActiveScale
81% Hero SKU DiscountShopeeDiscount14–18 Aug6 SKUSpecial price hero SKURp1.760.000Rp7.180.0004,08xActiveGuard Margin
Weekend Flash SaleShopeeFlash Sale16–17 Aug8 SKUTimed Flash SaleRp820.000Rp3.940.0004,80xEnding SoonMonitor
Live Voucher BoostTikTok ShopVoucher14–20 Aug10 SKULIVE voucherRp940.000Rp5.180.0005,51xActiveMaintain
Mid Month Flash SaleTikTok ShopFlash Sale15–18 Aug8 SKUFlash Sale placementRp1.210.000Rp7.960.0006,58xActiveScale
Product Discount Wave 2TikTok ShopDiscount14–19 Aug7 SKUProduct discountRp1.340.000Rp4.820.0003,60xActiveOptimize
Active Promotion memakai metrik berjalan. ROI dan spend akan terus berubah sampai promosi selesai.

Completed Promotion Evaluation

Promo yang periodenya sudah selesai. Gunakan hasil final untuk keputusan Scale / Maintain / Optimize / Stop pada activation berikutnya.

FINAL RESULT
PromotionChannelTypePeriodSKU ScopeOrdersPromo GMVSpend UsedPromo ROIIncremental GMVIncremental ROIMargin SignalDecision
Payday Voucher WaveShopeeVoucher25–31 Jul14 SKU486Rp18.440.000Rp1.900.0009,71xRp5.720.0003,01xHealthyScale
Previous Hero DiscountShopeeDiscount18–24 Jul6 SKU318Rp9.120.000Rp3.100.0002,94xRp2.030.0000,65xMargin WatchOptimize
Previous Mid Month Flash SaleTikTok ShopFlash Sale10–13 Jul8 SKU328Rp12.780.000Rp1.600.0007,99xRp3.250.0002,03xHealthyScale
LIVE Voucher TestTikTok ShopVoucher05–09 Jul10 SKU211Rp5.760.000Rp1.200.0004,80xRp1.110.0000,93xWatchMaintain
Promo ROI = Promo GMV ÷ Promo Spend Used · Incremental Promo ROI = (GMV saat promo − baseline GMV) ÷ Promo Spend Used.

Cancellation & Return

Leakage dilihat per channel → SKU → reason, lalu diterjemahkan menjadi marketing/PDP action dan impact ke Revenue Net.

Created Orders3.425Total created
Cancelled299▼ comparison
Cancel Rate8,7%▼ 1,8 pt
Cancel ValueRp12.440.000Order value
Return Orders37After shipment
Return Rate1,18%Return / paid
Refund ValueRp2.680.000Revenue impact
Seller Controllable11,4%Need action

Cancellation Reason

Prioritaskan reason yang bisa ditreatment oleh seller/ops.

CANCEL
Buyer / Payment
233
System / Review
32
Seller / Ops
34

Return Reason

Fokus reason yang bisa diperbaiki dari PDP/offer/product communication.

RETURN
Expectation mismatch
14
Wrong variant
10
Product defect
7
Other
6

Channel → SKU → Reason Monitor

Revenue impact harus terhubung kembali ke Product Performance dan Weekly Review.

LEAKAGE
ChannelProductPaid OrdersCancel RateReturn RateRefund ValueTop ReasonControllable?Recommended Action
ShopeeSakata Ultimate3919,5%2,05%Rp820.000Expectation mismatchYesRevise PDP visual/copy
TikTok ShopDominus Pro5285,7%0,76%Rp420.000Buyer changed mindLowMaintain
ShopeeNano Ultimate3428,2%2,34%Rp690.000Wrong variantYesClarify variant naming

Timeline Semua Divisi

Timeline ini tidak diinput manual. Seluruh blok otomatis dihasilkan dari Task List setiap divisi.

Source of Truth = Task List. Saat task dibuat atau diubah di Project, timeline ikut berubah otomatis berdasarkan Start Date + Deadline + Division + Type + Campaign + Status. Jadi tim tidak perlu maintain dua data berbeda.
Periode:
Task Aktif Minggu Ini23
Affiliate Task7
Campaign Task14
BAU / Routine9
Divisi / Workstream
Sen 10
Sel 11
Rab 12
Kam 13
Jum 14
Sab 15
Min 16
AdsGenerated dari task Ads
Scale Hero SKUCampaign · In Progress
Affiliate · ROLE KAMUTask dari Project Affiliate
Review CreatorBAU · 12:00
Shortlist 9.9Campaign · 17:00
MarketplaceGenerated dari task Marketplace
Lock Promo + PDP9.9 · Due 11 Aug
Live StreamingGenerated dari task Live
V2L + Product RotationCampaign support
Customer ServiceGenerated dari task CS
Promo Brief + BroadcastCampaign support
BAU / Routine Campaign Done Task divisi lain

BAU → Timeline

Recurring task menghasilkan occurrence sesuai jadwal. Contoh: Review Creator Performance muncul setiap hari aktif tanpa perlu membuat task baru manual.

Campaign → Timeline

Task campaign tampil sepanjang Start Date sampai Deadline. Jika deadline berubah di Project, panjang atau posisi blok timeline ikut berubah otomatis.

Next Week Preview

Generated dari task upcoming
StartDivisionTaskTypeSourceDue
17 AguAffiliateReaktivasi Winning Creator Wave 2Campaign9.9 Mega Campaign19 Agu
18 AguAffiliateRelease Sample Batch 9.9 #02Campaign9.9 Mega Campaign20 Agu
21 AguAffiliateWeekly Creator Tier ReviewBAU WeeklyRecurring Weekly21 Agu

Project — Execution System

Struktur ini dibuat sama untuk semua divisi. Performance boleh berbeda, tetapi setiap tindakan masuk ke bahasa kerja yang sama.

Universal execution flow: Direction / Performance Signal / Weekly Review / Routine → Task → To Do → Doing → Review → Done. Semua divisi memakai field dan rule completion yang sama.
Periode:
s/d
Work Type:
Throughput Minggu Ini8
Meaningful task selesai
Current WIP3 / 3
Limit sudah penuh
On-Time Rate88%
Sesuai komitmen deadline
Blocked1
Butuh bantuan / dependency
Avg Cycle Time2,4 hari
Start → Done
Unplanned Work18%
Task dadakan minggu ini
Leader Direction · Priority 1

Scale Hero SKU Marketplace untuk 9.9

Leader menentukan arah dan outcome. Specialist menentukan execution plan untuk mencapai target tersebut.

ObjectiveNaikkan Net Revenue Marketplace
TargetGMV +15%
GuardrailCR tidak turun & budget promo sesuai guardrail
Deadline25 Agu 2026
Execution Plan6 Task

Dibreakdown oleh Marketplace Specialist.

Progress Initiative72%

Naik otomatis dari execution task.

DependencyMarketplace

Promo, stock, dan PDP Hero SKU harus locked.

TO DO

4
CAMPAIGNPerformance Signal
P1

Shortlist 30 SKU Potential untuk 9.9

Pilih SKU berdasarkan traffic, CR, revenue, stock, cancellation, dan promo readiness.

Expected Output30 SKU qualified + treatment sheet
AFMarketplaceDue 12 Agu · 15:00
CAMPAIGNWeekly Review
P2

Finalisasi Promo Mechanism 9.9

Finalize voucher threshold, eligible SKU, budget, dan expected outcome.

Expected OutputFinal mechanism + approved SKU list
AFMarketplaceDue 13 Agu
BAU WEEKLYRoutine

Weekly SKU Treatment Review

Update Winner / Potential / Low CR SKU dan kandidat treatment berikutnya.

Expected OutputUpdated SKU tier + action candidate
AFMarketplaceDue Jumat

DOING

WIP 3 / 3
BAU DAILYRoutine

Review SKU Performance Harian

Cek SKU yang perlu scale, monitor, atau treatment conversion.

Expected OutputSKU action list hari ini
AFMarketplaceDue 12:00
CAMPAIGNBLOCKED
P1

Activation Hero SKU Wave 1

Menunggu promo, stock, dan PDP Hero SKU siap sebelum activation dilanjutkan.

DependencyMarketplace · Promo/Stock/PDP Hero SKU
AFMarketplaceBlocked 1 hari
BAU DAILYRoutine

Check Promotion Activation H+1 / H+3

Update status promo live, SKU coverage, dan issue activation.

Expected OutputSemua due activation ter-check
AFMarketplaceDue 15:00
WIP limit penuh. Tim tidak menarik task baru sampai minimal 1 task aktif masuk Review / Done.

REVIEW

2
CAMPAIGNLeader Direction
P1

SKU × Promotion Matching

Execution selesai. Menunggu review sebelum activation berikutnya.

Result32 SKU match ke 4 promo mechanism
AFMarketplaceEvidence ✓
CAMPAIGNWeekly Review

Promotion Cost Reconciliation

Actual subsidy/cost sudah diinput. Menunggu validasi evidence.

Result4 activation · actual Rp2.920.000
AFMarketplace3 evidence

DONE

8
CAMPAIGNWeekly Review

Audit Hero SKU Conversion

Task selesai dengan result dan evidence lengkap.

Result10 SKU treatment mapped · 8 priority scale
AFMarketplaceOn time ✓
BAU DAILYRoutine

Check Outstanding Promotion

Recurring occurrence Senin selesai dan masuk history.

Result14 activation checked · 9 healthy
AFMarketplaceEvidence ✓
SourceDirection / Performance / Weekly Review / Routine
CommitmentOwner + Expected Output + Deadline
FlowTo Do → Doing → Review → Done
CompletionResult + Evidence wajib sebelum Done
Tidak ada task yang sesuai dengan filter saat ini.

Task List

View alternatif untuk scan cepat dan filter tanggal
TaskTypeSourceOwnerStatusExpected OutputDueEvidence
Review SKU Performance HarianBAURoutineMarketplaceDoingSKU action list11 Agu 12:00—
Activation Hero SKU Wave 1CampaignLeader DirectionMarketplaceBlocked20 SKU locked12 Agu1 link
SKU × Promotion MatchingCampaignLeader DirectionMarketplaceReviewSKU-promo map11 Agu✓
Audit Hero SKU ConversionCampaignWeekly ReviewMarketplaceDone10 SKU treatment mapped10 Agu✓

Budget Marketplace

Budget hanya fokus pada biaya promo yang benar-benar terpakai: Discount, Voucher, dan Flash Sale. Ads Spend tidak masuk domain Marketplace Specialist.

PERIODE UTAMA08 Agu 2026 — 14 Agu 2026
VS
COMPARISON01 Agu 2026 — 07 Agu 2026
Promo Budget TargetRp15.000.000Current period
Promo Spend UsedRp10.300.00068,7% used
RemainingRp4.700.00031,3% available
Discount UsedRp4.800.000Actual cost
Voucher UsedRp3.100.000Redeemed only
Flash Sale UsedRp2.400.000Actual sold qty
Promo GMVRp48.760.000Attributed
Promo ROI4,73xGMV ÷ spend

Promo Spend Composition

Actual cost yang sudah terbakar.

USED COST
Discount
Rp4.800.000
Voucher
Rp3.100.000
Flash Sale
Rp2.400.000
Promo Spend = Discount Used + Voucher Used + Flash Sale Used

Budget Efficiency

Jangan scale promo hanya dari GMV; lihat Promo ROI + margin impact.

EFFICIENCY
Promo ROI4,73x
Incremental ROI1,61x
ContributionRp51.120.000
Budget HealthHealthy

Budget by Channel & Promo Type

Promo spend harus bisa ditelusuri hingga channel dan jenis promo.

BREAKDOWN
ChannelDiscountVoucherFlash SaleTotal SpendPromo GMVPromo ROIIncremental ROIStatus
ShopeeRp3.100.000Rp1.900.000Rp800.000Rp5.800.000Rp30.220.0005,21x1,84xHealthy
TikTok ShopRp1.700.000Rp1.200.000Rp1.600.000Rp4.500.000Rp18.540.0004,12x1,31xMonitor

Top Promo Spend by SKU

Produk yang menyerap budget terbesar harus dibaca bersama contribution margin.

SKU ABSORPTION
ProductPromo SpendPromo GMVPromo ROIContribution After PromoDecision
Dominus ProRp2.150.000Rp13.420.0006,24xRp7.680.000Scale
Sakata UltimateRp1.980.000Rp7.120.0003,60xRp3.040.000Optimize
Nano UltimateRp1.440.000Rp8.630.0005,99xRp4.210.000Maintain

Weekly Review

Cek hasil, catat yang perlu dibahas, lalu pilih prioritas minggu berikutnya.

04–10 Agu 2026 Review meeting · 12 Agu 2026
Draft
Net Revenue Rp126.840.000 Achieved
Avg Product CR 2,36% Healthy
Promo GMV Rp48.720.000 Achieved
Cancel Rate 8,7% Watch

Need Attention

Tambah / hapus sesuai meeting

Next Priority

Maks. 3 fokus utama
P1
P2
Publish hanya membuat item di Next Priority menjadi Project Task.
✓ Weekly Review published. Next Priority sudah dibuat menjadi Project Task.

Data Source Marketplace

Upload raw data berdasarkan jenis report. Shopee mendukung multi-file batch. Sistem produksi nantinya melakukan detect source → period validation → SKU mapping → metric generation.

Business SOTMarketplace Metrics memasok GMV, Revenue Net, Orders, Visitors, CR, AOV dan order health sesuai kolom yang tersedia di report masing-masing channel.

Shopee Metrics — Multi-file

Upload beberapa report Shopee sekaligus dalam satu batch. Cocok untuk beberapa report metriks yang berbeda dan periode yang sama.

ChannelShopee
ModeMulti-file Batch
OutputExecutive Dashboard
ValidationPeriod + duplicate
Pilih beberapa file ShopeeXLSX / CSV · source bisa dioverride setelah detect

TikTok Shop Metrics

Raw TikTok Shop untuk outcome marketplace level channel.

ChannelTikTok Shop
ModeBatch supported
OutputExecutive Dashboard
ValidationPeriod + source
Pilih file TikTok MetricsXLSX / CSV
01Upload Raw
02Detect Channel
03Detect Report
04Validate Period
05Normalize
06Generate KPI
SKU SOTRaw Product Performance dipisahkan dari level toko. Channel SKU dipertahankan untuk analisis per marketplace lalu dimapping ke MASTER SKU untuk membentuk Product Performance Keseluruhan.

Shopee Product Performance

Product/SKU performance Shopee. Shopee SKU dipertahankan sebagai primary key analisis lalu dimapping ke MASTER SKU untuk Product Name + HPP.

Upload Product Performance ShopeeViews · Orders · GMV · CR · Stock jika tersedia

TikTok Product Performance

Product performance TikTok Shop. TikTok SKU dipertahankan sebagai primary key analisis dan tidak digabung dengan SKU channel lain.

Upload Product Performance TikTokViews · Orders · GMV · CR · Stock jika tersedia
Mapping: Channel SKU → MASTER SKU → Product Name → Total HPP. Channel SKU tetap menjadi grain utama pada Product Performance masing-masing channel.
2 Promo ChannelsPromotion Data hanya difokuskan ke Shopee dan TikTok Shop. Jenis raw: Voucher, Discount, dan Flash Sale.

Shopee Promotion Data

Upload raw promo Shopee. Bisa batch beberapa file Voucher, Discount, dan Flash Sale.

Upload Voucher / Discount / Flash SaleMulti-file · actual used cost

TikTok Shop Promotion Data

Upload raw promo TikTok Shop dengan tipe report yang sama jika tersedia.

Upload Voucher / Discount / Flash SaleMulti-file · actual used cost

Voucher

Cost hanya nominal voucher yang redeemed/terpakai.

Voucher Used = Σ redeemed voucher value

Discount

Hitung price gap hanya pada qty yang benar-benar terjual.

Discount Used = (Normal − Promo Price) × Qty Sold

Flash Sale

Cost berdasarkan selisih harga pada qty Flash Sale yang terjual.

FS Used = (Normal − FS Price) × Qty Sold
MASTER SKU 2026Internal SKU RUSEL CO menjadi product identifier utama. Total HPP dipakai untuk Product Profitability, Budget Efficiency, dan Contribution After Promo.
Master SKU84
Marketplace Mapped79
Need Mapping5
HPP Coverage100%

MASTER SKU Preview

Prototype preview. Struktur final mengikuti master internal yang akan kamu gunakan.

MASTER DATA
Internal SKUProductTotal HPPShopee MappingTikTok MappingLazada MappingWebsite MappingStatus
RSL-HB-26-032-BK-BOXHandbag Dominus Pro BasicRp113.011MappedMappedMappedMappedReady
RSL-HB-25-026-ULT-BKHandbag Sakata Ultimate Black BasicRp91.119MappedMappedMappedMappedReady
RSL-HB-23-009-BKHandbag Nano Ultimate Black BasicRp79.369MappedMapped—MappedPartial
MASTER SKU tidak menggantikan raw marketplace. Fungsinya sebagai layer mapping internal untuk menyatukan product identity + HPP di semua channel.

Import History

Audit batch, channel, report type, coverage period, row count, mapping, dan processing status.

AUDIT
Imported AtBatchChannelReport TypeFilesCoverageRowsSKU MappingStatus
14 Agu 2026 14:32BAT-0814-01ShopeeMarketplace Metrics408–14 Agu12.840—Processed
14 Agu 2026 14:18BAT-0814-02ShopeeProduct Performance108–14 Agu38498,7%5 Need Mapping
14 Agu 2026 13:55BAT-0814-03TikTok ShopVoucher + Discount + FS308–14 Agu1.420100%Processed

Riwayat Marketplace

Jejak perubahan performance signal, Weekly Review decision, task, result, dan evidence.

DateTypeReferenceDecision / ActionOwnerEvidence
14 Aug 2026Performance SignalSakata Ultimate CRRevise offer + voucherMarketplace SpecialistAttached
13 Aug 2026PromotionHero SKU VoucherScaleMarketplace SpecialistAttached

Evidence Marketplace

Evidence operasional khusus Marketplace: activation proof, campaign approval, PDP change, dan result proof.

Promotion Activation

Screenshot voucher, flash sale, campaign/event, shipping promo setelah aktif.

Linked to TaskRequired

PDP / Product Treatment

Before-after title, image, price, voucher, bundle, product detail atau variant treatment.

Linked to ProductOperational

Result Proof

Screenshot/report hasil setelah treatment untuk memenuhi rule Result + Evidence sebelum Done.

Completion GateRequired

Evidence Log

Evidence tetap terhubung ke Project Task dan history.

DateTaskEvidence TypeReferenceOwnerStatus
14 AugActivate Hero SKU VoucherPromotion ActivationScreenshotMarketplace SpecialistComplete
14 AugAudit Sakata PDPPDP TreatmentBefore / AfterMarketplace SpecialistNeed Result
UNIVERSAL DATA SOURCE

Import Database

Source tersedia mengikuti workspace aktif. Beberapa jenis file dapat dimasukkan dalam satu batch.

Workspace · Marketplace
Upload database

XLSX, XLS, atau CSV · pilih satu atau beberapa file sekaligus.

TRANSACTIONPesanan
EVALUATIONCreator Performance
SOURCE OF TRUTHVideo Affiliate
LIVELIVE Harian
SAMPLESample Performance
MASTER DATAMaster TikTok
MASTER DATAMaster Shopee
FileDetected SourcePeriodStatus
0 file dipilih Multi-source queue

Prototype UI: setiap file dapat memiliki source berbeda dalam satu import batch.