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.
Jerome Wrigley · 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
Amazon
17 Common Amazon FBA and SKU Problems and How to Fix Them in 2027
The 17 most common Amazon FBA and SKU problems sellers face, from stranded inventory to fees and suspensions, with a practical fix for each in 2027.
Cross-channel
Building an Affiliate Program From Scratch as a Marketplace Seller
An affiliate program can drive external traffic without upfront ad spend. Here is how marketplace sellers can build one from scratch, step by step.
Cross-channel
Email and SMS List Building for Sellers Who Rely Too Much on Marketplace Traffic
Marketplace traffic can disappear overnight through algorithm changes or policy shifts. Here is how to build an owned email and SMS list as a hedge.
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.