How to Build a Negative Keyword List That Saves 30% Ad Spend

## Introduction Negative keywords are the unseen heroes of a profitable Google Ads account. They prevent your ads from showing on irrelevant searches, directly blocking wasted spend. In many accounts, 20–40% of the budget is eaten by queries that never convert. A systematically built negative keyword list can reclaim that money. This guide will show you how to audit your search terms, build a precise negative keyword list, and deploy it for maximum impact. ## Step 1: Pull a Clean Search Terms Report Start inside Google Ads. Go to **Campaigns** → **Keywords** → **Search terms**. Set the date range to the last 30 days (or longer if traffic is low). Click the **Download** icon and export as an Excel or Google Sheets file. Make sure you include all columns, especially **Clicks**, **Impressions**, **Cost**, **Conversions**, and **Conversion value**. Open the spreadsheet and immediately apply a filter to isolate the worst offenders. Add a column for **Cost per conversion** (total cost divided by conversions). In a new column, use this formula: ```excel =IF([Conversions]=0, "No conversion", [Cost]/[Conversions]) ``` Then sort by this helper column descending. The top rows are your biggest wasters – keywords that cost money but yielded zero conversions. Also scan queries with a high cost-per-conversion compared to your target CPA. Next, manually review the filtered list. Look for: - Irrelevant brand terms (other companies, competing products) - Informational phrases ("what is", "how to", "free", "download") - Location mismatches (searches with cities you don’t serve) - Typos or spelling variations you don’t want - Mismatched intent (e.g., “used” when you sell new, “jobs” when you sell products) Highlight rows that contain these patterns. This is your raw material for negative keywords. ## Step 2: Categorize and Organize Candidate Negatives Group the highlighted terms into logical buckets. Common categories include: - **Brand negatives**: names of competitors, similar brands you don’t sell - **Intent negatives**: “free,” “course,” “manual,” “salary,” “internship” - **Product type negatives**: outdated models, unrelated categories - **Location negatives**: cities, states, or countries outside your target area - **Qualifying negatives**: “cheap,” “luxury” if your offer sits in the middle For each bucket, create a separate sheet or section. This makes it easier to apply bulk changes later. Now, for each search term, decide the optimal **match type** for the negative: - **Broad match**: Blocks any search that contains all the negative keywords in any order (can also block close variants). Use broadly for words like “free” to stop most free-related queries. - **Phrase match**: Blocks searches that include the exact phrase in the same order. Use for “cheap running shoes” when you don’t want any “cheap” phrase. - **Exact match**: Blocks only that specific search term or very close variants. Use for high-spend exact queries like [free ipad 2024] (replace specific year with current). Create a final list with four columns: **Keyword**, **Campaign**, **Ad Group**, and **Match Type**. If you want to add the same negative across many campaigns, consider a shared negative keyword list. ## Step 3: Apply Negatives Using Google Ads Editor The fastest way to implement your list is through Google Ads Editor. Download the free desktop tool, open your account, and follow these steps: 1. In the left navigation, go to **Shared library** → **Negative keyword lists**. 2. Click **+ Add negative keyword list**, name it (e.g., “Ecommerce wasteful terms”). 3. Select the new list, then click the **+ Add negative keyword** button. In the table, paste your keywords, one per row. In the **Match type** column, assign broad, phrase, or exact. 4. After entering all keywords, click **Post** to upload the list. 5. Assign the shared list to relevant campaigns (select campaigns → **Associate** with the list). If you need campaign- or ad-group-specific negatives, navigate to **Keywords and targeting** → **Keywords, Negative**. Select the campaign or ad group, then add your negatives manually or paste them. **Important:** When adding exact negatives for high-spend queries, don’t over-block. Continuously check search terms to see if you stop appearing for useful variants. Adjust match types as needed. ## Step 4: Monitor and Refine Your Negative List Negative keywords aren’t a set-it-and-forget-it tactic. Schedule a weekly or monthly review: - Check the search terms report again for new wasteful queries. - Identify queries that were blocked but should have been shown; remove any over-blocking negatives. - Look for emerging competitor names or seasonal trends. - Use the **Change history** to see how negative additions impacted click and conversion volume. Consider using the Ad Preview and Diagnosis tool to confirm that your ads no longer trigger for blocked terms. After adding negatives, monitor your wasted spend metric (cost of clicks without conversions) and aim for a measurable reduction—30% is a realistic goal. ## Real-World Example A mid-sized sporting goods retailer found that “free yoga mat” and “yoga mat cleaning” generated hundreds of clicks but zero sales. By adding “free” as a broad negative and “cleaning” as a phrase negative, their wasted spend dropped by 34% within two weeks. The budget was reallocated to high-converting terms, lifting overall ROAS by 12%. ## Final Thoughts Building a negative keyword list is a high-leverage activity that pays back immediately. Use the search terms report to find leaks, batch your negatives with a structured approach, and commit to regular maintenance. Start small, measure the impact, and scale the process across all campaigns. Every dollar saved on irrelevant clicks is a dollar you can reinvest into growth.