Why did profit drop? Ask Si and read the channel breakdown
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.
By The DataxLand team· · 5 min read
"Revenue is only down 8% — so why is profit down by more than a third?" It is the question business owners ask most at the start of the month, and the hardest one to answer with a table of numbers. Profit is what is left after a long chain of deductions. A small change at the top of the chain can move profit a long way at the bottom.
This post shows how to split a change in profit into its causes, applies it to an example, and then explains how to read the answer when you ask Si "why did profit drop".
The numbers in this post are an illustration with stated assumptions, not a real business's figures.
Three ways to look at a change in profit
The same "profit down 12 million" can be split three ways. Each answers a different question.
| Split | Answers | Example conclusion |
|---|---|---|
| By formula | Which item in the profit calculation changed most? | "Ads rose 6 million; lower revenue cost 6 million of margin" |
| By one dimension | Which channel or product dragged it down? | "TikTok Shop down 10 million, Shopee down 3 million" |
| By a two-dimension combination | Where exactly? | "Product X on TikTok Shop" |
Go in this order: the formula tells you the kind of problem (selling less, spending more, paying higher fees), the dimension tells you where, and the combination tells you what to fix first.
Example: this month vs. last month
Assumption: a business selling on three channels, two consecutive months. Shopee and TikTok Shop are two of the largest marketplaces in Vietnam and South-East Asia.
| Item | Last month | This month | Change |
|---|---|---|---|
| Net revenue | 250,000,000 ₫ | 230,000,000 ₫ | −20,000,000 ₫ |
| Cost of goods | 130,000,000 ₫ (52%) | 117,300,000 ₫ (51%) | +12,700,000 ₫ |
| Marketplace, payment and shipping fees | 45,000,000 ₫ (18%) | 43,700,000 ₫ (19%) | +1,300,000 ₫ |
| Contribution margin | 75,000,000 ₫ (30%) | 69,000,000 ₫ (30%) | −6,000,000 ₫ |
| Advertising | 40,000,000 ₫ | 46,000,000 ₫ | −6,000,000 ₫ |
| Profit after fees | 35,000,000 ₫ | 23,000,000 ₫ | −12,000,000 ₫ |
The "Change" column shows the effect on profit: a lower cost is a plus. Adding the four component rows: −20 + 12.7 + 1.3 − 6 = −12 million ₫, exactly the change in profit.
Reading by formula
Split by formula, cost of goods "helped" by 12.7 million ₫. That is misleading: cost of goods fell mostly because you sold less, not because you bought cheaper. A better reading splits further by ratio:
Effect of selling less = −20,000,000 × 30% (last month's contribution margin) = −6,000,000 ₫
Effect of the COGS ratio = 230,000,000 × (52% − 51%) = +2,300,000 ₫
Effect of the fee ratio = 230,000,000 × (18% − 19%) = −2,300,000 ₫
Effect of advertising = 40,000,000 − 46,000,000 = −6,000,000 ₫
Total = −12,000,000 ₫The conclusion is much clearer: half of the lost profit comes from selling less, half from higher ad spend. Goods one percentage point cheaper just offset fees one point higher. Revenue fell only 8% but profit fell 34%, because ad spend rose 15% at the same time without lifting revenue.
Reading by channel
| Channel | Profit last month | Profit this month | Contribution to change |
|---|---|---|---|
| Shopee | 24,000,000 ₫ | 21,000,000 ₫ | −3,000,000 ₫ |
| TikTok Shop | 6,000,000 ₫ | −4,000,000 ₫ | −10,000,000 ₫ |
| Website | 5,000,000 ₫ | 6,000,000 ₫ | +1,000,000 ₫ |
| Total | 35,000,000 ₫ | 23,000,000 ₫ | −12,000,000 ₫ |
TikTok Shop accounts for most of the drop and swung from profit to loss. The next question is no longer "why did profit drop" but "what did the extra ad spend on TikTok Shop bring in".
Reading by two-dimension combination
The last step is finding the channel × product or channel × campaign pair that contributed most. Usually one or two pairs explain most of the change: a campaign whose budget went up, a product that went out of stock, a SKU with unusually many returns. That is your Monday-morning task.
Five common reasons profit drops
- Ad spend grows faster than revenue. Check ROAS by campaign, especially campaigns that auto-optimise for GMV.
- Product mix shifts towards low-margin products: revenue holds but contribution margin falls.
- Marketplace fees change from a date mid-month; the increase is small but applies to every order.
- The return rate rises on one channel, bringing both refunds and return shipping costs.
- The numbers are not complete yet: fees still estimated, new cost prices not entered, the last day's data not fully in. Before concluding, check the "data as of" line and the share of estimated fees.
The fifth reason is not a real drop in profit. That is why every answer about profit should say whether the numbers are complete.
How to ask Si for an answer you can use
A good question names the metric, the period and the comparison:
| Instead of | Ask |
|---|---|
| "Why is profit down?" | "Why did profit after fees drop this month compared with last month?" |
| "Which channel is bad?" | "Which channel pulled profit after fees down the most this month?" |
| "How are the ads doing?" | "Ad spend and profit after fees on TikTok Shop by week, last 8 weeks" |
For multi-step questions like this, turn on Deep thinking: Si splits by formula, then by channel, then by product, and the Reasoning section shows its steps. Every number in the answer has a Sources section with the metric, version, period and the date the data runs to.
How DataxLand does it
The "why" is not written by the AI. On a dashboard, click Why? on the profit-after-fees tile to open the number inspector: the Why it changed tab splits the change by formula, by formula tree, by the values pulling down most, and by notable two-dimension combinations, with a table of this period, the comparison period and the SQL that ran. The metric engine computes that breakdown from approved definitions; when you ask Si "why", Si uses exactly this explanation, in the app or in Telegram and Slack.
See how to phrase questions in Ask Si in the app and the overview on the Si page. A profit and loss dashboard by channel and product is in the retail · finance template.
FAQ
Does Si guess the cause?
No. The breakdown is computed by the metric engine on published data. Si puts that breakdown into words and says Couldn't answer this question when the metric doesn't exist or the data is not enough.
Should I compare with last month or the same month last year?
Compare with last month to see the recent trend; compare with the same period last year when the business is clearly seasonal (Lunar New Year, the year-end sale season). For months with big sale days, comparing with the previous month easily leads to the wrong conclusion.
Profit dropped but contribution margin held — what does that mean?
The problem sits below contribution margin, usually advertising. As in the example above, contribution margin held at 30% of revenue, but higher ad spend pushed profit down.
Why is this week's profit different today from yesterday?
Because marketplace fees are still estimated and orders can still be returned. Check the share of estimated fees before drawing conclusions about the latest week.
Read next: AI answers with sources · P&L dashboard: 8 metrics · What ROAS is profitable