Detects broken conversion tracking before it wrecks Smart Bidding: flags conversion actions that flatlined vs their baseline, whole-account spend with zero conversions, and setups where nothing counts toward the Conversions column.
by Jordan Lagan (concept), Chiliad (rewrite)·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.
Broken conversion tracking is the most expensive silent failure in PPC: campaigns keep spending while Smart Bidding optimizes toward nothing. This script compares each conversion action's recent window against its baseline window and alerts on three conditions: an established action recording zero recent conversions (the signature of a broken tag or import), the whole account spending with zero conversions recorded, and setups where no enabled action counts toward the 'Conversions' column. The email fires only when something is wrong — silence means healthy.
| Variable | Default |
|---|---|
RECENT_DAYS | 7 |
BASELINE_DAYS | 30 |
MIN_BASELINE_CONVERSIONS | 5 |
EMAIL_ADDRESS | (empty) |
=== Conversion Tracking Health Check === Enabled conversion actions: 6 (3 counting toward Conversions) Recent window (2026-07-08 to 2026-07-14): 84.0 conversions, spend 3120.40 Baseline window (2026-06-08 to 2026-07-07): 361.5 conversions [PROBLEM] FLATLINED ACTION: "Purchase — website" recorded 118.0 conversions in the baseline window (2026-06-08 to 2026-07-07) but ZERO in the last 7 days. Check the tag, import, or the page it fires on. Email sent to you@example.com
Conversion data lags: website tags up to ~24h, offline imports much longer — verify before declaring an action dead, but always verify quickly. Uses all-conversions per action, so secondary actions are monitored too. On very low-volume accounts, raise RECENT_DAYS to avoid noise.