How to Find Negative Keywords for Google Ads

This article focuses on how to negative keywords for local businesses. Check out our negative keyword lists to learn more about negative keywords for Google Ads and Microsoft Ads.

Negative Keywords for Local Businesses

Negative keywords focusing on the competition are essential for local business owners running their own ad campaigns – as well as marketing agencies running ads for local businesses. When running ad campaigns for local businesses, I’ve found the following to almost always be true:

Budgets are Tight

Unlike a large company running a branding campaign, the ad campaign spends for local businesses must get a direct return on investment month after month.

Adding Competitors as Negative Keywords

Don’t bid on your competitor’s brand name.  Not only should you avoid bidding on your competitor’s names, you should also make competitor brand names negative keywords.

Most of the people searching for your competitors probably already have an existing relationship with that competitor. Therefore, if someone is searching for your competitor, it doesn’t make sense for your ad to show for those search queries.
For example, if you’re the owner of ABC Dental, you don’t want your ad to show for searches of Smith Dental across the street. If someone goes on Google to search for Smith Dental, they probably already have an existing business relationship and are doing a Google search for one of the following reasons:

  • They forgot their appointment time or are looking to reschedule
  • They need directions for their appointment
  • They have questions about insurance claims

Undesirable Google Ads Impacts

By advertising on your competitor’s brand name, you risk the chance of someone accidentally clicking on your ad and costing you money. Additionally, your clickthrough rate is likely to be low – hurting your quality score. Finally, click costs for brand terms are much cheaper for the brand owner than they are for you.

5 Tools To Find Negative Keywords

So we know not to deliberately bid on our competitors’ business names. Let’s go a step further by making sure anything related to our competition is added as a negative keyword. So how do we find competitor business information?

1) Search Terms Reports – Especially Microsoft

A common way would be to comb through the search terms provided by Google to find negatives. This is something you should be doing periodically anyway. I would strongly recommend that you go through the search term report daily at the beginning of an ad campaign and weekly after that.

Google Search Terms Access
The Google Search Terms Report is found under the Keywords tab

You should also check out the Microsoft Ads search terms as sometimes you’ll discover more search terms in that report than what is provided in Google.

Microsoft Ads Search Term Report

The Microsoft Ads Search Terms Report can be found under the “Keywords” tab.

The search terms reports on both ad platforms are helpful, but there’s a way to create a negative keyword list for all of your competitors before your advertising campaign even begins.

2) Use Our Negative Keyword Lists

On this site (FlexLeads.com), we have negative keyword lists containing the most common first and last names in the United States. By merely implementing these negative keywords, you’ll cut down on a lot of searches for your competitors and save your ad dollars for more relevant searches.

If someone in your town of Springfield searches for “Springfield dentist Wilson” (Dr. Wilson is one of the dentists at your competitor Smith Dental) – your ad won’t show because “Wilson” is a common name that is on our negative keyword list.

3) Google Ads Keyword Planner

Back in the day, the Google Ads Keyword Planner used to be open to everyone and it used to provide valuable keyword information for you to discover keywords to bid on for your ad campaigns. While I will still use the keyword planner when rolling out new campaigns, it is best used for uncovering negative keywords.

Accessing the Google Keyword Planner

Access the Google Keyword Planner under Tools & Settings – Keyword Planner

The tool is great for finding keywords that you don’t want to bid on. Be sure to use the Keyword Planner to find negative keywords that Google believes are closely related to your main keywords but that are actually irrelevant and will just waste your budget.

Keyword Planner Results

The Keyword Planner is great at finding competitor-related keywords that you don’t want to waste ad spend on

Plugging “Dentists” into the keyword planner, I was able to come up with multiple searches for my competitors. I don’t want my ad to show when people search for my competition. As a result, I would make “aspen”, “dentalworks”, “dental works”, “all smiles” and “riverside” negative keywords.

4) Use Other Keyword Tools

Ubersuggest is a keyword research tool by Neil Patel which allows you to search for keywords related to your subject matter for free.

In the example below, I used “dentists” as my search term. You’ll notice in the results, the keywords “dentists for dogs” and “dentists job” both appeared. Your goal is to bring new patients into your dental practice. You’re not a veterinarian and you’re not trying to attract job seekers – this makes “dogs” and “job” negative keywords that should be added to our list.

Ubersuggest keyword results

Ubersuggest is a keyword tool that can be a good source of negative keywords

5) Use a Free Library Resource – referenceUSA

If you can take advantage of your local library and the Reference USA subscription which it may have to find out pertinent information about your competitors. This one of the best tools it is free.

Here, I’m logged into reference USA through my local library.

Reference USA Home Page

Choose either the US Business Database or the US Healthcare Database

I have the option to choose from a number of available databases. As you can see highlighted above, you’ll want to search either the U.S. Businesses database (A) – or the US healthcare database (B). The example I’m using is for dentists, so I’ll choose the U.S. Healthcare database.

Finding Dentists With Reference USA

See the text below to figure out how to zero in on competitors in your area

Next, you’re taken to the healthcare database search area. I’ve selected the Advanced Search tab (A). I’m then searching for all dental offices in Greensboro, NC. There are numerous ways to get what you’re looking for using the database.
In this case, I check the “City/State” box in the geography section (1), then I enter Greensboro (2) and click the go button (3). I then select Greensboro, NC (4).Next, I have to find the dentists I’m looking for. Again, there are multiple ways to do this in the database. I select “Primary Specialty” (5) in the Practice / Credential Section. I then scroll until I find “Dental-General Practice” (6).Next, I click “Update Count” (7) to make sure that everything looks like it has been filtered properly. You’ll notice my record count from the screenshot above was 1,143,637 has been filtered down to just 95 records as you can see in the screenshot below.

Viewing Results in Reference USA

Updating the count results in much fewer records, click on “View Results” to see the competition

I then click on “View Results” to see all the general dentists in the Greensboro, NC area.

Select all dentists in the result set to look for negative keywords

I’m going to select all of these results and download them to a spreadsheet. I click on the top checkbox (1) to select all records. I then click the arrow button (2) to page through all results until I reach the end of the records.

Download Competing Dentist Information

Download all competing dentists locally to your computer

At the end of the records, I select Download (1) to download all the records to Excel.

Downloading Dentists to Excel

Download options – here we choose to download to Excel

The download options are presented on the next screen. I chose Excel 2007 / 2010 (1) and selected the summary level (2). I then downloaded the records to excel (3).

Excel Result Set of All Dentists

Excel spreadsheet containing information for all 95 of our dental competitors

You now have two options. You can manually go through the records and add negative keywords based on first name, last name, and office name fields. You can even use the street address – sometimes people will search for “Dentist on Oakcrest” – using Oakcrest as a negative will prevent your ad from showing for irrelevant searches.
You can also come up with a more automated way to analyze records as shown in the next section.

Advanced: Refining Your Excel Spreadsheet to Add Negatives

Step 1 is to eliminate all columns that wouldn’t work as negative keywords. I would recommend keeping only the First Name, Last Name, and Office Name columns. As mentioned above, you could also use street names to find negatives, but I’m not going to do so in this example.So we now have three columns as shown below

3 column result set

Partially truncated result set containing only the first name, last name and office name of competitng dentists

The next step is to combine all three columns into one large column. So cut and paste the rows from the last name and office name over to below the existing data in the first name column.

Then you’ll highlight all data in that remaining column and Select – Data – Sort A-Z. I also deleted all blank rows.

Excel Data Sort

Sort the data in Excel by choosing “Data” – then sort from A to Z.

Next step is to eliminate duplicates by going to Data – Remove Duplicates.

Remove duplicate records in Excel

Select Data – Remove Duplicates in order to leave only unique records in Excel

From here, you can manually peruse the list for negatives.
Note:
There are other more automated ways to perform this process, but it gets into pretty advanced excel user-defined functions.

Add Negative Keywords to Your Ad Campaigns

Once you’ve come up with a list of negative keywords related to your competitors, it is time to head over to Google and add negative keywords by creating a negative keyword list.

Accessing Negative Keyword Lists in Google Ads

Go to Tools & Settings – Negative keywords lists to access negative keyword lists in Google Ads

Fortunately, this is easy enough to do. Under Tools and Settings, Select “Negative Keyword Lists”.

Adding a negative keyword list in Google Ads

Click the “Plus” button. From here, you’ll provide a name for your negative keyword list (1). Then add your negative keywords by pasting them (2) and select save (3). From here, you can apply your negative keyword list to multiple campaigns in your account.

Setting up a negative keyword list

Setting up a negative keyword list

Match Type for Negatives Behaves Differently

You’ll obviously want to use great care when adding negative keywords to your campaign. Remember that unlike regular keywords, negative keywords don’t use variants. So an exact match negative keyword must be an exact match to the search term or else the ad will still show.Likewise, a broad match negative keyword will prevent ads from search queries that contain the broad match phrase, but ads will still show for plural forms of that broad match negative keyword.
Negative Keyword Jumpstart Guide

Negative Keywords

Get our List of over 3600 Negative Keywords for free by clicking below:

Send Me My Free Guide


Get the List of Over 3,600 Negative Keywords – for Free

Fill out the form below and we’ll send you full access to the list.

We hate SPAM and promise to keep your email address safe. Here’s our privacy policy.