ClickCatalyst
Back to Margin Erosion Audit
Audit Guide · 21 sections · 5 pages · Scroll to explore

How to Read Your Margin Erosion Report

Your audit breaks the ROAS illusion by comparing reported revenue against actual profit after ad costs and COGS. This guide explains every metric and the exact actions to take. The PDF skeleton on the right highlights where you are.

Page 1The Profit Illusion
S1

The Four Headline KPIs

Page 1 — revenue does not equal profit

These KPIs break the ROAS illusion. Your dashboard says 4x ROAS — but after subtracting the actual cost of goods sold and advertising spend, the profit number tells a different story. If true profit after ads is negative, your account is a cash incinerator disguised as a revenue generator.

Gross Revenue

Total conversion value reported by Google Ads over the reporting period. This is the top-line number everyone celebrates. It tells you nothing about profitability.

True Profit After Ads

The Real Number

Gross profit (from Shopping feed COGS data) minus total ad spend. This is what actually hits your bank account. When this number is negative, every sale costs you more than you earn — regardless of what the ROAS says.

If negative, the entire account is unprofitable. Stop scaling and read the rest of this audit to find where margin is being destroyed.

Profit Margin %

True profit after ads as a percentage of gross revenue. This is the real margin — not the gross margin from your P&L, but the margin after Google takes its cut. A 4x ROAS with a 10% gross margin can still produce a negative profit margin after ad costs.

has_cogs_data flag

Data Quality

Indicates whether your Shopping feed includes cost_of_goods_sold. If false, the audit uses revenue minus ad spend as a proxy (contribution margin) — accurate for cost structure but missing COGS. Product-level margin analysis requires COGS data in your Merchant Center feed.

If has_cogs_data is false, add cost_price or cost_of_goods_sold to your product feed. Without it, the audit cannot calculate true product-level profitability.

S2

Revenue vs Profit Waterfall

Page 1 — see exactly where margin disappears

A waterfall chart with four steps: Gross Revenue (starting point) → minus Ad Spend → minus COGS (from Shopping feed) → Net Profit After Ads (what remains). The widest single drop between steps is the most urgent lever — that is where profit disappears.

Ad Spend > COGS

Ads Eating Margin

You're spending more on advertising than your products cost to produce. Google is a larger expense than your supplier. This is the clearest signal that bids need to be pulled back to protect margin.

Set target ROAS above your break-even point (see Break-Even ROAS table below). The algorithm doesn't know your COGS — you have to encode your margin requirement into the target.

COGS > Ad Spend

Normal Structure

Product costs exceed ad costs — a healthy cost structure for most ecommerce businesses. Margin erosion, if present, comes from the ad spend slice growing faster than revenue.

S3

ROAS vs Margin Comparison

Page 1 — the campaigns where ROAS lies

Each campaign's ROAS alongside its contribution margin (revenue minus ad spend). The ILLUSION status flags campaigns where ROAS exceeds 3x but contribution margin is negative — mathematically possible when low-margin products have high conversion values but the ad cost exceeds the thin margin.

ILLUSION: High ROAS, Negative Margin

Deceptive Metric

This campaign generates revenue at a strong multiple of ad spend, but the underlying product margins are so thin that ad costs still exceed gross profit. ROAS says 'scale this' — margin says 'you lose money on every sale.'

Do not scale based on ROAS alone. Calculate break-even ROAS for this campaign's product mix and set that as the target minimum.

Loss-Making (ROAS < 1.0)

Obvious Loss

Spending more than the revenue generated. No illusion needed — this campaign loses money on every metric.

Pause or dramatically reduce budget unless this campaign serves a non-revenue purpose (brand awareness, remarketing seed).

S4

Break-Even ROAS by Category

Page 1 — the minimum ROAS you need to not lose money

For each product category with COGS data, this table calculates the exact break-even ROAS: 1 divided by the gross margin rate. A category with 40% gross margin needs a minimum 2.5x ROAS to break even. The ROAS buffer column shows how much headroom you have — negative buffer means you're underwater.

LOSS: Below break-even ROAS

Losing on Every Sale

Current ROAS is below the break-even threshold for this category. Every conversion in this category costs more in ad spend than the gross profit it generates. You are paying Google more than you earn from the sale.

Either increase the target ROAS for campaigns selling these products to the break-even level, or exclude this category from ad campaigns entirely and sell through organic channels.

MARGINAL: Within 20% of break-even

Fragile

ROAS is slightly above break-even — a small CPC increase or conversion rate dip would push this category into loss. There is no margin for error.

Set a monitoring alert. If CPA for this category rises by more than 10%, trigger a budget review immediately.

Page 2Product Margin Leakage
S5

Margin Destroyer Products

Page 2 — products selling at a loss after ad costs

Products that convert (they sell!) but where ad spend exceeds gross profit — meaning you lose money on every sale. Different from zombie products (which don't sell at all). These are more dangerous because they look like winners in the Ads dashboard.

Negative net profit after ads

Loss Per Sale

Every unit sold costs more to advertise than the gross profit it generates. The algorithm will continue scaling these products because it optimizes for conversion volume, not profitability — it has no visibility into your COGS.

Either set a minimum ROAS target above break-even for campaigns containing these products, exclude them from paid advertising and sell through organic channels, or negotiate lower COGS with your supplier.

S6

Top Profitable Products

Page 2 — your actual margin generators

Products where gross profit after ad spend is highest — your actual profit drivers. These products have proven they can absorb advertising costs and still generate positive returns. Every incremental dollar spent here is more likely to generate real profit.

High net profit + strong ROAS

Scale These

These products deliver both revenue and profit. They are your account's foundation. If any of these lose budget to margin destroyers, the entire account's profitability suffers.

Ensure these products are in their own asset group or campaign with dedicated budget. Protect them from being outbid by loss-making products in the same campaign.

S7

Category Profitability

Page 2 — which product categories make vs lose money

Net profit (gross profit minus ad spend) aggregated by product category. Categories with negative net profit are systematically unprofitable — not just individual bad products, but entire product lines where advertising destroys margin at the category level.

Negative bars

Category-Level Loss

This entire product category loses money after ad costs. Even if individual products within it convert, the category as a whole is a net negative. The problem is structural — margin rates in this category cannot support advertising costs.

Reduce or eliminate ad spend on this category. Redirect budget to profitable categories. These products may sell better through SEO, email, or marketplace channels where customer acquisition cost is lower.

S8

Revenue vs Profit Leaders

Page 2 — the products that trick you

Two lists side by side: Top Revenue products and Top Profit products. When these lists don't overlap, your account is optimizing for the wrong metric. A product generating high revenue with thin margins and heavy ad spend may rank #1 in revenue but not appear in the profit top 5 at all.

Products in revenue top 5 but not profit top 5

Revenue ≠ Profit

These products look great in the dashboard but generate less actual profit than products with lower revenue but better margins. The algorithm will push budget toward these because it sees revenue, not margin.

Adjust bidding strategy to account for margin differences. Set higher target ROAS for low-margin, high-revenue products to force the algorithm to be more selective about which clicks to buy.

Page 3Campaign-Level Truth
S9

Campaign True Profitability

Page 3 — contribution margin by campaign

Each campaign's revenue minus ad spend (contribution margin) ranked from worst to best. This strips the ROAS illusion and shows the raw dollar amount each campaign contributes to or subtracts from your bottom line. Negative contribution margin = the campaign costs more than it returns.

Negative contribution margin

Cash Drain

This campaign's ad spend exceeds its revenue. Without even accounting for COGS, the campaign is unprofitable. With COGS factored in, the loss is even worse.

Campaigns at the bottom of this table are the first candidates for the Kill List on page 5. Review each one before the end of the week.

S10

Break-Even Tier Analysis

Page 3 — how many campaigns are above vs below break-even

All campaigns bucketed into four tiers: Profitable (>1.5x ROAS), Above Break-Even (1–1.5x), Below Break-Even (0.5–1x), and Significant Loss (<0.5x). The campaign count and total spend per tier reveals whether unprofitability is isolated or systemic.

Significant Loss tier consuming > 20% of spend

Systemic Problem

More than a fifth of your total budget goes to campaigns that return less than half their cost. This isn't a few bad keywords — it's a structural allocation problem where the algorithm funnels significant budget to loss-making campaigns.

Start with the Kill List on page 5. Simultaneously, review whether your target ROAS or tCPA settings are set too loosely for these campaigns.

S11

Spend Efficiency Gap (SCALE vs CUT)

Page 3 — which campaigns deserve more vs less budget

Each campaign's ROAS compared to the account average. The ROAS gap column shows how far above or below average each campaign sits. SCALE campaigns outperform by 30%+. CUT campaigns underperform by 30%+. The gap quantifies how much better your money would work if reallocated.

SCALE action

ROAS > 1.3x avg

This campaign generates significantly more return per dollar than the account average. Budget moved here from CUT campaigns improves overall profitability without increasing total spend.

CUT / REALLOCATE action

ROAS < 0.7x avg

This campaign drags the account average down. Budget here earns 30%+ less than it would in a SCALE campaign. Reallocating is a zero-cost profitability improvement.

Reduce budget by 30–50% over 2 weeks. Redirect to campaigns marked SCALE in this table.

S12

Budget Concentration Risk

Page 3 — is too much riding on too few campaigns?

Each campaign's spend share as a percentage of total budget. If one campaign accounts for 40%+ of spend, your profit depends almost entirely on that campaign's continued performance — a fragile position.

Top campaign > 40% of spend

Fragility Risk

If this campaign's ROAS declines by 20%, your account-level profitability would shift dramatically. Concentration amplifies both gains and losses.

Build alternative campaigns to diversify. Even if the top campaign is your best performer, dependency is a risk.

Page 4Stability & Trend
S13

Daily Profit Trend

Page 4 — is profit improving or deteriorating?

Two lines: daily revenue and daily ad spend. The gap between them is your daily contribution. A narrowing gap means margin is being squeezed in real time — even if both lines are rising, the profit between them is shrinking.

Lines converging

Margin Squeeze

Ad spend is growing faster than revenue. Each day, you earn less profit per dollar of revenue. This pattern compounds — left unchecked, the lines will cross and the account becomes unprofitable.

Identify which campaigns increased spend without proportional revenue increase. Those campaigns drove the convergence.

S14

ROAS Efficiency Curve

Page 4 — is ROAS declining despite stable spend?

Daily ROAS plotted over time alongside daily spend. A declining ROAS trend despite stable spend is evidence of margin erosion the account dashboard won't surface — the same budget buys progressively less return.

Declining ROAS with stable spend

Diminishing Returns

You're spending the same amount but getting less back. Causes include: audience saturation (the best prospects already converted), creative fatigue (CTR declining), competitive pressure (CPCs rising), or seasonal demand shifts.

Refresh creatives, expand keyword targets, and review whether new competitors have entered your auctions. Check auction insights for rising competitor impression share.

S15

Margin Velocity (Weekly)

Page 4 — margin direction at the pace that matters

Weekly contribution margin (revenue - ad spend) alongside margin percentage. When both lines decline, the problem is absolute. When margin drops but margin_pct is stable, the problem is a revenue mix shift — selling lower-margin products at higher volume.

Margin declining, margin % stable

Revenue Mix Shift

Your margin rate hasn't changed — the algorithm is selling lower-margin products at higher volume. The per-sale profit is the same, but the product mix has shifted toward cheaper items that generate less total profit.

Review which product categories grew in volume. Set differentiated ROAS targets by category to steer the algorithm toward higher-margin products.

S16

GA4 Revenue Validation

Page 4 — does GA4 confirm what Ads reports?

Campaign-level comparison of Ads-reported revenue vs GA4-recorded revenue. The gap percentage reveals phantom revenue — conversions Ads claims that GA4 doesn't confirm. True ROAS (using GA4 revenue) may be dramatically lower than Ads-reported ROAS.

Large gap (Ads ROAS >> True ROAS)

Phantom Revenue

Google Ads reports significantly more revenue than GA4 confirms. Your profit calculations based on Ads data are over-optimistic. Margin erosion is worse than the Ads dashboard suggests.

Use GA4 revenue as the source of truth for all profitability decisions. Ads-reported ROAS should only be used for relative campaign comparisons, not absolute profit calculations.

Page 5Decisions
S17

Kill List (Pause These Campaigns)

Page 5 — campaigns that should be paused this week

Campaigns where revenue minus spend is negative AND they consume more than 2% of total account spend. These aren't low-spend experiments — they're meaningful budget allocations producing guaranteed losses. The loss column shows exactly how much you save by pausing.

Loss column

Guaranteed Savings

The absolute dollar amount this campaign loses every reporting period. Pausing it recovers this exact amount — not a projection, not a model, just money that stops leaving your account.

Pause these campaigns within the week. If they serve non-revenue purposes (remarketing seed, brand awareness), move them to a separate budget with non-ROAS objectives.

S18

Scale List (Push Budget Here)

Page 5 — campaigns that deserve more investment

Campaigns with positive profit AND ROAS above the account average. Budget redirected here from the Kill List generates above-average returns. Each row shows spend, profit, and ROAS so you can prioritize which campaigns get more budget first.

High profit + high ROAS

First Priority

These campaigns are already profitable at current spend. Increasing budget here is the safest reallocation available — you're adding fuel to a proven engine.

Increase daily budget by the amount freed from Kill List campaigns. Distribute proportionally based on each Scale campaign's ROAS rank.

S19

Bidding Strategy vs Break-Even ROAS

Page 5 — are your ROAS targets set above or below profitability

For campaigns with Shopping data (COGS), this table compares the bidding strategy's target ROAS against the actual break-even ROAS calculated from gross margin. If your target ROAS is set below break-even, you are explicitly telling the algorithm that unprofitable conversions are acceptable.

RISK — Target ROAS below breakeven

Structurally Unprofitable

Your bidding target is set lower than the minimum ROAS needed to break even after COGS. The algorithm is performing exactly as instructed — hitting your target — but every conversion at that target is a loss.

Increase target ROAS to at least 10% above the break-even ROAS for this campaign's product mix. Build in a margin buffer — break-even is not a target, it's a floor.

LOSS — Actual ROAS below breakeven

Missing Even the Floor

The algorithm isn't even hitting break-even, regardless of what the target is set to. Signal quality or creative quality may be so poor that the algorithm cannot achieve the minimum viable ROAS.

Fix signal quality and creative assets first. A target ROAS increase without fixing the underlying constraints will just reduce volume to near-zero.

S20

Budget Reallocation Plan

Page 5 — the specific money moves to make

Each campaign shows the suggested budget to cut (for underperformers) or add (for outperformers). The cut amount is capped at 50% of current spend — aggressive enough to be meaningful, conservative enough to avoid algorithm learning resets. The add amount is similarly proportional to the performance gap.

Suggested budget to cut

Calculated as current spend multiplied by the performance gap ratio (how far below average ROAS the campaign sits), capped at 50%. A campaign with ROAS 50% below average gets a 50% budget cut recommendation.

Implement cuts over 2 weeks (25% per week) to prevent sudden algorithm re-learning. Redirect freed budget to campaigns with 'suggested budget to add' in the same table.

S21

Account Risk Summary

Page 5 — the three structural risks threatening your margin

Three risk categories quantified as a percentage: High Budget Concentration (dependency on one campaign), Unprofitable Campaign Spend (budget flowing to loss-makers), and Volatility Risk (how erratic profit is day-to-day). Together, these frame the structural challenges beyond individual campaign fixes.

High Budget Concentration

How much of total spend is concentrated in the top campaign. High concentration amplifies every other risk — if that campaign degrades, there's no backup.

Volatility Risk

The coefficient of variation of daily profit. High volatility means profitability swings wildly — making forecasting impossible and increasing the chance of unexpected loss days.

Investigate what causes the swings: day-of-week effects, promotion cycles, or algorithm bid oscillations. Stabilize with ad schedules and budget caps.

How to Read Your Margin Erosion Audit — ClickCatalyst Interpretation Guide