Differences in how keyword duplication is treated, and using Microsoft Advertising Intelligence to fine-tune your keyword roster
This is the latest in a series of articles that explains how Microsoft Advertising adCenter differs from Yahoo! Search Marketing. They’re intended to help Yahoo! advertisers prepare for the upcoming transition and become familiar with adCenter.
Keyword normalization is the process by which a paid search provider finds and flags duplicate keywords within an ad group. This normalization process occurs automatically, and usually saves you time, because you don’t have to manage multiple variations of the same keyword.
Yahoo! Search Marketing has used a keyword mapping system in which singular and plural variations, and common misspellings of a keyword, map to the primary form of that keyword. The net result is that you do not need to bid on multiple variations of a keyword.
On the other hand, in Microsoft Advertising adCenter, normalization does not affect singular and plural variations, misspellings, spaces within or between words, or apostrophes that are a part of the word. adCenter treats these individual variations separately, so if you want to receive traffic from them, you’ll have to add each keyword variation to your campaigns. A keyword is considered a duplicate by adCenter if it contains extraneous characters or words, or if its punctuation or capitalization are slightly different.
Let’s look at a real-world example: the keyword “truck.” If you were bidding on this keyword only, Yahoo! Search Marketing could still display your ads for all other associated keyword variations, like “trucks” or “truk.” However, in adCenter each keyword is considered a separate marketplace, and you’d need to bid on each variation separately to help ensure full coverage for your keyword.
Yahoo! Search Marketing:

Microsoft adCenter:

When you import a keyword list into adCenter, duplicate keywords within the same ad group will be flagged with an error message and not uploaded. This gives you the chance to review the list and make any necessary edits.
Expand Your Keyword List
Once you transition your Yahoo! Search Marketing campaigns to adCenter, you’ll need to update and expand your keyword lists because there are a significantly higher number of keywords that can be entered, optimized and bid on in adCenter due to the differences in keyword normalization. You can easily pluralize your keyword list by using Microsoft Excel and build upon your existing keywords using Microsoft Advertising Intelligence (see more below).
Creating Pluralized Keywords
The “concatenate formula” in Microsoft Excel is used to join several text strings into one, and this is an easy way to quickly create pluralized variations of your keywords. You’ll start by opening a new Excel worksheet, then copying and pasting your keyword list into column A. To add an “s” at the end of each keyword, simply use the concatenate formula as seen below:

Lastly, copy and paste that formula down the column and you will have a new keyword list that includes plural variations.

For additional information on how to use the concatenate feature in Microsoft Excel, please watch this step-by-step video.
Expanding keyword lists using Microsoft Advertising Intelligence
Microsoft Advertising Intelligence, a free, easy-to-use keyword research and optimization tool that operates in Microsoft Office Excel 2007, can help ensure that your keyword list is fully expanded. It uses actual query data on any search term, and allows you to optimize your campaigns to help improve ROI. Two of the tools you’ll probably be using the most in your adCenter account are Keyword Extraction and Keyword Suggestion.

The Keyword Extraction tool suggests a list of keywords based on the content of a website. Simply enter a website into an Excel field and click on “Keyword Extraction.”

You’ll then receive a list of keywords that are relevant to the website that you entered. It’s a great way to quickly generate a keyword list based on a specific website.
The Keyword Suggestion tool has several features that help you build a list of new keywords from scratch, or expand upon an existing keyword list.

While all three features suggest new keywords, they work slightly different from one another:
- Campaign Association: Creates a list of keywords that are based on the bidding behavior of advertisers. It will suggest keywords that are in a similar category to the keywords that you entered and helps ensure that you’re not missing any of the important generic terms.
- Queries That Contain Your Keyword: Generates keywords based on queries that contain the specified keyword. This can be used to identify missing keywords from your campaigns and to generate a list of negative keywords to be added to your account.
- Related Search: Develops a list of keywords based on Bing related searches. This is a great way to expand your keyword lists beyond generic search terms.
Of course, after you generate a list of keywords using the Keyword Suggestion features, make sure you remove the duplicate keywords and review the list to help ensure that all of the new keywords are relevant.
You can download the Microsoft Advertising Intelligence tool today, so you can immediately benefit from the keyword expansion and other features.
For more on how Microsoft Advertising adCenter differs from Yahoo! Search Marketing, please review the full feature comparison.
If you have any questions or comments, please leave them below.
— The Team