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!

Enjoy!

Aug 03rd by Mike L

If an established site drops from page 1 to page 10 – what do you do? I’ll tell you what I would do!

It’s Mike Liebner here! A brand new Blogging Underground member just asked me for help in the BU forum and I thought I would share this valuable info with you too.

The BU member wanted to know how to get his old established “PageRank 3 authority site” back up to the top of Google, as it had been #1 for a long time and had dropped significantly. In particlular he wanted to know how to post in the BU blogs to fix the problem.

I analyzed his site and found a bunch of mistakes and problems so I thought I would share the suggestions with all of you guys and expand a little so you too can get an idea of the things I would do to bring an older established site up that had dropped in rankings significantly.

199-internet-coupon

If an established site has major problems – just posting in the Blogging Underground blogs or getting links from any other websites or blogs is not always going to be enough to magically solve the problems that dragged a site down in the first place and get it back on top.

Don’t get me wrong – the right kind of links will help almost any site move upwards – but we also need to look at other factors that could be hurting the site.

It could be as simple as getting a few of the right kind of links – but most likely it would require more than just OFF SITE FACTORS to get a site moving up the rankings and eventually back on top.

You may need to fix your ON SITE FACTORS too and correct any mistakes you can find.

Generally it’s pretty hard for me to make specific suggestions to someone about their site without taking a good amount of time to study the site in great detail. Problems are not always apparent on the surface. We don’t always see what Google sees unless we dig to find things. Plus I don’t know everything that has been done historically to a site which may have affected how Google sees that web site.

While it is normal for an established top ranking site to fluctuate in rankings when an algorithm change occurs at Google (they do happen with regularity) – it is not normal for a site to drop down 100 positions or worse.

If a ranking drops more than 50 or 100 positions then most likely there is something wrong with the site or you just did something they don’t like.

It might be fixed with some good quality links – but it may require additional work to get it back up.

So why does a site drop so drastically? Well – if it is still indexed there is hope. Also – you need to wait a few days or even a week or two if you can and see if it bounces back. A site will often come back after they re-adjust their algo changes – so don’t panic too quickly!

It may just be that over time a lot of little things added up and suddenly the site looks spammy – or it could be that the algo change factors something in heavily that was not factored in before.

Regardless of why a site has dropped – we need to look at the site itself and try to find things that we know that Google generally does not like and improve them.

Almost all sites have something that can be improved and often a few fixes can be enough.

The site I analyzed for the Blogging Underground member was NOT the type of site we teach members to build in the 12 Step Success Strategy Training.

It was more of a “cookie cutter” type site – very obviously auto generated by a script.

Sorry, but most coders who make scripts that auto-generate websites do not usually know GOOD SEO and they often structure sites the wrong way and do things that Google does not like.

A few less than perfect SEO blunders may not be a huge problem – but over time as a site matures, the bad things can start to add up and eventually hurt a site.

That’s why we offer training at Blogging Underground to help people build sites the right way from the ground up, so we have as much going for us in our favor as possible!

Every little bit helps!

The training here focuses on building themed content rich sites targeting a primary keyword and secondary keywords and supporting the site internally with good articles and proper site structure.

Sites that are built the right way from the ground up usually only need a small amount of good quality links to boost them to the top of Google because we only do things we know they like.

If you followed the training here at Blogging Underground and built sites according to the steps we teach, you most likely would NOT be having the kind of problem this member is having, because our training avoids doing the things that most often gets sites in trouble

The member’s site I have analyzed is more of a “cookie cutter” type of auto generated thin content site, built with a script that has little, if any original or unique content. It has lots of pages with similar or near identical content.

The site has page after age of line listings of services offered that link to inner pages with buy buttons and hardly any text.

I’m not slamming sites like this. I understand many of you have sites that are not purely “article type sites” and that’s fine – I also have some auto generated sites and sites that run scripts and do just fine with them – but you do need to be more careful with those kinds of sites because they are most likely to do things that can get penalized.

Penalties are normal – whether you are aware of the or not.

All sites get some kinds of penalties – that’s ok – usually they are not enough to drag it down, but unless you’re Wal-Mart or Amazon, or have a ton of natural traffic from people who love what you offer and visit your sites from word of mouth, it may not be easy to get on top with those kinds of sites if and when they get penalized for something.

Now – don’t freak out about getting penalized by Google.

Every site – even the most popular are getting scored and rated by Google and have some minuses going against them – it’s just that sites that have lots of PLUSES don’t get hurt as much by the penalties.

If your site ranked in the first 10 results before and you had a sudden drop to 100 or even lower, then there is a good chance something you did recently, or have been doing consistently factored in highly and is causing the drop in rankings.

Since we’re not talking about dropping from 1 to 2 or 5 – but rather dropping 50 positions or more in a short period – it can’t simply be related to what other sites are doing or have done – it’s something your site is doing.

The good news is that as long as your site is indexed by Google and can be found, there is a good chance we can get the site back on top by fixing flaws we know are bad for a site and by starting to do things we know Google likes.

If you start doing these things and see upwards movement it is simply a matter of getting enough little things on the site fixed to tip the scale back in your favor.

If however after a few weeks of fixing things and your site does not move up at least a little in the rankings – then you need to ask yourself if it’s worth spending much more time on fixing the site.

You don’t want to waste time if you know you have done something really evil like blasting directory submissions or some kind of large scale automated spamming that you got caught for.

That’s hard to correct and a site may not be able to recover in the immediate future.

For example if you have 1,000’s of identical spammy text links with the same exact text or too many SIMILAR links from blasts of some kind it could be holding you back.

Then again its possible Google has simply changed an algo and now doesn’t like pages that have over x % of keyword density – or too many links on a single page or whatever it may be. If that is the case a few simple fixes may be all you need to get back on top.

The site I looked at for the Blogging Underground member that dropped to 100th place for his main keyword is thin on content – especially on the home page. It is also repetitive and is hammering a lot of the same keywords at a very high density.

Check out your page URL in the free AUKDAT keyword density analyzer tool

> AUKDAT Article Undeground Keyword Density Analyzer Tool

This particular site I am analyzing has no real content other than listings of services and no real content or even a description of what the site is about. Just a list of what’s for sale.

That isn’t enough.

In this case I suggest adding a few paragraphs of text talking about “the primary target keyword” for the URL so there is some real relevant content on the page.

I also saw this site was using HOME as the link site wide – I would make sure that the HOME link is changed to the keyword being targeted or “The Keyword Phrase Home”

That’s why I like ‘exact match domains” so much. It is very natural to link to the keyword for the home page links site wide.

The site has over 3,000 pages indexed but all the pages are near identical. I only looked at a handful but all of them were “thin content” and/or replicated/duplicated/similar content.

A few good original article pages would do wonders for this site.

Create some articles for relevant related keywords and put them on the site and make sure each article page links to the home page with the “exact target keyword” within the content. This is an in-content link and has magical powers whether internally on your own site or externally linking from another domain.

Each of the new article pages added to the site should be linked from articles posted in the Blogging Underground blogs and point to the new article pages that have the text links pointing at your home URL.

You will boost the value of these new pages and the relevance if done according to what we teach here at Blogging Underground will have a big impact.

Just a few articles will go a long way.

I suggest starting with a unique article posted in 3 different BU network blogs pointing at each new article page you added on your site. You are announcing your article pages in the BU blogs and establishing relevance for your keywords.

This is very powerful.

This in itself may be enough to get you moving upwards – but you still should try to fix other things you know can be improved on your site.

On this particular site I was analyzing, I would also make sure I had a good variety of links from lots of different places pointing at my home page, making sure that TOO MANY of them were NOT perfect links for “exact keywords”.

In other words make sure you have some links with the domain/URL or click here or click here for x etc.

The site I was analyzing had pages indexed on Google with BOTH www and without www – ie http://www.domain and http://domain

When Google sees those they consider them as 2 different URL’s that have exactly the same content. This dilutes BOTH URLS and makes it harder for that page to rank.

Make sure if this occurs that you put a script on your server to force one way or the other – otherwise your URL’s have duplicates with same exact content. You can do this by putting code in your .htaccess file

You can find the code in the BU Forum at this URL:

http://www.bloggingunderground.com/members/forum/viewtopic.php?f=22&t=565

The site I analyzed had too much thin content, the near empty text light pages could be diluting the overall value of the site – especially if you have www and non-www URLS indexed that show exact same pages.

Get social!

It’s more important than ever to have some good social signals coming in to a site.

I would make sure the domain had a good variety of ‘social signals” coming in – Facebook likes, tweets on twitter linking to the site and some other web 2 links that popular sites usually have these days.

Also – if this is an important branded site or a money site, it should have its own associated social accounts that link back to the site and regularly announce things for the site.

Twitter.com/yourdomain

Facebook.com/yourdomain

Pinterest.com/yourdomain

etc.

Buffer Sites

Another thing that would help is to create a few related “article sites” about “the exact keyword target” and use the sites to link to your money site home page and to the best article pages.

They should have reasonably good content on them that is relevant to “the exact keyword target” and link from those articles to your home page and your best content on the money site.

Ideally you’d buy related “exact match keyword” domains that are on different servers/hosting/ip addresses – but if not practical – free hosted blogs can also be used as the buffer sites.

Link the “buffer sites” in the Blogging Underground blogs and in other places to make sure those sites have a little power of their own.

That could help a lot to revive a site like the one I analyzed. The additional PLUS POINTS may be enough to outweigh any penalties or negatives that originally dragged the site down in the first place.

Any one or two of the things I suggested may be enough to get the site back on top – but maybe it will take more of them – so I would just keep going and making the improvements and fixes until some upward movement occured.

Those suggestions should help almost anyone get a site that dropped back up on top.

Just remember – you’re trying to tip the scales back in your favor – so start doing more good things and fix as many of the bad things that you can and you should be able to get an older site that dropped back to number one!

power of links

Best wishes for your online success!

Mike Liebner


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


 

Apr 25th 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 www.Google.com and type in

site:your-domain-name-here.org

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 http://your-domain-here.com and http://www.your-domain-here.com

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

Is it harder to get a top ranking now?

It is NOT harder now to get a top ranking than before the Penguin update!

Hi its Mike Liebner here with a long info packed article I hope you’ll read and even print if you find it valuable. I think it may inspire you and help you get focused on what is needed to be done to get top rankings right now!

We’ve had a lot of new members joining the past few weeks to take advantage of special prices, plus a lot of existing members have been renewing their memberships.

> Blogging Underground $99. Special Deal with a huge 4,800 PLR Bonus

I was just explaining in the Blogging Underground member’s forum to a returning member who was concerned it had gotten more complicated after Penguin, that while it may seem like more work would be required after the Panda Penguin update, that the reality is that it’s as easy or easier!

If you have not built a brand new site recently – you really should see for yourself how easy it is to get on top!

Right now if you follow the basic principles of the 12 Step Success Strategy System here at Blogging Underground it is very easy to build brand new sites and get them on top and keep them there simply by doing wehat we’ve always done – build pages and get links!

For the most part – depending on what keywords you go after – you don’t need to do that much once you’ve gotten to the top for your target keyword.

Simply keep the website blog fresh with a new post once in a while and try to add a good article as a page once in a while! Whenever you add something new – get a few fresh links coming in! This is working right now for me and for Blogging Underground members.

I still buy exact keyword domains and put up new sites and just by following the basic 12 Step Success Strategy I am getting my sites to the top very fast. And while the new sites do usually drop, it’s easy to get them back up on top with a new post added to the site along with a few fresh new links coming in.

The secret here is keeping the new site fresh.
 
Fresh content and fresh links work like magic!

I find adding a new post to the blog is often enough to boost the ranking. It shows Google the site is NOT STALE and gives them more confidence so they will move you back upwards.

Most times this is all that is needed, but if your keyword is more competitive you might want to do a little extra such as send a few social signals with Facebook and Twiiter etc.

Social signals happen with popular websites! Send a few yourself to get the ball rolling!

For safety and insurance, your site will be stronger with a few social signals coming in from the popular places online – but are optional.

You can get away without them – but they do help. That’s why I call them insurance.

I don’t usually do a lot of social marketing, yet I still get on top pretty easy for most keywords doing the same 12 Step Success Strategy stuff I’ve always been doing.

Looking back at what happened in the few months after Penguin – I can now say that the basic rules haven’t really changed so much.

The main consideration is being aware that a human reviewer might visit your website at some point in the future. You’ll be in a better position by making your sites look better (images and videos help!) and also by adding some social elements such as like buttons, google + buttons and the other social stuff webmasters dow with their sites.

Social buttons make it easy for people who visit your site to share your content. Sharing good stuff is social!

Tip: Use a WordPress plugin on your blog and make sure you have some popular social buttons on your sites. Use them for your own account(s) and also keep in mind other people who visit will use them and send social signals for you.

http://www.shareaholic.com/publishers/sharing/

Backlinks are still #1.

Good relevant in-content links work. It’s still what Google loves more than anything else.
 
If you can get links with your keyword in the content of good related articles you’ll do well.

Tip: Make sure you vary the link text – that IS more important now than before.
 
Link Text should not ever be 100% the same in all your links. Add variations. Add an extra word now and then – link to a related keyword phrase once in a while and even add “click here for _” or use a web URL as a link to add variety to your incoming links.

Get social! Social Signals are easy to add in the mix.

Social signals are when there are links and bookmarks from the popular social sites that people use these days – mostly for fun – but also businesses too are using Facebook likes and Twitter tweets and Pinterest pins and bookmarks and comments and the stuff that shows Google that people are buzzing about what you have.

You don’t need to become a social expert but it’s smart to do some of the common things that normal people with web sites do.

It’s not absolutely necessary, but helps! It is more for insurance than anything.
 
Why? Because if a human reviewer ever looks at your site, they will see it looks good and has social signals and link diversity and that reinforces the value they perceive your site as having. Popularity counts!

Looking good is important too.

The sites in danger of being deindexed by a human reveiwer are typically spammy looking, or thin on original or compelling content, and missing the kinds of social signals and interaction with visitors that typically exist on most sites these days. Add images. Add videos. Put stuff that people will check out and keep them from bouncing.

Add social elements so people share your links and bookmark you.

This social stuff isn’t hard. Start with Facebook or Twitter and expand with time. As time goes on, try to do some of what you see other sites doing. If you see something new popping up a lot – find a way to add it to your site.

Pinterest is a great example of something new that is now hitting critical mass.

I avoided it for a long time, but it’s actually pretty simple. I just created my first account.

http://pinterest.com/mikeliebner/

Pinterest is easy and it’s also a great source of traffic right now – not just good for link juice.

Just create a Pinterest account and every once in a while if you use a picture on one of your blogs, make sure you go to Pinterest and add it. Pinterest will link to your URL where the picture is. Easy to do and Google will see it and so will people who see you on Pinterest.

Facebook

Everyone has a Facebook account, right? You don’t have to become a Facebook expert. Just create a free account and use it once in a while for your web sites!

http://www.facebook.com/mikeliebner

If you have a Facebook account as you’re surfing sites you should start clicking the like button on stuff you see that you like. It will get listed on your Facebook page. Also you should like your own stuff (once in a while) or even create short posts linking to your stuff from your Facebook page. That’s so easy and helps send social signals. Other people will see it too and like it.

Twitter

Are you Tweeting on Twitter? You should be.

Just create a free Twitter account and once in a while create a tweet and link to a URL on your site. It will add a social signal.

www.twitter.com/mikeliebner

Also – lots of other sites like www.Topsy.com link to the Twitter users and will also show your links.

By linking your pages on Twitter, it also means other places will show your links too.

How easy is that? That’s pretty easy. All the social signals stuff is easy! You’re probably already doing a lot of this just for fun. Well – now do a little for your web sites.

This extra social stuff can help you, but don’t get overwhelmed by this stuff. It should be fun!

Doing ALL of the social stuff is not required.
 
At the very least though, you should try to do at least a few social things for your most important sites, especially when they are brand new.
 
Social signals add LINK DIVERSITY which is something I have suggested is important for a long time. I’ve always included getting links form other places than just the BU BLOGS in the 12 Step Success Strategy. It adds diversity to your sites footprint.

Social signals help add link diversity.

Backlink Your Backlinks

Also very powerful – backlink some of your backlinks!

It helps if the web pages your links are on ALSO have links coming in – ideally from other sites linking to them that are not connected.
 
Tumblr.com and Twitter are great for this. Free hosted blogs are great too.

Get a free Tumblr.com account and create a few blogs (they allow more than 1) and write a post now and then to link to your best pages and new posts.

http://mikeliebner.tumblr.com/

There are also many other places you can get free hosted blogs such as livejournal.com, wordpress.com and squidoo.com etc.

That’s pretty easy to do. And it’s NOT hard work!

So – if you want to build web sites and get top rankings it still is pretty easy!

Follow the 12 Step Success Strategies that we teach in the Blogging Underground members section. This stuff still works!

Blogging Underground $99. Special Deal with a huge 4,800 PLR Bonus

As far as ranking on top of Google and getting free search engine traffic – an exact keyword domain with some good relevant content structured the right way (Pages NOT Posts) makes it easy to get on top. Maybe even easier now, than before.

So as far as things getting more complicated – NOT REALLY!

The same stuff we have been doing at BU for a long time works very well right now.

So – if you thought everything changed and SEO is dead and marketers are doomed – think again – this stuff is still working.

While very little has changed – we do know they do appreciate social signals and that can help you get to the top and stay on top – especially with the more competitive keywords.

So just build some good sites doing the stuff shown in the 12 Step Success Strategy at Blogging Underground and also do a few extra social things and you should be set!

The main thing is getting links in some good quality articles pointing at your pages so you can move up to the top!
 
Not hard at all!
 
If you need good quality in-content links then you need Blogging Underground!

We have almost 300 blogs indexed by Google that members can post articles in!

We’re also offering the Blogging Underground $99. Special Deal with a huge 4,800 PLR Bonus

It’s a great time to be a Blogging Underground member!

You can still get on top! You just need some good links!

Best wishes for your online success!

> See also A Blogging Strategy That Works (more tips)

Jul 22nd by Mike L

Google recently wrote that it believes that SEO can be positive.

Hi, it’s Mike Liebner here and I thought it would be a good idea to share a link where
Google explains how it is making “algorithm changes’ that will be rewarding webmasters who take the time to build high quality sites.

> Official Statement from Google Search

Knowledge is power – so please read this!

I am not trying to make you fearful of their changes, but rather help you to understand what they consider good things to do with websites as well as what they consider to be “webspam”.

It’s worth reading, but please remember that Google will never want anybody to find out angles on how to gain an advantage – so just remember while we certainly want Google to index our websites and list our sites at the top, they will never fully embrace SEO and approve of the things that almost all webmasters do to get top rankings.

So what should we do about the changes???

I wrote a detailed article that explains what you need to do in great detail!

Stop by my blog to read my article on Google Penguin and please feel free to leave your comments!

Best wishes for your online success!

May 07th by Mike L




    A Very Important Concept