Google Ads script

Wasted-spend keywords (cost, no conversions)

Read-only. Lists enabled keywords that spent over the threshold but produced zero conversions in the last 30 days — strong candidates to pause or optimize. Change COST_THRESHOLD for your currency.

← All scripts
Read-onlyTry the script in a demo account — see the log, the changes and what it means.
Demo account
Script · Wasted spend
Not run yet
function main() {
// Read-only: keywords that spent over the threshold with zero conversions (last 30 days).
var COST_THRESHOLD = 200; // in account currency — adjust to taste
var keywords = AdsApp.keywords()
.withCondition('Status = ENABLED')
.withCondition('Cost > ' + COST_THRESHOLD)
.withCondition('Conversions = 0')
.forDateRange('LAST_30_DAYS')
.orderBy('Cost DESC')
.get();
Logger.log('Keyword | Cost | Clicks (spend with no conversions)');
while (keywords.hasNext()) {
var k = keywords.next();
var s = k.getStatsFor('LAST_30_DAYS');
Logger.log(k.getText() + ' | ' + s.getCost().toFixed(2) + ' | ' + s.getClicks());
}
}
Press Preview to see what the script does in the demo account.

Simulated run in a fictional demo account. The script’s real code runs in your browser against sample data — nothing connects to Google Ads, no emails are sent and no sheets are created.

How to run the script
  1. Google Ads → Tools → Bulk actions → Scripts.
  2. Click + and paste the code. Authorize when asked.
  3. Run a preview first and read the log.
  4. Schedule the script if you want it to run regularly.
SEOZ runs these checks for you — automatically, with alerts when something breaks.
Try the guided demo →More scripts