๐ŸŽ‰ First 100 users: Use code EARLY-BIRDS-50 for 50% off!

Search Term Gold Miner

Analyzes Google Ads search term reports to uncover wasted spend, hidden opportunities, and negative keyword gaps. Triggers when user wants to review search terms, find wasted budget, discover new keywords, or clean up irrelevant traffic. Provides actionable lists of negatives to add, keywords to promote, and spend-saving estimates.

Google AdsIncludes Sample Data
Download
Search Term Gold Miner
SKILL.md
HOW_TO_USE.md
sample_input.json
expected_output.json
skillsgoogle-adsSKILL.md
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
# Search Term Gold Miner
 
Turn your search term report into actionable profit. Find the money you're wasting and the opportunities you're missing.
 
## Core Philosophy
 
**Every search term tells a story.** Either it's making you money, costing you money, or waiting to be discovered.
 
**The 3 Buckets:**
1. **Gold** - Converting terms that deserve their own keywords
2. **Garbage** - Non-converting terms bleeding your budget
3. **Grey Zone** - Terms needing more data before judgment
 
---
 
## Required Context
 
### Must Have
 
**1. Search Terms Data**
Export or paste search term report including:
- Search term
- Impressions
- Clicks
- Cost
- Conversions (critical)
 
Better if you also have: conversion value, match type, campaign/ad group
 
**2. Time Period**
- Minimum: 14 days (need enough data for patterns)
- Ideal: 30-60 days (reliable patterns)
- Maximum: 90 days (beyond this, data gets stale)
 
### Strongly Recommended
 
**3. Performance Thresholds**
- Target CPA: $___
- Minimum acceptable CVR: ____%
- Cost threshold for "significant spend": $___
 
Without thresholds, I'll use these defaults:
- Significant spend = $50+ with 0 conversions
- Promotion threshold = 3+ conversions
- CVR concern = below 1%
 
### Nice to Have
 
- Existing negative keyword lists (I'll check for gaps)
- Business context (B2B/B2C, product type, sales cycle)
- Brand terms to exclude from analysis
 
---
 
## Analysis Framework
 
### Phase 1: The Garbage Hunt
 
**Objective:** Stop the bleeding. Find terms wasting money.
 
#### Tier 1: Obvious Waste (Pause Immediately)
 
**Zero-Conversion Bleeders**
- Terms with $50+ spend and 0 conversions
- Action: Add as exact match negatives
- Priority: CRITICAL
 
**Intent Mismatches**
Patterns indicating wrong audience:
- Job seekers: "jobs," "careers," "salary," "hiring"
- Students: "course," "certification," "learn," "tutorial"
- DIYers: "how to," "DIY," "free," "template"
- Researchers: "what is," "definition," "vs," "comparison"
 
**Competitor Searches**
- Terms containing competitor brand names
- Unless: You're intentionally conquesting
- Action: Negative or dedicated conquesting campaign
 
**Location Mismatches**
- Geographic terms outside service area
- "near me" variations in wrong markets
 
#### Tier 2: Likely Waste (Review & Negate)
 
**High Click, Zero Convert**
- 20+ clicks with 0 conversions
- Indicates: Wrong intent or landing page mismatch
 
**CPA > 3x Target**
- Terms technically converting but unprofitably
- Threshold: If target CPA is $50, flag terms with CPA > $150
 
**Low Quality Indicators**
- Very short queries (1-2 words, too broad)
- Questions without purchase intent
- Informational queries in transactional campaigns
 
---
 
### Phase 2: The Gold Discovery
 
**Objective:** Find money-makers hiding in broad match.
 
#### Promotion Criteria
 
**Star Performers** (Promote to Exact Match)
- 3+ conversions
- CPA at or below target
- Currently matching via broad or phrase
 
**Why Promote?**
1. Better Quality Score potential
2. More bidding control
3. Dedicated ad copy opportunity
4. Cleaner data attribution
 
#### Opportunity Patterns
 
**Theme Clusters**
Multiple related terms converting = ad group opportunity
- Example: "emergency plumber," "24 hour plumber," "plumber now"
- Action: Create dedicated ad group with themed ads
 
**Long-Tail Winners**
4+ word queries with good CVR often indicate:
- High intent
- Lower competition
- Specific landing page opportunity
 
**New Keyword Ideas**
Terms with:
- Decent impressions (100+)
- Good CTR (above account average)
- Reasonable clicks but no conversions YET
- Clear commercial intent
 
---
 
### Phase 3: The Grey Zone
 
**Objective:** Identify terms needing more data before judgment.
 
**Insufficient Data Criteria:**
- < 10 clicks: Too early to judge
- < $20 spend: Not enough investment
- < 7 days of data: Could be anomaly
 
**Monitoring Recommendations:**
- Set calendar reminder to re-review in 2 weeks
- Consider bid reduction (not elimination) if concerning
- Flag for increased monitoring
 
---
 
## Scoring & Prioritization
 
### Waste Impact Score
 
| Score | Criteria | Urgency |
|-------|----------|---------|
| 10 | $200+ spend, 0 conversions | Immediate |
| 8 | $100-200 spend, 0 conversions | This week |
| 6 | $50-100 spend, 0 conversions | Priority |
| 4 | CPA > 3x target | Review |
| 2 | Low volume concerns | Monitor |
 
### Opportunity Score
 
| Score | Criteria | Action |
|-------|----------|--------|
| 10 | 5+ conversions, CPA < target | Promote immediately |
| 8 | 3-4 conversions, CPA at target | Strong promote candidate |
| 6 | 2 conversions, good signals | Add to watchlist |
| 4 | 1 conversion, high intent | Monitor |
 
---
 
## Output Format
 
### Executive Summary
 
```
SEARCH TERM HEALTH: ๐ŸŸข/๐ŸŸก/๐Ÿ”ด
Period Analyzed: [dates]
Total Terms Reviewed: [X]
Estimated Monthly Waste: $[X]
Opportunities Found: [X] keywords
```
 
---
 
### ๐Ÿšจ Immediate Negatives (Add Today)
 
**Total Wasted Spend: $[X]**
 
| Search Term | Clicks | Cost | Conv | Action |
|-------------|--------|------|------|--------|
| [term] | [X] | $[X] | 0 | Exact negative |
| [term] | [X] | $[X] | 0 | Exact negative |
| [term] | [X] | $[X] | 0 | Exact negative |
 
**Pattern-Based Negatives:**
Add these as phrase match negatives to block variations:
- "[pattern]" - Reason: [why]
- "[pattern]" - Reason: [why]
 
**Copy-Paste Negative List:**
```
[term 1]
[term 2]
[term 3]
```
 
---
 
### โญ Keywords to Promote
 
**Estimated Monthly Value if Promoted: $[X]**
 
| Search Term | Conv | CPA | Current Match | Recommendation |
|-------------|------|-----|---------------|----------------|
| [term] | [X] | $[X] | Broad | Add as Exact |
| [term] | [X] | $[X] | Phrase | Add as Exact |
 
**Ad Group Opportunities:**
Terms that cluster together for dedicated ad groups:
1. **[Theme]:** [term 1], [term 2], [term 3]
2. **[Theme]:** [term 1], [term 2], [term 3]
 
---
 
### ๐Ÿ‘€ Watchlist (Need More Data)
 
| Search Term | Clicks | Cost | Signal | Review Date |
|-------------|--------|------|--------|-------------|
| [term] | [X] | $[X] | [note] | [date] |
 
---
 
### ๐Ÿ“Š Search Term Quality Breakdown
 
```
Gold (Converting well): XX% of spend
Garbage (Wasted): XX% of spend
Grey Zone (Needs data): XX% of spend
Branded (Excluded): XX% of spend
```
 
---
 
### ๐Ÿ’ก Strategic Insights
 
**Pattern 1: [Observation]**
[What you're seeing in the data and what it means]
 
**Pattern 2: [Observation]**
[What you're seeing in the data and what it means]
 
**Recommendation:**
[One strategic recommendation based on overall patterns]
 
---
 
## Analysis Principles
 
### Be Conservative with Negatives
- When in doubt, DON'T negate
- One good conversion can justify previous waste
- Use exact match negatives to preserve variations
- Consider: Is this term genuinely irrelevant, or just underperforming?
 
### Be Aggressive with Promotions
- Winning terms deserve attention
- The cost of NOT promoting: poor QS, less control, attribution issues
- Threshold: If it converted 3x, it's proven
 
### Context Matters
- B2B: Longer sales cycles mean patience with grey zone
- E-commerce: Faster feedback, can be more aggressive
- High-ticket: One conversion can change everything
- Lead gen: Quality matters more than volume
 
### Account for Seasonality
- Compare to same period last year if available
- Note any obvious seasonal patterns
- Flag terms that might be temporarily poor performers
 
---
 
## Limitations
 
**I can assess:**
- Conversion patterns at search term level
- Obvious waste patterns
- Keyword promotion opportunities
- Theme clustering
 
**I cannot assess:**
- Lead quality (need backend data)
- Assisted conversions (need attribution data)
- Impression share by term (not in standard export)
- Why specific terms aren't converting (need landing page analysis)
 
**For deeper analysis, also provide:**
- Landing page URLs for non-converting terms
- Backend conversion quality data
- Multi-touch attribution report
- Competitor auction insights
 
---
 
## Quality Checklist
 
Before delivering analysis:
- [ ] Negative recommendations sorted by spend impact
- [ ] Each negative includes match type guidance
- [ ] Promotion candidates verified for statistical significance
- [ ] Copy-paste lists provided for easy implementation
- [ ] Dollar impact estimated for key recommendations
- [ ] Grey zone items have clear review timeline
- [ ] No branded terms accidentally flagged as waste
Ready
UTF-8Verified

Related Skills

Explore more Google Ads skills to enhance your workflow.

ab-test-designer
๐Ÿ”

Ab Test Designer

Designs rigorous A/B tests for Google Ads with clear hypotheses, success metrics, sample size calculations, and test duration estimates. Triggers when user wants to test something, run an experiment, compare ad variations, or asks "should I test X vs Y?" Provides scientific test framework that prevents common mistakes and ensures statistically valid results.

view skill โ†’
ad-copy-performance-ranker
๐Ÿ”

Ad Copy Performance Ranker

Analyzes RSA ad performance using Google Ads MCP data. Ranks headlines and descriptions by effectiveness, identifies winners/losers, and provides creative optimization recommendations. Triggers when user asks about ad copy performance, RSA analysis, or wants to improve ad creative. Pulls live data via ad_group_ad action.

view skill โ†’
bid-strategy-auditor
๐Ÿ”

Bid Strategy Auditor

Evaluates whether your Google Ads bid strategy is helping or hurting performance. Triggers when user questions Smart Bidding effectiveness, wants to compare bid strategies, or asks "should I use manual or automated bidding?" Analyzes conversion data, learning period status, and strategy fit. Provides honest assessment with switch recommendations when warranted.

view skill โ†’
budget-allocation-optimizer
๐Ÿ”

Budget Allocation Optimizer

Analyzes campaign performance and recommends optimal budget distribution to maximize conversions at target efficiency. Triggers when user asks about budget allocation, wants to redistribute spend, or asks "where should I put my budget?" Uses marginal CPA analysis to identify reallocation opportunities. Shows exactly how much to move and expected impact.

view skill โ†’

Frequently Asked Questions

Common questions about Search Term Gold Miner and how to use it effectively with Claude.

Search Term Gold Miner is a pre-built AI skill for Claude that helps with google ads tasks. Analyzes Google Ads search term reports to uncover wasted spend, hidden opportunities, and negative keyword gaps. Triggers when user wants to review search terms, find wasted budget, discover new keywords, or clean up irrelevant traffic. Provides actionable lists of negatives to add, keywords to promote, and spend-saving estimates. This skill is designed to work seamlessly with Claude Code and other Claude-powered applications, enabling marketers and businesses to automate and enhance their google ads workflows.

To use Search Term Gold Miner, download the skill files and add them to your Claude project. The skill includes a detailed HOW_TO_USE.md guide that walks you through the setup process step by step. Simply follow the instructions to integrate the skill into your workflow and start generating results immediately.

Yes, Search Term Gold Miner comes with sample input data that demonstrates how to structure your requests for optimal results. The sample_input.json file shows the expected data format, and expected_output.json provides an example of what Claude will generate. This helps you understand exactly how to use the skill and what to expect from the output.

Unlike traditional google ads tools, Search Term Gold Miner leverages Claude's advanced AI capabilities to provide intelligent, context-aware assistance. It combines pre-built expertise with Claude's reasoning abilities, allowing for more nuanced and customized outputs. The skill is also free to use, continuously updated, and integrates directly with your existing Claude workflow.

Absolutely. The skill files are fully editable, allowing you to modify the prompts, add your own brand guidelines, or adjust the output format to match your requirements. You can also combine this skill with other Claude skills to create powerful automated workflows tailored to your business needs.

Yes, Search Term Gold Miner is completely free to download and use. All InsightfulPipe skills are open source and designed to help marketers and businesses leverage AI more effectively. You can download the skill files, use them in your projects, and even modify them to suit your specific requirements.