Author Topic: Google's Keyword Tool  (Read 1616 times)

Offline magicman

  • SR Member
  • Posts: 1,599
    • View Profile
    • Business Building for Small Business
Google's Keyword Tool
« on: July 30, 2011, 05:32:32 AM »
I know this is going to sound a bit silly, but I could use a little help with Google's Keyword Tool. Up until now, I've been doing screen capture and pasting into a Open Office Text doc. (Are you groaning at the caveman?)

How can I download these results into a spreadsheet so I can actually work with the results? I've tried to follow the G directions and get a bunch of junk - long strings of numbers -in many columns.

Ideas, please? - Thanks, Magicman



Offline Wayne

  • Sr. Member
  • Posts: 527
  • Let's EAT: Exposure-Action-Trade
    • View Profile
    • Mercs LLC: Action Oriented Technology
Re: Google's Keyword Tool
« Reply #1 on: July 30, 2011, 12:00:19 PM »
Have you downloaded a CSV file and opened it with OpenOffice Calc?

Offline magicman

  • SR Member
  • Posts: 1,599
    • View Profile
    • Business Building for Small Business
Re: Google's Keyword Tool
« Reply #2 on: July 30, 2011, 08:45:20 PM »
Yup. A bunch of the columns just have long strings of numbers in them. Am I doing it wrong, ya think? -MM

Offline Wayne

  • Sr. Member
  • Posts: 527
  • Let's EAT: Exposure-Action-Trade
    • View Profile
    • Mercs LLC: Action Oriented Technology
Re: Google's Keyword Tool
« Reply #3 on: July 30, 2011, 11:25:35 PM »
I can't troubleshoot this one without more info.

Can you do a quick video and/or screen shots? Jing's 5min limit should be plenty to show what you're doing.

Ed Guerena

  • Guest
Re: Google's Keyword Tool
« Reply #4 on: July 31, 2011, 05:46:12 PM »
Can't you just delete the columns you don't need and just leave the information you want?

For example, columns A, C, D and E have enough interesting information for my Kindle keyword research.

I haven't figured out how to interpret the "competition" (B) column in this raw form.  Anybody have an idea?

When I run this CSV file through Niche Profit Classroom's Money Word Matrix Tool, however, it cranks me out some more valuable information like Page Rank, Competition Rating, etc...

Your mileage may vary.

Ed

Oviedo

  • Guest
Re: Google's Keyword Tool
« Reply #5 on: October 21, 2011, 08:47:32 AM »
Magicman -

I'll perform some magic for you.  What info in the Google Research tool results are you interested in?

Just send me the "keyword" and I will email you the results.

Oviedo

jamaks

  • Guest
Re: Google's Keyword Tool
« Reply #6 on: October 22, 2011, 08:32:32 AM »
Hi Magicman, the secret is in changing the "separator options" They appear immediately under Character Set in Open Office Calc. Different CSV sources use different seperators, but in the case of Google the separator is "Tab" Simply uncheck the default value and check the "Tab" value (first in the list) and you will have a usable set of figures to work with. Trust this helps.

Regards. Jim

jamaks

  • Guest
Re: Google's Keyword Tool
« Reply #7 on: October 22, 2011, 08:49:09 AM »
Hi Ed, the competition data is merely an indicator of how many people are bidding on the keyword in an adwords campaign. It has no bearing on actual competing web pages.

If you were monetizing your web page with adsense you would be looking for high competition in this instance since more bidders through adwords for the keyword would mean higher CPC which in turn would mean a better payout for the adsense publisher.

A low competition figure would probably indicate that it would not be worth monetizing with adsense since the CPC would be minimal and there may not be enough advertisers to even get a paying ad displayed - in this instance a public service ad would be likely if you have allowed Google that option. Hope this helps.

Regards. Jim