Driving Forward > Digital Marketing Blog

Database Driven Website Have Duplicate Content? Here’s A Workaround

By

Sometimes despite the best efforts of webmasters, database driven sites fall prey to duplicate content issues. One of the more common ways duplicate content can occur on database powered sites happens when more than one URL results in the dynamic creation of webpages with identical code. To search engines, this represents duplicate content – and having large amounts of it can negatively impact your site’s indexing and ranking.

But the good news is there is a workaround.

Technically, it doesn’t matter that there is more than one way to call the same page from a database driven site. So as long as the page is linked to from other site pages using a consistent URL, the search engines will not detect the “duplicate content”. In other words, search engine bots would have no way to discover the alternative URL of the page (assuming it is not linked to from an external site using the unfavorable URL).

Therefore, a temporary workaround maybe to consistently link to a duplicated page using a single preferred URL. If you have massive amounts of duplicate content, you may find there is a pattern to the URLs of duplicated pages. For example, let’s say you have the following URL problem:

duplicate content table

In this example, both the Services Page and Product Page have two URLs that can call them from the database. However, the structure of many database driven content management systems (CMS) will often produce duplicate content in easily decipherable patterns – such as the one in the simplified example above. The next steps are to select a preferred URL nomenclature (In the example above, this would likely be the URL that uses letters to call pages) and ensure that only this naming convention is used throughout the site.

However, this should only be a temporary solution. Ideally, you want to completely remove any way identical pages can be called from your database.

Depending on the length of time it is estimated to find a permanent fix for the issue (more than 2 months), you may want to go into Google Webmaster Tools and go to –> Tools –> Remove URLs. Next, input the URLs that you wish Google to delete from its index into the tool. Only do this after the above recommendations have been implemented.

Hope this helps.

Search

6 Google Analytics KPIs CMOs Should Track

By

As a CMO, you will receive daily, weekly, or monthly reports from your marketing teams with a lot of KPIs and metrics; however, you need to break through the clutter and understand the 6 important Google Analytics KPIs you need to watch to ensure online marketing campaigns perform well. 1. Conversions Using Google Analytics, you…

Read the full article

Search

3 SEO Metrics for CMOs

3 SEO Metrics for CMOs

By

Effective SEO management and reporting should provide quick access to key performance metrics while delivering the flexibility to tailor results to your needs. SEO metrics should provide valuable, fast answers and clear stories around your marketing questions as they relate to search engine optimization. Comprehensive SEO Metrics to Track How can we arm our CMOs…

Read the full article

Event

December 9, 2019

Become a Marketing Engineer at MTech Summit. Register now to get a $60 discount.

Register Now!

Contact Us

Schedule a presentation. Tell us about your marketing goals. Find our offices. Or, just say hello. We would love to hear from you!

Contact Us   

Infographic

Google World Infographic

Overdrive Google World Digital Marketing Infographic

Visualize the world of Google's companies, technologies, and services. Get the PDF with live links to over 200 assets.

Get Access!   

eBook

The Digital Advertising Guide – 2nd Edition

Overdrive Digital Advertising Guide - PDF

Get your head around the many advertising options available to digital marketers today.

Get Access!   

Presentation

Google Gallery

Google SEO and Search Gallery: 16 Years of Search Results Presentation

Explore how Google’s results page has evolved with 54 images illustrating 16 years of development.

Get Access!   
Dev Tool:

Request: database-driven-website-have-duplicate-content-heres-a-workaround
Matched Rewrite Rule: ([^/]+)(?:/([0-9]+))?/?$
Matched Rewrite Query: name=database-driven-website-have-duplicate-content-heres-a-workaround&page=
Loaded Template: single.php