Google Ads Search Terms Report: Find Waste and New Keywords

Build a Google Ads search terms report that shows what people typed, what it cost and what converted, plus negative keyword candidates, with AI.

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
  1. Who this report is for
  2. What the report includes
  3. How to build it in Better Analyst from Google Ads
  4. Questions to ask
  5. Sample output
  6. Charts to use
  7. Keep it up to date
  8. Further reading
  9. FAQ

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

Metrics and dimensions in this report
MetricSource fieldWhy it matters
Search termsearch_term_view.search_termThe query someone actually typed, which is often quite different from the keyword you bid on.
Statussearch_term_view.statusShows whether the term is already added as a keyword or excluded, so you only review new ones.
Campaigncampaign.nameKeeps a term in context, because the same query can perform differently from one campaign to another.
Ad groupad_group.nameTells you where a new keyword or negative keyword belongs when you act on the report.
Costmetrics.cost_microsSpend on the term, returned in micros, so divide by 1,000,000 to get account currency.
Clicksmetrics.clicksShows whether a term has enough volume to judge before you exclude it.
Conversionsmetrics.conversionsThe split between terms that earn their spend and terms that only cost money.
Conversion valuemetrics.conversions_valueRanks converting terms by revenue, not by conversion count alone.

How to build it in Better Analyst from Google Ads

  1. In Better Analyst, open Connectors and choose Google Ads.
  2. 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.
  3. Select the customer account to review and click Save. Manager accounts appear for context but can't be selected.
  4. Attach that account to a chat and ask for search terms over a fixed window, such as the last 30 days, sorted by cost.
  5. 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.

Sample data: search terms for one account over 30 days (illustrative, not a real account)
Search termStatusClicksCostConversionsSuggested action
crm for small agenciesNone84$4129Add as exact keyword
free crm softwareNone131$3880Add negative
agency crm pricingAdded46$2976Keep
crm jobs remoteNone38$1210Add negative
best crm for client reportingNone27$1643Add 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

Try Better Analyst free

Frequently asked questions

Why doesn't the search terms report add up to my total spend?
Google leaves out queries that too few people searched, for privacy. The report only shows terms that clear that threshold, so its totals usually come in below campaign totals. Compare the two to see how much spend is hidden.
What is the difference between a search term and a keyword?
A keyword is what you bid on. A search term is what the person typed. Broad and phrase match can show your ad for many different queries, which is why this report is where wasted spend usually turns up.
Can Better Analyst add negative keywords for me?
No. The connector is read-only and cannot change campaigns. It gives you the list, and you add the negatives in Google Ads or Google Ads Editor.
Does this cover Performance Max?
Mostly not. Search term detail mainly covers Search campaigns, and Google exposes less for Performance Max, which you can still report on at campaign level.