Hi Guys, I am looking for a keyword manipulation tool that will enable me to change keywords to phrase and exact matching, and change their orders. i.e. I may have these keywords: digital point rocks digital point rox I'd like to copy them to: "digital point rocks" - phrase matching [digital point rox] - phrase matching and I'd like their orders to be swapped around: "digital rocks point" "rocks digital point" "point digital rocks" [digital rocks point] [rocks digital point] [point digital rocks] etc. Though the example does not make much sense, with a lot of keywords, people would be typing them in! The whole point of all this is to lower the CPC. Phrase and exact matching does that. Has anyone seen such a tool? PPC Keyword Generator tries to do something similar, but isn't quite what I'm looking for. I'd be happy to pay.
I'm not exactly sure what you look for but In Keyword ELITE you can add and remove " and [] characters in your keyword list plus many other editing features. You can also organize your Adwords Groups in Keyword ELITE. It costs ~160$ US so it's not a free tool but it has many features besides editing keyword lists and organizing adword groups. Before i bought Keyword ELITE i used excel to change to exact or phrase match. I used the CONCATENATE function to add characters at first: for example =CONCATENATE("["+A1+"]") (this adds [ in the beginning and ] at the end of the keyword located in cell A1). If you have a long list of keywords you just copy the formula down the list. I then used the "search and replace" feature in EXCEL to remove the "[] characters or change the keywords from one match to another. I'm sure there are better ways but it worked for me before.
Binko is spot on with the excel advice - the challenge with excel is that it is not a great tool for text manipulation. if you have any programming experience, I would suggest using Perl or Python, or PHP to write a quick script that 1) takes each line of text 2) seperates it into its word compoents by using spaces 3) creates a new list of of words, and then puts the appropriate matching around them. Any one of the above languages is GREAT for text manipulation, and easy enough to do the work quickly. You could also write an excel macro using VBScript, but not as useful. If you want to go the buying route, check out KeywordCompanion. I just bought it myself, and will give feedback after I work with it. It basically is a list / keyword managment tool that is good if you have a large list of keywords to split, group, etc.
Thanks for the suggestions guys. The excel way sounds cool. I would rather automate as much as possible, so I will probably look into the programmatic way. Someone should write a script like this and host it, it'll be a great link bait!