Find Google Ads waste

Use the StoreHero MCP to do the following analysis. Always anchor the answer in real StoreHero data, not platform-reported metrics.

Find Google Ads waste over the last 30 days. Anchor everything in real blended performance — pull blended CPA, new customer acquisition cost (nCAC), and new customer contribution margin as the ground truth. Then identify Google spend that isn't paying back when measured against StoreHero data, not Google-reported ROAS.

Look for:

1. Search terms — high-impression, zero or low-conversion queries that don't match buyer intent. Show wasted spend per term and recommend phrase or exact negative additions, at account or campaign level
2. Broad-match bleed — broad-match keywords matching to irrelevant queries, with the wasted spend total
3. Shopping/PMax SKUs — products taking spend but with StoreHero contribution margin per acquired customer below nCAC threshold
4. Branded vs. non-branded leak — brand campaigns inflating reported ROAS while non-brand quietly underperforms blended targets
5. Campaign-level — campaigns spending >$500/week with blended CPA above nCAC ceiling, with min 20 conversions for significance
6. Display/Search Partners — opt-in expansions that look profitable on Google's view but fail vs. StoreHero blended

For each waste source: $ wasted last 30 days, projected $ saved if action taken, and the exact action (negative keyword list, exclusion, bid cap, campaign pause, SKU exclusion).

End with a single number: total $ wasted last 30 days that could be recovered with this week's actions.

At the bottom of your answer, render an inline visual summary: a single big KPI card showing total recoverable $ over 30d, plus a horizontal bar chart of waste sources ranked by $ impact, colour-coded by ease-of-fix. Place text commentary alongside the visuals. Use the Spend Advisor tool to suggest what to explore next.