Calendar Online
Pusat workflow campaign content: planning, request intake, dan monitoring calendar.
Input Campaign Calender
Form request content untuk campaign, marketplace, ads, dan kebutuhan brand.
Dashboard Ads
Summary of all ads platform performance
Ringkasan Platform Ads
Ringkasan semua platform ads utama. Platform paling kiri mengikuti filter Platform di atas.
| Platform | Spend | GMV | Orders | Items Sold | ROAS | Cost Ratio % | CPO | CVR % | Price Point | AOV | CPM | CPC | Clicks | Impressions | CTR % |
|---|
Trend Harian Revenue & Biaya Iklan
Omzet per Platform
Biaya per Platform
Items Sold per Platform
Impressions per Platform
ROAS per Platform
CTR & CVR per Platform
AOV & Price Point per Platform
Cost per Order per Platform
Klik & Konversi per Platform
Order & Produk Terjual per Platform
Dashboard Sales
Loading Sales summary from Supabase...
Ringkasan Platform Sales
Ringkasan semua platform utama. Platform paling kiri mengikuti filter Platform di atas.
| Platform | Target | Total Sales | Harga Bruto | Avg Diskon | Order | Unit Terjual | Basket Size | AOV | Price Point | Diskon Barang | Diskon Lainnya |
|---|
Harian Produk Terjual & Total Pembeli
Harian AOV & Price Point
Distribusi Price dari Amount
Revenue per Provinsi Pengiriman
Revenue per Kota Pengiriman
Top shipper - share revenue
Sales Analysis
Sales Contribution by Platform
| Platform | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point |
|---|
Sold by Module
| Module | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point | Detail |
|---|
Module Product Detail
| Product | Units Sold | Sales | Order | Avg Discount | AOV | Price Point |
|---|
Most Purchased Sizes
| Size | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point |
|---|
Most Selected Colors
| Color | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point |
|---|
Most Purchased Brands
| Brand | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point |
|---|
Most Purchased Genders
| Gender | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point |
|---|
Most Purchased Categories
| Category | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point |
|---|
Most Purchased Product Statuses
| Product Status | Units Sold | % Unit | Sales | Order | Avg Discount | AOV | Price Point | Detail |
|---|
Shipping City
| City | Revenue | Order | Units Sold | Total Buyers | Basket Size | Avg Discount | AOV | Price Point | Detail |
|---|
Marketplace Analysis
Shopee funnel, TikTok source of action, price distribution, and marketplace voucher AOV distribution.
Shopee Product Funnel
Products Viewed -> Products Clicked -> Added to Cart -> Products Sold (Orders Shipped)
Funnel Leakage & TikTok Traffic
Light carousel: Shopee leakage and TikTok traffic are limited to the top 200 products.
Shopee Source of Action
Sales composition by Shopee promo, live, membership, and traffic. Vouchers are split out as support incentives.
Price Distribution Shopee
Parent SKU price-point buckets from shipped-ready sales / shipped-ready sold products.
Store Benchmark
Revenue, CTR, AOV, ATC to Sold, and ATC Rate follow the selected platform filter.
Product Opportunity Matrix
Shopee and TikTok carousel; product details load after click.
Voucher AOV Distribution Shopee
Voucher AOV is calculated from shipped-ready sales / shipped-ready orders.
| AOV Bucket | Voucher | Shipped-Ready Sales | Shipped-Ready Orders | Avg AOV | Voucher Cost | Sales Share |
|---|
Marketplace X Ads Analysis
Real sales from Dashboard Sales matched against Dashboard Ads spend for the same sales period.
Sales: Dashboard SalesAds: Dashboard AdsPeriod: selected range
Budget Fit
Ads spend share compared with real sales share for the selected scope.
Efficiency Ranking
Blended ROAS, CPO, and cost ratio from the same real sales revenue.
Real Sales x Ads Detail
Sales uses Dashboard Sales total sales; ads uses Dashboard Ads spend. Ads period is capped to the latest available sales date.
Revenue viewSpend view
| Platform | Real Sales | Orders | Qty | AOV | Ads Spend | Ads GMV | CPO | Cost Ratio | Blended ROAS | Status |
|---|
Sales X Stock Analysis
Matched products use the latest available stock. Quadrants compare sales strength and stock risk. SSR = Stock / Sold.
Sales vs Stock Quadrant
Scatter visual: X = Total Sold, Y = Total Stock. Click a point or detail button to view the table.
-
Sales by Product Age
| Product Age | Products | Units Sold | % Units | Sales | Orders | Avg Discount | AOV | Price Point | Details |
|---|
New Arrival Performance
| Product | Age | Units | Sales | Avg Discount | Price Point |
|---|
Aging Products Still Selling
| Product | Age | Units | Sales | Avg Discount | Price Point |
|---|
New Products Selling Slowly
| Product | Age | Units | Sales | Avg Discount | Price Point |
|---|
Refill Impact
| Product | Refill | Units | Sales | Avg Discount | Price Point |
|---|
Age Bucket by Platform
Product age cohort distribution by platform.
Age Bucket by Category & Brand
Category summary. Click a category to drill down by brand.
Age Bucket by Category & Platform
Category summary. Click a category to drill down by platform.
Stock Analysis
Stock summary and analysis from Stock Management data.
Stock Analysis
Active Stock Product Age
Product age visual only includes articles with active stock and follows the Stock Analysis filters.
Active Stock & Product Age
Effective age date from New Arrival or latest refill, matched through stock article code.
| # | Article | Brand | Gender | Category | Module | SKU | Total Stock | Stock/SKU | Live Source | Age Date | First Live | Latest Refill | Age Days | Age Months | Bucket | Refill Qty | Match |
|---|
PA
No active-stock article matches the age filter.
The page default uses product age below 24 months.
Latest Refill for Active Stock
Refills whose articles still have active stock and pass the filter.
| # | Article | Brand | Refill | Upload | Qty | Stock | Age | Bucket |
|---|
RF
No refill on active stock yet.
Refills appear when an active-stock article has a latest refill date.
Stock by Brand
| Brand | Broken Rate | SKU | Total Stock | Stock Per SKU | Total Sold | SSR |
|---|
Stock by Gender
| Gender | Broken Rate | SKU | Total Stock | Stock Per SKU | Total Sold | SSR |
|---|
Stock by Category
| Category | Broken Rate | SKU | Total Stock | Stock Per SKU | Total Sold | SSR |
|---|
Stock by Product Status
| Product Status | Broken Rate | SKU | Total Stock | Stock Per SKU | Total Sold | SSR |
|---|
Stock by Size
| Size | Broken Rate | SKU | Total Stock | Stock Per SKU | Total Sold | SSR |
|---|
Stock by Color
| Color | Broken Rate | SKU | Total Stock | Stock Per SKU | Total Sold | SSR |
|---|
Stock by Module
| Module | Broken Rate | SKU | Total Stock | Stock Per SKU | Total Sold | SSR |
|---|
Low Stock
| Name | SKU | Brand | Stock |
|---|
Highest Stock
| Name | SKU | Brand | Stock |
|---|
Ads Analysis
Cross-platform ads efficiency, creative fatigue, voucher efficiency, and budget allocation.
Platform Efficiency Map
Spend position, ROAS strength, and revenue scale by channel.
Spend vs Revenue Contribution
Compare budget share against revenue share to spot overfunded and underfunded channels.
ROAS & Cost Ratio Per Channel
Channel efficiency view using ROAS and ads cost as a share of revenue.
Spend and Revenue by Category
Category allocation from ads summary rows, sorted by the strongest business value.
Spend and Revenue by Brand
Brand allocation from ads summary rows, including ROAS and cost ratio.
Budget Action Priorities
Practical signals for budget moves, tracking checks, and scale opportunities.
Detail Tables
Marketplace ads detail has moved to Ads Analysis. Pagination fetches API data per page, 10 rows per page.
Product Ads Compare
Compare ads naming with marketplace products. Initial load only fetches page 1, while page 2 is prefetched in the background.
Stock Manajemen
Area pengelolaan data stock untuk dibandingkan dengan performa sales
Upload Data Stock
Drag & Drop atau Klik Upload Stock
XLSX persediaan gudang. Sheet Data1 akan dibaca otomatis, patokan stock memakai kolom Tersedia.
Kamus Modul Kode Produk
Dipakai untuk kamus modul dari Excel. Kode di luar kamus modul Excel nanti dianggap REJECT; data yang sudah punya label tidak akan ditimpa saat diterapkan.
Kamus disembunyikan. Buka hanya saat perlu mencari, edit, atau tambah kode modul.
Replace Kamus Produk Status
Upload file master kamus terbaru. Sistem akan replace master Excel/status, manual override tetap dilindungi.
Upload file master kamus terbaru. Sistem akan replace master Excel/status, manual override tetap dilindungi.
Drag & Drop atau Klik Upload Kamus Status
Header wajib: Kode Barang, Kode Warna, Kode Extend, Brand, Modul, Dept, Dept Detail, Gender, STATUS PRODUK.
Masukkan contoh SKU untuk melihat hasil baca kode.
Kamus Excel belum terbaca.
Semua Data Stock Tersimpan
0 dipilih0 data
| # | Tanggal | SQL | Nama | SKU | SKU Induk | Variasi | Brand | Gender | Kategori | Status Produk | Lokasi | No Rak | Tersedia | QTY | Dipesan | Reserved | Harga Jual | HPP | Nilai Persediaan | Archive | Bundle | Aksi |
|---|
▦
Belum ada data stock
Upload file XLSX persediaan gudang di atas untuk memulai.
Data Umur Produk
Pemetaan umur produk dari tanggal New Arrival atau refill terbaru yang sudah tersimpan di SQL
Upload New Arrival
Drag & Drop atau Klik Upload New Arrival
XLSX dengan sheet WEB dan MP. Header mengikuti format file live product yang sama.
Upload Refill
Drag & Drop atau Klik Upload Refill
Akan dicocokkan ke SKU lama dan memakai tanggal refill terbaru sebagai umur produk.
Filter Umur Produk
Cari SKU dan kelompokkan umur produk berdasarkan tanggal New Arrival atau refill terbaru.
0 SKU
Produk KPI
Bucket umur produk, source live, dan dampak refill terbaru
New Arrival & Umur Produk
Tanggal umur efektif dari New Arrival atau refill terbaru
| # | SKU | Brand | Gender | Kategori | Modul | Live Source | Tanggal Umur | First Live | Refill Terbaru | Umur Hari | Umur Bulan | Bucket | WEB | MP | Qty Refill | HJP | Match |
|---|
PA
Belum ada data umur produk
Pastikan SQL product_age_payload sudah dijalankan di Supabase.
Refill Terbaru
Artikel yang tanggal umurnya ditimpa oleh refill paling baru
| # | SKU | Brand | Refill | Upload | Qty | HJP | Umur | Bucket |
|---|
RF
Belum ada refill terbaru
Upload file refill atau refresh SQL setelah import selesai.
Upload Target Sales
Baca workbook target bulanan dan harian per channel, termasuk sheet tersembunyi dan rumus cached Excel.
Upload Workbook Target
Drag & Drop atau Klik Upload Target Sales
XLSX target online. Sistem membaca semua sheet, nilai cached dari formula, target bulanan, target harian, dan validasi total.
Validasi Harian
Cek distribusi % dan total sales per sheet.
| Sheet | % Total | Daily Sum | Total Sheet | Status |
|---|
TD
Belum ada validasi harian
Sheet harian akan muncul setelah file terbaca.
Target Bulanan per Channel
Dibaca dari sheet TARGET BULANAN. QTY mengikuti nilai cached Excel.
| # | Channel | Jenis Toko | QTY | Sales Target | Share |
|---|
TB
Belum ada target bulanan
Pastikan workbook memiliki sheet TARGET BULANAN.
Detail Target Harian
Semua baris harian dari TARGET HARIAN dan sheet channel.
| # | Sheet | Row | Tanggal | % Contribution | Sales/Day |
|---|
DH
Belum ada detail harian
Upload workbook target untuk membaca semua baris harian.
Manajemen Data Sales
Upload data sales MTD dari marketplace - data tersimpan terpisah dari data ads
Upload Data Sales
Auto detect dari file
MTD
Drag & Drop atau Klik Upload
MTD: tanggal dibaca dari kolom Date/Tanggal di setiap row. Tanggal input hanya dipakai kalau ada row tanpa tanggal.
Semua Data Sales Tersimpan
Filter, periode, dan status SQL untuk data sales yang sudah tersimpan.
0 dipilih0 data
Filter Data Sales
Status SQL
Danger Zone Sales
| # | Tanggal | Platform | Channel | Status Channel | Toko | Shipper | Kota | Provinsi | SKU Induk | Size | Warna | Produk | Sales | Order | Unit | AOV | SQL | Aksi |
|---|
▤
Belum ada data sales
Upload file XLSX sales di atas untuk memulai
Sales Shopee
Analisis parent SKU / parent produk Shopee
Harian Revenue Dikirim & Total Produk Terjual
Harian Produk Terjual & Total Pembeli
Harian AOV & Price Point
| # | Product | Parent SKU | Total Sales | Order | Unit | Price Point | Gross Amount | Total Discount | Avg Discount | AOV |
|---|
S
Belum ada data Sales Shopee
Upload XLSX di Manajemen Data Sales
Sales TikTok
Analisis sales TikTok per produk: GMV total, tab toko, live, video, dan kartu produk
Harian Revenue & Produk Terjual
Harian Produk Terjual & Pembeli
Harian AOV & Price Point
| # | Product | Parent SKU | Total Sales | Order | Unit | Price Point | Gross Amount | Total Discount | Avg Discount | AOV |
|---|
T
Belum ada data Sales TikTok
Upload XLSX product list TikTok di Manajemen Data Sales
Sales Tokopedia
Analisis sales Tokopedia per produk
Harian Revenue & Produk Terjual
Harian Produk Terjual & Pembeli
Harian AOV & Price Point
| # | Product | Parent SKU | Total Sales | Order | Unit | Price Point | Gross Amount | Total Discount | Avg Discount | AOV |
|---|
P
Belum ada data Sales Tokopedia
Upload XLSX di Manajemen Data Sales
Sales Lazada
Analisis sales Lazada per produk
Harian Revenue & Produk Terjual
Harian Produk Terjual & Pembeli
Harian AOV & Price Point
| # | Product | Parent SKU | Total Sales | Order | Unit | Price Point | Gross Amount | Total Discount | Avg Discount | AOV |
|---|
L
Belum ada data Sales Lazada
Upload XLSX di Manajemen Data Sales
Sales Blibli
Analisis sales Blibli per produk
Harian Revenue & Produk Terjual
Harian Produk Terjual & Pembeli
Harian AOV & Price Point
| # | Product | Parent SKU | Total Sales | Order | Unit | Price Point | Gross Amount | Total Discount | Avg Discount | AOV |
|---|
B
Belum ada data Sales Blibli
Upload XLSX di Manajemen Data Sales
Sales Akulaku
Analisis sales Akulaku per produk
Harian Revenue & Produk Terjual
Harian Produk Terjual & Pembeli
Harian AOV & Price Point
| # | Product | Parent SKU | Total Sales | Order | Unit | Price Point | Gross Amount | Total Discount | Avg Discount | AOV |
|---|
A
Belum ada data Sales Akulaku
Upload XLSX di Manajemen Data Sales
Sales Zalora
Analisis sales Zalora per produk
Harian Revenue & Produk Terjual
Harian Produk Terjual & Pembeli
Harian AOV & Price Point
| # | Product | Parent SKU | Total Sales | Order | Unit | Price Point | Gross Amount | Total Discount | Avg Discount | AOV |
|---|
Z
Belum ada data Sales Zalora
Upload XLSX di Manajemen Data Sales
Data Marketplace Management
Kontrol data marketplace Shopee dan TikTok yang dipakai halaman Marketplace.
Upload Marketplace ke SQL
Drag & Drop atau Klik Upload
Pilih platform dan kelompok Excel dulu, lalu upload file Shopee/TikTok marketplace.
Upload file menyimpan row sesuai kelompok Excel dan nama sheet. Tombol snapshot hanya untuk data ringkasan yang sedang tampil.
Belum ada proses upload marketplace.
Marketplace Dataset Registry
Loaded Marketplace Tables
Data Affiliate Management
Upload raw Shopee SellerConversionReport CSV atau TikTok Affiliate XLSX ke SQL affiliate tanpa mencampur source marketplace lain.
Upload Affiliate ke SQL
Drag & Drop atau Klik Upload
CSV Shopee SellerConversionReport. Header Kode Pesanan, Nama Produk, Affiliate, Platform, dan Nilai Pembelian akan dipertahankan di payload raw.
Belum ada proses upload affiliate.
Affiliate Upload Summary
Preview dibangun dari file terakhir yang dipilih sebelum/selama upload SQL.
Preview Raw Rows
| # | Order / ID | Status / Source | Date | Product | Affiliate / Creator | Channel | Sales | Refund | Qty |
|---|
Marketplace Shopee
Shopee marketplace performance dari product, promo, live, traffic, voucher, dan membership periode terbaru
Shopee Open API
Sandbox connection for Marketplace Shopee only. Token data is stored server-side.
Shopee Traffic Quality
Pengunjung, follower growth, view depth, dan durasi kunjungan.
Voucher vs Non Voucher
Voucher sales, non-voucher sales, buyer mix, dan conversion rate.
Shopee Chat Revenue & Broadcast
Chat revenue, chat conversion, dan broadcast funnel dipisahkan dari traffic product.
Kontribusi Sales per Action
Top Parent Product
Category Composition
Promo Engine
Kompetitif Harga Parent SKU
Marketplace TikTok
TikTok product performance berdasarkan product list dan source action
TikTok Growth Intelligence
Creator ROI, sample tracker, refund leakage, creator-product fit, promo leakage, dan affiliate action.
Kontribusi Sales per Action
Top TikTok Products
Affiliate TikTok
Latest month affiliate analysis: creator efficiency, refund leakage, sample ROI, product fit, dan action priority.
Top Creator GMV vs Commission
Refund Risk Creator
Top Product Affiliate Fit
Creator Efficiency Table
| # | Creator | GMV | Commission | ROI | Orders | Items | Refund | Refund Rate | Samples |
|---|
Product Fit Table
| # | Product | GMV | AOV | Orders | Items | Refund | Refund Rate | Samples |
|---|
Action Priority
| # | Signal | Target | Impact | Reason | Action |
|---|
Affiliate Shopee
Affiliate Growth Control Center: source efficiency, creator/affiliate quality, product fit, commission, risk, category, MCN, dan action priority.
Source GMV vs Spend
Commission Efficiency
Category Performance
Affiliate Leaderboard
| # | Affiliate | GMV | Spend | ROI | Commission | Orders | Items | Cancel | Quadrant |
|---|
Product Affiliate Fit
| # | Product | GMV | Orders | Items | Spend | Commission | Cancel |
|---|
Action Priority
| # | Signal | Target | Impact | Reason | Action |
|---|
Manajemen Data Ads
Upload data harian dari semua platform - data tersimpan otomatis
Upload Data Harian
Drag & Drop atau Klik Upload
CSV/XLSX harian untuk tanggal, platform, tipe iklan, dan store yang dipilih
Semua Data Ads Tersimpan
Filter, periode, dan status SQL untuk data ads yang sudah tersimpan.
0 dipilih0 data
Filter Data Ads
Status SQL
Danger Zone Ads
| # | Tanggal | Platform | Store | SQL | Brand | Gender | Kategori | Tipe Iklan | Nama Iklan | Status | Impressions | Klik | CTR | CVR | Konversi | Terjual | Omzet | Biaya | ROAS | ACOS | Voucher Amt | Vouchered Sales | Aksi |
|---|
▣
Belum ada data
Upload file CSV di atas untuk memulai
Shopee Ads
Analisis data iklan Shopee per tanggal, minggu, atau bulan
Ringkasan Store Shopee
| Platform | Store | Spend | GMV | Orders | Items Sold | ROAS | Cost Ratio % | CPO | CVR % | Price Point | AOV | CPM | CPC | Clicks* | Impressions* | CTR % |
|---|
Biaya & Revenue Trend
Store Performance
Brand Performance
Gender Performance
Category Performance
Detail Iklan
| # | Tanggal | Nama Iklan | Store | Brand | Gender | Kategori | Tipe | Impressions | Click | Revenue | Biaya | ROAS | ACOS | CTR | CVR | Price Point | Order | Terjual |
|---|
S
Belum ada data Shopee
Upload CSV Shopee di Manajemen Data Ads
TikTok Ads GMV
Analisis GMV Max Product dan GMV Max Live dari data TikTok Ads
Ringkasan Store TikTok
| Platform | Store | Spend | GMV | Orders | Items Sold | ROAS | Cost Ratio % | CPO | Price Point | AOV |
|---|
Biaya & Revenue Trend
Live vs Product: Spend & Revenue
Live vs Product: ROAS, CPO & Price Point
Live vs Product: Spend Share & Revenue Share
Live vs Product: Orders & Items Sold
Detail Iklan TikTok
| # | Tanggal | Nama Iklan / LIVE | Store | Status | Tipe | Mode | Impressions | Klik | CTR | CVR | Order | Omzet | Biaya | ROI | ACOS |
|---|
T
Belum ada data TikTok
Upload XLSX TikTok di Manajemen Data Ads
Lazada Ads
Analisis data harian Lazada Ads per tipe campaign
Ringkasan Store Lazada
| Platform | Store | Spend | GMV | Orders | Items Sold | ROAS | Cost Ratio % | CPO | CVR % | Price Point | AOV | CPM | CPC | Clicks* | Impressions* | CTR % |
|---|
Biaya & Revenue Trend
Impressions & Klik Trend
CTR & CVR Trend
Detail Lazada Ads
| # | Tanggal | Nama Campaign | Store | Status | Tipe | Impressions | Klik | CTR | CVR | Order | Terjual | Omzet | Biaya | ROI | ACOS | CPO |
|---|
L
Belum ada data Lazada
Upload XLSX Lazada di Manajemen Data Ads