TL;DR: A marketing unit economics dashboard is useful when it connects CAC, LTV, gross margin, payback, and ROAS by source and cohort, so budget decisions are based on profitable growth instead of platform ROAS alone.
What is unit economics?
Unit economics means measuring revenue and cost at the level where the business actually creates value. For a subscription company, the unit may be a subscriber. For ecommerce, it may be an order, customer, product line, or customer cohort. For a local service business, it may be a booked job, accepted estimate, recurring account, or qualified lead source.
The point is simple: the business should know whether one customer, order, campaign, or cohort is profitable after the real cost to acquire and serve it. Revenue alone is not enough. Clicks alone are not enough. A ROAS dashboard alone is not enough when margin, refunds, sales labor, repeat purchase, churn, and payback timing change the answer.
A marketing unit economics dashboard puts the marketing view and finance view in one place. It connects ad spend, sales cost, customer acquisition cost, gross margin, customer lifetime value, payback period, and return on ad spend. That lets the team ask better questions:
- Which source brings customers who pay back fastest?
- Which campaign has high ROAS but poor contribution margin?
- Which segment has expensive CAC but strong customer lifetime value?
- Which channel looks bad in month one but wins by month six?
- Which offer should be paused because payback is too slow?
This matters because small businesses often scale from the wrong number. A campaign can show strong return on ad spend inside an ad platform while producing low-margin customers. Another campaign can look weak on first-purchase ROAS while bringing repeat buyers with better LTV. Without one view, marketing, sales, and finance argue from different dashboards. Getting these numbers right takes the same discipline as building a credible business process automation ROI case: measure the true cost before you trust the return.
Use the same operating mindset as a marketing dashboard: the dashboard is not decoration. It is a weekly decision system. Unit economics just makes the decision system more financially honest.
What should a marketing unit economics dashboard include?
A marketing unit economics dashboard should include the metrics that connect demand generation to profit and cash recovery. The first version does not need complex forecasting. It needs clean definitions, source-level reporting, and a simple model that everyone agrees to use.
Use explicit fields for CAC payback and gross margin LTV so everyone sees cash recovery and margin-adjusted value, not only revenue or ad-platform conversion value.
Start with these blocks:
| Block | Metrics | Decision it supports |
|---|---|---|
| Acquisition | Spend, leads, qualified leads, new customers | Which source creates enough qualified demand? |
| Cost | Ad spend, sales labor, agency cost, tools, discounts | What did it really cost to acquire customers? |
| Revenue | First order, first invoice, booked revenue, paid revenue | What came back from the cohort? |
| Margin | Gross margin, contribution margin, refunds, fulfillment cost | Is the revenue profitable after direct costs? |
| Lifetime value | Repeat revenue, subscription value, churn, retention | Is CAC justified over time? |
| Payback | Months or orders needed to recover CAC | Can the business afford the cash cycle? |
| ROAS | Revenue divided by ad spend | Is paid media efficient before deeper cost layers? |
| Alerts | CAC spike, margin drop, slow payback, tracking gap | What needs action this week? |
The key is not the number of charts. The key is agreement on what each metric means. CAC should not mean media spend in one meeting and total sales plus marketing cost in another. LTV should not mean gross revenue in one tab and gross-margin LTV in another. ROAS should not be treated as profit.
For most small and mid-sized businesses, the best first dashboard has these views:
- Executive summary: CAC, gross-margin LTV, payback, ROAS, contribution margin, and revenue by source.
- Source view: Google Ads, Meta Ads, organic search, referral, email, outbound, partners, and offline sources.
- Cohort view: customers grouped by first purchase month, first lead month, campaign, product, or region.
- Quality view: qualified lead rate, close rate, refund rate, churn, no-show rate, and repeat purchase.
- Action view: alerts, owners, next steps, and open data issues.
If creator or partner campaigns are part of the mix, connect the same source-cost view to influencer outreach automation so discovery, follow-up, discount codes, and affiliate revenue are not measured in a separate spreadsheet.
A good marketing unit economics dashboard should make budget decisions easier. If the next action is still unclear after the meeting, the dashboard is too broad, too messy, or missing the cost layer.
How to build an LTV CAC dashboard
An LTV CAC dashboard connects customer lifetime value to customer acquisition cost. That sounds simple, but the useful version requires three choices: how to define CAC, how to define LTV, and which level of segmentation is decision-ready.
Customer acquisition cost is commonly calculated as total sales and marketing cost divided by new customers in the same period. That cost can include ad spend, sales salaries, agency fees, software, creative work, discounts, and commission. A lightweight dashboard can start with paid media CAC, but the decision dashboard should also show blended CAC and fully loaded CAC.
Customer lifetime value estimates how much net profit a customer generates during the relationship. For subscription businesses, a basic model often uses average revenue per subscriber divided by churn rate. For ecommerce and services, the model may use repeat purchase rate, average order value, gross margin, refund rate, and expected order count.
Do not build an LTV CAC dashboard around one global ratio. Segment it. A blended ratio can hide the channel that is creating the problem.
Useful segments include:
| Segment | Why it matters |
|---|---|
| Source | Paid search, paid social, email, organic, referral, outbound, partner. |
| Campaign | Different offers create different customer quality. |
| Product or service | Margin and repeat purchase change by category. |
| Region | Close rate, delivery cost, and service capacity may differ. |
| Customer type | New buyer, repeat buyer, trial user, enterprise lead, local service lead. |
| Cohort month | Payback and retention need time-based tracking. |
The dashboard should also separate short-term and long-term signals. CAC is known quickly. LTV is estimated and matures over time. Payback sits between them because it shows how long cash is tied up before the acquisition cost is recovered.
A practical LTV CAC dashboard can use these rows:
| Source | New customers | CAC | Gross-margin LTV | LTV:CAC | Payback | ROAS | Decision |
|---|---|---|---|---|---|---|---|
| Paid search brand | 42 | $84 | $410 | 4.9 | 1.2 months | 7.4 | Protect budget, watch saturation. |
| Paid social prospecting | 67 | $138 | $260 | 1.9 | 4.8 months | 3.1 | Keep tests small, improve offer. |
| Partner referrals | 18 | $62 | $530 | 8.5 | 0.7 months | n/a | Build more partner capacity. |
| Retargeting | 31 | $48 | $120 | 2.5 | 0.9 months | 9.2 | Do not over-credit; many users were already warm. |
This table is more useful than a beautiful chart because it forces the decision. Protect, pause, test, fix, or scale. That is the job.
Why a ROAS dashboard is not enough
A ROAS dashboard tells you revenue divided by ad spend. In Google Ads, a target ROAS of 500% means the advertiser is aiming for $5 in conversion value for every $1 in ad spend. That is useful, but it is not the same as profit.
ROAS misses several important costs and risks:
- Cost of goods sold.
- Shipping, payment fees, and fulfillment.
- Returns, refunds, chargebacks, and discounts.
- Sales labor and account management.
- Agency and software cost.
- Churn and repeat purchase quality.
- Delayed revenue and slow payback.
- Attribution overlap between channels.
That is why a ROAS dashboard can encourage bad scaling. A low-margin product with aggressive discounts can show strong platform ROAS but weak contribution margin. A subscription campaign can show weak first-month ROAS but strong LTV after retention is included. A local service campaign can create many calls but few qualified jobs because the leads are outside service area.
Use ROAS as an early signal, not the final decision. The dashboard should show ROAS next to CAC, gross margin, payback, and LTV. The moment those numbers disagree, the team has useful work to do, and a quick ROAS leak check can pinpoint where ad spend is being wasted before the deeper cost layers are modeled.
For example:
| Campaign | Platform ROAS | Gross margin | CAC | Payback | Better decision |
|---|---|---|---|---|---|
| Discount bundle | 6.2 | 21% | $74 | 5.6 months | Reduce discount or cap spend. |
| Service estimate | 2.4 | 54% | $190 | 2.1 months | Improve landing page, keep testing. |
| Repeat-buyer email | 18.0 | 39% | $12 | 0.2 months | Scale carefully, avoid over-mailing. |
The highest ROAS is not always the best budget use. It may be retargeting demand that already existed. It may be discount-driven. It may be small and impossible to scale. The best source is the one that produces profitable customers at a payback period the business can fund.
This is also where anomaly detection in sales data helps. If CAC jumps, payback slows, or contribution margin falls, the dashboard should flag it before a monthly review.
What data sources should feed the dashboard?
A marketing unit economics dashboard needs more than ad data. It needs the systems that prove what happened after the click, lead, call, purchase, or renewal.
Typical sources:
| Source | Data needed |
|---|---|
| Ad platforms | Spend, campaign, ad group, clicks, conversions, conversion value. |
| Web analytics | Source, landing page, conversion path, UTM parameters. |
| CRM | Lead status, owner, qualified status, opportunity, close date, revenue. |
| Ecommerce | Orders, products, refunds, discounts, gross sales, net sales. |
| Billing | Subscription revenue, churn, expansion, failed payments, active customers. |
| Finance | Cost of goods, fulfillment cost, gross margin, payment fees. |
| Sales ops | Sales salaries, commission, call outcomes, booked meetings. |
| Spreadsheets | Manual source maps, offline revenue, partner fees, one-off adjustments. |
The dashboard will fail if source naming is messy. Paid search, google / cpc, Google Ads, PPC, PMAX, and branded search may all refer to related but different rows. Before building charts, create a source map:
| Field | Rule |
|---|---|
| Source group | Paid search, paid social, organic search, email, referral, partner, offline. |
| Campaign name | Channel, audience, offer, region, month, and test ID. |
| Cost owner | Marketing, sales, agency, software, discount, fulfillment. |
| Revenue type | Booked revenue, paid revenue, first order revenue, recurring revenue. |
| Customer key | Email, phone, customer ID, account ID, or CRM contact ID. |
Then decide the grain. Daily source-level data is useful for spend and leads. Monthly cohort data is better for LTV and payback. Trying to force all metrics into the same date grain creates bad math.
Keep a data quality panel inside the dashboard. Show missing UTM rate, unmatched CRM leads, orders without source, contacts without owner, and revenue without customer ID. This is unglamorous, but it prevents fake precision.
If the team already has a business process automation ROI model, reuse its cost discipline. Hidden labor and tool cost matter. The same is true here: if the dashboard ignores sales time or fulfillment cost, the result is not unit economics. It is a media report.
Case study: high ROAS, low margin, wrong scale
Consider a composite ecommerce and subscription SMB. The team had three dashboards: ad platform ROAS, ecommerce sales, and a finance spreadsheet. Each dashboard looked reasonable alone. Together, they told a different story.
Paid social campaign A had strong platform ROAS because it promoted a discounted starter bundle. The first order converted well. But the bundle had low margin, high shipping cost, and low repeat purchase. CAC looked acceptable when only ad spend was counted, but fully loaded CAC and contribution margin showed slow payback.
Paid search campaign B looked weaker in the platform because the first purchase was smaller. But those buyers bought higher-margin items, returned less often, and came back for subscriptions. First-month ROAS was lower, but gross-margin LTV was stronger.
The team built a marketing unit economics dashboard with source, campaign, new customers, CAC, gross-margin LTV, payback period, refund rate, and repeat purchase. The decision changed:
- Campaign A was capped and tested with a smaller discount.
- Campaign B kept budget despite weaker first-order ROAS.
- Retargeting was separated from prospecting so it did not take too much credit.
- Email follow-up was improved because repeat purchase affected LTV.
- Finance reviewed contribution margin monthly, not only revenue.
The result was not a magic chart. It was a better weekly budget conversation. The business stopped asking "which campaign has the biggest ROAS?" and started asking "which campaign creates customers we can profitably keep?"
That is the practical value of this dashboard.
How to calculate the core metrics
The dashboard needs simple formulas that the team can inspect. Start conservative, then refine.
| Metric | Basic formula | Notes |
|---|---|---|
| CAC | Sales and marketing cost / new customers | Use the same period for cost and new customers. |
| Paid CAC | Ad spend / new paid customers | Useful for channel operations, but incomplete. |
| Gross margin | Revenue - direct cost | Include cost of goods, fulfillment, refunds, and fees where possible. |
| Gross-margin LTV | Expected lifetime revenue x gross margin rate | Better than revenue LTV for budget decisions. |
| Subscription LTV | Average revenue per subscriber / churn rate | Use carefully when churn is unstable or cohorts are young. |
| Payback period | CAC / monthly gross profit per customer | Shows how long cash is tied up. |
| ROAS | Conversion value / ad spend | Useful early signal, not full profitability. |
| Contribution margin | Revenue - variable costs - acquisition cost | Good for campaign and cohort decisions. |
For a first version, do not pretend the model is more precise than the data. Label estimates clearly. A young cohort may have projected LTV. A mature cohort may have actual LTV. A lead source may have incomplete cost. The dashboard should show confidence, not hide uncertainty.
One useful pattern is to show three LTV columns:
| Column | Meaning |
|---|---|
| First purchase value | What the customer paid first. |
| 90-day gross-margin value | What the cohort produced after refunds and direct cost. |
| Projected LTV | Expected value based on retention, repeat purchase, or subscription behavior. |
This prevents one common mistake: using lifetime value as a hopeful story. If projected LTV is doing all the work, the dashboard should make that obvious.
What does it cost to build?
The cost depends on data cleanliness, source count, and whether the business needs a spreadsheet, BI dashboard, warehouse, or custom automation. A practical SMB range:
| Setup | Typical cost | Good fit |
|---|---|---|
| Spreadsheet model | $0-$50 per month | Early validation, low data volume, manual review. |
| BI dashboard | $10-$50 per user per month | Teams that need shared reporting and recurring review. |
| Connector and warehouse layer | $20-$300+ per month | Multiple sources, history, scheduled refresh, cleaner joins. |
| Custom dashboard build | $1,500-$8,000 one time | When source cleanup, cohort logic, and automation rules matter. |
| Monthly tuning | 2-8 hours per month | Metric review, source mapping, alerts, and QA. |
The first version should be cheap enough to change. Do not spend months building a perfect warehouse before the team agrees on CAC, LTV, payback, and contribution margin definitions. Build a small model, use it in budget review, then automate the parts that create repeated manual work. To check whether a build pays back, run the numbers through an ROI calculator before committing to a custom project.
Automation is useful after the model is trusted. For example:
- Pull daily ad spend and conversion value.
- Match new customers to source and campaign.
- Update cohort payback each week.
- Alert when CAC rises above target.
- Alert when gross margin falls below threshold.
- Send slow-payback campaigns to review.
- Push source-quality notes into CRM.
Before automating these alerts, use a marketing attribution reconciliation worksheet to confirm that platform conversion value and CRM revenue use the same cohort and definitions. Otherwise, an alert may react to attribution overlap or a late refund instead of a real unit-economics change.
Common mistakes
The most common mistake is treating ROAS as profit. ROAS is ad efficiency. It does not include every cost needed to acquire, convert, fulfill, retain, or support the customer.
The second mistake is using blended averages too early. Blended CAC and blended LTV are useful for board-level reporting, but they hide source problems. Segment by source, campaign, product, and cohort before making budget calls.
The third mistake is ignoring payback. A source can be profitable eventually and still create cash pressure today. Small businesses need to know whether payback is measured in days, weeks, months, or longer.
The fourth mistake is counting leads instead of qualified customers. Lead volume is not a unit economics metric until lead quality, close rate, and revenue are connected.
The fifth mistake is trusting dirty attribution. If many orders, calls, or CRM contacts have missing source data, the dashboard should show that as a data issue. Do not hide the gap behind a clean chart.
The sixth mistake is comparing young and mature cohorts as if they have the same evidence. A new campaign may only have first-order data. An older source may have retention and refund history. Label actuals and projections separately.
The seventh mistake is overbuilding. A small team does not need an enterprise model on day one. It needs a clear marketing unit economics dashboard that turns weekly data into better budget decisions.
FAQ
What is unit economics?
Unit economics is the measurement of revenue and cost at the level of a customer, order, subscription, product, or other value-producing unit. In marketing, it helps answer whether a source or cohort creates profitable customers after acquisition and direct costs.
What should a marketing unit economics dashboard include?
A marketing unit economics dashboard should include CAC, LTV, gross margin, payback, ROAS, contribution margin, source, campaign, customer cohort, data quality, and action owners. The goal is not more charts. The goal is better budget decisions.
How do you calculate CAC?
CAC is generally calculated as sales and marketing cost divided by new customers in the same period. For operating detail, show paid CAC, blended CAC, and fully loaded CAC separately so media efficiency does not get confused with total acquisition cost.
How do you calculate LTV?
LTV estimates the value a customer creates over the relationship. For subscriptions, a simple version uses average revenue per subscriber divided by churn rate. For ecommerce and services, use repeat purchase, average order value, gross margin, refunds, and expected order count.
What is an LTV CAC dashboard?
An LTV CAC dashboard compares customer lifetime value with acquisition cost by source, campaign, product, or cohort. It helps teams see which channels create profitable customers and which channels only look efficient before margin and payback are included.
Why is a ROAS dashboard not enough?
A ROAS dashboard shows conversion value divided by ad spend. It does not show full CAC, gross margin, refunds, sales labor, churn, retention, or cash payback. Use ROAS as one signal inside a broader unit economics view.
Answer clarity notes
- Dates: source links reflect the cited source or publication context; check current vendor pricing, platform rules, and regulations before acting.
- Scope: this article is for US SMB operating decisions, not legal, financial, medical, tax, or platform-policy advice.
- Evidence: public sources support linked statistics; That'sGonnaHelp examples are operator composites unless a named public customer is cited.
- Do not infer: cost ranges, ROI examples, timelines, and tool capabilities are planning guidance, not guarantees.