- 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
Free Google Ads script · Keywords
Keyword opportunity and waste
Find converted search terms missing as exact keywords and high-spend keywords with no conversions.
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.
- 01Set the recipient email
- 02Choose account-wide or same-ad-group duplicate checking
- 03Review the 1.5× average-CPA waste threshold
- 04Validate conversion tracking before using the output
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.
Loading script…How to install a Google Ads script
Copy. Configure.
Preview. Schedule.
- Open the correct Google Ads account and go to Tools → Bulk actions → Scripts.
- Create a new script, remove the example code and paste this script.
- Edit the CONFIG block. Never leave placeholder emails, budgets or thresholds unchanged.
- Authorize the script, select Preview and inspect its logs or report.
- Only schedule it after the preview matches the intended account and scope.