Builds account-level search-term reports with custom filters across six configurable date ranges so you can compare how queries trend over time.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/search-term-trends
Monitors your account for unexpected performance deviations by comparing today's stats against historical averages for the same weekday. Sends an alert email when impressions, clicks, conversions, or cost deviate beyond configurable thresholds.
One 0-100 score for the whole account, built from seven objective checks — tracking flatlines, disapprovals, serving status, budget losses, negative coverage and query hygiene — with the deduction breakdown as your fix list.
Finds the structural gaps that stop ad groups from serving: ad groups without active ads, without an RSA, without keywords, keyword-stuffed themes, and multi-RSA ad groups.
Generates a daily at-a-glance performance overview of your entire Google Ads account. Writes prior-day stats to a Google Sheet with running history and optionally emails a formatted comparison of yesterday vs. two days ago vs. one week ago.
Generates a Google Spreadsheet with ad performance stats segmented by headline and final URL, including distribution charts. Covers all ad types and optionally emails the report link weekly.
Maps every campaign's ad schedule and flags forgotten narrow serving windows, stale schedule bid modifiers that Smart Bidding ignores, and (optionally) campaigns running 24/7.
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.
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INCLUDE_INTENT | false |
SEND_ERROR_EMAIL_TO_SHABBA | false |
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.
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).