Start with the decisions the dashboard needs to support
A dashboard is not a warehouse of figures. Before choosing a single column, list the decisions it should make easier: whether to restock, adjust a price, pause an ad campaign or delist a SKU. Every metric displayed should be able to trigger one of these decisions; otherwise, it is just clutter.
Also define how often it will be read. A seller who manages advertising day to day will need a weekly view, whereas a portfolio review is typically done monthly or quarterly.
Finally, think about who will be reading it: a dashboard for the seller running the campaigns does not need the same level of detail as a summary view for a partner or a lender. Two consistent views fed by the same data are better than a single screen that nobody can read.
Choose a handful of genuinely useful metrics
On Amazon, as on other marketplaces, revenue is the most visible metric and the least informative about profitability. Build your dashboard around profit metrics, calculated the same way for every product.
- Net sales after refunds
- Marketplace fees by category (referral, fulfillment, storage)
- Advertising spend relative to sales
- Margin per unit and total margin per product
- Variance between actual and forecast margin
- Available stock expressed in weeks of sales
Track sales, expenses, margins and variances against your initial assumptions.
Explore the solutionMake your data sources reliable before polishing the display
Data comes from several places: the platform’s sales and payment reports, the advertising console, supplier invoices and shipping costs. The main risk is inconsistency: the same product identified differently depending on the source, periods that don’t line up, fees counted twice.
Create a single product master that links platform identifiers, your internal SKUs and the current purchase cost. Date your purchase costs: when a supplier changes its prices, the history must stay accurate. This discipline matters more than the choice of tool.
Organize the screen from the big picture to the detail
A good structure has three levels. At the top, a few key figures for the period compared with the previous one. In the middle, a ranking of products by total margin, which immediately shows the top contributors and the loss-making SKUs. At the bottom, the detail for a single product: a breakdown of its fees and how it has changed over time.
Highlight exceptions rather than averages: a color or marker for products that exceed a drift threshold draws attention to where action is needed. The platform’s native reports remain useful for operational detail; the profit dashboard complements them by bringing together what they present separately.
Finally, add a section for dated comments, even a basic one. Noting that a rise in fees corresponds to a change in fulfillment method, or that a drop in sales coincides with a stockout, saves you from repeating the same investigation the following month and makes the dashboard understandable to anyone who consults it.
Homemade spreadsheet or dedicated tool: selection criteria
A spreadsheet works well at the start: it is flexible and forces you to understand every calculation. It reaches its limits when the number of SKUs grows, imports become tedious or several people edit it. The criteria to consider are update time, the risk of formula errors, the ability to track several channels and readability for a partner.
Profit+ is one option among others for this need: it offers a dashboard, expense tracking, margin calculation per product and drift alerts, in a view dedicated to operational profitability that complements the dashboards provided by marketplaces.
FAQ
Do you need a dashboard for each marketplace?
A consolidated view with a channel filter is better. That way you see the overall profitability of a product sold in several places, while still being able to isolate a channel that is eroding the margin. Separate dashboards make trade-offs harder.
How often should you update purchase costs?
Whenever the supplier price, shipping cost or packaging changes, keeping the effective date. Without these updates, the dashboard shows a theoretical margin that may diverge from reality for a long time.
How do you include advertising in profit per product?
Assign each advertising expense to the product it promotes, then deduct it from that product’s margin. For campaigns covering several products, allocate the spend using a simple key, such as attributed sales, and apply it consistently.
Need a demo or a project review?
Dyonysos can present Profit+, study your use case and design a test suited to your context.
Contact us