Published August 17th, 2008 by
'Ten SEO Mistakes Made on Database Driven Websites' – 'Site Reference' Newsletter
The latest ‘Site Reference’ newsletter has been released. The featured article is titled “Ten SEO Mistakes Made on Database Driven Websites” by Mark Stubbs. [Site Reference Newsletter]
The latest Site Reference newsletter has been released.
‘Ten SEO Mistakes Made on Database Driven Websites’
by Mark Stubbs
Search engine friendly websites is one of those often heard phrases, both from web site development companies and from their clients. Everyone knows that this is important to have, and yet it is one of the things that is actually often overlooked.
Search engine optimisation companies actually spend a lot of their time analysing a website and removing barriers to the search engines ranking a site highly. At the web development level, it is possible to build a site that is perfectly search engine friendly. One of the hardest types of site to get right though are database driven websites. Listed below are ten of the most common issues that are created, often unknowingly, in the development process of a dynamically generated web site.
1. Pages with duplicate content – not enough differential areas within the pages, so that only small areas of the page change from page to page. It is essential that enough of the page text changes for the search engines to see an appreciable difference between one page and the next.
2. Pages with duplicate page titles – the page title is a great indicator to the search engines of the primary content of the page. Whilst this is often unique on sites such as e-commerce websites, it is often overlooked in other sites, particularly where small areas of the site are generated from a database, such as news pages.
3. Pages with duplicate meta descriptions – again, this is easy to overlook and set a global or category level meta description. These give the search engines a reason to penalise your site for not giving them enough information, and again, creating a unique meta description for every page is an essential SEO task.
4. Using auto-generation of pages as a shortcut instead of creating good content. This is linked quite closely to point 1, where it is possible to create pages that have only a tiny percentage difference between them. Databases are fantastic ways of storing information, but you still need to put the work in to fill them with content. Unique information about the subject of the page will immensely help both the long tail and the ability of the search engines to determine that a page is valuable.
5. Creating pages that are hidden behind form submissions or javascript postbacks that cannot be accessed by a search engine crawler. This is far more common that is generally realised. For instance .NET creates postback links by default instead of proper links – potentially making huge sections of a site unreachable. Likewise, it is easy to hide lovely content rich areas of your site behind a drop down selector in a form that means certain areas of the site are not visible.
6. Too many query strings – this is a common bugbear of the professional SEO, where complicated database selections create deep levels of pages, but with seven or eight &id= type strings. Additionally, some bad development methodology can leave pages with null query strings that appear in every URL but don’t do anything. The answer to this is generally URL rewrites, creating much more search engine friendly and user-friendly URLs!
7. Putting query strings in different orders when accessed through different places – this can create duplicate content issues, which can cause major penalties.
8. Not using user language to generate automated pages – if you are going to create a database driven website that uses words in the query strings (or better in rewritten URLs) make sure that you use words that will help you with SEO – if you sell widgets, make sure you are using the word widgets somewhere in the URL instead of just product= or
9. Not allowing the meta data and title to be edited easily after the site build. It is possible to hardcode the generation of meta information into a database that doesn’t allow it to be edited later. Creating a mechanism for modifying this information initially helps everyone at a later stage when the information needs changing without shoehorning it into an already developed structure.
10. Creating keyword stuffed pages by using auto-generation. Once upon a time, search engines quite liked pages with high densities of your keywords, but now these are likely to get you marked down rather than up. So be aware when creating pages that long pages with lots of your products on can create too high a density. For instance listing blue widgets, light blue widgets, navy blue widgets, sky blue widgets is going to create a page with a very dense page for the phrase “blue widgetsâ€.
These are just 10 of the commonest potential optimisation pitfalls when creating dynamic websites. There are many more facets to producing a great database driven site, including user friendliness, speed, performance and security, but they all add together to make the best solution to your needs.
About Mark Stubbs
Mark Stubbs is a freelance writer who specialises in internet marketing and web site development. For more information on database driven websites he suggests that you visit www.obs-group.co.uk .
Top Strategies and Intelligence…
How to Optimize for Google: Part 3 of 3
You want your website in the top rankings at the titan of searchengines, Google. With a little planning and thought, there are methodsto do this without hard work or heartache. In the last of thisthree-part article series, learn the final SEO tricks to ensure thatGoogle will absolutley love and promote your site.
Put Your Website to Work – Monetize your traffic today!
Join Neverblue Ads and access 1000′s of high quality offers. With advertisers in every vertical, you’re sure to find some high converting ads to help monetize your traffic.
Lots and lots of content makes you more search engine friendly, helpsestablish your knowledge and expertise, explains in detail what youoffer, and justifies that offer with all the explanations, statistics,and rationale you can muster. The problem is nobody reads it.
A Few Words From Our Experts…
Give Your Visitors Confidence To Buy: Getting Past The Order Form
Your sales are reduced when you fall victim to a very common problem.Prospects not getting past your Order Form. WHY they run is simple.Lack of confidence. WHAT to do about it is a bit more involved. You canreduce your prospects vamoosing (is there correct spelling forsynthesized words?) from your Order Form with a few simple adjustmentsand additions to your web sales process. Overall, it’s about addingmarketing copy at the top of your Order Form. The online marketing andecommerce system that I use, www.HandsFreeBusiness.com allows me to put HTML, audio and video at the top of their secure order forms…
How to Sell to the Rich – Part 2
I received some interesting comments about my last post. It seems thereare a few readers out there who are not marketers, either of the onlineor offline kind. And they didn’t agree with my contention that moneybrings happiness (and that more money brings more happiness). And, thatif you are ever to become a successful direct marketer – specifically,one who markets to the rich – you must first, as a priori, want withall your might – to be rich! One reader went so far as to imply that Iwas a moron (ouch!) Okay, so these dissenters probably either scannedthe post or didn’t fully understand it – and saw only what they wantedto see – an opportunity to disagree. I mean, after all, how couldanyone in their right mind ever disagree with anything I say? Sheesh!
Succeed With These Webmaster Resources…
Learn the exact same secret that allows 1 man to get all his Google ads completely free while everyone else has to keep paying for theirs.
The Ultimate Guide To Personalized Search- FR*EE DOWNLOAD
I can’t stress enough that people need to understand the implication for Personalized Search in order to go forward. This could decidely change how an SEO operates as well as how they qualify campaigns and therefore plays a huge role on your site’s success…
Want Your Visitors To Keep Coming Back?
All you need to do is give them an incentive and we’ve got you covered. We’ve spent years collecting books on every topic and now you can give them away for FR*EE to your visitors in just minutes…
Questions, Answers and Discussions From Our Members…
Can I Use Google Analytics with Blogger/Blogspot?
One of our members wants to know if it’s possible to use the GoogleAnalytics sytem on her blogs through Blogger or Blogspot — and if so,what the best method is for implementing it. Find out by readingexperts’ comments.
PicScout Making Money from Finding Copyright Issues
Are you aware that there are nefarious spider bots scanning images onyour website for illegally-gotten images from libraries such as Gettyand iStockPhoto? Learn more about what web developers are dealing with.
How to Use Reviews as a Marketing Tool
Looking for a way to write product or service reviews that will generate advertisement for blog or site? Find out what other users are doing to gain traffic through writing or submitting their reviews.
Korat wants to know if he’s using keyword phrasing for his websitebuild, and his phrases are incorrectly written, will it cause anyeffect to the site’s ranking on search engines. Read what the pros say and put in your two cents about incorrect grammar in keyword phrases.
Basket Lady says she’s struggling with her web domains. She is havingto rename her business, and consequently she believes she needs torename her online address. She does not want to lose her rankings withsearch engines and needs some advice on URL redirects.
Where to Place Banners on a Website?
While I am selecting a banner ad position for my website, which ofthese positions are the most profitable ones for click generation, oris it the same everywhere? Where would you put your banners?
Newsletter Information
RSS Feed: Use our articles as your content – subscribe to our RSS feed
Want to read more articles? Go to the front page of Site Reference
We also have plenty of articles in our archives
*IMNewswatch would like to thank Site-Reference for granting permission to reprint the latest newsletter.