How to Build a Unit Economics Dashboard That Actually Drives Decisions

Here's a brutal truth about most DTC brands: they're flying blind.

They'll tell you their revenue is up 40% year-over-year. They'll show you their ROAS in the ad platform. They'll point to a Shopify dashboard that says everything is green. And then they'll wonder why their bank account keeps shrinking.

The problem isn't a lack of data. It's a lack of the right data, organized in a way that actually tells you whether your business is healthy — or hemorrhaging cash on every order.

That's what a unit economics dashboard fixes. Not a vanity metrics dashboard. Not a "look how much revenue we did" dashboard. A dashboard that answers the only question that matters: are we making money on each unit we sell, and if not, where is it breaking?

At ATTN Agency, we've helped over 100 DTC brands build profitability visibility from scratch. This is the playbook.

Why Most Ecommerce Dashboards Are Useless

Let's start with what you probably have right now:

Shopify Analytics — tells you revenue, AOV, conversion rate. Doesn't know your COGS, shipping costs, or actual margin.
Google Analytics / GA4 — great for traffic attribution. Says nothing about profitability.
Ad Platform Dashboards — Meta, Google, TikTok all report ROAS. But platform ROAS ≠ profitable ROAS. A 3x in-platform ROAS might be a 0.8x blended ROAS once you account for everything.
Triple Whale / Northbeam / Polar — better. But they're attribution tools with some P&L features bolted on. They're not built from unit economics up.

The gap is always the same: nobody connects the ad spend to the fully-loaded cost of fulfilling that order and the actual lifetime value of the customer it acquired.

Your dashboard needs to close that gap.

The 7 Metrics Your Dashboard Must Track

Before you pick a tool, you need to know what you're measuring. Here are the non-negotiable metrics for any DTC unit economics dashboard:

1. Fully-Loaded COGS (Cost of Goods Sold)

Not just the product cost from your manufacturer. The real COGS:

Raw product cost — what you pay per unit
Packaging — boxes, inserts, tissue paper, tape
Inbound freight — getting product from manufacturer to your warehouse
Warehousing allocation — per-unit share of storage costs
Fulfillment labor — pick, pack, ship cost per order

Most brands only track the first one. That means they're understating COGS by 15-30%, which means their margin calculations are fiction.

Example: A skincare brand we worked with thought their COGS was $8.50/unit. When we loaded in packaging ($1.20), inbound freight ($0.85), and pick/pack ($2.10), actual COGS was $12.65. That's a 49% difference. Their "65% gross margin" was actually 47%.

2. Customer Acquisition Cost (CAC)

Blended CAC. Not platform-reported CPA. Blended means:

Total marketing spend (all channels) ÷ Total new customers acquired

Include everything: ad spend, agency fees, influencer costs, affiliate commissions, content production, tool subscriptions for marketing. If it exists to acquire customers, it goes in the denominator's cost bucket.

For most DTC brands at scale, blended CAC runs $35-$85. If you're only looking at Meta's reported CPA of $22, you're kidding yourself.

3. Contribution Margin Per Order

This is the single most important number in your business:

Revenue − COGS − Shipping − Payment Processing − CAC (allocated) = Contribution Margin

If this number is negative on first orders, you need to know by how much. If it's positive, you need to know how much runway you have before it flips.

Track this as both a dollar amount and a percentage. A $12 contribution margin on a $60 AOV (20%) tells a very different story than $12 on a $120 AOV (10%).

4. LTV:CAC Ratio (by Cohort)

Not a single LTV number. LTV by monthly acquisition cohort, tracked over 30, 60, 90, 180, and 365 days.

Why cohorts? Because your January customers might behave completely differently from your July customers (especially if you ran heavy discounts in January). A single blended LTV number hides these differences.

Healthy benchmarks:

30-day LTV:CAC → 1.0x or higher (you broke even in month one)
90-day LTV:CAC → 1.5-2.0x
365-day LTV:CAC → 3.0x+ (the gold standard)

If your 365-day ratio is below 2.0x, your business model has a structural problem that no amount of ad optimization will fix.

5. Payback Period

How many days until a customer's cumulative contribution margin equals the CAC spent to acquire them.

Formula: CAC ÷ (Average Monthly Revenue Per Customer × Contribution Margin %)

If your payback period is 90 days and you're spending $500K/month on ads, you need $1.5M in working capital just to fund the acquisition pipeline. This is where brands run out of cash despite being "profitable."

Target: Under 60 days for bootstrapped brands. Under 90 days if you have capital. Over 120 days? You're in danger zone.

6. Repeat Purchase Rate & Frequency

Repeat rate: % of customers who buy more than once within 12 months
Purchase frequency: average number of orders per customer per year

These feed directly into LTV. A 30% repeat rate with 2.1 average orders tells you that your repeaters are buying roughly 4.7 times each — which means your LTV is heavily concentrated in a small customer segment.

Your dashboard should break this out by acquisition channel. Meta customers might repeat at 25% while email-acquired customers repeat at 45%. That changes how you allocate budget.

7. Gross-to-Net Revenue Ratio

How much of your top-line actually makes it to net revenue after:

Discounts and promotions
Returns and refunds
Chargebacks
Taxes collected (not revenue)

Most brands operate at 75-85% gross-to-net. Meaning for every $100 in gross revenue, only $75-$85 is real. If your dashboard shows gross revenue and your cost calculations assume that's what you're collecting, every margin number downstream is inflated.

Choosing Your Dashboard Stack

You have three realistic options, each with tradeoffs:

Option A: Spreadsheet (Google Sheets / Excel)

Best for: Brands doing under $2M/year, or anyone who needs to understand the math before automating it.

Pros:

Free
Fully customizable
Forces you to understand every calculation
Easy to share with investors or partners

Cons:

Manual data entry (or semi-manual with imports)
Breaks at scale
No real-time visibility
Human error in formulas

Setup time: 2-3 days for a solid template. Budget 1-2 hours/week for maintenance.

We actually recommend every brand start here, even if they plan to automate later. If you can't build it in a spreadsheet, you don't understand it well enough to interpret an automated version.

Option B: BI Tool (Looker Studio, Tableau, Power BI)

Best for: Brands doing $2M-$20M/year with someone technical enough to maintain data pipelines.

Pros:

Connects directly to data sources (Shopify, ad platforms, accounting)
Auto-refreshes
Professional visualizations
Shareable dashboards

Cons:

Requires data pipeline setup (ETL)
Needs a data warehouse (BigQuery, Snowflake)
Someone has to maintain it
$500-$2,000/month in tooling costs

Our recommended stack: Shopify → Fivetran → BigQuery → Looker Studio. This handles 80% of DTC dashboard needs for roughly $600/month in tooling.

Option C: Purpose-Built Profitability Tools

Best for: Brands that want out-of-the-box unit economics without building custom pipelines.

Tools to evaluate:

Lifetimely — best for LTV/cohort analysis, weak on cost tracking
TrueProfit — strong on real-time profit per order, integrates COGS
Daasity — full analytics platform, higher price point, good for $10M+ brands
Tydo — clean interface, good for basics, limited customization

Pros:

Fast to deploy (days, not weeks)
Pre-built DTC-specific views
No technical maintenance

Cons:

Monthly subscription ($100-$1,000+/month depending on tool and GMV)
Limited customization
You're locked into their calculation methodology
Often missing key inputs (they estimate what they don't have)

Building the Dashboard: Step-by-Step

Regardless of which tool you choose, the build process is the same:

Step 1: Nail Your Cost Inputs (Week 1)

Before you build anything, gather accurate cost data:

Product COGS — get this from your manufacturer invoices, not estimates. Break it down per SKU.
Packaging costs — calculate per-order, not per-month. Include everything that goes in the box.
Shipping costs — pull 90 days of shipping invoices. Calculate average cost per zone and weight tier. Don't use a single average — it'll mislead you on heavy or far-flung orders.
Payment processing — typically 2.9% + $0.30 for Shopify Payments/Stripe. But check for chargebacks, currency conversion fees, and Shop Pay rates (which are lower).
3PL/fulfillment costs — per-order pick/pack fees, storage per cubic foot, any monthly minimums.
Marketing costs — every invoice, subscription, freelancer payment, and tool cost that exists for customer acquisition.

Put all of this in a single source-of-truth document. Update it monthly. Costs change — renegotiated shipping rates, new packaging, manufacturer price increases. A dashboard built on stale costs is worse than no dashboard.

Step 2: Map Your Data Sources (Week 1-2)

| Data Point | Source | Update Frequency | |-----------|--------|-----------------| | Revenue & orders | Shopify | Daily | | Ad spend | Meta/Google/TikTok APIs | Daily | | COGS | Manual input or ERP | Monthly | | Shipping costs | ShipStation/ShipBob/3PL | Weekly | | Payment processing | Stripe/Shopify Payments | Monthly | | Returns | Shopify + Loop/Returnly | Weekly | | Email/SMS costs | Klaviyo/Attentive | Monthly |

The biggest gotcha here: ad platform APIs report spend differently than your invoices. Meta rounds. Google converts currencies at different rates. Always reconcile API data against actual billing statements monthly.

Step 3: Build the Core Views (Week 2-3)

Your dashboard needs exactly four views:

View 1: Daily P&L Summary

Gross revenue, net revenue, total COGS, total shipping, total processing fees, total ad spend, contribution profit
Show as both absolute dollars and margins
Include a 7-day and 30-day rolling average to smooth daily noise

View 2: Per-Order Unit Economics

Average order: revenue, COGS, shipping, processing, allocated CAC, contribution margin
Break this out by new vs. returning customers
Show by product category if you have multiple lines

View 3: Cohort LTV Analysis

Monthly acquisition cohorts on the Y-axis
Cumulative revenue (and ideally, cumulative contribution margin) at 30/60/90/180/365 days on the X-axis
Color-code by acquisition channel if possible

View 4: Channel Efficiency

Per-channel: spend, new customers acquired, CAC, first-order contribution margin, projected LTV
Include blended row at the top
This is where you make budget allocation decisions

Step 4: Set Alerts and Thresholds (Week 3)

A dashboard you check once a week is better than nothing. A dashboard that tells you when something breaks is 10x better.

Set alerts for:

Contribution margin drops below X% — usually 15-20% is the floor
CAC exceeds $X — based on your payback period math
Return rate exceeds X% — product quality or expectation mismatch
Gross-to-net ratio drops below X% — heavy discounting or return spike

In Looker Studio, you can set up scheduled email reports with conditional formatting. In Google Sheets, use conditional formatting + a simple Apps Script to send email alerts. Purpose-built tools usually have this built in.

Step 5: Establish Review Cadence (Ongoing)

Daily: Glance at the P&L summary. Flag anomalies.
Weekly: Review per-order economics and channel efficiency. Make spend allocation adjustments.
Monthly: Deep-dive into cohort LTV data. Update cost inputs. Reconcile ad spend against invoices.
Quarterly: Revalidate all assumptions. Are your COGS still accurate? Has your shipping cost profile changed? Did a new product launch shift the mix?

Common Mistakes That Wreck Your Dashboard

Mistake 1: Using Averages When You Need Distributions

A $55 average AOV might mean 80% of orders are $40-$70 (tight distribution, predictable) or it might mean half your orders are $25 and half are $85 (bimodal, needs different strategies for each segment).

Your dashboard should show distributions, not just averages, for key metrics like AOV, COGS, and shipping costs.

Mistake 2: Ignoring Time Lag

If you calculate CAC using today's spend and today's conversions, you're wrong. Most attribution windows are 7-28 days. A $10K spend day might generate conversions over the next two weeks.

Use a 7-day or 14-day lagged CAC calculation — or better yet, use cohort-based CAC where you attribute all spend to the cohort it was targeting.

Mistake 3: Not Accounting for Returns in Margin

If your return rate is 15% (common in apparel), that's not just lost revenue. It's:

Refund of purchase price
Original shipping cost (sunk)
Return shipping cost (if you offer free returns)
Restocking/inspection labor
Potential inventory write-off if returned product can't be resold

A 15% return rate can reduce your effective contribution margin by 20-25%. If your dashboard shows margin before returns, you're overestimating profitability.

Mistake 4: Building It Once and Walking Away

Costs change. Channel mix shifts. New products launch. A dashboard built on January's assumptions is fiction by June.

Assign an owner. Set a monthly review to validate inputs. Treat the dashboard like a living document, not a one-time project.

What Good Looks Like: Benchmark Numbers

For reference, here's what healthy DTC unit economics look like across our client base:

| Metric | Healthy Range | Warning Zone | |--------|--------------|-------------| | Gross margin (fully loaded) | 60-75% | Below 50% | | Contribution margin (after CAC) | 15-30% | Below 10% | | Blended CAC | $30-$60 | Above $80 | | LTV:CAC (12-month) | 3.0x+ | Below 2.0x | | Payback period | 30-60 days | Above 90 days | | Repeat purchase rate | 30-45% | Below 20% | | Gross-to-net ratio | 80-90% | Below 75% | | Return rate | 5-15% | Above 20% |

These vary by category (supplements vs. apparel vs. home goods), but they give you a starting point.

The Bottom Line

A unit economics dashboard isn't a "nice to have." It's the difference between a brand that scales profitably and one that scales itself into a cash crisis.

The math isn't complicated. The data exists. The tools are available. What's usually missing is the discipline to gather accurate inputs, build the framework, and review it consistently.

Start with a spreadsheet. Get the numbers right. Then automate. The brands we've seen succeed aren't the ones with the fanciest dashboards — they're the ones who actually use the dashboard to make decisions every single week.

Your P&L doesn't lie. But it can't tell you the truth if you never build it.