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

Why Rising Sales Can Mean Falling Profit

Illustrative example: an online store 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."

The numbers are a model example, but the mistake itself is one of the most common 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. Sales growth sounds great in a meeting, but without answering "how much of that was left after costs?" it 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). You count how much profit was left after subtracting product cost, returns, order fulfillment costs, and the ad spend itself. Sales from Google Ads alone do not answer that question. This is exactly the difference between ROAS and POAS (Profit on Ad Spend: profit after product cost, returns and fulfillment, divided by ad spend), 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. Illustrative example: a customer acquired through a branded Google campaign costs $5, while one from a broad Meta campaign costs $35. Without segmentation, you don't know where you're 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. In GA4, the starting point is cohort exploration, and revenue per customer since the first visit shows up in the user lifetime exploration.

Only these three views together answer the question in this article's title. Any single metric (ROAS alone, CAC alone or 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.
• Divide ad spend by the number of new customers (customers, not transactions) separately for each channel, to see the 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.

Working through these steps by hand takes longer the first time, because you build the spreadsheet from scratch, but after that you can update it on a regular cycle. The 5-minute check from the title comes from a dashboard where these three views are automated and sitting ready on one screen.

Warning Signs That Are Easy to Miss

A few situations where "good" numbers at first glance mask a 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 hoodie in the first section.
• 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 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 (you can import non-Google campaign costs into GA4, but product cost and returns still have to be counted separately). That's the point where a centralized panel connecting ad account, store, and CRM data in one place becomes a necessity; we cover it on the Dashboards page. If your data foundation (conversion tracking, signal quality) is shaky, start with the GA4 audit, which shows what your site actually measures, and 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