Database & SEO

Hi guys,

I’m trying to do SEO for multiple areas within a City for a business that covers a wide area for their work.

Eg. A plastering company in London might want to also rank for the smaller towns and areas within London as it is such a large area.

Instead of duplicating content or creating content for each town I was thinking of a dynamic page where I would just change the location within the main text via a database & dataset. So I would have a database with the town names in like so:

Plasterer in London
Plasterer in Brixton
Plasterer in Chelsea
Plasterer in Camden Town

The main body of text and images would be the same but the location would change depending on the search term that was used. So if someone searched for a ‘Plasterer in Chelsea’ the page would rank for that search term and they would land on the dynamic page for a ‘Plasterer in Chelsea’

I hope you know what I’m getting at. I’m not asking how to do it, I already know how to set it all up I would like to know whether this method would work in search results.

I thought it was the holy grail when I thought it up but I’m now starting to doubt it, would the dynamic page rank within search results for all towns?

Please ask if you’re not sure what I mean.

Thanks a lot!

There is not a certain answer to this question. It really depends if Google ranks the dynamic pages or marks it as duplicate content. I have seen it go either way for different sites so unless you test it yourself we won’t know.

Thanks Shan. I will definitely be testing it for myself, I have already started building the dynamic page I just wanted to know whether anyone else had tried the idea beforehand so I could learn from them. I realise now that this is the wrong forum for this question, apologies for that.

Based on the dynamic page’s content, you can modify the page’s meta tags using the Wix Seo API functions getMetaTags() and setMetaTags() . No telling how Google does things, but taking into account the page’s unique content, together with the unique meta tags, you might end up achieving the desired results.

Based on the dynamic page’s content, you can modify the page’s meta tags using the Wix Seo API functions getMetaTags() and setMetaTags() . No telling how Google does things, but taking into account the page’s unique content, together with the unique meta tags, you might end up achieving the desired results.

Great, I didn’t think of that, I’ll give a go. Thanks Yisrael.