search-term-miner

Featured

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. 付费广告搜索词挖掘/否定关键词/浪费词清单

Data & Documents 2,635 stars 347 forks Updated today Apache-2.0

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# 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](../campaign-architect/SKILL.md)...

Details

Author
aaron-he-zhu
Repository
aaron-he-zhu/aaron-marketing-skills
Created
8 months ago
Last Updated
today
Language
Python
License
Apache-2.0

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Listed

search-term-miner

Mines paid search terms / search queries and sorts every one into KEEP, HARVEST, REVIEW, or EXCLUDE with the spend and conversion evidence behind each call. Use this whenever someone asks about search terms, search queries, query reports, wasted search spend, which keywords to add or negate, "what are people actually searching", irrelevant clicks, or shares a search terms export from Google Ads, Microsoft Ads, or Amazon Ads — even if they don't use the words "search term report".

0 Updated 1 weeks ago
riz1k9
AI & Automation Listed

google-ads-search-terms

B2B Google Ads search terms report process — mining wasted queries, promoting winners, and review cadence. Use for search terms report, query mining, finding wasted spend, zero-conversion queries, promoting search terms to keywords. Triggers on "search terms report", "search query report", "mine queries", "zero conversion queries", "wasted queries", "promote search terms". Do NOT use for building the negative list buckets (use negative-keywords).

2 Updated 3 days ago
Growth-Today
Data & Documents Listed

negative-keyword-builder

Turns wasted search queries into an approval-ready negative keyword list — picks the right match type, groups queries into single phrase negatives using n-gram analysis, and safety-checks every proposal against converting queries before recommending it. Use whenever someone mentions negative keywords, blocking bad searches, match types for negatives, "stop showing for X", building an exclusion list, or already has a set of wasted queries to turn into exclusions, on Google Ads, Microsoft Ads, or Amazon Ads. If it has not yet been established which queries are wasted, run search-term-miner first.

0 Updated 1 weeks ago
riz1k9