Here is an updated video on the Keyword Research Spreadsheets in the members section of Blogging Underground which includes an in depth explanation of the new Google Keyword Planner Tool in Adwords.

Click the IMAGE BELOW to watch the video!

The video above explains how to use the new keyword research spreadsheets plus shows in great detail how to find incredible keyword opportunities using our spreadsheets or by the new Google keyword planner tool.

If you’d like to see a sample of the spreadsheets – go ahead and download the zips linked below. I’ll include a zip with 10 of the newest spreadsheets (.CSV) plus an older zip with 10 of the spreadsheets from before Google made the changes to the keyword tool.

> Newest KEYWORD OPPORTUNITIES Zip with 10 .csv format spreadsheet files

> Older format KEYWORD OPPORTUNITIES Zip with 10 .xls format spreadsheet files

There are over 71 zips in the Keyword Rsearch section for Blogging Underground members – that’s around 710 individual spreadsheets with over a million keyword opportunities!

Download the zips and see for yourself how easy it is to find great keywords!


Aug 03rd by Mike L

Linking for a new site

There is a discussion in the Blogging Underground forum about linking and what percentages you should be going after for brands and exact keywords in domains and so forth.

It is LESS IMPORTANT for a new site than for a site that already has a LOT of links coming in.

The main thing I say about getting your NEW site linked is don’t worry about PERCENTAGES of LINK TEXT too much at the beginning BUT just make sure you don’t do anything ONE WAY and 100%.

It’s really not necessary to count links on a brand new site and keep track of what link text was used x number of times BUT that said you should be including some variations so they aren’t all the same.

At the beginning when you first launch a website you are trying to establish what the site home page is about, so you really don’t need to worry too much about over doing it.

In fact – at the beginning you SHOULD be overdoing it a little! Especially IF your keyword is in the domain name!

Focus on your main target keyword for your home page and then for each URL and then every few links that are placed in the BU Blogs use a slight variation – ie shuffle the order of the words in the phrase or add an extra word before or after or in the middle.

The obnoxious patterns don’t emerge until you have a LOT of the same links coming in.

That said – as I point out in the Blogging Underground 12 Step Success Strategy Training it is important to not only target a primary keyword but also secondary keywords for the home page and each URL.

Just make sure the words you are linking to in the link text are actually on the web page.

What words are on your page that you can link?

If you want to know the 2 and 3 word phrases that are on your pages – simply drop the URL into the AUKDAT Keyword Density Analyzer Tool and it will show you all the words.

You’ll get MORE TRAFFIC if you link a good variety of the words that are appearing on your pages, rather than only a few words.

You can rank for LOTS of keywords on each page – not just one primary!

I personally don’t like putting any exact % on the link text used to link to new sites – I always just do it by how it feels and it still works well – even after Panda and all those ‘over optimization penalties” that hit a lot of sites.

Now – once a site is indexed and starts ranking for keywords and is moving up – then you need to start being aware that you must include more variations and types of links and even do some bad linking.

Yes – bad linking is good. You need some less than perfect links in order for your site to be normal.

Every site has some bad links and links that are not in your control and the search engines know this.

Once I have 30 or more “perfect links” I know that are indexed and coming in, I will consciously start to add in more link variations and “bad text” links with stuff like click here, more info on x, www.domain – add extra words – shuffle the order, misspell, capitalize, lowercase and so forth.

It is also important to make sure you have some less than perfect links coming in – ie nofollow links and bookmarks and social links – even if they are coming from shortened URLS or redirects.

Once again – we want our site to be normal and not too perfect or ‘over optimized”.

What about brands and product names?

As far as “brand” linking goes – if your site domain is a product name or company name or diferent than your primary target keyword phrase for your home page – you need to have a good amount of links to whatever that is – if you don’t have any links or only a few to the “brand” and LOTS with the keyword target that will be seen as UN-NATURAL

Example: if you domain name is but your primary target keyword is nut butter – then make sure you have a healthy amount of links for BOTH – and most likely it should be NOT TOO HEAVY for the target keyword NUT BUTTER since it is different.

ALSO – include both in some links – “ Nut Butter” or “Newtella Nuts Agogo Nut Butter” or “Nut Butter at” etc.

Just be human and you should be fine.

NOW if you are using bots or automated linking schemes – yes – you could get in trouble – but that has always been risky and we don’t suggest you do that on your money sites.

There are enough blogs spread over the globe here in the BU Blog Network so you don’t need to go automated on your money sites for the most part.

Now – if the site is a feeder and one or more layers removed from your money site – that is a different story – you can blast away on those layers – just don’t KILL your money maker by over optimizing or revealing obnoxious patterns.

> Is it worth $16.58 per month to get access to post in our blogs? YES! <

Best wishes for your online success!

Not a BU member yet? Be sure to check out the Special Quarterly Deal – it’s only $33. a month to join Blogging Underground right now! More details and the secret purchase link is HERE

Related Articles


Mar 24th by Mike L

Linking Tips for Brand New Domains

Do you need to worry about the keywords used in the anchor text on brand new domains?

I was just asked by a Blogging Underground member who was following the 12 Step Success Strategy Training about how to link a brand new site and whether we should VARY the first links that are coming in so the link text is not all the same.

My response is different depending on whether the domain name has the keyword phrase in it or not.

Is it an exact keyword domain (aka exact match domain)

If your domain is something like:

Then your MAIN TARGET keyword should be WordPress SEO Tips

If it is an exact match domain you should initially be linking to establish the main target keyword for the home page and domain name.

You actually want to start off with a high % of exact keywords in the links. It’s natural.

IF it is an exact match domain!

I’d say 3 out of 4 OR even 4 out of 4 for the example above – WordPress SEO Tips is good to start for a the domain – since the domain name is the EXACT KEYWORD.

On a new site it’s NATURAL to link to the exact keyword of a domain name.

It is NOT natural to link a KEYWORD that is NOT the domain name.

If your domain name is NOT the keyword – then you shouldn’t do it 4 out of 4.

That is NOT natural.

For the most part if you are using exact keyword domains, I don’t think it is necessary to worry about link text variations on a new site until you have a higher number of links coming in.

Just make sure you try to stay away from doing any one thing 100%

4 out of 4 is nothing to worry – 9 out of 10 is nothing to worry about – but 40 out of 40 is a pattern that will stick out like a sore thumb!

as more links are coming in you increase the variety and you start to include more different keyword targets. Add an extra work. Shuffle the order of the link text.

For an exact keyword domain that is brand new and getting it’s first links I’d keep it tight and do a HIGHER % of “exact keywords” for the first 10 or so links coming in.

8 or 9 out of 10 with the exact keyword in the domain sounds about right.

Then as you get on the first page for your traget keyword and start moving up, you can mix in a few more links that are variations (extra word etc.)

Now – you may start to drop in ranking initially when this happens – but it should level out over time and you’ll move back up as all the pages with links come in and start to get crawled and indexed.

Once you get a large number of links coming in, you will need a better overall variety of text links- including some links with anchor text that are not so good…

Less than ideal links with text such as click here for ZZZ, Visit at etc

It’s only natural for a site to get links that are NOT PERFECT.


PLUS as you get more than a handful of links coming in you will need a natural mix of different link types.

I’d say when you start to get more than 20 links coming in you should make sure at least a few are coming in that are nofollow links such as those from bookmark sites and from social sites like pinterest, facebook, twitter etc.

As a site becomes established the patterns start to be revealed more and more.

The patterns will show when you hit a CRITICAL MASS of lots of text links coming in.

We don’t know the exact number, but it’s pretty clear with the newest algo changes they do expect variety and reward for it!

Now – what about if a domain does NOT have the keyword in it?

Well – in that case you need to be more careful and make sure you do not have too many links coming in that are NOT in domain name.

It’s natural for keywords in domains to be in the link text – it is less COMMON for text links to a home page that are NOT in the domain name.

If your brand new domain is something like and you are linking heavy for WordPress SEO Tips and nothing else – well you might just get in trouble pretty quick and get flagged as an “evil doer” and have little chance at ever ranking for that keyword until the ratios are more natural which could take a long time to correct (if you even figure it out!)!

So – the moral of the story is – that the 12 Step Success Strategy Training here at Blogging Underground suggests going for EXACT KEYWORD DOMAINS for a good reason.

Exact Keyword Domains are easier to get to rank for the keywords in the domain!

And we focus on doing what is the easiest! You’ll get on top faster and stay there longer if you get an exact keyword domain and follow the training here at Blogging Underground!

This stuff works! It still works and will continue to work!

More info and a special $99. offer for Blogging Underground can be found HERE

Dec 12th by Mike L

I often get asked how to find out if a site is ranking and/or indexed by Google.

Often I find people are obsessing about all the keywords they are trying to rank for and are spending a lot of time checking rankings when in actuality we should be checking REFERRERS to see what keywords actually send your sites traffic!

So – to see how many pages are on Google or to find out if your site is indexed – go to and type in

Google will show you the URL’s it has in it’s index.

Type it in without the www to see ALL pages including any subdomain pages or pages indexed w/o the www in the URL

If you find you have BOTH www. and NON www for the same pages indexed by Google you will need to try and fix that. Otherwise you’ll have 2 identical pages and they will both be dilluted in value. Make sure only ONE is indexed for max effect!

ie and

You don’t want both versions indexed – one or the other. I usually go with www

If you have WordPress – it will usually take care of that for you in the .htaccess file. If you do not use WordPress or it isn’t working – then go find your .htaccess file which will be located in the root folder of your domain on the hosting account – and upload it so you can edit the file. NOTE that files that begin with a . like .htaccess may be hidden depending on the setting of your hosting or FTP program.

Get the .htaccess file and simple add this code and modify by replacing your domain name: (Read the rest of this entry…)

Oct 07th by Mike L

Are you familiar with Keyword Density?

It’s really important that you understand keyword density if you’re building web sites and targeting specific “exact match keywords“!

If you are NOT aware of your keyword density it is possible your page and/or website will be OVER OPTIMIZED and that can cause big problems!

It’s actually better to be UNDER OPTIMIZED than to have too much of a good thing!

What is your keyword density?

If you want to look at a URL and see the keyword density, you should really have a look at my free AUKDAT Keyword density Analyzer TOOL!

How often a keyword appears on a page is referred to as “keyword density”. Over optimization is when your page or site is TOO PERFECT. Stuffing a keyword will cause high keyword density and is a case of over optimization! (Read the rest of this entry…)

Sep 13th by Mike L

    A Very Important Concept