E-commerce AnalyticsPortfolio project, dummy data

E-commerce Sell-out 2026

A portfolio project on a consumer-health brand selling on Indonesian marketplaces

Net sales from TikTok Shop, Shopee, Tokopedia, Lazada and Blibli order exports, by platform, store, brand and item.

Daily store traffic reports: visitors, product clicks, ads and conversion, read next to the orders they produced.

Twin-date and payday sales tracked hour by hour against the previous campaign, with store voucher usage and platform rebates.

Bundles and multipacks are exploded into physical SKUs, each SKU × warehouse forecast is tested against actual sales, then turned into a carton shipment plan.

Loading data…

Illustration of the fictional product range: syrup, gummies, lotion, boxed caplets and capsules

Where buyers are, and where orders ship from

Sales trend

GMV of valid orders, excluding cancelled and returned orders

GMV by platform,

Daily GMV

Campaign day (twin date, payday)Ordinary dayDaily average

Platforms & stores

GMV share by platform

Shopping hours

Share of GMV by the hour the order was placed (WIB). Midnight flash sales on campaign days lift hour 00.

Store Warehouse GMV Orders Avg. order value GMV share vs last month

Brands

Click a dot or a bar to see that brand's items

Contribution vs growth

One dot per brand. Further right means a bigger share of GMV, higher up means it grew from last month.

Kids & FamilyAdult & Specialty

GMV by brand

Kids & FamilyAdult & Specialty

Items

Sellable items as listed on the marketplaces, including multipacks and bundles

Code Item Type Units GMV Avg. price vs last month

Illustration of a live shopping stream on a phone

From visit to order

Store funnel

All stores combined. Each step shows how many of the previous step made it through.

Conversion rate by platform,

Orders ÷ visitors.

Day by day

Campaign days bring more visitors and convert better

Daily visitors and conversion

Campaign dayOrdinary day

TikTok Shop GMV by content source

Where TikTok Shop buyers came from. LIVE sessions keep growing their share.

Store traffic

Conversion and ads by store · growth is in visitors

Store Visitors Product clicks Orders Conversion Ad CTR Visits from ads vs last month

Illustration of a 9.9 sale on a phone with a voucher and a shopping bag

Hour by hour

Cumulative GMV of valid orders against the previous campaign of the same type

Pacing

Checkpoint report

The update the team posts during the day: GMV so far, against the same hour and the full day of the previous campaign.

Campaign history

Full-day GMV of every twin date and payday since

Twin datePayday (25th)Ordinary day average

Store vouchers

Voucher Channel Min. spend Discount Used / quota Sold out at Cost GMV per Rp1 of cost

Voucher cost after platform rebates

Platforms co-fund part of the store vouchers on campaign days and pay it back as a rebate.

Illustration of a warehouse with cartons and a delivery van

Warehouse network

Bubble size = cartons to ship next monthRing = forecast accuracy this month

Forecast accuracy

Forecast vs actual, SKU units per month

ActualForecast

Accuracy by warehouse

Accuracy = 1 − WAPE. The darker the cell, the lower the accuracy. Click a row to filter the SKU table.

SKU × warehouse

Forecast error against actual. Blue: forecast too low. Red: forecast too high.

Forecast vs actual per SKU × warehouse

Log scale. Dots on the line are exact, the grey band is the ±25% tolerance. Ringed dots belong to the SKU on the right; click another dot to switch.

Forecast >25% too lowForecast >25% too highWithin tolerance

Stock cover

Days of inventory by warehouse

Each bar splits the SKUs a warehouse holds by how many days their stock lasts. The number is the warehouse's overall cover. Click a row to filter the table.

Stock by product status

Status from the monthly SKU review: steady sellers, new launches, slow movers and products being phased out.

SKU × warehouse pairs under 14 days, by month

SKU · warehouse Stock on hand Sold per day Days of inventoryCover Runs out around

Shipment plan

SKU 3-month avg. Forecast + Safety stock Units per carton Cartons to ship

How the data is processed

    Exploding items into physical SKUs

    One sellable item can hold several SKUs. Warehouse stock is counted in physical SKUs, not in sellable items.

    How the forecast works