Compares yesterday's average CPC per campaign against its 30-day baseline and alerts on spikes — the earliest visible symptom of a new competitor, broad-match drift, or a bid change gone wrong.
by Dmytro Tonkikh·chiliad.io
One table of every campaign's bidding strategy with the two flags that matter: Manual CPC campaigns with enough volume for Smart Bidding, and target-based campaigns too data-starved to learn.
Finds the reallocation hiding in plain sight: efficient campaigns losing volume to budget caps, idle budgets that could fund them, and full budgets funding poor CPAs.
Runs campaigns only inside their date windows — Black Friday starts at 00:00 without anyone staying up, sales end exactly on time, weekend campaigns run only on weekends.
Compares actual spend against your daily budget settings over 1, 7 and 28 days and alerts by email + Google Sheet when Google overdelivers beyond your thresholds.
Compares actual daily spend against the expected pace based on time of day. Logs over- and under-pacing campaigns and can auto-pause overspenders to protect your budget.
Analyses 30 days of hourly performance data across campaigns and calculates recommended ad schedule bid adjustments. Shows the full breakdown per hour before you choose to apply.
A sudden CPC jump is the earliest visible symptom of several expensive things: a competitor entering the auction, broad match drifting into pricier queries, a bid target change gone wrong, or seasonality arriving early. CPC Spike Alert compares yesterday's average CPC per campaign against its trailing 30-day baseline and emails when any campaign exceeds the baseline by your spike factor — with the estimated extra cost quantified. Catching it the next morning costs one email; catching it in the monthly report costs a month of expensive clicks.
| Variable | Default |
|---|---|
SPIKE_FACTOR | 1.5 |
MIN_CLICKS | 20 |
EMAIL_ADDRESS | (empty) |
[OK] Brand — Exact - yesterday CPC 0.42 vs baseline 0.39 === CPC Spike Alert (yesterday vs 30-day baseline) === Campaigns checked: 12 Spikes: 1 Generic — Broad yesterday CPC: 2.84 baseline: 1.61 (x1.8, ~412.30 extra on 335 clicks) Email sent to you@example.com
Low-click campaigns produce noisy CPCs — the MIN_CLICKS filter is what keeps this alert trustworthy; raise it if you get false alarms. When it fires, check in order: Auction Insights, the search terms report, recent bid/target changes, then the calendar.