Google Ads Scripts

Tags: search terms, trends, reports

Search Term Trends Report - New in Feb 2024! 🚀🌟

Create multiple Account-level Search Term reports based on Search Term, Campaign and Metric filters + choose your own (6 total) date ranges to compare.

  • What this script does: Search Term stats as an average across 6 different time periods
  • As an average? E.g. if the lookback window (days) is 365, it's the total clicks across 365 days (to yesterday) divided by 365
  • Recommended Schedule: Hourly if looking at today, otherwise daily

To create a new report, just duplicate an existing report tab then add your settings.

How many reports can I add?

The only limit is the script runtime of 30 minutes and the capacity of Google Sheets (10m cells max, but they can become frustratingly slow before that point).

Should the script timeout, either reduce the number of reports or add further Metric or Campaign filters.

Don't forget you can install the same script multiple times, just use a different Sheet Url each time.

What if I have suggestions?

Please let us know! Hearing your pain points in the number one way we can make improvements.

Read less


Paul. Search Term Trends Report (Google Ads Script)

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.