Find the words wasting your Google Ads budget, across every search term
A free, read-only Google Ads script that breaks your search terms into 1-, 2- and 3-word phrases, adds up cost and conversions for each, shows whether your keywords, AI Max or Performance Max brought them in, and fills a Google Sheet ready for ChatGPT, Claude or Gemini. From DetectivePPC.
By DetectivePPC. Written against the documented Google Ads scripts APIs (AdsApp.search with GAQL, SpreadsheetApp, MailApp). Logic-tested on fictional data; run Preview in your account first.
Get the script
We'll email you the script, the PDF guide, and the AI prompt as a zip.
Why it matters
Google omits search terms without enough query activity from the search terms report for privacy, so single terms often look too small to act on. Adding them up by phrase is how patterns like “free” or “jobs” show up.
Source: support.google.com/google-ads/answer/2472708
What lands in the Sheet
The script reads reports and fills a Google Sheet. It never adds negatives or edits anything in your account.
- SummaryDate range, costs, coverage, target CPA used (or a campaign cap if you set one).
- 1/2/3-gramsPhrase, cost, conversions, CPA, ROAS, share of cost, and the top search terms behind each phrase.
- FlaggedPhrases that spent without converting, or ran over 2x your target CPA. De-duplicated so each set of terms shows once.
- Match sourceCost, conversions, CPA and ROAS for your keywords, AI Max (broad match and keywordless), Performance Max and DSA.
- AI promptA ready prompt, with your target CPA filled in, if you also registered a company name (optional).
Sample output (fictional data)
What the Sheet looks like
Sample output (fictional data): "Brightside Dental Studio" is a made-up dental clinic. These Flagged-tab rows come from running the script on fictional search terms (LAST_30_DAYS, USD). They are not from a real account.
- free3201650.200—5.9%All terms (free dental clinic, …) have 0 conversions
- cheap3162541.200—4.9%Bargain intent (cheap dental implants abroad, dental school clinic cheap)
- dental tourism abroad199412.500—3.8%Service you do not offer
- jobs2102333.900—3.0%Job seekers (dental hygienist jobs, dental assistant jobs near me)
- invisalign vs braces158330.601330.603.0%High CPA (330.60 vs 55.82 target); 1 conversion
- how to264207.402103.701.9%Mixed: 1 converting (how to fix a chipped tooth), 1 not
- medicaid147159.800—1.5%You do not accept Medicaid
- dental school142128.700—1.2%Looking for a school clinic
- at home138114.400—1.0%DIY intent (how to whiten teeth at home)
A script shows you where search terms leak.
DetectivePPC runs a read-only Google Ads audit, gives you a scored case file with prioritized findings, and then monitors the account between audits, alerting you to anomalies like a CPA spike or a sharp spend drop, without any code to maintain.
7-day trial · 1 free audit · Read-only access
