Writing & Content

Paid Search Term Miner

Turn search-term reports into converting keywords and spend-saving negatives.

54/ 100
Use with care

Useful, but reliability, evidence or controls still have material gaps.

See how it was scored ↓
Works as-is in
Codex · Claude Code
Stars
★ 3k
Last updated
13d ago
License
Apache-2.0
paid-advertisingsearch-term-analysisnegative-keywordskeyword-mining
+2roasad-optimization

What does this skill do, and when should you use it?

This skill provides a recurring workflow for mining paid-ad search-term reports and maintaining negative-keyword hygiene. It harvests converting queries into keyword or ad-group candidates, then identifies queries and n-grams that spend without converting. Its outputs include an add/negate/move maintenance diff, a standing negative-keyword list, an n-gram waste report, and the ROAS S spend-efficiency score. It does not handle account structure, budget or bid allocation, or the final RQS.

Reads search-term exports containing query, impressions, clicks, cost, conversions, and optionally conversion value; confirms a direct-response, prospecting, or incremental-profit profile; filters converting queries above a stated threshold and routes them to new keywords or matching intent ad groups; flags non-converting queries above a stated cost floor and assigns exact or phrase negative match types at ad-group, campaign, or shared-list level; tokenizes non-converting queries into 1-, 2-, and 3-grams and ranks tokens by measured cost; produces add, negate, and move rows, a standing negative list, an n-gram waste report, an S score, and a handoff summary.

Good fit
  • A paid-search team receives a weekly search-term export and needs to promote converting queries into the existing keyword or ad-group structure.
  • An advertiser sees meaningful spend with zero conversions and needs a documented negative-keyword list with match types and levels.
  • A growth team wants to find recurring tokens that drain spend without producing conversions.
  • A paid-media lead needs search-term waste evidence and an ROAS S input before an account audit.

How do you install this skill?

Before you use it
  • Before applying negatives or moving queries between ad groups, obtain user confirmation of thresholds, match types, scope levels, and each recommendation to avoid suppressing valuable traffic.
  • Search-term exports may contain customer queries, costs, and conversion information; the skill does not define redaction, data minimization, or memory cleanup procedures.
  • Confirm the profile, conversion column, attribution window, and platform-field semantics before scoring S or classifying waste.
  • Tokenization rules for Chinese queries are unspecified; applying English-style n-grams directly may produce misleading findings.
Before you start
Your agent needs
  • Network access
  • Local filesystem
  • MCP Server

Install the repository in Claude Code or another Agent Skills-compatible host, then use ad/research/search-term-miner/SKILL.md. The README documents these collection-level commands: /plugin marketplace add aaron-he-zhu/aaron-marketing-skills, followed by /plugin install aaron-marketing@aaron for Claude Code, or npx skills add aaron-he-zhu/aaron-marketing-skills for generic hosts. The README shows a single-skill example using keyword-research, but does not document the exact single-skill command for this skill.

Generic route: install into Claude Code manually (macOS / Linux)
tmp="$(mktemp -d)"
git clone --depth 1 https://github.com/aaron-he-zhu/aaron-marketing-skills.git "$tmp"
mkdir -p ~/.claude/skills
cp -R "$tmp/ad/research/search-term-miner" ~/.claude/skills/
rm -rf "$tmp"

Generated from the source repository and skill path; it copies only this skill's folder. If the author's install steps above differ, follow those first. To scope it to one project, replace ~/.claude/skills with that project's .claude/skills.

How do you use this skill?

Provide a search-term report with query, cost, and conversions columns, adding conversion value when ROAS scoring requires it. Example prompts: Mine my search terms. Here is my exported search-terms report: [paste/path]. Goal is [DR/prospecting]. or Build a negative-keyword list and an n-gram waste report from this search-terms export: [path]. If the conversion column is missing, the skill stops and asks for it rather than mining or negating from clicks alone.

What are this skill's strengths and limitations?

Pros
  • Defines concrete add, negate, and move maintenance outputs.
  • Combines query-level negative hygiene with a cost-ranked n-gram waste report.
  • Requires figures to be labeled Measured, User-provided, or Estimated.
  • Works from user-provided exports and does not require a paid-ad API.
Limitations
  • Requires query, cost, and conversion data; it cannot proceed without the conversion column.
  • Does not design account structure, allocate budget or bids, or calculate final RQS.
  • Thresholds, cost floors, and negative levels must be stated for the run; the source does not define universal defaults.
  • The source does not provide an independent test suite or complete validation across specific ad platforms.

How does this skill compare with similar options?

Side by side with related skills; every score comes from the same FSRS standard.

Skill FS score Stars Last updated License
Paid Search Term Miner this page 54 · Use with care ★ 3k 13d ago Apache-2.0
Paid Ads Campaign Architect 57 · Use with care ★ 3k 13d ago Apache-2.0
Ad Fatigue & Frequency Manager 58 · Recommended ★ 3k 13d ago Apache-2.0
Paid Ads Audience Segment Builder 56 · Use with care ★ 3k 13d ago Apache-2.0
Paid Measurement Loop 54 · Use with care ★ 3k 13d ago Apache-2.0

Compared with campaign-architect, this skill owns search-term harvesting and negative hygiene while that skill owns account structure. Compared with budget-optimizer, it addresses query-level waste rather than budget and bid allocation. Compared with ad-account-auditor, it supplies the ROAS S evidence while the auditor calculates the full RQS and applies the audit gate.

How did FollowSkills review this skill?

FollowSkills review · FSRS-2.0
Use with care
54/ 100 5-point scale 2.7 / 5
The upstream repository has new commits since this review. The score still applies to the reviewed revision shown and may not cover the latest changes.
1Trust18 / 25 · 3.6/5

The skill treats exports as untrusted input, relies on user-provided manual exports by default, keeps APIs optional, and limits persistence to user-confirmed local memory; it does not clearly classify sensitive ad data, define deletion/rollback, or require item-level confirmation before acting on recommendations, so points are deducted.

2Reliability8 / 20 · 2.0/5

Column validation, stop-on-missing-input behavior, threshold-based routing, match-type labeling, and user-facing blocking are reasonably clear; however, harvest thresholds, waste cost floors, and malformed-data handling are unspecified, and there are no skill-specific key-path tests, limiting the static score.

3Adaptability11 / 15 · 3.7/5

Triggers, inputs, outputs, and non-fit boundaries are clearly described, and manual CSV input reduces platform dependency; evidence for platform-field variation, Chinese query tokenization, and mainland-China environment fit is limited, with geo-relevance explicitly marked low.

4Convention9 / 15 · 3.0/5

The skill has version, license, compatibility, Quick Start examples, contract, data sources, scope guard, and next-skill guidance; it lacks representative output examples, FAQs, named maintenance responsibility, changelog detail, and an independent update path, while publisher identity is unverified.

5Effectiveness6 / 15 · 2.0/5

The defined maintenance diff, harvested keywords/ad groups, negative list, n-gram report, and S score are directly aligned with the core mining task; however, thresholds and cost floors require judgment, and no representative output or real-result evidence is supplied, so the static ceiling applies.

6Verifiability2 / 10 · 1.0/5

The document specifies fields, method, and Measured/User-provided/Estimated labeling; it contains no reproducible skill-specific tests, execution records, or third-party corroboration. Repository tests cover architecture and audit artifacts rather than this skill's key paths.

1 2 3 4 5 6

Open a dimension to read why it scored that way

Reviewed Jul 20, 2026 Reviewed revision ebd436747f8f Review evidence[1][2][3][4][5][6][7][8][9]

Evidence confidence:Low — Mostly static review, author material or a limited demo; useful for discovery, not high-risk decisions.

See the full review method →

FAQ

Do I need to connect Google Ads or another ad API?
No. The documented Tier-1 path is a native ad-manager search-terms CSV supplied by the user; ad APIs and MCP are optional conveniences.
Can it work with clicks and cost but no conversion column?
No. It stops and asks for the conversion column instead of mining or negating based on clicks alone.
Will it directly change my ad account?
The source describes user-facing maintenance diffs and summaries. It does not state that the skill directly writes to or mutates an ad-platform account.

More skills from this repository

All from aaron-he-zhu/aaron-marketing-skills

Writing & Content

Paid Ads Campaign Architect

Designs paid account structure and reduces internal bidding and paid-organic overlap.

★ 3k FS 57 Use with care 13d ago
Data & Analysis

Paid Ads Account Auditor

Decide whether a paid-media account is safe to launch or scale using its own evidence.

★ 3k FS 59 Recommended 13d ago
Data & Analysis

Ad Experiment Designer

Design rigorous paid-ad A/B and incrementality tests, then determine whether results are statistically and practically meaningful.

★ 3k FS 59 Recommended 13d ago
Writing & Content

Ad Fatigue & Frequency Manager

Diagnose creative fatigue or audience saturation from frequency, CTR, and CVR trends, then choose rotate, widen, or hold.

★ 3k FS 58 Recommended 13d ago
Data & Analysis

Paid Ad Budget Pacing Monitor

Measure campaign spend against plan and flag when budget reallocation is warranted.

★ 3k FS 61 Recommended 13d ago
Data & Analysis

Paid Attribution Reconciler

Deduplicate paid conversions against order-ID truth and read incrementality.

★ 3k FS 59 Recommended 13d ago
Writing & Content

Paid Ads Audience Segment Builder

Turn your customer, CRM, or GA4 exports into seed, exclusion, and funnel-stage audiences for paid media.

★ 3k FS 56 Use with care 13d ago
Writing & Content

Paid Measurement Loop

Use a control and a fixed readback window to decide whether a paid-ad change should scale, keep testing, roll back, or remain unproven.

★ 3k FS 54 Use with care 13d ago
Writing & Content

Ad Creative Builder

Generate paid-ad variants that stay faithful to the landing page.

★ 3k FS 60 Recommended 13d ago
Writing & Content

Paid Ads Bid Strategy Planner

Choose a paid-media bidding model, set a defensible starting target, and protect the campaign’s learning phase.

★ 3k FS 58 Recommended 13d ago
Writing & Content

Paid Conversion Value Mapper

Map ad conversions to profit so tROAS optimizes contribution value instead of raw revenue or order count.

★ 3k FS 57 Use with care 13d ago
Writing & Content

Brand Safety Exclusion Manager

Build placement, network, content, and audience exclusion rules before paid campaigns go live.

★ 3k FS 56 Use with care 13d ago
Writing & Content

Influencer ROI Calculator

Calculate defensible influencer-campaign returns across ROI, ROAS, EMV, attribution, and lifetime value.

★ 3k FS 60 Recommended 13d ago
Writing & Content

Paid Ads Conversion Signal QA

Validate conversion events, UTMs, and cross-platform deduplication before paid campaigns launch or scale.

★ 3k FS 56 Use with care 13d ago
Writing & Content

Ad Landing Experience Checker

Preflight paid-traffic landing pages for message match, visibility, speed, form friction, and mobile readiness before launch.

★ 3k FS 55 Use with care 13d ago
Writing & Content

Product Feed Optimizer

Audit and repair Shopping and Performance Max product feeds for approvals, accurate listings, stronger titles, and feed-based campaign structure.

★ 3k FS 55 Use with care 13d ago
Writing & Content

SERP Analysis

Assess whether a query is realistically targetable by mapping its SERP structure, ranking patterns, and feature opportunities.

★ 3k FS 56 Use with care 13d ago
Writing & Content

Off-Site & AI Referral Analyzer

Audit backlink quality and measure traffic and conversions from AI assistants.

★ 3k FS 59 Recommended 13d ago
Writing & Content

Keyword Research & Content Planning

Discover, score, and cluster search terms into an actionable SEO/GEO content plan.

★ 3k FS 54 Use with care 13d ago
Writing & Content

On-Page SEO Checker

Diagnose single-page SEO problems and turn them into prioritized, actionable fixes.

★ 3k FS 54 Use with care 13d ago

Related skills