Search Term Analysis Tutorial: How to Clean Up Your Google Ads Search Terms Report Step by Step
This search term analysis tutorial walks you through a repeatable process for reviewing your Google Ads search terms report. You'll learn how to set the right date range, cut wasted spend with negative keywords, and turn converting queries into new keywords, using only a Search campaign account with a few weeks of data and a basic grasp of match types.
A search term analysis is the habit of checking what people actually typed before they clicked your ads, then acting on it. By the end of this tutorial you'll have a repeatable process for reviewing your Google Ads search terms, cutting wasted spend with negative keywords, and turning converting queries into new keywords. You'll need a Google Ads account with at least a few weeks of Search campaign data and a working grasp of match types (broad, phrase, and exact).
Step 1: Set Up Your Search Terms Report and Date Range
In Google Ads, the report has typically lived under Campaigns, then Insights and reports, then Search terms. Google moves its navigation around, so if you don't see that path, use the search bar in the interface or check Google Ads Help for the current location.
Next, pick a date range. Thirty days works for accounts with steady volume. If your campaigns get only a few clicks a day, stretch it to 60 or 90 days so you have enough data to judge anything. Avoid ranges that include a major promotion or an outage unless you want those distortions in your analysis.
Keep one distinction in mind throughout. A search term is the exact query a person typed. A keyword is what you bid on. Analysis is the work of spotting where the two drift apart, and deciding whether that drift is useful or wasteful.
Then set up your columns. Use the column editor to show:
- Impressions, clicks, and CTR
- Cost
- Conversions and conversion value
- Match type (how the query matched your keyword)
- Added/Excluded status, which tells you whether the term is already a keyword or a negative
One limit to know about: Google doesn't show every query. As of this writing, queries that don't meet its volume and privacy thresholds are grouped under "Other search terms," so part of your spend can sit there with no detail. Google Ads Help explains the current wording and thresholds. Treat the report as a large sample, not a complete record.
Step 2: Sort and Filter to Find What Deserves Attention
You can't review thousands of rows, so let the numbers point you to the ones that matter. Start by sorting by cost, highest first. The top spenders are where a bad decision costs the most and a good one saves the most.
Then sort by conversions, highest first, to see your winners. Keep in mind these two views are showing you different things, so run both.
Filters get you to the actionable rows faster. Two that cover most needs:
- Likely waste: cost above a threshold you choose, with conversions equal to zero. Pick a threshold that makes sense for your account, such as a figure near your target cost per conversion.
- Likely additions: conversions greater than zero, with status "None," meaning the term isn't yet a keyword in your account.
Filter by campaign or ad group too, and review one at a time. A query like "pricing" may be great for a bottom-funnel campaign and poor for a brand-awareness one. You can only judge a term against the goal of the campaign that served it.
The most common mistake here is acting on thin data. A term with one or two clicks and no conversions isn't proven junk, and a term with one conversion on two clicks isn't a proven winner. Set a minimum-data rule before you start, for example "no decision under 10 clicks unless the query is clearly irrelevant." The exact number is yours to choose. What matters is that you pick it in advance so you aren't rationalizing each row as you go.
Step 3: Sort Search Terms Into Four Buckets
Once you have a filtered list, put every term into one of four buckets. Each bucket maps to a different action.
- Relevant and converting: add as keywords (Step 5).
- Relevant but unproven: leave running and keep watching. Not enough data yet.
- Irrelevant: exclude with negative keywords (Step 4).
- Relevant but in the wrong place: the query is good but triggered the wrong campaign or ad group. Add it where it belongs and consider a negative in the wrong spot.
Here's an illustration. Imagine a project management SaaS running a Search campaign. Queries like "free project management software" and "project manager jobs" are irrelevant for a paid product, so they go in the irrelevant bucket. "Project management software for agencies" has converted twice, so it's a winner. "Client project tracker" has 6 clicks and nothing yet, which makes it relevant but unproven. And "project management software pricing" turned up in a top-of-funnel ad group when a pricing-focused ad group exists, so it belongs in the wrong-place bucket.
Use business context, not metrics alone. A term with zero conversions can still be right if it's new, if your sales cycle is long, or if conversions are reported with a delay. On the other side, a term with a conversion or two can be wrong if those conversions were low-quality leads. Know what a good outcome looks like for your business before you label anything.
If you'd rather not export to a spreadsheet just to sort and tag rows, Keywordme is a Chrome extension that lets you act on terms directly inside the Search Terms Report. That keeps the bucketing in the same screen where you make the changes.
Step 4: Add Negative Keywords the Right Way
Negative keywords stop your ads from showing for matching searches. Getting them right comes down to three decisions: match type, level, and how much you risk blocking.
Choose the match type deliberately
Negatives have broad, phrase, and exact match types, but they don't behave like their positive counterparts. Per Google Ads Help, negative keywords don't match close variants, so a negative for "jobs" won't automatically block "job" or "jobz." If you want plurals or misspellings blocked, add them yourself. Check Google's current documentation on negative match behavior before you build large lists.
Broadly, negative broad blocks searches containing all your negative terms in any order, negative phrase blocks searches containing the terms in that order, and negative exact blocks only that exact query. Use exact when a single query is bad but its neighbors are fine.
Choose the level
You can add negatives at the ad group level, the campaign level, or in a shared negative keyword list applied to multiple campaigns. A practical split:
- Ad group: the term is wrong for this ad group but fine elsewhere.
- Campaign: the term is wrong for the campaign's whole purpose.
- Shared list: account-wide junk like "free," "jobs," or "DIY," where it makes sense for every campaign. Check Google Ads Help for current list limits.
Avoid over-blocking
A single-word negative is blunt. Adding "free" as negative broad will also block "free trial" searches, which might be exactly what your SaaS wants. Before adding any short negative, search your report for converting terms that contain it. If any exist, use a phrase or exact negative instead.
Keywordme can add negatives straight from the Search Terms Report in a click, with the match type you pick, without leaving Google Ads. You still choose which terms to exclude and how; the extension just removes the copy-paste step.
Step 5: Promote Winning Search Terms to Keywords
Terms in your "relevant and converting" bucket have already proven themselves. Adding them as keywords gives you control over bids, ad copy, and landing pages that a loose match to some other keyword never will.
Pick the match type based on how much control you want:
- Exact: for proven terms where you want tight control over when the ad shows.
- Phrase: for controlled expansion, when you want the term plus relevant variations around it.
Then place each term in the best ad group, which is the one whose ads and landing page match what the person was looking for. If "project management software for agencies" converted, it belongs in an agency-focused ad group with agency-focused copy, not a generic one. Matching the query to the message is a big part of why promoting terms pays off.
Before you add anything, check for duplicates and cannibalization. Look at your existing keywords in the same campaign. If an exact-match version already exists elsewhere, adding another just splits impressions between two of your own ad groups and muddies your data. Also confirm the term isn't excluded by a negative you added earlier. It happens more often than you'd think.
If you have a long list of winners, Keywordme can add keywords from the report with a match type applied in one click, and its keyword clustering can help group related terms so you can build ad-group-ready lists faster. As with negatives, you decide what goes in. The tool speeds up the clicking.
After adding, give the new keywords time to collect data before you judge them. A few days of results isn't a verdict.
Step 6: Spot Patterns and Fix Structural Problems
Reviewing one query at a time only gets you so far. The bigger gains come from spotting themes across many queries. Look for recurring words or word groups (often called n-grams, meaning sequences of one, two, or more words) like "cheap," "near me," "reviews," "alternative," or "how to."
Many accounts spend real money on a single recurring word spread across dozens of low-volume queries. Individually none of them looks worth acting on, so they slip past a row-by-row review. Grouped, the pattern is obvious. You can find these by sorting the report and scanning, or by exporting and using a pivot table if you prefer a spreadsheet.
Then use the pattern to diagnose the cause rather than just the symptom:
- Lots of loosely related queries: your broad match keywords may be too loose, or you may lack smart bidding signals to steer them.
- Wrong-intent queries clicking: your ad copy may be attracting people it shouldn't. If your ad says "free guide" and you sell software, you've invited them.
- Relevant queries not converting: check the landing page. A mismatch between query and page is a frequent culprit.
- The same junk keeps returning: you're missing negatives, or your negatives are the wrong match type.
Fixes should go back to the source. Tighten match types, split an ad group where intents differ, rewrite the ads, or fix the page. Negatives treat the symptom, and they're worth adding, but they don't repair a structural problem.
A simple decision rule helps: if a theme carries meaningful spend and converts poorly, address the cause. If it's small, a negative is usually enough.
Step 7: Build a Review Routine and Track Results
A one-time cleanup decays. New queries appear constantly, so the review has to be a habit. A reasonable cadence ties to spend: weekly for high-budget accounts, every two weeks or monthly for smaller ones. That's a recommendation, not a rule. Adjust based on how fast new junk shows up in your account.
Keep a simple change log, even a shared document. For each change, record the date, what you did, and why. Without it, you can't tell later whether a shift in performance came from your negatives, a bid change, or seasonality.
To judge results, compare before and after on:
- Cost per conversion
- Conversion rate
- Share of spend going to terms with zero conversions
Allow for lag. Conversions can be reported days after the click, and a window that's too short will mislead you. Don't expect a specific savings figure; results depend on how much waste was there to begin with.
If you run an agency, standardize across clients. Use the same minimum-data thresholds, the same bucket definitions, and a starter shared negative list you adapt per account. Keywordme also supports multi-account and team use, which can help when several people review different clients. Check its current documentation for how that works for your setup.
Running the Loop Again: Start With Your Top Spenders
You now have the cycle: review the report, sort terms into buckets, add negatives, promote winners, fix the structural causes, and repeat on a schedule. The first pass is the longest. Each one after is faster because your negative lists and thresholds are already in place.
For a starting point, open your last 30 days, sort by cost, and work through the top 25 or so spenders using the steps above. That alone will show you how much of your budget is going to queries you never intended to pay for.
Optimize Google Ads Campaigns 10X Faster. Without Leaving Your Account. Keywordme lets you remove junk search terms, build high-intent keyword lists, and apply match types instantly, right inside Google Ads. No spreadsheets, no switching tabs, just quick, seamless optimization. Start your free 7-day trial (then just $12/month) and take your Google Ads game to the next level.