This script is everything you need for reviewing search terms and deciding to:
- Ignore them - anything marked "ignored" won't appear in the reports again
- Add Negative Keywords - cut wasted spend by adding negative keywords
- Add Keywords - add your best performing search terms as keywords
Adding new rules
There are two steps to adding new rules:
1) Duplicate (copy and paste) an existing row and update its settings
2) Duplicate a sheet and name it accordingly
Note the "Output Sheet Name" needs to match the name of the sheet. Numbering the sheets is often easiest.
Rules we recommend
Every account is different, but as a general rule we recommend setting up the following rules.
Remember these can be duplicated across multiple date ranges.
Cream of the crop / best performers.
Rule: Strong CPA/ROAS AND High Clicks/Conversions/Conversion Value.
Reason: Find potential keywords aka positive keywords.
Zero converters.
Rule: Conversions < 0.01 AND High Clicks.
Reason: Find potential negative keywords. Good option as an alert.
Poor performers (converters).
Rule: Conversions > 0 AND High Clicks AND poor CPA/ROAS
Reason: Find potential negative keywords. Good option as an alert.
Zero Clicks
Rule: Impressions > 100 AND Clicks < 1
Reason: Low Ctr can be a sign of irrelevant search terms. Find potential negative keywords especially with a view to increase overall Ctr
Poor Ctr
Rule: Impressions > 100 AND Clicks > 0.99 AND Ctr < 0.5%
Reason: Low Ctr can be a sign of irrelevant search terms. Find potential negative keywords especially with a view to increase overall Ctr
Negative Keyword Finder (with Positive Keyword & Ignore support)
$39
FREE
We're available for hire
Looking for a new script or an upgrade to an existing script? Perhaps a Google Ads API solution or your very own web app?
With a decade of experience and a library of templates, we deliver professional solutions fast.
Prices are quoted on a per-project basis.
You Might Also Be Interested In
This hugely popular script will automatically add negative keywords based on “positive keywords” you define. Ad Group Level.
Setup rules to update keyword and product bids based on cost, conversions, ROAS, CPA, and more. This script also includes pause functionality.
Create 1 word, 2 word, 3 word and 4 word nGrams from search queries.