The Keyword Counter in WordStream, illustrated in the following figure, generates a more realistic report of the different search referred keywords and their associated visit counts:
The WordStream Keyword Counter: Enables a Search Marketer to Determine the True Keyword Count and Their Associated Frequencies.
When you upload keywords from Google Analytics into WordStream, it may seem as though some disappear in the process! If your keyword count goes down, don't worry--you didn't lose them. WordStream has a more advanced process of removing formatting to ensure that highly similar keywords are actually counted as being the same keyword and not counted as being different keywords.
i just uploaded 1,273 keywords from google analytics but i'm only seeing 972 keywords in wordstream. what happened to the other 301 keywords? Is the KEYWORD COUNTER WRONG?
It's safe to say that the other 301 keywords weren't actually unique, individual keywords, but rather variations of the same keyword. WordStream normalizes your keywords by making them all lowercase, removing leading and trailing whitespace, and removing certain formatting such as punctuation, and other invalid characters- and replaces them with a space. For example, Angela owns a salon and wants to attract people who are looking for haircuts. In WordStream, the segment, Haircut, with its corresponding adtext, may include the keywords:
- haircut (note the leading spaces)
In Google Analytics, the above are counted as 7 different keywords, even though they're clearly the same keyword with different punctuation, case, and leading whitespace.
why remove Keyword formatting?
There are several simple reasons:
- Formatting characters such as spaces, etc. don't tell us anything more about the searcher, and wouldn't necessitate the creation of another AdGroup or different adtext .
- Google Adwords  won't even allow you to bid on keywords with certain dis-allowed characters, such as exclamation points, question marks, ampersands, the @ symbol, brackets, etc. Just try it out and see for yourself. The allowable characters for keywords on Google Adwords include alpha numeric, including English and non-English international language characters, dashes, underscores, periods, single quotes, and spaces "([^\d\w\-_\.\' ])". By removing formatting, WordStream is making your life easier by removing the characters that you would have had to end up removing anyway.
- By removing irrelevant keyword formatting you can get a more accurate sense of the relative importance of different keywords. If the preceding example was the output of a typical Web analytics application , the search marketer might be led to believe that the keyword: "haircut" was a relatively un-important keyword having generated just one visitor, but in reality it might be a very important keyword that generated 7 visits through search. By removing formatting, WordStream enables a greater degree of grouping - highly similar keywords get grouped together automatically, which gives the search marketer a better understanding of the true statistical distributions of keyword taxonomies that they're working with.
The Ultimate Keyword Counter!
WordStream is the ultimate keyword counter because it is smart enough to realize that certain keyword searches are essentially the same thing, thus it enables a search marketer to infer a more accurate keyword visit count. It also means you don't have to export keyword reports from Web Analytics applications into Microsoft Excel and manually cleanse the keyword data of invalid characters - rather you can immediately use the keyword data in various search engine marketing platforms such as Google Adwords, Yahoo! Search Marketing, and MSN search. If you're struggling with keyword visit counting, sign up for a free trial  of WordStream!