How to build a contribution margin dashboard you trust
Most e-commerce brands track ROAS but not contribution margin. Here's how to build a dashboard that shows real profit per order.
You probably don't know your real profit per order
Most D2C founders can tell you their ROAS. Very few can tell you their contribution margin per order after all variable costs. That gap is where brands slowly bleed out while thinking they're growing.
Contribution margin is the money left over from a sale after you subtract every variable cost tied to that order. Not just COGS. Everything: shipping, payment processing, packaging, returns, discounts, and the ad spend that drove the purchase. It's the number that tells you whether selling more units actually makes you richer or just busier.
Why ROAS alone will mislead you
A 4x ROAS on Meta sounds great. But if your average order is $60, your COGS is $18, shipping costs $7, your payment processor takes $2.10, your packaging is $1.50, and you offered a 10% discount, here's what actually happened:
- Revenue: $60
- Discount: -$6
- COGS: -$18
- Shipping: -$7
- Payment processing: -$2.10
- Packaging: -$1.50
- Ad spend at 4x ROAS: -$15
- Contribution margin: $10.40
That's a 17.3% contribution margin. Not bad, but not the 75% gross margin you might quote on a pitch deck. And if your return rate is 15%, that $10.40 gets shaved down further because you eat shipping both ways on returns and sometimes lose the inventory entirely.
The point is not that 4x ROAS is bad. The point is that ROAS doesn't capture enough of the picture to make decisions with.
What goes into the dashboard
You need a single view that updates daily (or close to it) and shows contribution margin at three levels:
- Per order (average across all orders that day/week)
- Per channel (Meta, Google, email, organic, etc.)
- Per product or product category
Here are the line items to include for each order:
- Net revenue (after discounts and before tax)
- COGS per unit, pulled from your product data
- Shipping cost (what you actually pay, not what you charge the customer)
- Payment processing fees (usually 2.9% + $0.30 for Shopify Payments, varies by provider)
- Packaging and insert costs
- Return cost allocation (take your monthly return costs and divide by total orders to get a per-order average)
- Variable ad spend attributed to that channel
Subtract all of those from net revenue. That's your contribution margin.
How to actually build it
Option 1: Spreadsheet. Seriously. For brands under $3M in annual revenue, a Google Sheet updated weekly works fine. Pull your Shopify order export, your ad platform spend, and your shipping invoices. Map them together. It takes about 90 minutes per week once you have the template built. This is unglamorous and it works.
Option 2: A tool like Triple Whale, Lifetimely, or Polar Analytics. These pull data from Shopify, your ad accounts, and your shipping provider automatically. They're not perfect out of the box. You still need to input accurate COGS per SKU, your actual shipping costs (not estimates), and your return rates. Most brands set these up once and never update the inputs, which makes the dashboard useless within a few months.
Option 3: A custom build in a BI tool like Looker Studio or Metabase. This makes sense if you have someone technical on the team or an agency handling your data. You connect your Shopify database, ad APIs, and shipping data into a warehouse (BigQuery is free for small volumes) and build the views you need.
Regardless of which option you pick, the most common failure is wrong COGS data. If your product costs have changed since you last updated your records, every number downstream is wrong. Set a calendar reminder to update COGS quarterly at minimum.
Decisions this dashboard actually unlocks
Once you have reliable contribution margin data by channel and product, you can answer questions that matter:
- Which products should you push in ads? Not the highest AOV ones. The highest contribution margin ones.
- Where is your ad spend actually profitable? A channel with 3x ROAS might deliver better contribution margin than one with 5x ROAS if the product mix and AOV are different.
- Should you offer free shipping? You can model exactly how much margin you lose per order and decide whether the conversion rate lift justifies it.
- When should you cut a promotion? If a 20% sitewide sale drops your contribution margin below $5 per order, you're paying to lose money at scale.
The number to watch every week
Track your blended contribution margin percentage across all orders, all channels, every week. Plot it over time. If it's trending down while revenue is trending up, you are growing yourself into a hole. If both lines trend up together, you have a real business.
At Argus, contribution margin is one of the first things we calculate for every brand we work with, because you can't build a growth plan on top of numbers you don't trust. If you want us to look at yours, ask for a free growth plan.