google-search-term-audit
Forensic Google Ads Search-term waste audit. Pareto-filters down to the 80% of spend that matters (campaign-level, then search-term-level), then flags wasteful terms using campaign-relative triggers:
SKILL.mdskills/google-search-term-audit/SKILL.md
GitHubGoogle Search Term Audit — Waste Forensics (Read-Only)
For the Google Ads account the user names, run a forensic search-term waste audit. Read-only — produces a suggested-exclusion list, never executes mutations.
If the user didn't name an account, list their connected accounts and ask which one to use.
Phase 1 — Data selection + Pareto filtering
- Campaign filter: Search campaigns only (exclude Shopping, PMax, Display).
- Campaign Pareto: Identify the campaigns that account for 80% of total Search spend.
- Search-term Pareto (per campaign): Within each selected campaign, pull the search terms that account for 80% of that campaign's spend.
This focuses the audit on the spend that actually matters.
Phase 2 — Waste identification (the "Red List")
For each high-spend search term, compare against its own campaign's averages (not account averages — relativity matters).
Trigger 1 — Low Engagement Red Flag
- Search term spend ≥ 5% of campaign total, AND
- Search-term CTR ≥ 40% lower than the specific campaign's average CTR
Trigger 2 — Low Conversion Red Flag
- Search term spend ≥ 8% of campaign total, AND
- Search-term CVR ≥ 40% lower than the specific campaign's average CVR (zero conversions counts)
Any term hitting either trigger goes on the Red List.
Phase 3 — Root-cause analysis
Review the Red List for common "waste words" — patterns that appear across multiple flagged terms. Examples:
"free [product]","how to [verb]","diy [thing]","jobs","salary","reviews of [competitor]"
If 3+ Red List terms share a common waste word, recommend a single root negative that covers them all instead of a list of individual negatives. Saves ad-group bloat.
Output
Section 1 — Red List table
| Search term | Campaign | Term spend | % of camp spend | Term CTR | Camp avg CTR | Term CVR | Camp avg CVR | Trigger | Suggested negative |
|---|
Sort by term spend descending. Cap at top 30.
Section 2 — Root negative recommendations
For each common waste word found:
Suggested root negative: "[word]" (phrase match) — covers N terms on the Red List, $X total wasted spend
Section 3 — Per-campaign exclusion summary
For each campaign with Red List terms:
- Total Red List spend
- Total Red List conversions
- Estimated monthly savings if all suggested negatives applied
- One-line take:
Recommend adding NN exact negatives + N phrase root negatives to [campaign]
End with: _All recommendations — no negatives added. Use the google-ads-search-execution skill to enact any subset of these exclusions._