Keyword Discovery Script (with Fuzzy Match)
This script will surface successful search terms which havenât yet been added as keywords. Itâs great for finding new Search opportunities.
There are two main steps:
- Grab search terms based on your filters (these generally want to be successful search terms)
- Populate the sheet (and optionally send an alert) if any of the search terms are NOT in as keywords
The script can be run manually as part of your internal processes or on a schedule. Enable notifications to receive an email when there are new opportunities.
Using the advanced filters, you can define success however you like. That includes filtering search terms based on text they contain (or donât contain).
Introducing Fuzzy Matching
The first version of this script was producing a lot of accurate but unhelpful results.
If âpurple dog collarsâ has been added as a keyword then âpurple dog collarâ isnât much of an opportunity thanks to close variant matching.
Thatâs where fuzzy matching comes in. Similar to close variant matching, the script wonât report opportunities (or alert you) if thereâs an existing, similar keyword.
Here are some examples:
Search Term | Keyword | Fuzzy Match Score |
---|---|---|
dog collars | dog collar | 91% |
purple dog collars | dog collars | 61% |
purple dog collars | purple dog collar | 94% |
purple dog collars | pink dog collars | 72% |
cat collars | dog collar | 63% |
stories for dogs | story for dogs | 81% |
Settings
Settings depend on goals but itâs generally wise to setup at least two rules:
- Successful search terms: high clicks, with conversions at a good ROI
- High clicks: if theyâre relevant, adding search terms as keywords can help keep an eye on performance and reveal Quality Score metrics
Adding new rules
Adding new rules is simple:
- Copy and paste an existing row
- Duplicate an existing output sheet
- Name the new sheet
- Enter the same name in the Output Sheet Name column so the script knows where to store opportunities
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.