# Analyze Search Terms for Better Paid Campaigns

Paid-search exports can hide converting queries and costly irrelevant traffic. This skill turns an export into keyword opportunities, negative keywords, n-gram waste findings, and a reviewable maintenance diff.

## Install

```bash
npx skillstore add aaron-he-zhu/search-term-miner
```

## Metadata

- Status: approved
- Slug: aaron-he-zhu-search-term-miner
- Version: 19.0.0
- Author version: 19.0.0
- Skillstore revision: r2
- Version status: valid
- Tree hash: d3ff55bb80eb589b32a1b948c306865cf43b8f7d15184da485674619b203ba81
- Author: aaron-he-zhu
- GitHub username: aaron-he-zhu
- License: Apache-2.0
- Repository: https://github.com/aaron-he-zhu/aaron-marketing-skills/tree/main/ad/research/search-term-miner
- Ref: 0715a6e09ea875c8e28cb705ce87cc83045e69c1
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, network, filesystem
- Quality score: 81
- Quality tier: silver
- Public page: https://skillstore.pages.dev/skills/aaron-he-zhu-search-term-miner
- Manifest: https://skillstore.pages.dev/api/skills/aaron-he-zhu-search-term-miner/manifest

## Capabilities

- Extract converting search queries as candidate keywords or ad-group themes.
- Identify search terms with spend and no conversions for negative-keyword review.
- Summarize recurring waste patterns with an n-gram analysis.
- Create an add, negate, or move maintenance diff from the export.
- Use query, impression, click, cost, conversion, and conversion-value fields when available.
- Save a reusable mining summary only after user confirmation.

## Use Cases

- Review monthly search-term waste: Find costly non-converting queries and produce a negative-keyword review list.
- Discover new keyword themes: Turn proven converting queries into candidate keywords and ad-group themes.
- Prepare a client optimization report: Create a clear maintenance diff and n-gram waste summary from a client export.

## Prompt Templates

### Beginner: review an export

```
Analyze this search-terms export. List candidate keywords, negative keywords for review, and the evidence for each recommendation.
```

### Intermediate: find waste patterns

```
Mine this export for queries with spend but no conversions. Create an n-gram waste report and group the proposed negatives by theme.
```

### Advanced: build a maintenance diff

```
Use this search-terms export to create a maintenance diff with Add, Negate, and Move sections. Include query metrics and state any assumptions.
```

### Advanced: compare periods

```
Compare these two search-terms exports. Identify new converting themes, emerging waste, and changes to the negative-keyword review list.
```

## Limitations

- It relies on the accuracy and completeness of the supplied search-terms export.
- It recommends actions but does not apply changes in an advertising platform.
- It does not design account structure, allocate budgets, or calculate a final account-quality score.
- Sparse conversion data can make negative-keyword recommendations less reliable.

## Best Practices

- Export sufficient date range and include cost, conversion, and conversion-value columns when possible.
- Review negative-keyword recommendations for relevance before applying them.
- Use consistent campaign and match-type context when interpreting query performance.

## Anti Patterns

- Do not add every non-converting query as a negative keyword without checking volume and intent.
- Do not treat a small export as conclusive evidence of long-term performance.
- Do not use this skill as a substitute for budget allocation or account-structure planning.

## Security Audit

- Audited at: 2026-07-27T11:42:53.351\+00:00
- Summary: All 35 static detections are false positives caused by Markdown backticks, relative documentation links, and repository metadata. The skill describes analysis of a user-provided paid-search export and requires confirmation before saving a workspace summary. No executable command, network request, path traversal operation, reconnaissance behavior, or prompt injection attempt was found.

## Stats

- Views: 1
- Downloads: 4
- Favorites: 0
- Popularity score: 0