I'm looking for what could be one keyword tool, but probably is two different ones. I would prefer free of course, but if that isn't possible, looking for lower cost. The first one would be for keyword filtering. Something that would take a long list of keywords and let me filter the list for word or multiple word matches. As an example - with the following list: brown bags red bags paper bags brown paper bags paper sacks Using the utility, if I filtered for "bags", then the first 4 keyphrases would come up - searching for paper bags would bring up #3 and #4... would be ideal, would be searching for "brown bags" and bringing up #1 and #4 (meaning, the words must be contained, but not necessarily in order). The second utility I am looking for is to take a keyword list and create the 3 possible listings for each one aka: brown bags red bags paper bags becomes: brown bags "brown bags" [brown bags] red bags "red bags" [red bags] paper bags "paper bags" [paper bags] Anyone have any that they use and/or could recommend? Thanks, Matt
you are looking for a custom solution, since a tool like this does not work. I actually created one that does the 1st scenario, the second I wouldn't use because this tells me your do things on the web interface, which takes forever. You should consider using adwords editor to make your life easier. Unfortunately, I do not think I can share the tool I have designed
robertpriolo, Wow... well, that solves the 2nd request... lol I just downloaded the tool and figured out how to quickly solve that problem. Now I'm debating dusting off what previously was my VB5 skills (yea, it's been awhile) and seeing what I can create with VB6 (I still have an installed copy). I have some ideas of how I could code the basic filter engine. I guess if I can't find an acceptable tool I will have to do it myself. csourse, Efficient PPC doesn't look like it does what I'm looking to do with filtering... Thanks to you both, Matt PS. If anyone still is looking for what my 2nd keyword tool would do... here is a free site: http://wisitech.com/what-we-do/free-seo-tools.php
Here try this code, it should solve your problem Sub extractthiskeyword() Dim xthiskw As String xthiskw = "*" & InputBox("Enter Keyword To Extract Name") & "*" Dim stepthisrow As Integer stepthisrow = 1 For Each C In Range("A1:A" & Range("A65000").End(xlUp).Row) If C Like xthiskw Then C.Cut Range("D" & stepthisrow).Select ActiveSheet.Paste stepthisrow = stepthisrow + 1 Else End If Next End Sub
dude, no programming required! excel has filtering options, just go through the help files. as for your 2nd tool. what you're looking for is an "adwords wrapper", just type it in google, the first result is free and easy to use.
Revenuewire put out a tool that does what you asked for Get it here: h++p://blog.revenuewire.com/?p=38 I suggest you get it while it's still free.
Exel and Adwords Editor are the best free tools. But if you want to be "professional", try keyword elite..