· 6 min read
What is AOV? Raise order value without raising fees
What AOV is, why bigger orders earn more on marketplaces, and how to raise it with bundles, free-shipping thresholds and gifts without burning margin.
Blog
· 6 min read
What AOV is, why bigger orders earn more on marketplaces, and how to raise it with bundles, free-shipping thresholds and gifts without burning margin.
· 6 min read
Investor reporting from sales data: growth, unit economics, retention, channel concentration risk and cash, with definitions and how to share them.
· 8 min read
Build an Excel profit and loss file for Shopee, TikTok Shop and your website: sheet layout, SUMIFS and XLOOKUP formulas, splitting vouchers, fees and ads.
· 6 min read
A P&L template for cafes and restaurants: food cost, prime cost, theoretical vs actual COGS, delivery app commissions, with a line-by-line worked example.
· 5 min read
A monthly management report for service companies: recognised revenue, gross profit by project, utilization, receivables and cash on one page, with an example.
· 5 min read
What contribution margin is, how it differs from gross profit, how to calculate it online, and how to use it for break-even ROAS and revenue.
· 6 min read
20 data tasks in the 4 weeks before 11.11 and 12.12 to measure true profit, catch errors early and avoid arguing about numbers after the sale.
· 5 min read
Define your own KPIs without skewing shared numbers: naming, versions, checking numbers before activation, who approves, with a profit-after-packaging example.
· 6 min read
How to set a Shopee or TikTok Shop price from the profit you want: divide by (1 − % fees), a worked 20% margin example, per-order fees, vouchers, returns.
· 6 min read
Measure true profit after 11.11 and 12.12: compare with a baseline, subtract pulled-forward revenue, wait for returns and final fees, then judge.
· 6 min read
Why ad managers report more revenue than you made: attribution windows, double counting, GMV and cancellations. How to reconcile, and true ROAS.
· 7 min read
How to calculate cost of goods sold for an online shop: weighted average, FIFO, by batch and by effective date, with a worked example and a cost table in Excel.
· 7 min read
How returned goods put back in stock change COGS, inventory and profit: three return scenarios, costing returned sales and a worked example.
· 5 min read
Why profit falls hard when revenue dips only a little: how to split a profit change by formula, channel and product, and how to read Si's answer.
· 6 min read
Sales data checks: mismatched SKUs, duplicate rows, unknown order statuses, missing cost of goods, provisional fees. Catch them in Excel or automatically.
· 8 min read
Which channel to drop? A four-question framework for profit by channel: contribution margin, ads, shared costs and cross-channel effects.
· 6 min read
Build a product P&L to find best-selling SKUs that lose money: revenue × margin matrix, causes of loss, a traffic-builder check and decisions.
· 6 min read
Looker Studio for shops on Shopee, TikTok Shop and a website: connecting sources, what it does well, where profit after fees gets stuck, how to split the work.
· 6 min read
Using Sapo, KiotViet, Haravan or Nhanh.vn but no true profit report? What sales software has, what it lacks, and 3 ways to join it with marketplaces and ads.
· 6 min read
What provisional fees are, why the latest week's profit changes after marketplace settlement, a worked one-week example, and how to read unsettled profit.
· 5 min read
Power BI for small businesses: how Free, Pro and PPU licenses differ, who has to pay, and why the real cost includes the hours to build and maintain reports.
· 5 min read
GMV Max on TikTok Shop optimizes for ROI on GMV. How to turn that ROI into real profit: break-even ROI, organic GMV and a worked example.
· 5 min read
What cancellation rate divides by, where unpaid orders go, how failed delivery differs from cancellation: a standard status set to compare every channel.
· 6 min read
Allocate order-level vouchers to products by line value: four methods compared, a worked example, Excel formulas, and no fake SKU profit.
· 6 min read
Set up scheduled P&L reports and alerts in Telegram: which metrics to send, when, how to set thresholds without noise, and how to ask Si in the group.
· 6 min read
A step-by-step formula from listed price to profit after marketplace fees, cost of goods, returns and ads, with a worked example on three channels and a self-check list.
· 5 min read
Eight metrics that tell a multi-channel seller how much real profit they make, where, and whether to trust the numbers, with a 5-minute read.
· 1 min read
How to compute the true profit of a marketplace order — from the selling price to the cash you receive after cost of goods, fees, returns and ads.
· 6 min read
What Shopee, TikTok Shop and Lazada changed in 2026 fees, what price each fee applies to, when it is deducted, and how to get one true profit number.
· 4 min read
There is no universal good ROAS. How to compute break-even ROAS from contribution margin after marketplace fees, why platform ROAS runs high, and a three-channel example.
· 5 min read
The semantic layer explained with small-business examples: why dashboards, accounting spreadsheets and AI answers disagree, and how one versioned definition per metric fixes it.
· 5 min read
A return costs more than lost revenue: two-way shipping, packing, ad spend and sometimes the goods. Formulas, worked numbers and tracking by channel.