7 replies to this topic

[btreloar]

I'm evaluating the Google Keyword Tool as a potential replacement for my subscription at Keyword Discovery. All I need from Google are the monthly search volume numbers. I do my own AllInTitle evaluations, etc.

When I look up keywords in the Google tool, I can easily click "Add" for the ones I like, and then Google will download my selection. But unless I take everything Google throws at me and choose to "Download all keywords", what Google downloads is only a list of my selected keywords without the search volume numbers.

Am I missing something obvious here? How can I download selected keywords and their monthly search volume numbers?

[Jill]

I don't think you can. You need to download the whole thing and cull via excel.

[btreloar]

I don't think you can. You need to download the whole thing and cull via excel.

<sigh> I was afraid of that.

On the bright side, the Search Based Keyword Tool does seem to allow export of just selected keywords, and includes monthly search volume, too. That one's looking better and better.

[linkb8]

Lol, that's why I liked the search based tool at first but when I checked the numbers they didn't match up between the 2 tools. Also I found the search based one would not always return stats for the keywords I typed in, which was frustrating.

What I do to pull down the search volume numbers in the Adwords KW tool in bulk is use Advanced Web Ranking. They have a keyword tool that allows you to pull down the search volume numbers and copy and paste them into a notepad. I'll pull down search volume for 300 keywords in just a few clicks that way, and get search volume for 1000s of keywords at a time. Saves so much time.

[Theo]

There is always winautomation.com and Excel macros to fully automate the whole process of boring repetitive and time consuming tasks.

The Google Adwords Keyword Tool allows one to export .scv files. These are excel friendly.

It takes a while to climb the learning curve here, but once you do, these tasks can run in the background while you can use your time with more productive brain work.

Just my 2 cents though.

Theo

[caneman]

Unfortunately, its all or nothing. I wish G would change that, but for now its not unfortunately.

[Lorelle]

Here's a workaround. As you browse the list of keywords, as usual, click Add to put them into the right-hand side of the page. Then output the list to a text file (tip: choose the plain csv format), and copy and paste the list in the usual place where it says "Enter one keyword or phrase per line." Uncheck "Use synonyms." Next, click "Filter my results" and checkmark "Don't show ideas for new keywords." Click "Get keyword ideas" and voila! You get the complete list.

Hey, here's another cool trick I found recently. It's a shortcut to find out what the current estimated bid is for advertisers in the top 3 slots. It gives you this info instead of the graph showing advertiser competition.

Simply do your keyword search as usual, and when the list comes up, highlight a few lines with your mouse. Copy and paste into a plain-text email or Notepad document.

[caneman]

Lorelle, thanks very much for those tips, seems like that would save some time and I will give it a try. I wish there was a way to click a button from excel and have the keyword search show up in your spreadsheet. I can total webpage count searches in excel using vba but have no idea how to interface with google kwt and get that data, anyone know how to do this?