跳到正文
cccskills
免费在 GitHub 公开

wasted-spend-finder

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.

中文简介正在准备中。当前显示原文说明。

集成工具Google AdsYouTube

实测评分 未实测

查看安装方法

包含的文件(4)

  • SKILL.md5.0 KB
  • EXAMPLES.md2.5 KB
  • LICENSE1.0 KB
  • REFERENCE.md4.0 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Wasted Spend Finder

Identify and categorize wasted ad spend across Google Ads and Meta platforms. Produces uploadable exclusion lists with thematic categorization.

Install

git clone https://github.com/thatrebeccarae/claude-marketing.git && cp -r claude-marketing/skills/wasted-spend-finder ~/.claude/skills/

Core Capabilities

Google Ads Waste Detection

  1. Search Term Waste — zero-conversion terms above spend threshold
  2. Placement Waste — Display Network sites/apps and YouTube channels with no conversions
  3. Keyword-Level Waste — low conversion rate keywords relative to spend

Meta Ads Waste Detection

  1. Placement Waste — Audience Network apps, low-quality inventory
  2. Audience Segment Waste — lookalike/interest targeting with poor performance
  3. Creative Waste — high frequency + zero conversions, creative fatigue

Waste Thresholds

Spend Threshold Formula

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:

  • Spend exceeds the threshold AND
  • Conversions = 0 AND
  • Minimum click threshold is met

Minimum Click Thresholds

Campaign TypeMin Clicks Before Flagging
Search (branded)50
Search (non-brand)25
Display / GDN15
YouTube20
Meta Feed20
Meta Stories15
Meta Audience Network10

Conversion Rate Minimums

Flag keywords/placements performing below these floors:

Campaign TypeMin Conversion Rate
Search (branded)8%
Search (non-brand)1.5%
Display0.3%
YouTube0.2%
Meta Feed0.5%
Meta Stories0.3%

Negative Keyword Categorization

Classify wasted search terms into themes for organized exclusion:

ThemePatternMatch Type
Competitor termsBrand names, product namesExact / Phrase
Informational intenthow to, what is, tutorial, guide, definitionPhrase
Wrong product/serviceRelated but non-target productsPhrase / Exact
Geographic irrelevanceWrong cities, states, countriesExact
Job/career searchesjobs, salary, hiring, career, resumePhrase
Free/cheap intentfree, cheap, discount, coupon, dealPhrase
Irrelevant modifiersDIY, homemade, kids, old, usedPhrase

Placement Exclusion Categories

Google Display Network

  • Low-quality apps (game apps, utility apps, kids apps)
  • Parked domains and MFA (made-for-advertising) sites
  • Irrelevant content categories

YouTube

  • Music videos and lyrics channels
  • Kids and animation content
  • Gaming content (unless relevant)
  • Clickbait and low-quality channels

Meta Audience Network

  • Game apps
  • Utility and calculator apps
  • Foreign language apps
  • Apps with under 100 reviews

Workflow

1. Data Collection

Pull data for the analysis period (typically 30-90 days):

Google Ads:

  • Search terms report
  • Placement report (Display + YouTube)
  • Keyword performance report
  • Campaign/ad group settings for CPA benchmarks

Meta Ads:

  • Placement breakdown report
  • Audience breakdown report
  • Ad-level report with frequency data

2. Apply Thresholds

Calculate waste threshold per campaign using the formula above. Flag items exceeding thresholds.

3. Categorize

Assign each flagged item to a theme category. Group for batch exclusion.

4. Generate Exclusion Lists

Output CSV files ready for upload:

  • negative-keywords.csv — with match type and campaign/ad group scope
  • placement-exclusions.csv — with reason and spend wasted
  • audience-exclusions.csv — with segment details and waste amount

5. Validate

  • Cross-check that exclusions do not remove converting terms
  • Verify match types will not over-exclude
  • Estimate savings from the proposed exclusions

Safety Rules

  1. Analysis only. Never make live account changes without human review.
  2. Projections are estimates. Label all savings projections clearly.
  3. Check for false positives. Some high-spend zero-conversion terms may be in a consideration window.
  4. Consider attribution. View-through and assisted conversions may justify some "wasted" spend.
  5. Preserve data. Export current state before applying any exclusions.

For GAQL query patterns and CSV formats, see REFERENCE.md.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

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.

中文简介正在准备中。当前显示原文说明。

thatrebeccarae/claude-marketing1772026年5月15日 更新

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.

中文简介正在准备中。当前显示原文说明。

thatrebeccarae/claude-marketing1772026年5月15日 更新

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.

中文简介正在准备中。当前显示原文说明。

thatrebeccarae/claude-marketing1772026年5月15日 更新

brand-dna

免费

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.

中文简介正在准备中。当前显示原文说明。

thatrebeccarae/claude-marketing1772026年5月15日 更新

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.

中文简介正在准备中。当前显示原文说明。

thatrebeccarae/claude-marketing1772026年5月15日 更新

braze

免费

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.

中文简介正在准备中。当前显示原文说明。

thatrebeccarae/claude-marketing1772026年5月15日 更新

查看 thatrebeccarae 的全部技能

报告此技能的问题