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
View the Google Sheet Template
Lifetime access + updates
Delivery
Instant Access
The script and template sheet will be available to download once payment is confirmed.
Payment
Buy for Life
Purchases are for the original, editable source code and include lifetime updates. By purchasing, you agree not to resell or distribute the script.
Refunds
Any-reason-refunds for 30 days
Purchases are refundableable for any reason within 30 days of purchase.
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.