How To Optimize Database-Driven B2B Websites | Search Engine Optimization A to Z Search Engine Optimization A to Z: How To Optimize Database-Driven B2B Websites
Contact Us:

If You Have Any Problem, Wanna Help, Wanna Write Guest Post, Find Any Error Or Want To Give Us Feedback, Just Feel Free To Contact Us. We Will Reply You Soon.

Name: *


Email: *

Message: *


Skillblogger

LiveZilla Live Help

Thursday, April 24, 2014

How To Optimize Database-Driven B2B Websites

Database-driven websites are very common in the B2B sector . That's because many companies want to have a catalog on their website for dealers available products , but it would not be cost effective to manually build out those pages as they are meant does not generate revenue .
Optimization of database-driven websites , B2B follows the same basic SEO principles as any other website, but the execution is much different.
Here is a simple guide on how to optimize one dynamic content for product catalogs or similar content .

How Database - Driven Websites Work

If you're like a database-driven site works are not , not familiar , it's easy. Instead of manually updating multiple page types , you create a database full of variables that are dynamically pulled into the content that you can update with millions of pages in seconds. Although this created low quality content as a static website, it is a very cost effective means of managing a website with a high number of product pages.


Here is an example of how a dynamically generated h1 tag works:
h1 tag of the formula :
Model [ Model Number] [Product Name] tool
Database:
Model numbers in the database: 101 , 102 , 103
Product names in the database: widget , Widgeter , Widgeting
Heading output :
Page 1: Model 101 widget tool
Page 2: Model 102 Widgeter tool
Page 3: Model 103 Widgeting tool
Database-driven websites are so easy . The more database fields that you create and distribute among tags and content to be the more unique content. The key to success with this type of websites , SEO , in order to eliminate the possibility of duplicate content . With each database field placement decision that you make , should duplicate content problems always be a top consideration.

Dynamic Product Page Optimization

Now you have a basic understanding of how database-driven websites work , here is how these concepts apply to SEO for product pages.

Creating Rules

Prior to the generation of content , you will need to analyze the database to create rules for generating things like URLs , title tags and meta descriptions . With special characters , all uppercase, or non-unique content in the database potentially SEO topics when the content is filled .
Once you identify all database fields , which could potentially create SEO topics , have your developers / engineers create arguments so that if these problems are generated, they will be removed immediately before the contents are filled .
For example , let's say , a database field has a registered trademark symbol in some of the records . If the same field used in the URL and title tag , it would create a URL to decipher either with the trademark symbol , or other characters , and the title tag would also have them. By creating a rule to strip this character from complete if it fills in one of these fields , your site will generate a clean URL and title tag .

Title Tag formula

Title tags can be very difficult , because the product sites in the same category may have very similar product names, or other close fitting parameters. There is also a 70 character buffer limit for title tags , so you can occasionally generate a title with more than 70 characters . To solve the buffer boundary problem, create an argument that says all the signs are deducted after the first 70 from the title tag .
For the title tag formula the first database field should be the unique identifier available . The title tag should start with its unique attribute. For database-driven product pages , this is the model number is usually followed by the product name. Of course there are many other unique identifiers that you can have available.
Here is an example of a title tag formula , and it seems like after it is filled up :
[ Model Number] [Product Name] - [ Product Category ] | brand name
102 Widgeter - Widget Tools | WidgetCo
In this example, there were no duplicate model numbers in the database , for example in given at the beginning of this article , so I have it as the first database field in the day. The second database field for product name was very similar to the rest of the record, but was still unique, so I decided to use it as the second field. The third field was the product category, which is used for multiple products , so I finally got it . As a best practice , it is always a good idea to create a brand concept at the end as well as extended.

Meta Description Formula

The meta description formula follows the same basic principles as the title tag formula - take advantage of the unique features in the beginning and are a brand concept . Much like title tags, meta descriptions have a 156 character buffer limit. You have an argument , removes the build up everything after 156.
Descriptions have a little more room for uniqueness, because you have to create a formula with different content for each product category . Here is an example of some is poorly written, but decently executed meta descriptions that are used for two different product categories.
Example 1: The Model [ Model Number] [Product Name] by WidgetCo is an industry-leading [Product category 1]. Learn more here !
Example 2: Our model [ model number] [Product Name] offers the best in [Product Category 2 ] for the manufacturing industry . Exclusively Manufactured by WidgetCo .
With these two formulas , each meta description will have unique content placement , before it reaches the 156 character buffer limit , so that any possibility of duplicate content is omitted.

URL formula

URLs , the default usually generated by a set of parameters that will make no sense for the people with the website technology . By using a URL rewrite script, you can set these parameters translate into a readable database fields . Another common problem with dynamic URLs is to use uppercase. Through the use of regular expressions in the URL rewrite script , you can also force the URLs are lowercase. When creating a script like this, it is imperative that you clean URL redirects a function that generates the old URL to the new in order to avoid duplicate content issues.
To generate clean URLs , you will have a formula that will create a unique URL for each product page in the manufacture URL paths that must follow the navigation hierarchy. Below is an example of how a database with the same example I used in this article to generate .
/ Products / [Product Category ] / [ Model Number] - [Product Name] /
This formula translate
/ Products/widget-tools/102-widgeter /
Well, that's not much better than something like that?
/ Product.asp ? Cat = 3 & productId = 1

h1 Tag Formula

Generate h1 tags is probably the easiest part of the optimization of database-driven websites , so I have to keep this one short. Include the most important and unique database fields and whatever you think additional text needed. Below is an example of this.
Model [ Model Number] [Product Name] Product details
This leads to :
Model 102 Widgeter product details
It is keyword - rich and has a slight variation of the URL and title tag .

content formula

Create the body of content is the hardest part of the optimization of a dynamically generated website. You need to have at least 150 words of content for SEO best practices , and still keep it very clear and not read how it was generated by a machine.
The key is to use as many database fields as possible . When creating the database, you should items such as product specifications, product descriptions, etc. are this way you can minimize the amount of duplicate content that appears on the page , and use the uniqueness of the database fields to generate unique content. Here is an example of how this can be performed.
Paragraph 1: Lorem ipsum Model [ Model Number] [Product Name] amet , consectetur adipiscing elit . Integer nec odio . Praesent libero . Sed cursus ante dapibus diam. Sed nisi . Nulla quis nibh SEM imperdiet at elementum . Duis ipsum sagittis . Praesent mauris . [Product Category ] sed dolor sit amet semper nec Tellus porta .
Paragraph 2: [ product description ]
Paragraph 3: [ Product Specifications ]

Conclusion 

Optimization of dynamically generated content is easy. The given examples in this article , that a simple database with just a few fields. In a real application, a database-driven website will have many more database fields available to create unique , optimized content .
There are two key concepts to keep in mind - attention to duplicate content and generate content as unique as possible . If you follow these two basic principles , and apply them to general SEO best practices , you will optimize the power of thousands of pages in a few hours.

Opinions that are in the article that the guest author and not necessarily Search Engine Land .

Like the Post? Share with your Friends:-

Team SB
Posted By: Shahriar Hasan

0 comments:

Contact Us

Name

Email *

Message *

 

Latest post

About Us

Recent Comment

https://www.facebook.com/shahriar.hasan.315
Copyright © . SkillBlogger. All Rights Reserved.
Designed by :-Way2themes