Daily GMV by platform
Gross merchandise value
Sales mix
GMV share by platform
GMV by category
E-Category, current scope
GMV by segment
Top E-Segments in scope
Insights
Generated from the filtered dataset
GMV · CBP · DBP by platform
Sales value at each price basis
GMV by e-subcategory
Top subcategories in scope
Platform scorecard
Reconciled across scope · comparison follows the LM / AP3M switch
| Platform | GMV | CBP | DBP | AIV | AOV | Discount | Item Sold | GMV share |
|---|
Monthly GMV by platform
Full calendar months · GMV
Discount depth vs. units sold
Each point is a SKU-week · size = GMV
Higher discount should buy more volume. Points far right with small size are deep discounts that aren't moving units.
Discount depth by category
Weighted by CBP
Estimated claim by SKU
Absolute discount (CBP − GMV) — the claimable amount per SKU
| Super SKU | GMV | CBP | Claim (CBP − GMV) | Discount % | Item Sold |
|---|
Claim = CBP − GMV, the absolute discount below consumer list price, aggregated per Super SKU in the current scope. Sorted by largest claim. Values follow the LC/USD switch.
Stock on hand by Super SKU
Stock position, days-of-inventory & class
| Super SKU | Class | DOI | SOH | Avg Item Sold | Avg DBP | Avg CBP | Avg GMV |
|---|
Item sold — demand & forecast
Weekly singlelized item sold · shaded zone is the forecast band
Top SKUs by item sold
Demand leaders in the current scope
| SKU | Item Sold | GMV | DBP | Discount | Share |
|---|
GMV trend by category
Daily GMV per category across the selected range
Category-level performance
by E-Category
| Category | GMV | Sales in CBP | Item Sold | PV | Visitor | Conversion | Order | AIV | AOV | GMV gap vs CBP |
|---|
Item Sold = singlelized · AIV = GMV ÷ items · AOV = GMV ÷ orders · Conversion = orders ÷ visitors · GMV gap vs CBP = (CBP − GMV) ÷ CBP. LM compares with the same dates one month earlier · AP3M compares with the average of the same dates over the past 3 months (switch top-right). Click a column header to sort. GMV / AIV / AOV follow the LC/USD switch.
SKU-level performance
by Super SKU
| Super SKU | GMV | Sales in CBP | Item Sold | PV | Visitor | Conversion | Order | AIV | AOV | GMV gap vs CBP |
|---|
Item Sold = singlelized · AIV = GMV ÷ items · AOV = GMV ÷ orders · Conversion = orders ÷ visitors · GMV gap vs CBP = (CBP − GMV) ÷ CBP. LM compares with the same dates one month earlier · AP3M compares with the average of the same dates over the past 3 months (switch top-right). Click a column header to sort. GMV / AIV / AOV follow the LC/USD switch.
Conversion rate by platform
Item Sold ÷ Visitors
Traffic & conversion by SKU
Per Super SKU
| SKU | PV | Visitor | Item Sold | Conversion | AIV | Size | Price / size |
|---|
Conversion = Item Sold ÷ Visitors · Price / size = AIV ÷ E-SIZE (per gram / ml / piece, by the SKU's unit). AIV and Price/size follow the LC/USD switch. Click a column to sort.
A/B Testing
Scope follows the main filters on top (country, platform, category, segment, SKU type, date). CBP/DBP use effective pricelist prices.
Current promo — locked to period
Simulation
units_sim / day = units_current / day × ((1 − d_sim) ÷ (1 − d_current)) ^ (−elasticity) GMV_sim = units_sim × CBP_eff × (1 − d_sim) CBP_sim = units_sim × CBP_eff CLAIM_sim = units_sim × CBP_eff × d_sim Δ% = (SIM − CURRENT@same_duration) ÷ CURRENT@same_duration d_current, units_current/day, CBP_eff ← main filters (scope + date range) CBP_eff, DBP_eff ← effective pricelist price (latest ≤ each row's month) elasticity ← ln(units) ~ ln(1 − d) regression, full history (override with slider)
Unmapped SKUs — sales dropped from staging
—
| Month | Country | Platform | Platform Code | Variant Code | Description | GMV (LC) | Item Sold |
|---|
Sales rows present in the raw seller-center files (daily, FLAG = 1) whose SKU has no PRODUCT MAPPING entry and is not covered by BUNDLE PRODUCT MAPPING. The transform drops these from STAGING SINGLE (the legacy UNMAPPED query), so their GMV and items are missing from every other page and from the database. Fix: add the codes to the PRODUCT MAPPING master in 02 MASTER DATA and re-run the ETL. GMV is in each row's own local currency. This list ignores the filters above and refreshes on each ETL run.
Export Data
All staging columns (daily rows) for the current filter, as CSV
Exports daily rows within the selected date range. Full-month rows are excluded to avoid double-counting.
Ask the Intelligence Hub
Answers reflect your filters and selected currency
Monthly trend
Breakdown
| Category | Item Sold | Sales DBP | Sales RBP | % of DBP | Rows |
|---|
Indonesia offline distributor sell-in (DMA). Values in IDR. Net figures include returns (negative rows); use the Returns toggle to isolate them. Aggregated in the database via /api/offline.
Monthly trend by channel
Channel share
Channel × Region
Rows: channel · columns: region, both sorted by the selected measure. Values in IDR (DMA sell-in). Net figures include returns.
Monthly trend by category
Top categories
Category × Region
Rows: product category · columns: region, both sorted by the selected measure. Values in IDR (DMA sell-in). Net figures include returns.
Monthly trend by channel
Top key accounts
Key accounts × Region
Customer groups within the selected channels (default: MMKA, MTKA, MTI, HABA). Toggle channel chips to widen or narrow the modern-trade scope. Values in IDR (DMA sell-in).
Monthly trend
Region share
Sub-distributors × Region
Channel SUBDIST only — sell-in to sub-distributors, by customer and region. Values in IDR (DMA sell-in). Net figures include returns.
National — Target vs Actual
Modern Trade — Target vs Actual by channel
General Trade — Achievement map · Indonesia
Click a region on the map to open its branch drill-down. Color = GT achievement vs target · gray = excluded (toggle via the Region chips or the drill panel).
General Trade — Target vs Actual by region
General Trade — Achievement ranking
Achievement detail — YTD (complete months)
Real 2026 targets from the Master Target file (millions IDR ×1e6). MT = HABA / MMKA / MTKA by channel; GT = all other channels by REGION NEW; National = MT + GT. Actuals = net Sales DBP (incl. returns).