Cross-channel
Building a Unit Economics Dashboard by SKU, Channel, and Promo
Aggregate profit numbers hide where you actually make and lose money. Here is how to build a unit economics dashboard broken down by SKU, channel, and promo.
Alex Jones · August 1, 2026 · 6 min read
Last updated August 2026
Photo via Unsplash
Table of contents
A single aggregate profit number tells you almost nothing about which specific products, channels, or promotions actually drove that result. A unit economics dashboard replaces that vague picture with real detail.
Why Aggregate Numbers Hide the Real Story
A business with healthy overall margin can still have individual SKUs losing money on every sale, hidden behind the average.
The Three Dimensions Your Dashboard Needs
By SKU
Every product needs its own contribution margin calculation.
By Channel
The same product often has different economics on different channels.
By Promo
Every promotion needs its own contribution calculation isolating discount and deal fee costs.
Building the Dashboard in Practice
Start with a spreadsheet pulling revenue, cost, fees, and ad spend per SKU. Use our Amazon Fee Calculator for platform fee accuracy.
What to Do With the Data Once You Have It
Identify strong performers, marginal performers needing adjustment, and clear losers to discontinue.
Common Mistakes When Building Unit Economics Dashboards
Evenly distributing ad spend and ignoring returns costs both distort the picture.
Check our newsletter for ongoing financial analytics coverage.
Frequently Asked Questions
How often should I update my unit economics dashboard?
Monthly at minimum, more frequent during promotions or new launches.
What is the minimum data I need to start building this?
Revenue, product cost, platform fees, and advertising spend per SKU.
Should I build this manually or use software?
Manual spreadsheets work for smaller catalogs, dedicated software helps as complexity grows.
Takeaways
- Aggregate profit numbers hide which SKUs, channels, and promos drive results.
- Build contribution margin at SKU, channel, and promo level separately.
- The same product often has different economics across channels.
- Review the dashboard on a consistent monthly cadence.
- Avoid even ad spend distribution and ignoring returns costs.
Related reading: Inventory Forecasting to Avoid Stockouts and Cohort Analysis 101.
Keep up with Amazon seller news and marketplace updates in the weekly Cruxfinder issue.
Related reads
Cross-channel
ChatGPT Recommended a Completely Fake Brand With Zero Real Products. Here's What That Means for Your Actual One
An entrepreneur built a fake deodorant brand with no real products, and ChatGPT started recommending it as a genuine option within weeks. Here's what the experiment actually showed, and what it means for real brands trying to earn AI visibility honestly.
Cross-channel
A Federal Bill Could Force Amazon and Walmart to Prove Wrongdoing Before Suspending Your Account. Here's Where It Stands
The Online Sellers Bill of Rights would require platforms to show proof before suspending sellers and release frozen funds after 30 days without evidence. Here's what it actually says, who's behind it, and how far it has to go.
Cross-channel
How to Use Printify to Create and Sell Custom Products on Amazon and Shopify
A practical walkthrough of setting up Printify for print-on-demand selling on Shopify and Amazon, including the extra approval step Amazon requires.
Frequently asked questions
- How often should I update my unit economics dashboard?
- Monthly at minimum, with more frequent review during promotional periods or new product launches.
- What is the minimum data I need to start building this?
- Revenue, product cost, platform fees, and advertising spend broken out per SKU are the essential inputs.
- Should I build this manually or use software?
- For smaller catalogs, a manual spreadsheet is manageable. As complexity grows, dedicated software becomes worth the cost.