Google Ads Scripts

Tags: google shopping, products, item ids, trends, reports

Google Shopping Product Trends Report - New in Feb 2024! 🚀🌟

Create multiple Account-level Google Shopping product reports based on Item ID and Campaign filters + choose your own (6 total) date ranges to compare.

  • What this script does: Product 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.

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

Don't forget you can install the same script multiple times, just update the Sheet Urls in each.

What if I have suggestions?

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

Read less


Barry. Google Shopping Product 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.