Archives every month's search terms into your own Google Sheet — a permanent query warehouse for multi-year trend analysis that survives Google's data trimming, restructures and agency changes.
by Dmytro Tonkikh·chiliad.io
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.
Google trims search term history and hides low-volume queries — what you can pull today is gone in two years. Search Term Archiver appends the last full month's search terms (with status, campaign, ad group, and full metrics) to a Google Sheet you own, once per month, never duplicating a month. Over time it becomes the asset Google won't give you: a multi-year query warehouse for long-horizon trend analysis, n-grams over years, and evidence that survives account restructures.
| Variable | Default |
|---|---|
SPREADSHEET_URL | (empty) |
SHEET_NAME | archive |
MAX_ROWS_PER_MONTH | 20000 |
MIN_CLICKS | 1 |
=== Search Term Archiver === Archived 18342 search terms for 2026-06. Archive: https://docs.google.com/spreadsheets/d/...
At 20k rows/month × 10 columns, the sheet holds roughly 4 years before nearing Google Sheets' cell ceiling — start a second spreadsheet then, or lower the cap. The month-dedupe checks the last archived row, so runs are idempotent: schedule it and forget it. Analyze the archive with pivot tables or plug it into Looker Studio.