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,471 stars 335 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
7 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

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).

1 Updated 5 days ago
Growth-Today
Data & Documents Listed

negative-keyword-engine

The single skill for all Google Ads negative keyword and search term work, with three modes: Audit (find wasted spend in a search terms report), Leakage (find systematic gaps in existing negative lists), and Mine (proactively build a comprehensive negative list for new campaigns or overhauls). Use this skill whenever the user wants to analyze, audit, or clean up search terms, find wasted ad spend, identify irrelevant queries, build or expand a negative keyword list, audit their negatives, or asks anything like "why is my CPA bad", "where is my budget leaking", "review my search terms", "what negatives should I add", "what should I be blocking", "negative keyword gaps", or uploads a Google Ads search terms report (CSV/Excel). Trigger even when the user doesn't say "negative keywords" explicitly: any request involving search terms data, PPC waste reduction, or blocking irrelevant traffic qualifies.

0 Updated 1 weeks ago
kochellenk-afk
AI & Automation Solid

search-term-cleanup

Audit and clean up search terms (negative keywords, intent classification, query hygiene). Use when the user asks to clean up search queries, add negative keywords, review search term reports, or improve match quality. Cross-references Search Console, GA4, and ad platform data. Also use when the user asks in Japanese (検索語句のクリーンアップ / 除外キーワードを追加して / 無駄な検索クエリを止めたい).

16 Updated today
logly