Systematic analysis of Google Ads and Meta advertising spend to identify wasted budget. Produces actionable exclusion lists with thematic categorization and statistical validation. Use when onboarding new accounts, performing monthly hygiene, or preparing for budget optimization.
インストールする前に、エージェントに与えられる指示の中身を確認できます。
Identify and categorize wasted ad spend across Google Ads and Meta platforms. Produces uploadable exclusion lists with thematic categorization.
git clone https://github.com/thatrebeccarae/claude-marketing.git && cp -r claude-marketing/skills/wasted-spend-finder ~/.claude/skills/
Waste threshold = Average CPA x Multiplier
Multiplier by campaign type:
- Search (branded): 2x CPA
- Search (non-brand): 3x CPA
- Display: 3x CPA
- Meta (all): 2.5x CPA
A search term, placement, or audience segment is flagged as waste when:
| Campaign Type | Min Clicks Before Flagging |
|---|---|
| Search (branded) | 50 |
| Search (non-brand) | 25 |
| Display / GDN | 15 |
| YouTube | 20 |
| Meta Feed | 20 |
| Meta Stories | 15 |
| Meta Audience Network | 10 |
Flag keywords/placements performing below these floors:
| Campaign Type | Min Conversion Rate |
|---|---|
| Search (branded) | 8% |
| Search (non-brand) | 1.5% |
| Display | 0.3% |
| YouTube | 0.2% |
| Meta Feed | 0.5% |
| Meta Stories | 0.3% |
Classify wasted search terms into themes for organized exclusion:
| Theme | Pattern | Match Type |
|---|---|---|
| Competitor terms | Brand names, product names | Exact / Phrase |
| Informational intent | how to, what is, tutorial, guide, definition | Phrase |
| Wrong product/service | Related but non-target products | Phrase / Exact |
| Geographic irrelevance | Wrong cities, states, countries | Exact |
| Job/career searches | jobs, salary, hiring, career, resume | Phrase |
| Free/cheap intent | free, cheap, discount, coupon, deal | Phrase |
| Irrelevant modifiers | DIY, homemade, kids, old, used | Phrase |
Pull data for the analysis period (typically 30-90 days):
Google Ads:
Meta Ads:
Calculate waste threshold per campaign using the formula above. Flag items exceeding thresholds.
Assign each flagged item to a theme category. Group for batch exclusion.
Output CSV files ready for upload:
negative-keywords.csv — with match type and campaign/ad group scopeplacement-exclusions.csv — with reason and spend wastedaudience-exclusions.csv — with segment details and waste amountFor GAQL query patterns and CSV formats, see REFERENCE.md.
まだレビューはありません。使ってみた感想をお寄せください。
概要と使いどころ
A/B and multivariate testing methodology. Design experiments, calculate sample sizes, determine statistical significance, avoid common pitfalls, and interpret results. Platform-agnostic framework applicable to landing pages, emails, ads, pricing, and product features. Use when the user asks about A/B testing, split testing, experiment design, statistical significance, or conversion experiments.
日本語の概要は準備中です。原文の説明を表示しています。
Google and Meta paid media account structure evaluation. Audits campaign/ad set architecture against conversion volume minimums, budget thresholds, and targeting overlap. Identifies over-segmentation, under-segmentation, budget fragmentation, and structural anti-patterns blocking algorithmic learning. Provides consolidation roadmaps with migration plans. Use when inheriting accounts, quarterly health checks, or before scaling budgets.
日本語の概要は準備中です。原文の説明を表示しています。
Answer Engine Optimization (AEO) and Generative Engine Optimization (GEO) specialist. Optimize content and websites to appear in AI-generated answers from ChatGPT, Perplexity, Claude, Google AI Overviews, and other LLM-powered search experiences. Use when the user asks about AI search optimization, AEO, GEO, AI Overviews, appearing in AI answers, LLM citations, or optimizing for generative search.
日本語の概要は準備中です。原文の説明を表示しています。
Extract brand identity from a website URL — voice, colors, typography, imagery, values, and target audience — into a structured brand-profile.json. The profile feeds downstream skills (seo-content-writer, email-composer, frontend-design, pro-deck-builder, cross-platform-audit) for brand-consistent output. Use when the user says brand DNA, brand profile, extract brand, analyze brand, brand voice, brand identity, brand colors, or brand style guide.
日本語の概要は準備中です。原文の説明を表示しています。
Develop brand voice, tone matrices, messaging frameworks, and brand book documentation. Use when the user asks about brand voice, tone of voice, brand guidelines, messaging framework, or brand consistency.
日本語の概要は準備中です。原文の説明を表示しています。
Braze customer engagement platform expertise. Audit campaigns, Canvases, segments, messaging channels, and data architecture. Use when the user asks about Braze, customer engagement, push notifications, in-app messaging, cross-channel orchestration, or lifecycle marketing at scale.
日本語の概要は準備中です。原文の説明を表示しています。