Google Ads Search Terms Report: Find Waste and New Keywords
Summary
A Google Ads search terms report lists the queries that triggered your ads, with cost, clicks and conversions for each. Connect your account to Better Analyst and ask which terms spent without converting, or which converting terms aren't keywords yet. Google hides low-volume queries, so the report never covers all of your spend.
On this page
Who this report is for
PPC managers and agency account leads who review search queries every week or two, looking for negative keywords to add and converting queries to promote, across one account or several client accounts.
What the report includes
| Metric | Source field | Why it matters |
|---|---|---|
| Search term | search_term_view.search_term | The query someone actually typed, which is often quite different from the keyword you bid on. |
| Status | search_term_view.status | Shows whether the term is already added as a keyword or excluded, so you only review new ones. |
| Campaign | campaign.name | Keeps a term in context, because the same query can perform differently from one campaign to another. |
| Ad group | ad_group.name | Tells you where a new keyword or negative keyword belongs when you act on the report. |
| Cost | metrics.cost_micros | Spend on the term, returned in micros, so divide by 1,000,000 to get account currency. |
| Clicks | metrics.clicks | Shows whether a term has enough volume to judge before you exclude it. |
| Conversions | metrics.conversions | The split between terms that earn their spend and terms that only cost money. |
| Conversion value | metrics.conversions_value | Ranks converting terms by revenue, not by conversion count alone. |
How to build it in Better Analyst from Google Ads
- In Better Analyst, open Connectors and choose Google Ads.
- Click Connect with Google and sign in with the Google account that can see the ads. Accounts under a manager (MCC) account are discovered for you.
- Select the customer account to review and click Save. Manager accounts appear for context but can't be selected.
- Attach that account to a chat and ask for search terms over a fixed window, such as the last 30 days, sorted by cost.
- Check the query behind the table, then ask for the terms with spend and no conversions as a separate list.
Questions to ask
- “Show search terms from the last 30 days with cost, clicks, conversions and conversion value, sorted by cost.”
- “Which search terms spent more than 50 in the last 90 days without a conversion?”
- “List converting search terms that aren't already added as keywords.”
- “Which campaigns have the highest share of spend on terms with no conversions?”
- “Group search terms containing "free" or "jobs" and total what they cost this quarter.”
Sample output
Sample data for illustration, not real account data.
| Search term | Status | Clicks | Cost | Conversions | Suggested action |
|---|---|---|---|---|---|
| crm for small agencies | None | 84 | $412 | 9 | Add as exact keyword |
| free crm software | None | 131 | $388 | 0 | Add negative |
| agency crm pricing | Added | 46 | $297 | 6 | Keep |
| crm jobs remote | None | 38 | $121 | 0 | Add negative |
| best crm for client reporting | None | 27 | $164 | 3 | Add as phrase keyword |
Charts to use
- Spend by converting versus non-converting terms (Stacked bar chart): How much of each campaign's search term spend produced no conversions.
- Top terms by cost (Horizontal bar chart): The handful of queries taking the most budget, so review starts where the money is.
Keep it up to date
Schedule a task to rerun the review every Monday and send the terms with spend and no conversions by email or Slack. Better Analyst only reads the account, so adding the negatives stays with you in Google Ads.
Further reading
Frequently asked questions
Why doesn't the search terms report add up to my total spend?
What is the difference between a search term and a keyword?
Can Better Analyst add negative keywords for me?
Does this cover Performance Max?
Related reports
Google Ads Keyword Performance Report: CPA and Quality Score
Build a Google Ads keyword performance report with cost, CPA, match type, Quality Score and impression share, and find keywords to pause or raise.
Google Ads Report Template: Metrics, Layout and Example
A Google Ads report template for clients or your team: which metrics to include, a sample table and charts, and how to build it from your live account.
Ad Spend Pacing Report in Google Sheets: Budget vs Spend
Track ad spend pacing from Google Sheets: spend to date vs prorated monthly budget by platform and campaign, projected month-end spend, and pacing alerts.