Help Center/Negative Keywords Tool

Negative Keywords Tool

Upload a Google Ads Search Terms Report and identify low-performing words. Build a negative keyword list in Exact, Phrase, or Broad match format for upload into Google Ads.

What Is the Negative Keywords Tool?

The Negative Keywords Tool helps you clean up your Google Ads traffic by identifying words that appear in your search terms but do not convert well. Instead of reviewing thousands of individual search terms, the tool breaks them into single words and aggregates performance metrics. That makes it easy to spot patterns like the word "free" or "meaning" dragging down your account across many search terms.

How It Works

The tool follows a three-step workflow: upload, analyze, and export. Every upload is saved as an analysis, so you can close the tab and continue later.

  1. Upload. Export a Search Terms Report from Google Ads (as CSV) and upload it to WonderAds. The tool detects columns automatically for common Google Ads exports, or you can map them manually.
  2. Analyze. The tool splits every search term into individual words and aggregates impressions, clicks, transactions, costs, and CPA per word. Words that appear in many low-performing search terms will have high costs and low (or zero) conversions.
  3. Export. Mark the underperforming words as Exact, Phrase, or Broad negatives. Your choices are saved automatically. Download the formatted list as a CSV or copy it to your clipboard, then upload it into Google Ads as a negative keyword list.

The Negative Keywords page lists all saved analyses with their number of search terms, words and chosen negatives. Open one to continue, or delete it when you no longer need it.

Uploading Your CSV

Navigate to "Negative Keywords" under "Tools" in the sidebar. Click "Upload report" and drop your Search Terms Report file.

  1. In Google Ads, go to Insights & Reports > Search terms. Set your date range and download the report as CSV.
  2. In WonderAds, click "Upload report" and drop the file or click to choose it.
  3. The tool auto-detects common column names (Search term, Impressions, Clicks, Conversions, Cost, CPC). If it cannot detect a column, map it manually using the dropdowns.
  4. Preview the first 5 rows to verify the mapping looks correct.
  5. Click "Analyze" to save the report and open the analysis. The name defaults to the file name; click the title to rename it.

The required columns are Search Term, Impressions, Clicks, Transactions, and Costs. CPC is optional. Make sure your CSV includes these metrics.

Understanding the Word Table

After processing, the tool shows a table of all unique words extracted from your search terms. Each word row shows the sum of impressions, clicks, transactions, costs, and the calculated CPA (cost per transaction) across every search term where that word appears.

Click the eye icon next to any word to see the full list of original search terms that contain it. That helps you verify whether the word is truly low-performing or just appearing in a mix of good and bad terms.

Filtering the Results

Use the filters above the table to narrow down the word list. Each filter is a chip with three parts: a metric (Impressions, Clicks, Conversions, Costs, or CPA), a comparison (more than, less than, or exactly), and a value. You can combine multiple filters and they are joined with AND logic.

  1. Click "Filter" to add a filter chip.
  2. Example: "Conversions exactly 0" shows only words with zero conversions.
  3. Example: "Costs more than 50" combined with "Conversions exactly 0" shows expensive words with no conversions, the prime negative keyword candidates.
  4. Remove a chip with its ×, or click "Clear all".

Marking Negative Keywords

Each word row has a switch with Off, Exact, Phrase and Broad. Pick a match type to mark the word as a negative keyword; the row turns red and the word is struck through. Pick Off to remove it again. Choices are saved automatically.

  1. Exact: the word is added as [word]. Only blocks searches that match this exact word.
  2. Phrase: the word is added as "word". Blocks searches that contain this word as a phrase.
  3. Broad: the word is added as word (no brackets). Blocks searches that contain this word in any order.

For single-word negatives, Exact and Phrase behave the same way. Broad negative is the most aggressive: it blocks any search containing that word regardless of context.

Exporting Your Negative List

The header of an analysis shows how many negatives you chose. You have two export options:

  1. "Export N negatives": downloads a CSV named after the analysis with one keyword per line, formatted with the correct notation ([word], "word", or word).
  2. The copy button next to it copies the same formatted list to your clipboard so you can paste it directly into Google Ads or a spreadsheet.

In Google Ads, navigate to Tools > Negative keyword lists, create a new list, and paste or import your negative keywords. You can then apply the list to your campaigns.

Example Workflow

Here is a practical example. Suppose your CSV contains these search terms:

  1. "buy blue socks": 100 impressions, 10 clicks, 1 transaction, €10 costs
  2. "buy blue socks online": 50 impressions, 10 clicks, 1 transaction, €10 costs
  3. "combine blue socks": 50 impressions, 5 clicks, 0 transactions, €5 costs
  4. "meaning of blue socks": 30 impressions, 3 clicks, 0 transactions, €3 costs
  5. The word "buy" has: 150 impressions, 20 clicks, 2 transactions, €20 costs, CPA €10.
  6. The word "combine" has: 50 impressions, 5 clicks, 0 transactions, €5 costs, no CPA.
  7. The word "meaning" has: 30 impressions, 3 clicks, 0 transactions, €3 costs, no CPA.
  8. You would mark "combine" and "meaning" as negative keywords since they never convert.

Data Privacy

The CSV is read in your browser. When you click "Analyze", the search terms (term, impressions, clicks, conversions, costs, CPC) and your chosen negatives are saved to your WonderAds account so you can come back later. Only members of the account can see them. Deleting an analysis removes its search terms for good, and all analyses are deleted with the account.