Google Shopping Product Trends Report
2 installs
Generates account-level Shopping reports filtered by Item ID and campaign across six customizable date ranges to reveal product-level trends.
shopping
reporting
trends
products
google sheets
item id
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/google-shopping-trends
Overview
The Shopping counterpart to the search-term trends report: pulls product performance by Item ID and campaign across six date windows so you can see which products are gaining or losing traction. Output lands in a Google Sheet template. Use it for weekly merchandising and bidding reviews.
Setup
- 1Copy the Google Sheet template linked on the source page.
- 2In Google Ads, go to Tools → Bulk Actions → Scripts.
- 3Click + to create a new script and paste the code below.
- 4Set INPUT_SHEET_URL. Configure report dimensions and date ranges in the sheet.
- 5Authorize, preview, then schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INCLUDE_INTENT | false |
SEND_ERROR_EMAIL_TO_SHABBA | false |
Expected Output
Shopping report built for account 123-456-7890. Products segmented by Item ID + campaign across six date ranges. Rows written to the report tab.
Notes
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template; report structure is configured there. SEND_ERROR_EMAIL_TO_SHABBA phones home when enabled (off by default).