Search Term Trends Report
2 installs
Builds account-level search-term reports with custom filters across six configurable date ranges so you can compare how queries trend over time.
search terms
reporting
trends
google sheets
date ranges
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/search-term-trends
Overview
Generates a search-term report in Google Sheets showing metrics across six date windows side by side, so rising and falling queries are obvious at a glance. Dimensions and metrics are configured in the sheet template. Use it for weekly trend reviews and to spot emerging demand or decay.
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 the date ranges and filters 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
Report built for account 123-456-7890. Six date ranges compared (e.g. last 7 / prev 7 / last 30 / ...). Search-term rows written to the report tab with per-range metrics.
Notes
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template; date ranges and filters are configured there. SEND_ERROR_EMAIL_TO_SHABBA phones home when enabled (off by default).