ClickCatalyst
Back to Shopping Waste Audit
Audit Guide · 14 sections · 4 pages · Scroll to explore

How to Read Your Shopping Waste Report

Your audit reveals product-level waste across your Shopping campaigns — zombies, margin eaters, feed gaps, and category inefficiency. This guide explains every metric and the exact actions to take. The PDF skeleton on the right highlights where you are.

Page 1Shopping Health
S1

The Four Headline KPIs

Page 1 — the health of your Shopping account

These KPIs give you the top-line Shopping picture: total spend, overall ROAS, zombie count, and total active products. The zombie count relative to total products tells you whether the waste problem is isolated or systemic — 10 zombies out of 5,000 products is manageable; 200 out of 500 is a crisis.

Shopping ROAS

Total Shopping revenue divided by total Shopping spend. This is the blended number — it includes both your best-performing products and your worst zombies. The product-level analysis on page 2 breaks this apart to show where the ROAS is real and where it's propped up.

Zombie Count

Zero-Sale Products

Products with 20+ clicks, zero units sold, and cost above the currency-adaptive threshold (avg CPC × 20). Each zombie is a product the algorithm continues to fund despite zero historical sales — consuming budget that could go to proven converters.

If zombies exceed 10% of total products, this is a structural problem requiring immediate exclusions.

S2

Product Performance Distribution

Page 1 — how your catalog breaks down

All products classified into four tiers: Converting (has sales), Zombie (20+ clicks, zero sales), Untested (< 5 clicks), and Low Activity. A catalog skewed toward non-converting products signals a structural feed problem, not just a bidding problem.

Zombie + Low Activity > Converting

Catalog Imbalance

More products fail than succeed. The algorithm spreads budget across many non-performing products instead of concentrating on proven winners. This is a structural issue requiring product-level exclusions and feed optimization.

Implement the exclusion list on page 4. Then review your product feed for missing attributes that prevent products from finding the right audiences.

S3

Revenue Concentration (Top Products)

Page 1 — are a few products carrying the entire account?

The top 10 revenue-generating products with their share of total Shopping revenue. Extreme concentration means a single stock-out or price change can collapse the entire account's performance. Healthy accounts have revenue distributed across at least 20–30 products.

Top 3 products > 60% of revenue

Fragility Risk

Three products generate most of your Shopping revenue. If any goes out of stock, gets a price increase, or faces new competition, your account performance drops dramatically overnight.

Diversify by ensuring mid-tier products get sufficient impression share. Review listing group structure to prevent top products from absorbing all budget.

S4

Shopping Spend vs Revenue Trend

Page 1 — is efficiency improving or declining?

Daily Shopping spend and revenue plotted together. A spend line rising faster than revenue means ROAS is quietly deteriorating even if absolute numbers look healthy. The gap between the lines is your daily margin — watch whether it's widening (improving) or narrowing (eroding).

Spend rising faster than revenue

ROAS Erosion

Each day, you spend more to generate the same revenue. CPCs may be rising from competition, or the algorithm is increasingly bidding on lower-converting products as it exhausts high-intent audiences.

Review product-level CPC trends and competitive dynamics. Check whether new competitors entered your key product categories.

Page 2Product-Level Waste
S5

Zombie Products (Highest Wasted Cost)

Page 2 — the products burning your budget

Zombie products ranked by wasted cost — the absolute dollar amount consumed with zero sales. Sort by cost, not clicks. A product with 30 clicks at $5 CPC wastes $150. A product with 100 clicks at $0.50 CPC wastes only $50. Dollar impact is what matters.

Products at the top of this list

Exclude First

Each product you exclude at the top recovers more budget than excluding ten products at the bottom. Work top-down.

Exclude via listing group exclusions in your Shopping or PMax campaigns. Do not pause the entire campaign — surgically remove zombie SKUs.

S6

Margin Eaters (Net Profit Negative)

Page 2 — products that sell but lose money

Products with conversions but negative net profit after ads (gross profit minus ad spend < 0). These are worse than zombies from a business perspective — they look like winners in the dashboard while actively eroding your margin on every sale.

High ad spend, low gross profit

Margin Destruction

The algorithm bid this product up because it converts, but the product's margin is too thin to absorb the ad cost. You lose money on every sale — and the algorithm will keep scaling it because it doesn't see COGS.

Set a minimum ROAS target above break-even for this product's category, or exclude it from paid channels and sell through organic/email.

S7

High Click, Low Convert Products

Page 2 — products getting traffic but not converting

Products with 50+ clicks but a conversion rate below 0.5%. These products attract interest (clicks) but fail to close sales. The problem may be pricing, product page quality, reviews, shipping cost, or stock availability — not necessarily advertising targeting.

CVR < 0.5% with 50+ clicks

Conversion Problem

The product attracts relevant traffic but doesn't convert. This is typically a product page issue (bad images, unclear pricing, missing reviews) or a pricing competitiveness problem, not an ad targeting failure.

Review the product page: images, price vs competitors, review count, and shipping cost visibility. Fix the page before adjusting ad strategy.

Page 3Feed & Structure
S8

Feed Health Summary

Page 3 — is your product data helping or hurting?

A structural health check: total products, missing categories, missing brands, converting product count, and conversion coverage percentage. Products missing key attributes are invisible to Google's product taxonomy — the algorithm can't match them to relevant shopping queries.

Conversion Coverage < 20%

Structural Problem

Fewer than 20% of your products with traffic have ever converted. A small number of products carry all conversion weight while the rest consume budget. This indicates either a feed quality issue or a catalog that is too broad for your ad budget.

Focus ad spend on your proven converting products. Exclude products with zero conversions and 20+ clicks until feed quality improves.

Missing Brand or Category

Feed Gap

Products without brand or category attributes get lower Shopping placement quality. Google can't match them to relevant queries.

Update your Merchant Center feed — this is a feed management fix, not a Google Ads fix.

S9

Your Performance vs Industry Benchmarks

Page 3 — are your metrics normal or outliers?

Your average CPC and CTR compared to Google's Shopping benchmark data (benchmark_average_max_cpc and benchmark_ctr from the Google Ads API). This contextualizes your performance — a 2% CTR might seem low, but if the benchmark is 1.5%, you're actually outperforming.

Your CPC >> benchmark CPC

Over-Bidding

You're paying significantly more per click than the market average. This could indicate aggressive bidding strategies, high-competition product categories, or poor ad/landing page quality driving up CPCs through low Quality Score equivalents.

Review bidding strategy. If using tROAS, your target may be forcing the algorithm to overbid. If using manual bids, benchmark data suggests room to reduce.

Your CTR < benchmark CTR

Creative Issue

Your products get shown but clicked less than average. Product images, titles, prices, or review ratings may be less compelling than competitors.

Audit product titles (include key attributes buyers search for), images (use high-quality lifestyle images), and pricing competitiveness.

S10

GA4 Cross-Reference: Zombie Abandonment

Page 3 — do zombies also fail in your analytics?

Zombie products cross-referenced with GA4 ecommerce data: page views, cart adds, and purchases. If GA4 also shows zero purchases, the zombie classification is confirmed across both platforms — no attribution gap is creating false zombies.

GA4 purchases = 0

Confirmed Dead

Both platforms agree: this product gets traffic but never sells. There is no hidden conversion path justifying continued spend.

Exclude with confidence.

Cart adds > 0 but purchases = 0

Checkout Friction

Users add to cart but don't complete purchase. The product has demand but fails at checkout — investigate pricing, shipping costs, or checkout UX before excluding.

Check if the issue is product-specific (only this SKU) or site-wide (all products drop off at checkout).

Page 4Decision
S11

Products to Exclude (Priority Ranked)

Page 4 — the exact SKUs to remove from ads

Every zombie product with product ID, category, wasted cost, click count, action (EXCLUDE), and priority tier (HIGH/MEDIUM/LOW based on cost relative to the account's dynamic threshold). HIGH priority products should be excluded today. MEDIUM within the week. LOW can be monitored.

HIGH PRIORITY

Cost > 4x threshold

This product has spent more than 4x the zombie cost floor — far beyond the statistical minimum needed to confirm it doesn't sell. Every additional day of spend is pure waste.

Exclude immediately via listing group exclusions.

S12

Products to Boost (Profitable Winners)

Page 4 — where should recovered budget go?

Products with positive net profit (gross profit > ad spend) and 2+ conversions — proven profitable sellers. Budget recovered from zombie exclusions should flow here first. Each product shows spend, net profit, ROAS, and the action: BOOST BID.

High net profit + strong ROAS

Scale These

These products make money after ad costs. More impressions = more sales = more profit. They are the foundation your Shopping strategy should be built around.

Increase bid adjustments for these products or give them dedicated budget through listing group priority.

S13

Category vs Account ROAS Benchmark

Page 4 — which categories earn their budget

Each category's ROAS compared to the account average with a BOOST/MAINTAIN/CUT verdict. Categories 30%+ above average should receive more budget. Categories 30%+ below should be reduced. This turns individual product decisions into strategic category-level budget moves.

BOOST — Above average ROAS

> 1.3x avg

This category outperforms. Budget moved here from CUT categories improves overall ROAS without increasing total spend.

CUT — Below average ROAS

< 0.7x avg

This category structurally underperforms. Reducing its budget and redirecting to BOOST categories is a zero-cost efficiency gain.

Reduce budget allocation for this category in your listing group structure.

S14

Shopping Recovery Summary

Page 4 — the bottom line on what you can recover

A single-row synthesis: total spend, wasted spend, waste percentage, account ROAS, projected recovery value (wasted spend × account ROAS = what that budget would generate if redirected to converting products), and a severity verdict.

Projected Recovery Value

Business Case

If zombie budget were redeployed at your current account ROAS, this is the additional revenue it would generate. The waste doesn't disappear — it transforms into revenue by funding products that actually sell.

Present this number to stakeholders: 'We currently waste $X on products that never sell. Redirecting this to our proven winners would generate $Y in additional revenue at our current ROAS.'

CRITICAL WASTE (> 40%)

Structural Crisis

More than 40% of Shopping spend goes to products that don't sell. This is beyond optimization — it's a catalog strategy problem requiring product feed restructuring, listing group redesign, and potentially product line decisions.

How to Read Your Shopping Waste Audit — ClickCatalyst Interpretation Guide