· 6 min read
AI answers with sources: why not trust AI-written SQL
Can you trust AI data analysis? Five ways AI-written SQL produces wrong numbers, and why official numbers should come from defined metrics with sources.
The DataxLand product team
The team behind DataxLand writes about business data, metrics by industry and team, and how to use AI with your business numbers.
· 6 min read
Can you trust AI data analysis? Five ways AI-written SQL produces wrong numbers, and why official numbers should come from defined metrics with sources.
· 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
Alert on falling revenue or rising returns without drowning in messages: choose the period, threshold, change or anomaly condition, wait time and recipients.
· 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
Connect Claude Code and Cursor to business numbers over MCP: create a read-only token, configure the client, keep the token out of the repo, and sample prompts.
· 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.
· 15 min read
Vietnam's data protection law applies from 1 Jan 2026: what online sellers must know about buyer names and phone numbers, AI tools and deletion requests.
· 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.
· 5 min read
Send sales numbers to Google Sheets for your accountant on a schedule: pick metrics, overwrite or append, set up a service account, keep formulas intact.
· 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.
· 6 min read
A Telegram bot your whole team can ask about revenue: link accounts, bind the group to a workspace, ask with /ask, and set group rules so numbers stay safe.
· 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
What a lakehouse is, how DuckLake and Parquet differ from a traditional data warehouse, and why small-business data doesn't need a big cluster to be fast.
· 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.
· 5 min read
Lazada fees after May 2026: 6% order processing fee, 3,000 ₫ infrastructure fee, category fixed fee. One order's profit, compared with other marketplaces.
· 6 min read
Shopee fees: fixed fee, 6% transaction fee, 3,000 ₫ infrastructure fee, Voucher Xtra, co-funded vouchers. One order's profit, and why small orders pay more.
· 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
TikTok Shop fees after the 9 May 2026 change: commission, 6% transaction fee, Voucher Extra, 3,000 ₫ order processing fee, affiliate. Profit per order, worked.
· 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.
· 6 min read
Seven signs your Excel reporting file is overloaded, what a data warehouse really does, the cost and risk of each step, and how to move without dropping Excel.
· 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.
· 5 min read
What the Model Context Protocol is, why pasting sales files into a chatbot is risky, and how to give Claude or your own agent read-only access to approved metrics.
· 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.