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.

[MOGmartin]

Originally Posted by 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

thanks for letting me know, Ive not upgraded to 4.0.2 yet, I will check it out this weekend

[KissOfDeath]

Originally Posted by MOGmartin

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...

I'm not saying any solution is 100% the right one, I like to play around with different ideas and different theories, the fact is that the majority of my urls are not even indexed now and they were before, the only think that changed was the installation of this mod and the upgrade to 4.0.2,

you asked for feedback, maybe you wanted positive feedback only?
i'm just posting my findings positive of negative

[oddmud]

No answer to my problem?

[kall]

Originally Posted by MOGmartin

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/

Fairly obvious, given you made, shared, and use this mod.

These guys also know a little about SEO.

http://www.vbseo.com/f30/websiteowne...y-index-30707/ is a case study of someone who had a similar mod installed. Who knows if it was the absolute cause of his rankings tanking, but they did.

[KissOfDeath]

Originally Posted by kall

Fairly obvious, given you made, shared, and use this mod.

These guys also know a little about SEO.

http://www.vbseo.com/f30/websiteowne...y-index-30707/ is a case study of someone who had a similar mod installed. Who knows if it was the absolute cause of his rankings tanking, but they did.

that article seems to explain the exact issue i'm having, it will spike the traffic which is quickly noticed by google, who then punish you for cheating, he posted his before and after stats, i'll see if the same thing happens to me and post my findings,

i'll mark this down to experience, something new i've learnt

[KissOfDeath]

lol,

i disabled the mod about 5 hours ago, my indexed url's have already gone up to 18,101

[kall]

Originally Posted by KissOfDeath

that article seems to explain the exact issue i'm having, it will spike the traffic which is quickly noticed by google, who then punish you for cheating, he posted his before and after stats, i'll see if the same thing happens to me and post my findings,

i'll mark this down to experience, something new i've learnt

Yeah, that's why I grabbed it.. hadn't seen anyone else saying the same had happened to them with THIS mod until your post, so I shared.

*edit* The other mod, if I recall correctly, actually hyperlinked all the SE entries, to the page they were from. This mod doesn't do that, but it's similar.

[KissOfDeath]

Here are my stats from when the mod was installed till now, i'll post again in a few days when my missing pages are reindexed , you can see it builds up then starts on a rapid decline as google realise whats going on, you can see it builds up then starts on a rapid decline as google realise whats going on, i'm not trying to belittle the creatore work or anything, just saying i tried it and it didn't work for me, i would have actually made a donation to the creator if it did work for me but it just give me a short term gain then worked against me, i check my indexed urls every 3 - 4 days and google have only recently taken action, the fact that my pages are being immediately reindexed as soon as i dissable this mod tells me that it was the cause

[final kaoss]

I see all this "pages removed" "pages reindexed" stuff but do you have any screenshots to prove it? Hint

http://www.google.com/search?hl=en&c...g-sx9&aql=&oq=

[KissOfDeath]

Originally Posted by extreme-gaming

I see all this "pages removed" "pages reindexed" stuff but do you have any screenshots to prove it? Hint

http://www.google.com/search?hl=en&c...g-sx9&aql=&oq=

don't use the "site:"

I got my stats from google analytics's>traffic sources>search engines