Where the built-in search keyword report stops
Google's search terms report shows the queries that triggered your ads, with clicks, cost and conversions. It is accurate and free. The trouble starts at volume. A 30 day export from a mid-sized account holds 800 to 3,000 rows, and most are one or two clicks. Sorting by cost surfaces the few expensive rows, but the real money sits in word groups: "jobs" in 40 queries, "diy" in 25, none of them large alone.
The report also hides part of the picture. Google notes that queries with too little volume are grouped under "other search terms", so some spend never shows by name. Our search terms report guide explains how to read those hidden totals. Finally, the report has no memory. Nothing records what you excluded last month or why, so each review starts from scratch.
Four ways to work a search keyword report
1. The built-in report with filters. Cost: your time, roughly two to three hours a week per account if done properly. Fine for one account under 3,000 USD a month.
2. Spreadsheets and scripts. Export, pivot by word, mark candidates. It works, but formulas break, scripts fail silently and nothing checks a negative against conversions. Our scripts versus software comparison covers the trade-offs.
3. Broad PPC suites. Platforms such as Optmyzr and Adalysis include a search term module among many features. Good if you want one platform, but you pay for the whole bundle and the quality of that one module varies. See the Optmyzr alternative and Adalysis alternative pages.
4. A specialist negative keyword tool. NegativeKeywords reads the report, groups queries into repeated words, ranks them by cost, tests each proposed negative against converting queries and logs every change with undo. Plans run 49, 149 and 499 USD per month, and the irrelevant keywords tool page shows what it finds.
A worked search keyword report on 8,000 USD of spend
Illustrative numbers from a lead generation account, 30 days, 1,420 search terms. The raw report sorted by cost shows the top row at 61 USD, so nothing looks alarming. Grouped by word, the picture changes.
| Word group | Queries | Cost | Conversions | Decision |
|---|---|---|---|---|
| jobs, salary, hiring | 47 | 268 USD | 0 | Exclude at account level |
| diy, how to, template | 52 | 231 USD | 0 | Exclude as phrase match |
| cheap, free | 33 | 142 USD | 1 | Hold, one conversion |
| cost | 88 | 304 USD | 22 | Rejected, converts |
| near me | 64 | 219 USD | 17 | Rejected, converts |
Clear waste is 499 USD, or 6 percent of spend, spread over 99 queries no manual sort would have flagged. The "cost" and "near me" rows are the trap: together 523 USD of spend and 39 conversions. Anyone who excluded them as single words to look tidy would have lost more than the whole waste list was worth. At 8,000 USD a month this account fits Starter at 49 USD, so 499 USD of recovered waste covers it about ten times.
For break-even at other spend levels, the negative keyword software ROI guide has the table. The search term analysis tool guide goes deeper on the n-gram method behind it.
Search keyword report options compared
| Option | Groups by word | Conflict check | Change log | Cost |
|---|---|---|---|---|
| Built-in report | No | No | Account change history only | Free, plus your hours |
| Spreadsheet or script | If you build it | If you build it | Rarely | Your time |
| Broad PPC suite | Varies | Varies | Usually | Priced by spend or accounts |
| NegativeKeywords | Yes | Yes, every proposal | Yes, with undo | 49, 149 or 499 USD per month |
Time is the cost people forget. Agencies that review reports for many clients often reinvest the saved hours in finding new accounts, through referrals or outreach tools such as Microinfluencers for creator-led campaigns. The tool only pays back if the freed time goes somewhere.
Checks before you pay for a search keyword report tool
Test on your export. A tool should show ranked results from a pasted file before you connect an account. Use the NegativeKeywords demo for that.
Plant a trap. Find a word in both waste and conversions, like "cost" above. If the tool proposes excluding it broadly, move on.
Ask for the log. Every change should show date, data and undo, and be readable as a client report, see Google Ads reporting tool and white-label reports.
Count accounts and networks. Starter covers one Google Ads account up to 10,000 USD of monthly spend. Growth at 149 USD covers 5 accounts and Microsoft Advertising. Agency at 499 USD covers 50 clients. Google's own search terms report help documents the report itself, and the pricing page lists our plans.
Questions buyers ask
What is a search keyword report in Google Ads?
It is the search terms report: the list of real queries that triggered your ads, with clicks, cost and conversions. It differs from the keyword report, which shows the keywords you bid on. Waste hides in the search terms, so that is the report to review for negatives.
What is the best search keyword report tool?
The best tool is the one that turns the report into decisions. The built-in report is fine for one small account. Once you review it weekly across several campaigns or clients, a tool that groups queries by word, ranks waste and tests negatives against conversions saves hours and prevents bad exclusions.
How often should I review the search keyword report?
Weekly for accounts above 3,000 USD a month, every two weeks below that. New campaigns and broad match changes need a review after seven days, because that is when irrelevant queries appear fastest.