Marketing Dashboard: How to Check in 5 Minutes Whether Marketing Actually Makes Money

Why Rising Sales Can Mean Falling Profit

Picture an online store that spends $10 on advertising to sell a hoodie for $25. At first glance it looks great — the ad is "working," the product is selling. The problem is that the hoodie itself cost $17.50 to buy. Subtract the product cost and the ad cost and you get: 25 – 17.50 – 10 = a $2.50 loss on every unit sold. The more of these sales happen, the more the company loses — even though every single report from the ad platform shows "success."

This isn't a made-up example — it's one of the most common mistakes you'll see in companies that look only at revenue and ROAS in the Meta or Google dashboard, without checking what's actually left in the company's account after subtracting every cost. A 30% sales increase sounds great in a meeting, but without answering "how much of that was left after costs?" that number says nothing about the health of the business.

Three Numbers You Need to See on One Screen

To answer the question "is marketing actually making money," one metric isn't enough. You need three views at the same time, because each shows a different dimension of the truth:

Net profit per channel (not revenue). Not "how many sales did Google Ads generate," but how much profit was left after subtracting product cost, returns, order fulfillment costs, and the ad spend itself. This is exactly the difference between ROAS and POAS, which we covered in our article on Google Ads and Meta Ads budgets — a 4x ROAS can mean profit or loss depending on your product margin.

Customer acquisition cost broken down by segment. An average CAC for the whole company masks huge differences between channels and customer groups. A customer acquired through a branded Google campaign might cost $5, while one from a broad Meta campaign could cost $35. Without segmentation, you don't know where you're actually burning budget.

Customer value over time (LTV cohorts). A single transaction rarely tells the whole story. A customer who cost $35 to acquire but comes back every month for a year is far more valuable than a $5 customer who buys once and disappears. Tracking LTV in cohorts (e.g., customer value at 30, 90, and 365 days after the first purchase) shows whether an expensive acquisition channel is actually a bad deal, or just looks more expensive at first glance.

These three views together, not separately, answer the question in this article's title. Any single metric — ROAS alone, CAC alone, revenue alone — can always be misread in isolation from the other two.

How to Check This Without a Ready-Made Dashboard

If you don't have a dashboard built yet, you can do an approximate version of this test manually:

• Pull a report from your ad platform (Meta Ads Manager or Google Ads) for the last 30 days and note revenue and spend per channel.
• For each channel, subtract from revenue: the product cost (COGS) of units sold, an estimated cost of returns, and the ad spend itself. What's left is an approximate net profit — not ROAS.
• Divide ad spend by the number of new customers (not transactions — customers) separately for each channel, to see the real CAC per segment.
• If you have access to purchase history, check how many customers on average return and buy again within the first 90 days of their first purchase — that's your approximate LTV indicator.

This manual process takes more than 5 minutes the first time around, but once you've built the spreadsheet you can update it on a regular cycle. You only get the real 5 minutes once these three views are automated and sitting ready on one screen, instead of requiring manual recalculation every time.

Warning Signs That Are Easy to Miss

A few situations where "good" numbers at first glance mask a real problem:

• High ROAS with a low product margin. The lower the margin, the higher the ROAS needed for a campaign to be profitable at all — the same 3x ROAS is great at a 60% margin and a loss at a 15% margin.
• Promotions that boost sales while lowering profit. Discounts and sales increase transaction volume, but if margin drops faster than volume rises, the company sells more and earns less — exactly like the example in section 1.
• CAC rising faster than LTV. If customer acquisition cost keeps climbing month over month while customer value over time doesn't keep pace, the channel is losing profitability even if the number of new customers keeps growing.
• No distinction between new and returning customers in campaign reports. Remarketing campaigns look great partly because they "sell" to customers who would have come back anyway — without separating these two groups, it's easy to overstate a campaign's real contribution to growth.

When a Spreadsheet Is No Longer Enough

Manual calculations in Excel work fine as long as you have one sales channel and a handful of campaigns. It becomes a problem when you need answers faster than once a month, you're running several channels at once (Google, Meta, TikTok), or your sales data lives in a different system than your ad data, requiring manual spreadsheet merging every time. That's the point where a centralized panel connecting ad account, store, and CRM data in one place stops being a convenience and becomes a necessity — exactly what we cover on the Dashboards page. If your data foundation (conversion tracking, signal quality) is already shaky, it's worth starting with what we described in our piece on GA4 implementations — no dashboard can show the truth without clean data, no matter how nice it looks.

FAQ