ad-negative-keywords
Build and maintain negative keyword lists from search term reports to cut wasted ad spend in paid search - n-gram query mining to surface irrelevant search terms, the right negative match types and exclusion levels (account, shared list, campaign, ad group), and a review cadence that avoids overblocking queries that convert. Use whenever the user mentions a search term or search query report, irrelevant clicks, junk traffic, wasted ad spend, or wants to exclude or block keywords - even if they never say 'negative keywords'. Covers B2B lead gen and B2C/e-commerce; needs the account's query data. Do NOT use for account-wide underperformance with no query-level evidence - use mbfinotti/advertising-skills@ad-account-diagnostic instead.
Overview
Negative Keywords
Build and maintain a negative keyword list from search term reports, so paid-search budget stops leaking to irrelevant queries - without blocking the queries that convert.
The mechanics - match types, exclusion levels, thresholds, cadence - are identical for B2B lead gen and B2C/e-commerce. Two things differ by segment:
- Which junk categories dominate (see taxonomy).
- The decision data: B2B's sparse conversions force click/cost gates, B2C volume allows conversion-based gates.
Evidence gate
- Never propose specific negative keywords for a live account without its search term report (also called search query report).
- Missing report → request an export, explain the overblocking review below, and name zero candidate negatives in the meantime.
- Exception: a brand-new campaign with no history may get a starter exclusion list - label it "pre-launch starter, review against real queries after 7-14 days".
A list invented from imagination has no evidence of what actually matches, and its cost, blocked converting queries, stays invisible.
Clarifying questions
Ask once, briefly, before analyzing. Skip anything already answered. This is a tactical pass, not an interview.
- What counts as a conversion, and what is the target CPA or ROAS?
- What date range does the report cover, and roughly what did the account spend over it?
- What CPC range does the account run? (Sets the click threshold.)
- Which queries or themes must never be blocked - brand terms, converting themes, deliberate competitor bidding?
- Which levels can you edit: account/shared list, campaign, ad group?
- By what date must the saving show up in the account's numbers?
- Is this a one-off cleanup, or a standing maintenance job you want to keep compounding?
- What is the effort ceiling per pass - minutes available, who else has to approve a change, and can you reverse an account-level exclusion yourself?
Re-rank this skill's two option menus (exclusion level, cadence) against those answers:
- A hard date promotes the fast local rungs - ad group or campaign negatives applied in this pass.
- A standing-maintenance mandate promotes the compounding rungs - shared exclusion lists plus the quarterly conflict sweep.
- A tight effort ceiling or a slow approval path demotes account-level exclusions, which cost the most to audit and the most to reverse.
Every ordering below is a default, not a law: it shifts with the account and with who executes it. Re-rank against what you already know about this user - an in-house scripting ability makes the n-gram pass and the conflict sweep far cheaper than the default order assumes, and a shared list already built and attached makes that rung near-free. Where an answer rules a rung out entirely rather than moving it, delete it by name (see step 7).
Core mechanics
Read before adding anything - most negative-keyword damage traces to these rules.
- Positive keywords expand automatically to close variants.
- Negative keywords do NOT expand to close variants. Add plurals, synonyms, and word stems as separate negatives yourself.
- Casing and misspellings are matched automatically.
- Negative match types, ranked by waste blocked per unit of overblocking risk:
phrase > exact > broad.- Phrase (default) - blocks the words in that order; extra words around them still block. Best ratio: one entry kills a whole junk theme, and a wrong call costs that theme, not the account.
- Exact - blocks only that literal query. Safest and narrowest: use it for a surgical block next to converting siblings. It needs one entry per variant, so a list built mostly of exacts becomes a standing job.
- Broad - blocks any search containing ALL the words, in any order. Widest reach and widest blast radius: one bad broad negative silently zeroes a converting theme. Reserve for terms that are wrong in every recombination.
- Axes disagree:
- reach:
broad > phrase > exact - overblocking risk:
broad > phrase > exact - upkeep effort:
exact > phrase > broad
- reach:
- Move up to broad only when the term is wrong in every recombination AND the conflict check against active keywords comes back clean. Move down to exact when the term sits one word away from a converting query.
- Check the platform's default match type when adding from a report - some default to exact, which blocks the fewest searches. Switch to phrase deliberately.
- Negatives always beat positives: a blocked active keyword still displays as active but never enters the auction.
Workflow
- Pull the search term report for the lookback window.
- 7-14 days for a recurring weekly pass.
- 30-90 days for a first cleanup or a low-volume account.
- Sort by cost descending. Filter to zero conversions. This surfaces the spend producing nothing.
- Mark a term as a candidate when it crosses either gate:
- 15-20 clicks with zero conversions (tighten to 10-12 when CPC is high, roughly $3+).
- Spend of 1.5-2x target CPA with zero conversions, regardless of click count.
- Low-volume B2B: conversion data is too sparse to gate on - rely on the click/cost gates plus clear irrelevance from the taxonomy.
- Classify each candidate with the taxonomy below. A merely uncertain term is not a candidate - leave it to collect more data.
- Run the overblocking review on every candidate:
- Ever converted in account history (the term or a close sibling)? Do not negate.
- Would the chosen match type also block a plausible converting query? Narrow the match type or wording.
- Conflicts with an active keyword anywhere in the account? The negative silently zeroes that keyword.
- Set the match type per the ranking in Core mechanics, then expand variants manually: plural/singular, synonym, and stem forms.
- Pick the level, ranked by waste blocked per unit of blast radius:
shared exclusion list > ad group or campaign > account.- Shared exclusion list (default) - for a recurring theme across campaigns. Costs about an hour once: name it by taxonomy category, attach it, document it. After that every new campaign inherits it by attachment, so the payoff compounds. Reversible by detaching, and the blast radius stops at what you attached.
- Ad group or campaign - for a query genuinely local to one container. Near-zero effort, near-zero blast radius, and near-zero durability: the same term resurfaces in the next campaign and gets negated again from scratch.
- Account level - for universal disqualifiers and brand-safety terms only. Widest reach, and the worst reversibility of the three: it suppresses everywhere, including campaigns built later by someone who never saw the list, and nothing in those campaigns points back at it.
- Axes disagree:
- reach:
account > shared list > ad group - setup effort:
shared list > account == ad group - effort to audit later:
account > shared list > ad group - reversibility:
ad group > shared list > account
- reach:
- Account and ad group tie on setup effort because both are the same act - paste the term into one container's negative list, near-zero either way. Everything that separates them lands after setup, on reach, audit and reversal.
- What the efficiency order starves: the account-level exclusion. It buys the widest reach of the three and it is the one rung nobody can audit or reverse cheaply, so a ratio always picks something smaller. Promote it anyway for a universal disqualifier or a brand-safety term - the terms whose cost of leaking once is higher than the cost of an over-wide block - and the third time the same term needs negating in a new container.
- Move down when the term is only wrong for one product line, geography, or campaign intent.
- Delete, don't demote: with no edit rights at account level, that rung leaves this user's menu and is reported as deleted, not ranked last. Same for the shared list on a platform that has no shared-list object at all - plan on per-container negatives and a written re-application step, rather than a rung the account cannot express.
- Deliver in the output shape below. On a live account, present a draft for approval - never mass-apply silently.
- Log the change (date, terms, level, match type, reason) and schedule the next pass per the cadence.
Query mining for hidden terms
Platforms hide a large share of search terms - practitioner measurements center around 40% of spend. Token-level mining recovers signal the report no longer shows:
- Export all visible search terms with cost, clicks, conversions.
- Tokenize each query into unigrams, bigrams, and trigrams.
- Aggregate cost and conversions per token across every query containing it.
- Sort tokens by cost descending, filter zero conversions, apply the same gates as the main workflow.
- Negate bad tokens as phrase negatives. Flag high-converting tokens as expansion leads for the account owner - positive keyword research is out of this skill's scope.
- Can run scripts: a short tokenizer over the export is the fast path.
- Can't run scripts: do the same aggregation in a spreadsheet - split words into columns, pivot, sum cost per token. Same logic, smaller scale.
These two are deliberately unranked: capability decides, not efficiency. The tokenizer is only cheaper for someone who already writes scripts, and the spreadsheet produces the identical aggregation.
Cadence
Axes disagree:
- value (waste caught per hour):
recurring search-term pass > quarterly conflict sweep > monthly list audit - standing cost:
recurring pass > monthly list audit > quarterly conflict sweep
Get the top rung running before adding either other one. The sweep is the cheapest commitment on the page and still outranks the audit on value.
- Recurring search-term pass - budget 30-45 minutes.
- Weekly, 7-14 day lookback: higher-spend accounts (~$10k+/month), or anything new or in a learning phase.
- Bi-weekly to monthly: stable lower-spend accounts.
- Several near-empty passes in a row → lengthen the interval.
- Quarterly conflict sweep - a full conflict check against active keywords, plus the match-type review (are broad negatives over-blocking?). Four short runs a year that catch the most expensive failure in this skill: a negative silently zeroing a keyword that was serving.
- Monthly list audit - prune stale entries from shared exclusion lists, merge duplicates. Hygiene only: defer it while the recurring pass is still surfacing real waste.
Irrelevant-query taxonomy
Same categories for B2B and B2C; the weighting differs.
| Category | Signals | Hits hardest |
|---|---|---|
| Competitor | competitor brand names | both - strategy call, confirm before negating |
| Job seeker | jobs, careers, salary, hiring, intern, resume | B2B |
| DIY / free intent | free, diy, template, cheap, open source | B2B |
| Informational | what is, how to, meaning, tutorial, course, pdf | B2B |
| Wrong geography | cities/countries not served | both |
| Wrong product tier | used, refurbished, wholesale, mini, for kids, replacement | B2C |
| Comparison / research | reviews, best, vs, comparison | both - often early-funnel, not junk; judge per account |
| Unsafe / brand-unsafe | adult, illegal, tragedy-adjacent | both |
- Treat competitor and comparison terms as strategy calls, never automatic junk - some accounts bid them deliberately. Ask first.
- B2C/e-commerce adds attribute mismatches (size, color, gender, model) the catalog can't serve.
Output shape
Deliver every pass as:
- Summary: spend analyzed, wasted spend found (cost on zero-conversion candidates), % of total, and any exclusion level deleted from this account's menu with the constraint that deleted it.
- Additions table: term | match type | level | evidence (clicks, cost, conversions) | category | variants added.
- Do-not-negate list: candidates that failed the overblocking review, with the reason.
- Watchlist: uncertain terms left to collect data, each with the gate that would trip it.
- Next review date.
See references/worked-example.md for a filled-in B2B pass and an e-commerce pass, plus a negative example of what not to do.
Failure modes
- Overblocking: every negative narrows reach, and a healthy account's true waste is often only 4-8% of spend. Negate the clearly wrong, never the merely uncertain.
- Negating a converting term: the single most expensive mistake - the overblocking review exists for it. Check conversion history first, always.
- Forgetting the close-variant asymmetry: a negative blocks "running shoes" but not "running shoe". Lists without manual plural/synonym variants quietly leak.
- Default match-type trap: adding from the report at a default of exact blocks almost nothing - the list looks maintained while the waste continues.
- Conflicts with active keywords: a negative above an active keyword silently zeroes it. Run the quarterly sweep. Re-check whenever adding broad negatives.
- Volume worship: more negatives is not better. A large published study of account-level exclusions found near-zero CPA/ROAS difference versus accounts without them - where and how negatives are applied matters more than how many.
- Query-length blind spot: very long searches can slip past negatives positioned late in the phrase - never rely on negatives alone for brand safety.
Objective and measurement
- Primary KPI: wasted spend share = cost on zero-conversion irrelevant terms / total analyzed spend, recomputed each pass on the same lookback window length.
- Pass threshold: after 90 days on cadence, wasted spend share under 10% of non-brand spend AND zero converting terms blocked (verify against the change log and conversion history).
- Secondary KPIs:
- CPA/ROAS delta across adjacent equal-length windows.
- Reclaimed non-brand spend - practitioners report 10-20% reclaimed within 90 days on previously unmanaged accounts.
- Already at 4-8% wasted share? The account is near its practical floor: shift effort to the conflict sweep and watchlist, and lengthen the cadence rather than forcing new exclusions.
References
- references/worked-example.md - worked B2B and e-commerce passes in the output shape, plus a negative example.
- references/platform-notes.md - optional vendor-specific notes (defaults, limits, keywordless surfaces). Load only when the user names their platform.
- mbfinotti/advertising-skills@ad-bidding-strategy - bid strategy decisions.
- mbfinotti/advertising-skills@ad-spend-allocation - budget allocation across campaigns.
- mbfinotti/advertising-skills@ad-budget-pacing - campaign pacing and spend distribution.
- mbfinotti/advertising-skills@ad-account-diagnostic - account-wide underperformance diagnosis.
- mbfinotti/advertising-skills@paid-landing-page-audit - landing page optimization.
- mbfinotti/advertising-skills@ad-copy-variants - ad copy and creative testing.
Files 4 files
Install it by hand
Deska runs this for you, for every agent you pick. To run it yourself in a terminal:
npx skills add mbfinotti/advertising-skills --skill ad-negative-keywordsMore from mbfinotti
- affiliate-commission-structurembfinottiDesign the commission and payout structure of a commission-based affiliate program: rate model (revenue share, flat CPA, hybrid), rate level derived from unit economics, payout tiers, recurring duration and caps, attribution/cookie window, validation, clawback, and payment terms. Covers B2B SaaS and B2C ecommerce programs with professional affiliates. Use whenever the user mentions an affiliate commission rate, commission tiers, lifetime vs 12-month recurring commission, a cookie window, or a rate-card migration, even if they only ask how much to pay affiliates. Do NOT use for end-customer refer-a-friend rewards - use mbfinotti/partnerships-skills@referral-incentive-design instead. Terms drafting, payout auditing, and fraud rules are separate skills.3,700 installs on skills.sh0
- affiliate-onboarding-sequencembfinottiDesign the onboarding sequence that carries a newly approved affiliate from approval to first tracked conversion - touch plan (timing, channel, one action per touch), asset kit, time-boxed activation nudge, and never-activated follow-up branch. Covers B2B SaaS partner programs and B2C ecommerce affiliate programs. Use whenever the user mentions affiliate onboarding, an affiliate welcome email series, affiliate activation, a new-affiliate ramp, partner activation emails, or approved affiliates who never send a click or a sale, even if they never say onboarding. Starts at approval - to pitch affiliates who have not joined yet use mbfinotti/partnerships-skills@affiliate-recruitment-outreach.3,700 installs on skills.sh0
- affiliate-payout-auditmbfinottiAudit an affiliate or partner commission payout run for accuracy before money is disbursed - per-line rate and tier recomputation, double-counted conversions, clawback and validation windows, period cutoff, currency, rounding, and tax-form status, delivered as an audit report with severities and recommended holds. Covers B2B SaaS recurring revenue-share and B2C ecommerce order-level CPA programs. Use whenever the user mentions an affiliate payout audit, commission accuracy, payout reconciliation, overpaid or underpaid affiliates, or a pre-disbursement review, even if they never say audit. Do NOT use for spotting fraudulent affiliates - use mbfinotti/partnerships-skills@affiliate-fraud-detection instead.3,700 installs on skills.sh0
- affiliate-program-termsmbfinottiDraft the terms and conditions an affiliate accepts when joining a commission-based program - the affiliate program agreement, with the canonical clause set, prohibited-tactics clauses and enforcement ladder, commission validation, clawback and termination mechanics, and jurisdiction overlays (FTC endorsement rules, EU P2B, UK ASA/CAP, GDPR roles). Output is a clause-complete draft flagged for mandatory legal review, for B2B SaaS and B2C ecommerce alike. Use whenever the user mentions affiliate program terms, an affiliate agreement, prohibited tactics, or a brand-bidding policy, even if they only ask what affiliates must agree to. Do NOT use for reviewing a published post's disclosure label - use mbfinotti/partnerships-skills@affiliate-disclosure-compliance instead.3,700 installs on skills.sh0
- alliance-prioritizationmbfinottiRank named candidate strategic alliances and technology partnerships by expected value, effort, and risk, to decide where partner-team capacity goes - must-pass screens, a weighted alliance scorecard with sensitivity analysis, co-innovation and platform-dependency risk checks, a ranked shortlist, and a go/no-go recommendation memo. Covers B2B tech alliances and B2C brand and creator partnerships. Use whenever the user mentions alliance prioritization, partnership ranking, partner shortlisting, or asks which of several named partners deserves investment, even if they never say prioritization. Portfolio-level comparison only. Do NOT use for modeling one partner's P&L - use mbfinotti/partnerships-skills@partner-economics instead.3,700 installs on skills.sh0