Skip to main content

Worked example · every step free

One dataset, end to end

This page takes one messy search-terms export all the way to a governed weekly automation — the same journey the training path teaches, compressed into a ten-minute read. Every number is real: it’s the sample dataset built into the free Waste Finder, so you can press one button there and follow along live.

10-minute readReal numbersNo signup

The export you start with.

A month of search terms from one mid-sized account: 20 rows, $3,716.00 of spend. In Google Ads it’s Campaigns → Insights & reports → Search terms → Download CSV.

It looks harmless in a spreadsheet — which is exactly how waste survives. Nothing about a CSV tells you which rows never converted, and nobody rereads last month’s export on a busy Tuesday.

Search term,Clicks,Cost,Conversions campaign automation software,64,412.80,9 cheap free campaign tools,58,203.40,0 automation software download crack,21,88.20,0 best ppc automation platform,47,391.10,6 marketing automation jobs,83,176.90,0 free ppc audit template,66,148.50,2 what is campaign automation,39,84.10,1 automation agency near me,28,167.30,4 diy marketing automation course free,44,132.60,0 ppc management pricing,52,311.40,5 marketing automation salary,71,159.80,0 campaign automation reviews,25,142.70,3 free marketing tools for students,49,98.30,0 ppc audit service,31,228.60,4 automation software tutorial youtube,37,79.40,0 google ads automation script free,55,171.20,0 enterprise campaign automation,18,296.50,3 marketing automation internship,42,101.10,0 ppc waste analysis,22,134.90,2 automate google ads reporting,35,187.20,3

The same data is behind the “Try with sample data” button in the Waste Finder.

Two minutes of analysis.

Paste, one click. The finder flags every term that spent money and never converted, totals the damage, and ranks the recurring words behind it.

A third of this account’s spend produced nothing at all. That ratio is not an outlier — independent audits routinely put wasted paid spend at 10–30%. The point of automation isn’t that the analysis is hard; it’s that nobody does it every week by hand.

$1,210.90Spend with zero conversions
32.6%Share of total spend wasted
9Zero-conversion terms
460Clicks that led nowhere
Search termCostClicksConv.
cheap free campaign tools$203.40580
marketing automation jobs$176.90830
google ads automation script free$171.20550
marketing automation salary$159.80710
diy marketing automation course free$132.60440
marketing automation internship$101.10420
free marketing tools for students$98.30490
automation software download crack$88.20210
automation software tutorial youtube$79.40370

Where human judgment earns its keep.

The finder ranks five recurring words by the money behind them — and two of the five are traps.

“automation” and “marketing” carry the most wasted cost, but they’re this account’s own category. Add them as negatives and you switch off your own demand. The real signal is “free” — $605.50 of intent that was never going to pay — plus the career cluster (jobs, salary, internship) and the learner cluster (tutorial, course, students, crack) sitting in plain sight in the offenders table.

Six negatives cover all nine wasted terms — the full $1,210.90. This is the division of labour the whole practice is built on: the machine does the reading, the human makes the call. The guardrails in the next step turn that sentence into configuration.

What the tool ranks

"automation" ($909.20 across 7 terms) ← your own category — keep "marketing" ($668.70 across 5 terms) ← your own category — keep "free" ($605.50 across 4 terms) ← negative "tools" ($301.70 across 2 terms) ← check the underlying terms "software" ($167.60 across 2 terms) ← check the underlying terms

What a human ships

"free" "jobs" "salary" "internship" "crack" "tutorial" # 6 negatives · cover all 9 zero-conversion terms # $1,210.90 per report period cut off at the source

Guardrails before the loop runs.

Before this analysis is allowed to repeat itself — and act — the boundaries get written down. Not as policy prose: as a config the automation reads.

For an account spending about $124 a day, the Guardrail Generator produces something like the excerpt here in under a minute. The three non-negotiables at the bottom never change, whatever the numbers: every action logged as Trigger → Action → Impact, reversible, attributable.

## Hard limits (the system may never exceed these) - daily_spend_cap: $150 per account per day - max_budget_shift_per_action: 15% of the source budget - max_bid_change_per_action: 20% ## Approval threshold (ask a human first) - any single action moving more than $100 - approvals_route_to: you@yourcompany.com ## Quiet hours - 22:00–06:00 local time, no automated changes ## Exclusions (never touch) - brand campaign ## Every action, no exceptions - logged as: trigger → action → impact, with timestamp - reversible: the undo path is written down first - attributable: which rule fired, and why

The Monday-morning loop.

Now the manual pass becomes an automation: same read, same ranking, every week, without being asked — and a human still approves anything that moves money.

The free PPC Intelligence build guide shows both ways to build it: Path A on scheduled exports and a spreadsheet, Path B as an MCP-integrated agent with read-scoped access. Either way, what lands in the log every week looks like this.

One entry from the audit trail

2026-08-03 06:12 · weekly search-terms review TRIGGER scheduled Monday pass new rows: 20 · zero-conv share: 32.6% ACTION proposed 6 negative keywords ("free", "jobs", "salary", "internship", "crack", "tutorial") → routed for approval ($100 threshold) → approved 09:41 · applied as phrase negatives IMPACT $1,210.90/period of zero-conversion spend cut off at the source · undo path: saved negative-list export, one-click removal

Now with your numbers

The sample takes one click. Your own account takes about ten minutes — export, paste, read — and usually pays for the afternoon. Nothing you paste leaves your browser.

Run your own export →

Then build the loop

Everything this page did by hand, as a governed weekly automation on your own stack: the build guide is free, and stage four of the training path walks you into it.

Open the build guide →

Guardrails first: generate yours · or start from stage one.