Google Ads Scripts

Tags: keywords, opportunities, growth

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:

  1. Grab search terms based on your filters (these generally want to be successful search terms)
  2. 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 depend on goals but it’s generally wise to setup at least two rules:

  1. Successful search terms: high clicks, with conversions at a good ROI
  2. 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:

  1. Copy and paste an existing row
  2. Duplicate an existing output sheet
  3. Name the new sheet
  4. Enter the same name in the Output Sheet Name column so the script knows where to store opportunities
Read less


Keyword Discovery Script (with Fuzzy Match)

Lifetime access + updates


Instant Access

The script and template sheet will be available to download once payment is confirmed.


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.


Any-reason-refunds for 30 days

Purchases are refundableable for any reason within 30 days of purchase.

Install the script

The script will be available here after 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.

Learn more about our services or get in touch for a quote.

You Might Also Be Interested In

Members only

Auto Negative Keywords (Positive Keywords Script)

This hugely popular script will automatically add negative keywords based on “positive keywords” you define. Ad Group Level.

Members only

Rule Based Bid Updater / Pauser (Keywords & Products)

Setup rules to update keyword and product bids based on cost, conversions, ROAS, CPA, and more. This script also includes pause functionality.

Members only

Search Query N-Grams

Create 1 word, 2 word, 3 word and 4 word nGrams from search queries.