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)

$49

  FREE

View the Google Sheet Template

Lifetime access + updates

Install the script

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

Auto Negative Keywords (Positive Keywords Script)

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

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.

Search Query N-Grams

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


Join my Google Ads Automation Newsletter

Subscribe and I'll send the odd email when I publish new scripts & tools

    We respect your privacy. Unsubscribe at any time.