A marketplace profit dashboard should answer one question quickly: which products deserve more attention, more stock and more advertising budget because they actually make money?
If the dashboard only shows revenue, sessions and ROAS, it is not a profit dashboard yet. It is a very confident mood board. Let’s make it useful.
Step 1: define the decision
Write down the decisions the dashboard must support: scale ads, pause spend, reprice, replenish, fix content, reduce returns or export finance data. Dashboards without decisions become decoration.
Step 2: choose the SKU grain
Build the model at SKU, marketplace and date level. This lets you compare Amazon, bol, Mirakl, Walmart, TikTok Shop and Shopify without hiding weak products inside channel averages.
Step 3: collect the revenue inputs
revenue_inputs = orders + discounts + refunds + marketplace + sku + dateUse ordered revenue, shipped revenue, refunds, coupons and promotion cost where available. Keep definitions consistent.
Step 4: add variable costs
Add product cost, marketplace commission, fulfillment, FBA or LVB, storage, return handling, payment cost and variable operational charges. This is where the dashboard becomes slightly less cheerful and much more useful.
Step 5: connect advertising
Bring in ad spend, attributed revenue, ACOS, ROAS and TACoS. Then calculate contribution margin after ads. Link to TACoS vs ROAS and advertising reviews so campaign changes follow profit.
Step 6: add operating signals
Include stock cover, Buy Box, price position, organic ranking, conversion rate and return rate. Profit without operational context can recommend scaling a product that is about to stock out. Very dramatic. Avoid.
Step 7: create action views
| View | Use | Action |
|---|---|---|
| Scale list | High margin, enough stock, efficient ads | Increase budget |
| Fix list | Demand exists, conversion weak | Improve content or price |
| Pause list | Low margin, high spend | Cut bids |
| Replenish list | Good profit, low stock | Order inventory |
Common pitfalls
- Mixing VAT-inclusive and VAT-exclusive revenue.
- Using average commission instead of category fee.
- Reviewing ads without returns.
- Ignoring stock when recommending budget increases.
- Letting every team use a different profit definition.
What to check before trusting it
- Does total revenue reconcile with marketplace exports?
- Do SKU costs match finance?
- Are ad costs tied to the right marketplace and SKU group?
- Can the dashboard explain contribution margin changes week over week?
- Can you export the action list?
FAQ
What is the most important metric?
Contribution margin after ads, read beside stock and returns.
How often should it update?
Daily is good for operators; weekly is the minimum for advertising and stock decisions.
Should finance own the dashboard?
Finance should validate definitions, but marketplace teams need to use it operationally.
Can I build this in spreadsheets?
Yes, but it becomes fragile as channels, fees and ad accounts grow.
How does FiveX help?
FiveX connects analytics, profit analytics, Amazon P&L, repricing, stock and data exports in one workspace.
A good profit dashboard does not just report what happened. It tells you what to do next, preferably before the margin starts sending passive-aggressive emails.