Skip to content

thatrebeccarae/claude-marketing / skills/wasted-spend-finder

wasted-spend-finder

Verified

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.

FileKindSize
EXAMPLES.mdmarkdown2.5 KB
LICENSEother1.0 KB
REFERENCE.mdmarkdown4.0 KB
SKILL.mdskill md5.0 KB

REFERENCE.md

View on GitHub
# Wasted Spend Finder — Reference

## GAQL Queries (Google Ads Query Language)

### Search Terms Report

```sql
SELECT
  search_term_view.search_term,
  campaign.name,
  ad_group.name,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions,
  metrics.conversions_value
FROM search_term_view
WHERE segments.date DURING LAST_30_DAYS
  AND metrics.cost_micros > 0
ORDER BY metrics.cost_micros DESC
```

### Placement Report (Display + YouTube)

```sql
SELECT
  detail_placement_view.display_name,
  detail_placement_view.target_url,
  detail_placement_view.placement_type,
  campaign.name,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions
FROM detail_placement_view
WHERE segments.date DURING LAST_30_DAYS
  AND metrics.cost_micros > 0
ORDER BY metrics.cost_micros DESC
```

### Keyword Performance

```sql
SELECT
  ad_group_criterion.keyword.text,
  ad_group_criterion.keyword.match_type,
  campaign.name,
  ad_group.name,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions,
  metrics.conversions_value
FROM keyword_view
WHERE segments.date DURING LAST_30_DAYS
  AND metrics.cost_micros > 0
ORDER BY metrics.cost_micros DESC
```

### Campaign CPA Benchmark

```sql
SELECT
  campaign.name,
  campaign.id,
  metrics.cost_micros,
  metrics.conversions
FROM campaign
WHERE segments.date DURING LAST_30_DAYS
  AND metrics.conversions > 0
```

## Meta Ads API Queries

### Placement Breakdown

```
GET /{ad_account_id}/insights
?level=ad
&breakdowns=publisher_platform,platform_position
&fields=spend,impressions,clicks,actions,cost_per_action_type
&time_range={"since":"2026-02-13","until":"2026-03-13"}
```

### Audience Breakdown

```
GET /{ad_account_id}/insights
?level=adset
&fields=spend,impressions,clicks,actions,cost_per_action_type,frequency
&time_range={"since":"2026-02-13","until":"2026-03-13"}
```

### Creative Fatigue Detection

```
GET /{ad_account_id}/insights
?level=ad
&fields=ad_name,spend,impressions,frequency,actions,cost_per_action_type
&filtering=[{"field":"frequency","operator":"GREATER_THAN","value":"3"}]
&time_range={"since":"2026-02-13","until":"2026-03-13"}
```

## CSV Output Formats

### Negative Keywords CSV

```csv
Keyword,Match Type,Campaign,Ad Group,Spend Wasted,Clicks,Theme
"competitor product name",Exact,Search - Non-Brand,General,[cost],[clicks],Competitor
"how to do it yourself",Phrase,Search - Non-Brand,General,[cost],[clicks],Informational
"free alternative",Phrase,Search - Non-Brand,General,[cost],[clicks],Free Intent
```

### Placement Exclusions CSV

```csv
Placement,Type,Campaign,Spend Wasted,Impressions,Clicks,Conversions,Category
"game-app.example.com",App,Display - Prospecting,[cost],[impr],[clicks],0,Low-Quality App
"lyrics-channel",YouTube,Video - Awareness,[cost],[impr],[clicks],0,Music/Lyrics
```

### Audience Exclusions CSV

```csv
Audience,Type,Campaign,Spend,Impressions,Conversions,CPA,Recommendation
"Lookalike 5%",Lookalike,Prospecting,[spend],[impr],0,N/A,Exclude or narrow
"Interest: Cooking",Interest,Awareness,[spend],[impr],0,N/A,Exclude
```

## Savings Estimation

```
Estimated Monthly Savings = Sum of waste spend over analysis period / months

Confidence levels:
- HIGH: Zero conversions, 3x CPA threshold exceeded, 50+ clicks
- MEDIUM: Zero conversions, 2x CPA threshold exceeded, 25+ clicks
- LOW: Low conversion rate but some conversions present
```

## Common False Positives

| Scenario | Why It Looks Like Waste | Why It Might Not Be |
|----------|------------------------|-------------------|
| Brand terms from competitors | Zero direct conversions | May drive brand awareness |
| Broad educational queries | No immediate conversion | Top-of-funnel consideration |
| High-ticket items | Long conversion window | Attribution window too short |
| New campaigns (<14 days) | Insufficient data | Learning phase |
| View-through heavy platforms | Low click conversions | View-through conversions not counted |

Always check assisted conversions and extend the attribution window before excluding.
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall