I thought that I may share something with you, those who are Excel experts may stop reading just now, no breaking news here - just my humble experience from today.
So, lets get on it.
KS is a great tool, but we all know that results, especially after long term scrapping are various and need to be sorted out in some way.
Here is my short 'tutorial' on how to process gathered data in Excel. Precisely - how to remove unwanted key phrases from the list basing on 'unwanted' word(s).
I'm not an Excel expert by any mean, so I thought few people here may be also interested in some tricky features on how to remove unwanted keywords from the Keyword Snatcher results using Excel.
Ok, so what I'm talking about?
For this example I run few seconds (literally) of scrapping keywords for 'dog training london'
We have got:
As we can see right now, there is few words which aren't really 'money keywords' if you are ranking locally for London.
At first glance they are 'ohio' and 'ontario'. Yet 'south africa' and others. You've got the point.
Copy all the keywords (or download) and open in Excel.
Then click Filters from top menu in Excel
You'll see small arrow at the very first row of your keyword list, and click it.
Next, chose 'Text Filters' -> 'Contains' option
You will see dialog window.
The window will show 'contain' and a field to type in your 'unwanted' word. In our case (let's say) we don't want keywords containing 'ohio' and 'ontario'.
MAKE SURE YOU SELECT 'OR
' not 'And'!!!
Type in your unwanted keywords and make sure that you change the operator to 'OR'!
Otherwise it will select only rows containing both 'ohio' and 'ontario' (In that case nothing would be selected, you can believe me).
When you click 'OK', you'll get something like this :
Fine. You are on PC - simply click 'Delete' and congrats! - job done
If I remember - on Mac it would be Cmd+Backspace, but I'm not sure.
What you see now is your list with some 'gaps'. Those gaps (unless you sorted the list somehow) are empty spaces after deleted keywords. That's fine, everything is ok so far.
To sort it out and make nice and tidy, simply go to the menu and click A->Z icon, with column A (in this case) selected.
Ah, quick tip here. If you want to select only as much rows as exist in the spreadsheet - select cell A1 and click Ctrl-A (like 'select all' in Windows), it should select all your cells with the keywords.
Sorry image doesn't show 'selected' items, but you should end up with something like this:
After removing few more words:
I hope that helps a bit.