Blog Google
AgriciDaniel/claude-blog
Google API integration for blog performance: PageSpeed Insights, CrUX Core Web Vitals with 25-week history, Search Console performance, URL Inspection, Indexing API, GA4 organic traffic, NLP entity…
Systematic analysis of Google Ads and Meta advertising spend to identify wasted budget.
Install Wasted Spend Finder
$ npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install thatrebeccarae/claude-marketing wasted-spend-finder --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/thatrebeccarae/claude-marketing.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/wasted-spend-finder .claude/skills/wasted-spend-finder && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "wasted-spend-finder" agent skill from https://github.com/thatrebeccarae/claude-marketing/tree/main/skills/wasted-spend-finder into .claude/skills/wasted-spend-finder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wasted-spend-finder", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/thatrebeccarae/claude-marketing/tree/main/skills/wasted-spend-finderType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install thatrebeccarae/claude-marketing wasted-spend-finder --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thatrebeccarae/claude-marketing.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/wasted-spend-finder .agents/skills/wasted-spend-finder && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "wasted-spend-finder" agent skill from https://github.com/thatrebeccarae/claude-marketing/tree/main/skills/wasted-spend-finder into .agents/skills/wasted-spend-finder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wasted-spend-finder", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install thatrebeccarae/claude-marketing wasted-spend-finder --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thatrebeccarae/claude-marketing.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/wasted-spend-finder .cursor/skills/wasted-spend-finder && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "wasted-spend-finder" agent skill from https://github.com/thatrebeccarae/claude-marketing/tree/main/skills/wasted-spend-finder into .cursor/skills/wasted-spend-finder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wasted-spend-finder", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/thatrebeccarae/claude-marketing.git --path skills/wasted-spend-finder--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install thatrebeccarae/claude-marketing wasted-spend-finder --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thatrebeccarae/claude-marketing.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/wasted-spend-finder .gemini/skills/wasted-spend-finder && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "wasted-spend-finder" agent skill from https://github.com/thatrebeccarae/claude-marketing/tree/main/skills/wasted-spend-finder into .gemini/skills/wasted-spend-finder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wasted-spend-finder", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install thatrebeccarae/claude-marketing wasted-spend-finderInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/thatrebeccarae/claude-marketing.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/wasted-spend-finder .github/skills/wasted-spend-finder && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "wasted-spend-finder" agent skill from https://github.com/thatrebeccarae/claude-marketing/tree/main/skills/wasted-spend-finder into .github/skills/wasted-spend-finder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wasted-spend-finder", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install thatrebeccarae/claude-marketing wasted-spend-finder --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thatrebeccarae/claude-marketing.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/wasted-spend-finder .opencode/skills/wasted-spend-finder && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "wasted-spend-finder" agent skill from https://github.com/thatrebeccarae/claude-marketing/tree/main/skills/wasted-spend-finder into .opencode/skills/wasted-spend-finder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wasted-spend-finder", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
wasted-spend-finder- GitHub stars
- 161
- Token cost
- ~1.3k tokens
- SKILL.md length
- 506 words
- Files
- 4
- Skills in repo
- 55
- Repo updated
- First seen
- Licence
- MIT
At a glance
Systematic analysis of Google Ads and Meta advertising spend to identify wasted budget.
- Works in 5 steps: Data Collection → Apply Thresholds → Categorize → …
- Onboarding new accounts
- SKILL.md covers Install, Core Capabilities, Waste Thresholds and Negative Keyword Categorization, plus 3 more sections
- Calls git
What it does
Wasted Spend Finder is an agent skill from thatrebeccarae/claude-marketing. 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.
Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. The skill folder holds 3 other files (for example `EXAMPLES.md` and `REFERENCE.md`).
It sits in Marketing & SEO, covering Paid advertising. It works with Google Ads and YouTube. The repository describes itself as: A full marketing department for Claude Code. Skill packs for Klaviyo, Shopify, GA4, Looker Studio, paid media, and more. Audit, optimize, and report using natural language. The licence is MIT.
When your agent uses it
- Onboarding new accounts
- Performing monthly hygiene
- Preparing for budget optimization
Example prompts
- “/wasted-spend-finder”
Workflow steps
5 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit a8a63ec. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Shell commands in SKILL.md call:
git
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md. Its commands use git, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Wasted Spend Finder loads about 1.3k tokens when it runs. Until then it costs about 75 tokens; SKILL.md has 506 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from thatrebeccarae/claude-marketing at commit a8a63ec, republished under its MIT licence (© thatrebeccarae). 506 words, ~1,285 tokens.
Download SKILL.mdSave it as
.claude/skills/wasted-spend-finder/SKILL.md (or your agent's skills folder). This skill also uses 3 other files; get the full folder from GitHub.- name
- wasted-spend-finder
- description
- 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.
- license
- MIT
- origin
- custom
- author
- Rebecca Rae Barton
- author_url
- https://github.com/thatrebeccarae
- metadata.version
- 1.0.0
- metadata.category
- paid-media
- metadata.domain
- optimization
- metadata.updated
- 2026-03-13
- metadata.tested
- 2026-03-17
- metadata.tested_with
- Claude Code v2.1
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
- Search Term Waste — zero-conversion terms above spend threshold
- Placement Waste — Display Network sites/apps and YouTube channels with no conversions
- Keyword-Level Waste — low conversion rate keywords relative to spend
Meta Ads Waste Detection
- Placement Waste — Audience Network apps, low-quality inventory
- Audience Segment Waste — lookalike/interest targeting with poor performance
- 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 CPAA 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 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 |
Conversion Rate Minimums
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% |
Negative Keyword Categorization
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 |
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
Show full SKILL.md (195 more words)Show less
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 scopeplacement-exclusions.csv— with reason and spend wastedaudience-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
- Analysis only. Never make live account changes without human review.
- Projections are estimates. Label all savings projections clearly.
- Check for false positives. Some high-spend zero-conversion terms may be in a consideration window.
- Consider attribution. View-through and assisted conversions may justify some "wasted" spend.
- Preserve data. Export current state before applying any exclusions.
For GAQL query patterns and CSV formats, see REFERENCE.md.
© thatrebeccarae, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 3 other files in skills/wasted-spend-finder of thatrebeccarae/claude-marketing.
- SKILL.md
- EXAMPLES.md
- LICENSE
- REFERENCE.md
Open the folder on GitHubat commit a8a63ec
Compare with similar skills
Wasted Spend Finder next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Wasted Spend Finder this skillthatrebeccarae/claude-marketing | 161 | — | ~1.3k | Automated safety check: Pass | MIT | |
| Blog GoogleAgriciDaniel/claude-blog | 2.3k | 1 repos | ~3.3k | Automated safety check: Notes | MIT | |
| SEO Googleseranking/seo-skills | 161 | — | ~4.8k | Automated safety check: Pass | MIT | |
| Google Ads AuditAgriciDaniel/claude-ads | 9.9k | — | ~799 | Automated safety check: Pass | MIT | |
| Google Adsarnabbagxd/Brand-building-skills | 729 | — | ~3.1k | Automated safety check: Pass | MIT | |
| Paid Creative AItech-leads-club/agent-skills | 7k | — | ~6.4k | Automated safety check: Pass | Custom licence |
Similar skills
SEO Google
seranking/seo-skills
Direct access to Google's own SEO data via Search Console (Search Analytics, URL Inspection, Sitemaps), PageSpeed Insights v5, CrUX field data with 25-week history, Indexing API v3, GA4 organic…
Google Ads Audit
AgriciDaniel/claude-ads
Audits a Google Ads account across measurement, search terms, structure, creative, bidding, budgets and policy, and keeps every change as a draft.
Google Ads
arnabbagxd/Brand-building-skills
Plan, build, and optimize Google Ads campaigns — Search, Shopping, Performance Max, Display, and YouTube — including keyword research, match types, bidding strategy, Quality Score, ad extensions…
Paid Creative AI
tech-leads-club/agent-skills
When the user wants to create AI-generated ad creative, test performance creative, manage creative fatigue, or optimize paid media with AI tools.
Google Ads
kostja94/marketing-skills
When the user wants to set up, optimize, or manage Google Ads campaigns.
More from thatrebeccarae/claude-marketing
All 55 skills in this repoGoogle Analytics
thatrebeccarae/claude-marketing
Analyze Google Analytics data, review website performance metrics, identify traffic patterns, and suggest data-driven improvements.
Content Creator
thatrebeccarae/claude-marketing
Comprehensive content marketing toolkit with brand voice analysis, SEO optimization scripts, content frameworks, social media strategy, and content calendar planning.
Klaviyo Analyst
thatrebeccarae/claude-marketing
Klaviyo marketing operations and analyst expertise. An agent skill from thatrebeccarae/claude-marketing.
Klaviyo Developer
thatrebeccarae/claude-marketing
Klaviyo API and developer integration expertise. An agent skill from thatrebeccarae/claude-marketing.
Looker Studio
thatrebeccarae/claude-marketing
Looker Studio (formerly Google Data Studio) expertise. An agent skill from thatrebeccarae/claude-marketing.
Shopify
thatrebeccarae/claude-marketing
Shopify e-commerce platform marketing expertise. An agent skill from thatrebeccarae/claude-marketing.
Related
Works with
Categories
Questions about Wasted Spend Finder
What does Wasted Spend Finder do?
Systematic analysis of Google Ads and Meta advertising spend to identify wasted budget. Wasted Spend Finder is an agent skill from thatrebeccarae/claude-marketing. Systematic analysis of Google Ads and Meta advertising spend to identify wasted budget.
When should I use Wasted Spend Finder?
Wasted Spend Finder fits situations like: onboarding new accounts; performing monthly hygiene; preparing for budget optimization.
How do I install Wasted Spend Finder in Claude Code?
Run `npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a claude-code`. Or copy the skill folder (skills/wasted-spend-finder in thatrebeccarae/claude-marketing) into .claude/skills/wasted-spend-finder in your project. Claude Code loads it when a task matches its description.
How do I install Wasted Spend Finder in Codex?
Run `npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a codex`. Or copy the skill folder (skills/wasted-spend-finder in thatrebeccarae/claude-marketing) into .agents/skills/wasted-spend-finder in your project. Codex loads it when a task matches its description.
Can I use Wasted Spend Finder in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add thatrebeccarae/claude-marketing --skill wasted-spend-finder -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/wasted-spend-finder, .gemini/skills/wasted-spend-finder, .github/skills/wasted-spend-finder and .opencode/skills/wasted-spend-finder in your project.
What does Wasted Spend Finder need to run?
Going by SKILL.md and its folder, Wasted Spend Finder needs the command-line tools its instructions call (git).
Does Wasted Spend Finder access the network?
SKILL.md contains no URLs. Its commands use git, which can reach the network depending on how they are called. This is read from the text; nothing was executed.
Is Wasted Spend Finder safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Wasted Spend Finder use?
Wasted Spend Finder is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Wasted Spend Finder use?
About 1.3k tokens (SKILL.md is roughly 5.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Wasted Spend Finder?
Skills that share tags, products or a category with Wasted Spend Finder: Blog Google (AgriciDaniel/claude-blog, 2.3k stars), SEO Google (seranking/seo-skills, 161 stars), Google Ads Audit (AgriciDaniel/claude-ads, 9.9k stars) and Google Ads (arnabbagxd/Brand-building-skills, 729 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Wasted Spend Finder?
thatrebeccarae (a GitHub user) maintains it in thatrebeccarae/claude-marketing, which has 161 GitHub stars. The repository holds 55 skills in this directory. The repository was last updated on May 14, 2026.
Source: thatrebeccarae/claude-marketing on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.