Search Term Trends Report
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.
Paul. Search Term Trends Report (Google Ads Script)
$49
FREE
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.
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.