BU Keyword Research Spreadsheets

[admin]

I hope you get a chance to check out the BU Keyword Research Spreadsheets - they're better than you may realize!

OK - so most keyword research is old and useless - right? I know - lists are just lists! And a list itself is NOT worth anything.

But the BU Keyword Research Spreadsheets are NOT just lists! They are files loaded with opportunities IF you know how to use them!

For one - they ONLY contain thousands of "exact match" keywords with "exact" volume and AVG CPC data from Google! That's right! NO BROAD MATCH garbage with inflated volume!

And the way we have it set up is that we give you zips with 10 large spreadsheet files (.csv format) which when opened in Excel or a spreadsheet application can be sorted, filtered and cleaned!

That's where the power really comes in!

Open up a file and sort it and filter according to your settings - that way you can get a lean and mean file of keywords that you can use to either go "Domain Hunting" with or simply target for writing articles.

Well I could go on but you'd get a much better idea of how valuable our BU Keyword Research Spreadsheets are if you watch the video overview!

http://www.bloggingunderground.com/videos/bu-keyword-research-oveview/

[admin]

They come from the Google Keyword Tool. The data may have changed or have been updated.

There are currently over 32 zips - total of 320 spreadsheets and growing as I add 40 new ones every 2 weeks.

The keyword spreadsheets are constantly updated with the newest ones at the top. I am adding new ones every 2 weeks so there is no need to REDO any old ones - they all have value - regardless of the date - and if you only want to use the most recent ones - do that - but most users folowing the 12 step system will benefit from using all of the spreadsheets - even the oldest ones! Maybe even especially the oldest ones!

If you need current accurate data - youshould get that from the tool directly.

The spreadsheets work like magic. Really! I hear it all the time from people. They do what they are supposed to do. They are not intended to ALL be accurate up to the minute. If you need that - that's where the GKT comes in

I do not use the "new" Google keyword tool. It is still in beta and the old tool does exactly what we need.

First off - the volume and bid numbers themselves from Google are estimations so I doubt they are accurate to begin with.

I just looked up party supplies and it shows 823,000 volume for "exact match". I don't know which spreadsheet you were looking at. I'm sure that keyword is in several of them - some older - some newer.

That is another reason why I think that SOFTWARE CAN'T PREDICT PROFITABILITY. You need to eyeball the data a put it through tests and use your brain to make judgements based on several factors that can't be measured entirely by numbers alone.

The spreadsheets provided to members are just fine the way they are. They have fantastic keyword opportunities in them. How accurate the data is - should not impact the way you use them to find keyword targets.

The dates of the data are in the file name date.

Use only NEW files if you NEED the newest data - BUT - for waht I use the spreadsheets for and train BU people to do - the date of the data does not matter - there are keyword opportunities in ONE YEAR OLD spreadsheets.

That is why I suggest in the training going to the Google Keyword Tool to verify and look at the updated info to make surebids are still good and volume is still there.

Also keep in mind from month to month data flcutuates - Halloween is not a year round search topic so it goes up and down. Unless you have data from October (it's September now) it's not accurate anyways.

That said - I have never personally noticed a difference - however I must admit that is not something I look for.

[MasterMind]

Considering google now only shows their results instead of theirs and others the numbers from goog are always going to be smaller.

Even google admits the numbers are estimates and not always good estimate.

I sort the spreadsheets and eliminate everything less than 1000 hits. Then I run the keyword phrases thru godaddy to get the domains available. Then I take all those keyword phrases that could be domans and run them thru market samurai. Then I eleminate anthing under 200 hits per month and 2 bucks, depending on the CPC. Never less than two bucks tho.

By the time I'm done with that I go check competition to see how easy each one is. If they aren't easy I eliminate them or save them for a later page. Then, with any luck I may have a couple that will work and have 200 or more hits per month. Now these hits may seem low to you but that's the number of projectd hits if you are at #1.

Bit if advice, when you're looking at numbers on the net, if you didn't generate them yourself 1 minute ago, they are out of date. That's the way of the net. It changes every freaking nano second whether we like it or not.

Unfortunately we aren't making a finite judgement about keywords. What it boils down to is you are making an educated guess at best. That's why it isn't always going to work.

Oh, I cut off at 1000 hits because I figured out that works out to about 200 a month in market samurai so I see about an 80% difference. Nothing new there as I have always seen huge differences no matter where I got the numbers from. Exact also always looks real bad. I much prefer phrase for traffic numbers however for Mikes system exact works perfectly.

The placement of keywords in the numbers hierarchy shouldn't have changed so the keywords are still good no matter the traffic google says now. IOW the best keyword before the numbers change is probably still be the best keyword now.

Always remember, no matter what google says, they aren't very webmsater friendly so why would you expect any better numbers for keyword searchs than we get for site links from google. Ones a bad estimate, the other is an outright lie.

[admin]

The value of the BU keyword spreadsheets is as IDEA STARTERS to help make it easy to find KEYWORD OPPORTUNITIES you may not otherwise have considered.

Each sheet is loaded with a lot of keywords and they drift which makes many more tangents possible.

You need to open your mind to the possibilities instead of making the data do something which is apparently frustrating you.

It's a huge list of ideas. You can even use OLD OLD OLD spreadsheets and still find tons of great ideas.

The data being 100% current is not our job. That's google's job. If you ant current data - look it up on the Google Keyword tool. That's what I do - butonly after I have found some appealing keyword opportunities.

How you use them depends on what you are trying to accomplish - but you should ALWAYS look up the most recent DATA on Google after you have created a list of potential keyword targets.

Any report from any source is out of date the minute the data is pulled up. You can't expect an exact figure. Same applies to any data from any tool.

The spreadsheet's purpose is to give you a LARGE POOL of potential keywords to help you narrow down the possibilities.

They can be used in a million different ways.

[patpower]

I have been having expensive domain name buying Saturdays because of these keyword research spreadsheets.

I get so excited when you put out new ones. I open them and examine all the high CPC keywords, do more keyword research, then do a bulk domain search to find the available domain names.

I am always so amazed at what is still available and get so excited building my adsense blogs. I end up monetizing them with other things as well--clickbank and amazon and they end up being very successful blogs.

It is such fun.

Pat

[admin]

I have been having expensive domain name buying Saturdays because of these keyword research spreadsheets.

I get so excited when you put out new ones. I open them and examine all the high CPC keywords, do more keyword research, then do a bulk domain search to find the available domain names.

I am always so amazed at what is still available and get so excited building my adsense blogs. I end up monetizing them with other things as well--clickbank and amazon and they end up being very successful blogs.

It is such fun.

Pat

I love to hear that! I know! I just found 2 yesterday I could not resist. I can't believe the domains are available.

Just do ME ONE FAVOR THOUGH - only buy domains if you intend to put SITES UP for them.

Don't make the mistake I have made and buy domains that never get set up as sites!

[patpower]

Yes, I know what you mean.

I try to get right back to them and build the blog. My problem tends to be that after I put the one page up and it is indexed, then I forget to go back and finish them.

However, let me hasten to say. There have been times when I went back to the blog and was THRILLED BEYOND WORDS when I found out where I was ranked. After one article. TOO COOL! That gave me the incentive I needed to add new articles and products to it.

Currently, I do not have a blog up that does not pay for itself with Adsense income.

I guessed you know now that I am a big fan of BU.

Pat

[admin]

Thanks for sharing that!