| name | search-term-miner |
| slug | aaron-search-term-miner |
| displayName | Search Term Miner · 付费广告搜索词挖掘 |
| summary | 付费广告搜索词挖掘/否定关键词/浪费词清单 |
| description | Use when the user asks to "mine my search terms", "find new keywords from converting queries", "build a negative-keyword list", or "cut wasted paid spend"; harvests converting queries into new keywords/ad-groups, builds a standing negative-keyword list and an n-gram waste report from the search-terms export, and delivers a maintenance diff (add / negate / move). Not for account structure — use campaign-architect; not for budget split — use budget-optimizer; not for computing the final RQS — use ad-account-auditor. 付费广告搜索词挖掘/否定关键词/浪费词清单 |
| version | 19.2.0 |
| license | Apache-2.0 |
| compatibility | Claude Code and compatible agent-skill hosts |
| homepage | https://github.com/aaron-he-zhu/aaron-marketing-skills |
| when_to_use | Use on a recurring cadence to mine a fresh search-terms report: promote converting queries into new keywords or ad groups, build and grow a standing negative-keyword list, and produce an n-gram waste report that names the tokens draining spend without converting. |
| argument-hint | <search-terms export path/paste> [goal] [conversion column] |
| metadata | {"author":"aaron-he-zhu","version":"19.2.0","discipline":"ad","phase":"research","geo-relevance":"low","hermes":{"tags":["marketing","ad","research"],"category":"ad"},"openclaw":{"emoji":"🎯","homepage":"https://github.com/aaron-he-zhu/aaron-marketing-skills"}} |
Search Term Miner
Turns a search-terms report into two standing outputs: new keywords/ad-groups harvested from converting queries, and a negative-keyword + n-gram waste list built from queries that spent without converting. It is the recurring mining loop that campaign-architect used to carry as a mode — that skill now owns account structure only, and this skill owns the search-term harvest and negative hygiene. It scores the ROAS S (Spend-efficiency) lever it works on and hands off; it does not compute the final RQS.
Quick Start
Mine my search terms. Here is my exported search-terms report: [paste/path]. Goal is [DR/prospecting].
Build a negative-keyword list and an n-gram waste report from this search-terms export: [path].
Which converting queries should become new keywords or ad groups? Here is the search-terms + conversions export.
Skill Contract
Expected output: a maintenance diff (add / negate / move), a set of harvested keywords/ad-groups from converting queries, a standing negative-keyword list, an n-gram waste report ranking the tokens draining spend without converting, a ROAS S dimension score with notes, and the standard handoff summary.
- Reads: the exported search-terms report (query, impressions, clicks, cost, conversions, conv. value), the ROAS profile (
direct-response|prospecting|incremental-profit), and the existing ad-group/negative structure from campaign-architect when present.
- Writes: a user-facing mining diff and reusable summary to
memory/ad/search-term-miner/.
- Promotes: the standing negative-keyword list, harvested keyword themes, the n-gram waste findings, and the S score to
memory/hot-cache.md and memory/open-loops.md; propose durable negatives as pending-decision items.
- Done when: every converting query above the harvest threshold is routed to add / move; every wasted query is negated with a stated match type; the n-gram waste report names its top spend-draining tokens with Measured cost figures; and the ROAS S score is emitted with the typed profile named.
- Primary next skill: ad-account-auditor to score the full RQS and enforce the veto items.
Handoff Summary
