Search Term Manager
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
Install the script
We're available for hire
Looking for a new script or an upgrade to an existing script?
With a decade of experience and a library of templates, we deliver professional scripts fast.
Prices are quoted on a per-project basis then ad-hoc work is $75/hour.
You Might Also Be Interested In
Members only
Automatically add negative keywords based on “positive keywords” you define. Pro version. Ad Group Level.
Members only
Automatically add negative keywords based on “positive keywords” you define.
Members only
Setup rules to update keyword and product bids based on cost, conversions, ROAS, CPA, and more. This script also includes pause functionality.