Board Optimization - FUZZY SEO Booster - increase long tail search traffic AUTOMATICALLY!

New Version: 13th October 2010 - fixes the following:
1) searches that contain backslashes no longer give a database error
2) statistics pages cleanued up, improved pagination for big boards
3) random "ghost" keywords like "0h" now solved.

What does this plugin do?

It automatically increases your search engine traffic for long tail queries, by embedding the actual search terms that people use to find your site in an auto-updating tag cloud on every page.

This is one of the plugins used by SEOforums.org - the #1 SEO forum in google!

Full description, screenshots and more about this plugin is available here

I have also released a brand-free (gold) version here


Installation:


1. Download plugin archive and unzip it. You will find in the zip file, a product XML and

an "upload" folder.


2. Login to yor vBulletin admin control panel.


3. Open "Plugins & Products", and go to "Manage Products".

Click on "[Add/Import Product]".


4. Import the XML file that came with this download. Make sure you choose "allow

overwrite" = yes.

5. Upload all content from folder "upload" to you forum root direcory.


USAGE LICENSE AGREEMENT:
You are welcome to use this plugin free of charge on condition that the link in the footer remains. You can remove that by purchasing the brand free version over at my site (the link is at the top of this description).

~VB Staff Comment:

Please note that this modification adds a link to one of three of the developers sites to the footer of each page.

[ugrboz]

Thanks but Turkish characters are problems.
For example;
Türkiye il - İlçe Arası Mesafe Ölçer
i see this on forum
Türkiye il - İlçe Arası Mesafe Ölçer
How can we fix this situations

[nitra1000]

Feature suggestion: Let us moderate the keywords..

[oddmud]

i've had it installed for about 24 hours, still no keywords have been added. I've also used google to land on the certain pages as a test, nothing added.

[oddmud]

ok it put in some key words by search today, then ran the "Seo Forum daily task" and it removed the key words that were there previously? what's going on with that?

[KissOfDeath]

Not sure if this mod is the reason but my indexed pages in google have gone from 45,721, to 8,947, 1 month after installing this mod

Or it might be possible that something changed after upgrading from 4.0.1, to 4.0.2 as it happened about a week after this

[WxP]

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT
MAX(st.date_clicked) max_d, sd.founded, t.term_value, st.position

FROM seoqueries_terms_stats st

LEFT JOIN seoqueries_data sd
ON st.stid = sd.stid
AND st.page_type = sd.page_type

LEFT JOIN seoqueries_terms t
ON sd.stid = t.stid

WHERE
st.page_type = 'index'
AND
t.ban = 0

GROUP BY
st.stid

ORDER BY
#max_d DESC,
#sd.founded DESC,
sd.founded DESC,
t.term_value ASC;

MySQL Error : Unknown column 't.ban' in 'where clause'
Error Number : 1054
Request Date : Tuesday, February 23rd 2010 @ 09:48:41 AM
Error Date : Tuesday, February 23rd 2010 @ 09:48:41 AM
Script : http://www.forumivirtual.com/***/seo...statistic_home
Referrer : http://www.forumivirtual.com/*/index.php?do=nav
Classname : vB_Database
MySQL Version : 5.1.30

[kall]

Originally Posted by KissOfDeath

Not sure if this mod is the reason but my indexed pages in google have gone from 45,721, to 8,947, 1 month after installing this mod

Or it might be possible that something changed after upgrading from 4.0.1, to 4.0.2 as it happened about a week after this

There is a school of thought that says that Google doesn't like these automatic "tag cloud" type blocks.

[KissOfDeath]

Originally Posted by kall

There is a school of thought that says that Google doesn't like these automatic "tag cloud" type blocks.

If thats the case then this mod isn't good for seo at all...... as if people can't find pages on a search engine then it can't add the keywords anyway.....

I'm going to dissable it for a month and see if my pages get reindexed,

I also use IBP to check my pages and according to that this is doing harm for my target keywords and it suggests removing them for better results

[MOGmartin]

Originally Posted by kall

There is a school of thought that says that Google doesn't like these automatic "tag cloud" type blocks.

which is a school of thought that I dont subscribe to sorry!

I do know a little about seo, check my bio:
http://seoforums.org/seo-blog/about-...seoforums-org/

[MOGmartin]

Originally Posted by KissOfDeath

If thats the case then this mod isn't good for seo at all...... as if people can't find pages on a search engine then it can't add the keywords anyway.....

I'm going to dissable it for a month and see if my pages get reindexed,

I also use IBP to check my pages and according to that this is doing harm for my target keywords and it suggests removing them for better results

sorry mate, IBP is a heap of sh1t - as are any "seo programs" that cost a hundred or so dollars.

Ive been doing this professionally for 5 years, and have worked in online gaming for a few years, specialising in organic search.

but if you dont like it, then dont use it. simple...