Too many URLs is a Good Problem for SEO

If you ever receive an email from Google that says: “Googlebot found an extremely high number of URLs on your site,” then you’re probably doing something right. If you have an “extremely” high number of URLs in Google’s index, that is very good. Sometimes you may have a large website and may not get Google to even crawl all your URLs, so the fact that Google liked your site enough in the first place to crawl a high number of URLs, then you’ve done something right. Of course, it may also indicate a faulty URL structure that allows bad URLs, but it might also mean your site is just plain huge.

google

The more URLs you have in Google’s index, the more ‘chances’ you could say you have to rank for something. Maybe it’s like buying more lottery tickets, and thus, increasing your odds of winning.

The alert emailed to me above was for a site that has around 12 million pages indexed so far. The trick is that all 12 million pages are generated from only 1 page. That page has a few MySQL database queries which produce the content and uses an htaccess file to make the URLs SEO friendly.

It queries a table that has 100,000 cities in it and gives distances to different cities in the same 100,000-city list. Since 100k x 100k = 10 billion, that means there’s 10 billion pages/URLs generated from that single page. Even though Google crawled 10 million of them, it’s still only a fraction of the 10 billion total.

Generating a high page count from database content is a highly recommended technique for getting search traffic.

SEO Interlinking

SEO Interlinking
SEO Interlinking Strategy

Here’s a free tip to SEO pros who want to grow website traffic:

Do more interlinking of pages within your site.

In some situations, making more relevant links within your own site may have more impact on search engine ranking than getting a few more external links to your site. Link all of your related content together as much as possible, and if your site is weak in content for certain important keyword phrases, make new pages for that content simply to create more connections.

Let’s say I want to target the phrase ‘grow website traffic’ on this page, for example. Notice the URL, the H1 tag, links, and body copy all say that phrase currently. But if you do a Google search, you’ll notice grow website traffic dot com is nipping at the heels of this site at #2. If they did a few more things, they would be #1 above this site, since a keyword domain has more weight than a folder keyword like I have, agree? (keyword.com VS. domain.com/keyword). But, if either I or the owner of this domain were to do more interlinking, it would likely improve the ranking and may influence the order our sites appear in Google. Or, if you’re already #1, it may further solidify and distance yourself from the competition.

Interlinking: instead of just 1 page. You make 3 (or many more) pages within your site with those targeted keywords.

Example:
This site only has 1 page currently:
A. www.domain.com/grow-website-traffic/

But it would be more effective to make more pages like this:
B. www.domain.com/website-traffic-growth/
C. www.domain.com/growing-website-traffic/

Write a few paragraphs of original text, then interlink them. by linking A: to B and C, then link B: to A and C, then link C: to A and B.

Real working example:
http://animalprints.co/ – notice it links to BOTH category level pages, such as Birds, AND links direct to regular Bird pages.
http://animalprints.co/bird_prints/

Notice the Bird page links to BOTH other category pages AND other bird pages. One could make even more interlinked pages for birds and continue optimizing around those keywords. Basically, the more pages you add around a keyword idea and the more interlinking you do, the better you will rank. So, if a keyword phrase is really important to you, don’t give up after making only 1 page. Keep making more and more pages around it, and fill the page with unique text about the subject. If ou don’t have time, try paying a writer $5 on fiverr.com to write it for you. Easy way to get content.

TIP: One effective way to create more links within your site is to make a glossary or dictionary. Then on EVERY PAGE of your site, you query the dictionary/glossary and where it finds a match to your keyword(s), it will show a link to the glossary entry (which should be its own page optimized for that keyword). THEN- from that page, make sure you link back to the page(s) related to that keyword. Where do you get a dictionary database? Search Google for public domain .csv files, then upload it to MySQL. Anything published before 1923 in the United States is legal to put on your website and even sell. That is a valuable piece of information!

If you use a database-driven website, like MySQL, it can be even more effective in helping interlink pages. For each content page, you can do a query of your database, or glossary, etc. for matches, and whatever matches, display a link to that content. This is a big reason for how these behemoth sites like ehow.com, about.com, or dictionary.com seem to rank so well. They have massive databases, and the may have dozens of pages along the same keyword. Links upon links and links. A huge spiderweb of a site. If you were to draw a sitemap on paper with arrows, it would be a total mess. Many of these sites are gaming the system to rank well. Come on, we all know it’s a game. If you start maximizing the links within your site, you’ll be a few steps ahead in the game too.

7 Advanced SEO Techniques

Once you have your own website perfectly optimized, you may consider reinforcing your targeted keyword phrases by using external websites. In this post I’ll refer to ‘targeted keyword phrase’ a few times which means the phrase you want to rank well in search engines, such as ‘portland web marketing’ or ‘red toyota pickups’ or ‘bay area real estate’.

1. Facebook.

Facebook ranks high in search engines, so leverage that buy starting both a personal profile account and a fan page using your targeted keyword phrase. One you create them, you may then click the following URL on Facebook to make the URL SEO friendly. Note: there are certain requirements for being eligible to change your URL- it may involve having more than 100 friends and 100 fans, but you should confirm with Facebook.

The URL where you change your account URLs to be SEO friendly:
http://www.facebook.com/username/

Example before:
http://www.facebook.com/profile.php?id=100000834592661
Example after:
http://www.facebook.com/yourkeyword

Once you have those pages, link to them from your website, and link back to your website from your Facebook profile and fan pages. Make sure you link to the specific page matching your targeted keyword phrase. For example if facebook.com/BigRedBalloons is my phrase, I’m going to link it to a page on my website like, domain.com/Big-Red-Balloons/ or bigredballoons.edu  then link back to the Facebook page. Each time you link, you use the link text Big Red Balloons, of course. It also helps to have an image on your page named Big-Red-Balloons.jpg and alt text ‘Big Red Balloons’. You get the idea.

2. YouTube.

Do the same thing as above (but they don’t let you customize the URL though). Make an account with your username as your targeted keyword phrase. Link to your channel page and link it to your website with that keyword text. Every video you upload, use certain keyword text in the title to attract attention, but also use consistent words with your username and targeted keyword phrase(s) for your website. Example page: http://www.youtube.com/user/bigredballoonspage  . When your username is taken, of course, just come as close as you can, and limit the # of characters you add to the name.

Also, always put your URL in the description of your video so it shows up.

3. Twitter, and all other social media.

You’re getting the idea by now to leverage every account you create with keywords in the phrase and link them to your website to add leverage or reinforcements to your current search engine ranking. It will really help you. Google can still crawl via URL shorteners, such as those used on Twitter, but where possible, try to keep your posts short enough to use your real, direct URL to your website.

Other accounts you may consider for this technique: stumbleupon, digg, wikipedia, craigslist, buzz, yahoo answers

4. Free Hosted Websites

Even if you already have a website, such as a WordPress blog, create another blog hosted on wordpress.org, then syndicate some of your content and merge it with other RSS feeds into your blog there. The purpose is to get the benefit of link juice from the wordpress.org domain to your own website. You should also create other blogs on blogger, livejournal.com, etc.

When you use WordPress, always add Post Tags for each derivative of your targeted keyword phrase. Use the whole phrase, then different word combinations of it and different synonyms. When self-hosting, make sure you change the setting under Permalinks to customize the ‘category’ and ‘tag’ keyword to words that are also consistent with your targeted keyword phrase. For example, if I have a car related blog, instead of the word ‘tag’, I will change the it to say ‘car’. Makes sense, right? And of course, follow the 10 essential steps for a killer WordPress blog.

Also, create a free Google webpage, hosted on their server: http://sites.google.com/

Another example is this: http://www.co.cc/ so you get: www.your-targeted-keyword-phrase.co.cc, then link it to your website.

Look out for many similar free website hosting accounts like this you can leverage to get more optimized link text pointing to your website.

So, how do you get content on all these sites? You can syndicate your own content, then mix it up with other RSS feeds to make it semi-unique. You can accomplish this with Yahoo Pipes. One thing you can do is use public domain content- such as that from the federal government and publish, or you can take public domain feeds from other countries (other languages) and use Yahoo Pipes to translate it into English. You can get 100% fresh, original content that way. If you have it automatically posted on all your websites and blogs, it shouldn’t be too long before those miscellaneous sites get some Page Rank credibility to it, where your link back to your original website will mean something.

5. Company / Website profile sites

It’s also wise to leverage existing profile sites. Avoid the spammy ones, but focus on the ones that have already reached critical mass. Within the profile, you enter your company details and links to your website and use as many targeted keyword phrases in your description. For example, create a profile in AboutUs (http://www.aboutus.org/), Google Local (Google Maps), and CrunchBase.

6. Articles, Wikis, and user-submitted pages

Post articles and content in sites like Knol (http://knol.google.com/k), or Ezinearticles (http://ezinearticles.com/), and sprinkle in your keywords and links to your website.

Other sites you need to make pages for:
http://www.wikipedia.org
http://www.associatedcontent.com
http://www.squidoo.com/
http://hubpages.com/
http://www.ehow.com/
http://www.tumblr.com/
http://www.ning.com/
http://www.gather.com/
http://www.43things.com/
http://www.prsubmit.org/
http://www.asmallworld.net/
http://www.zimbio.com/
http://2leep.com/
http://www.bukisa.com/
http://answers.yahoo.com/

Here’s someone’s list of related sites: http://hubpages.com/hub/a-list-of-sites-where-you-can-make-money

Sometimes Google and Bing don’t recognize the pages you’ve created right away. So, you almost have to link build for THEM first, so your site gets credit for the links. As an example, I made a WordPress blog on ACL Surgery then created a Squidoo lens for it: http://www.squidoo.com/acl-surgery , but Yahoo Explorer and Google Webmaster Tools don’t show any links to it yet and there have been virtually no visits, but the page is Google-indexed, as it comes up in a search for Squidoo ACL surgery. So, it needs a little link juice to be crawled and for links to be recognized. So, by linking this blog post to it, that helps, but it will need even more. Interlinking the above user-submitted content pages helps in this effort. And remember when signing up for these sites to always choose a username that contains keywords you want to target.

Advanced SEO Tip: Once you’ve made all your articles, wikis, and user-submitted pages in English, translate all of them into Spanish, French, Russian, Chinese and submit them to each site that supports the language. For example, Wikipedia is in multiple languages, so that can be done. Even better is if you translate your own website into multiple languages and the links from your Spanish Wikipedia page links to your Spanish web site. That’s right- that may take some time.

7. Forums

Post in forums and include your URL as a footer of your profile, for those forums that allow it. Some forums have high Page Rank value, so it is worth researching and creating an account for it. For example IBM, Apple, and Adobe have user forums that have great PR and link juice.

For continuous learning you can also read and contribute to SEO forums like Digital Point. I hope this helps you. Best of luck in your journey for top search rankings.