Free Google Ads script · Keywords

Keyword opportunity and waste

Find converted search terms missing as exact keywords and high-spend keywords with no conversions.

ModeRead-only email and CSV report
Suggested frequencyEvery two to four weeks

What it is for

A faster check.
Not automatic judgement.

One report can surface both sides of keyword hygiene: search terms that converted but are not yet controlled as exact keywords, and enabled keywords that have spent well beyond the account’s average CPA without a conversion.

What the script does
  • Reviews converted search terms from the last 14 complete days
  • Checks whether an exact keyword already exists
  • Reviews 180-day keyword waste
  • Uses the last 30 complete days to calculate the account average CPA
Before the first run
  1. 01Set the recipient email
  2. 02Choose account-wide or same-ad-group duplicate checking
  3. 03Review the 1.5× average-CPA waste threshold
  4. 04Validate conversion tracking before using the output
Important

A zero-conversion keyword may still assist other journeys, and an exact keyword is not always required. Review intent, attribution and campaign structure first.

Use this script at your own risk. Google Ads interfaces and reporting fields change. Always run Preview in the intended account and read the logs before enabling or scheduling it.

Copyable source

Keyword opportunity and waste

Download .js ↓
Loading script…

How to install a Google Ads script

Copy. Configure.
Preview. Schedule.

  1. Open the correct Google Ads account and go to Tools → Bulk actions → Scripts.
  2. Create a new script, remove the example code and paste this script.
  3. Edit the CONFIG block. Never leave placeholder emails, budgets or thresholds unchanged.
  4. Authorize the script, select Preview and inspect its logs or report.
  5. Only schedule it after the preview matches the intended account and scope.
WhatsApp us ↗