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
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
# How to Use This Skill
Hey Claude, I just added the "search-term-gold-miner" skill. Can you analyze my search term report and find wasted spend?
## Example Invocations
**Example 1: Full Analysis**
Hey Claude, I just added the "search-term-gold-miner" skill. Can you review my last 30 days of search terms and tell me what to negate and what to promote? My target CPA is $45.
**Example 2: Quick Waste Hunt**
Hey Claude, I just added the "search-term-gold-miner" skill. Here's my search term export - just find the obvious money wasters I should negate today.
**Example 3: Keyword Discovery**
Hey Claude, I just added the "search-term-gold-miner" skill. I want to find search terms that are converting well but don't have their own keywords yet. Here's my data.
**Example 4: Negative Keyword Audit**
Hey Claude, I just added the "search-term-gold-miner" skill. Can you analyze these search terms and give me a list of negatives I can copy-paste into Google Ads?
## What to Provide
**Required:**
- Search term report (export from Google Ads or paste data)
- Must include: search term, clicks, cost, conversions
- At least 14 days of data (30+ days preferred)
**Recommended:**
- Target CPA or ROAS
- Business context (B2B/B2C, industry)
- Any brand terms to exclude from analysis
**Optional:**
- Existing negative keyword lists
- Conversion values
- Campaign/ad group breakdown
## What You'll Get
1. **Immediate Negatives** - Copy-paste list of terms to block today
2. **Promotion Candidates** - Converting terms that deserve exact match keywords
3. **Watchlist** - Terms needing more data before judgment
4. **Spend Breakdown** - Where your money is actually going
5. **Dollar Impact** - Estimated savings from recommendations
6. **Strategic Insights** - Patterns in your search data
## Pro Tips
- Run this analysis monthly to catch waste early
- Export "All time" first, then filter to last 30-60 days
- Include conversion values if you have them (enables ROAS analysis)
- Save the negative keyword list output directly to a Google Ads shared list
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
{
"time_period": "Last 30 days",
"target_cpa": 50,
"business_type": "B2B SaaS",
"search_terms": [
{
"search_term": "project management software",
"clicks": 156,
"cost": 312,
"conversions": 8,
"match_type": "Broad"
},
{
"search_term": "free project management tools",
"clicks": 89,
"cost": 178,
"conversions": 0,
"match_type": "Broad"
},
{
"search_term": "project management certification",
"clicks": 67,
"cost": 134,
"conversions": 0,
"match_type": "Broad"
},
{
"search_term": "best project management software for teams",
"clicks": 45,
"cost": 135,
"conversions": 5,
"match_type": "Phrase"
},
{
"search_term": "monday vs asana",
"clicks": 34,
"cost": 68,
"conversions": 0,
"match_type": "Broad"
},
{
"search_term": "enterprise project management",
"clicks": 28,
"cost": 112,
"conversions": 3,
"match_type": "Broad"
},
{
"search_term": "project management jobs",
"clicks": 52,
"cost": 104,
"conversions": 0,
"match_type": "Broad"
},
{
"search_term": "agile project management tool",
"clicks": 23,
"cost": 69,
"conversions": 2,
"match_type": "Broad"
},
{
"search_term": "how to manage projects",
"clicks": 41,
"cost": 82,
"conversions": 0,
"match_type": "Broad"
},
{
"search_term": "project management software pricing",
"clicks": 19,
"cost": 57,
"conversions": 3,
"match_type": "Broad"
}
]
}
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
{
"summary": {
"health": "YELLOW",
"period": "Last 30 days",
"terms_reviewed": 10,
"estimated_monthly_waste": 566,
"opportunities_found": 4
},
"immediate_negatives": {
"total_wasted": 566,
"terms": [
{
"search_term": "free project management tools",
"clicks": 89,
"cost": 178,
"conversions": 0,
"action": "Exact negative",
"reason": "Free seekers - wrong intent"
},
{
"search_term": "project management certification",
"clicks": 67,
"cost": 134,
"conversions": 0,
"action": "Exact negative",
"reason": "Education seeker - wrong intent"
},
{
"search_term": "project management jobs",
"clicks": 52,
"cost": 104,
"conversions": 0,
"action": "Exact negative",
"reason": "Job seeker - wrong audience"
},
{
"search_term": "how to manage projects",
"clicks": 41,
"cost": 82,
"conversions": 0,
"action": "Exact negative",
"reason": "Informational query - not purchase intent"
},
{
"search_term": "monday vs asana",
"clicks": 34,
"cost": 68,
"conversions": 0,
"action": "Exact negative",
"reason": "Competitor comparison - unless conquesting"
}
],
"pattern_negatives": [
{
"pattern": "free",
"match_type": "Phrase",
"reason": "Blocks free seekers"
},
{
"pattern": "certification",
"match_type": "Phrase",
"reason": "Blocks education seekers"
},
{
"pattern": "jobs",
"match_type": "Phrase",
"reason": "Blocks job seekers"
},
{
"pattern": "how to",
"match_type": "Phrase",
"reason": "Blocks informational queries"
}
],
"copy_paste_list": "free project management tools\nproject management certification\nproject management jobs\nhow to manage projects\nmonday vs asana"
},
"keywords_to_promote": [
{
"search_term": "project management software",
"conversions": 8,
"cpa": 39,
"current_match": "Broad",
"recommendation": "Add as Exact - star performer"
},
{
"search_term": "best project management software for teams",
"conversions": 5,
"cpa": 27,
"current_match": "Phrase",
"recommendation": "Add as Exact - high intent long-tail"
},
{
"search_term": "enterprise project management",
"conversions": 3,
"cpa": 37.33,
"current_match": "Broad",
"recommendation": "Add as Exact - B2B intent"
},
{
"search_term": "project management software pricing",
"conversions": 3,
"cpa": 19,
"current_match": "Broad",
"recommendation": "Add as Exact - bottom funnel"
}
],
"watchlist": [
{
"search_term": "agile project management tool",
"clicks": 23,
"cost": 69,
"conversions": 2,
"signal": "Borderline CPA ($34.50) - monitor",
"review_date": "2 weeks"
}
],
"quality_breakdown": {
"gold_percent": 52,
"garbage_percent": 45,
"grey_zone_percent": 3
},
"strategic_insights": [
{
"pattern": "Intent mismatch issue",
"observation": "45% of spend going to non-commercial queries (free, jobs, how-to). Broad match is too broad.",
"recommendation": "Tighten match types and build robust negative list"
},
{
"pattern": "Long-tail opportunity",
"observation": "4+ word queries converting at 2x the rate of short queries",
"recommendation": "Create dedicated ad group for long-tail variations with specific ad copy"
}
]
}
ReadySearch Term Gold Miner
MarkdownUTF-8