useful, now its work on my blog, thanks
Sure, in my experience between 20 and 30 is the best place to be aiming for.
more than that is overkill, and less than that and you dont get the long tail terms enough.
by the way, are you using the vBulletin or the wordpress version?
[QUOTE=bobbyb;2326]Ok, thanks for the info.
I am using the wordpress version.
Cheers[/QUOTE]
hey no probs, and welcome to our forums!
look forward to your feedback, and I hope it helps out with your long tail traffic! Any questions, just post them here.
thanks
I have been using the plugin for a while now and think it's pretty good however I too have experienced the same SQL errors. I do use WP Super Cache so I don't know if that is the problem but in all the errors the SQL Query is missing the appropriate post ID value.
I have put a workaround in to stop the error by adding to the seoqueries_get_page_terms function (just after the first IF statement) and in the seoqueries_init function just before the main select statement from the searchterms_data table the following code which exits if there is no valid ID or Type
[CODE] // if there is no page ID or page type quit now
if(empty($seoqueries->type) || $seoqueries->id = ''){
return;
}[/CODE]
Also I have found that there is an easy "hack" which can be used by people who may want to disrupt your site which uses the referer value to insert content you may not want to appear on your site. For example if you have a site with lots of content you might have many examples of words such as arse, gay or any kind of swear word which could be totally unrelated to your sites main content but appears anyway e.g a quote from someone, a comment or even something taken out of context.
Someone with a feeble childlike and puerile mind only need do a site: [domain] [word] search in google to find an instance of that word in any article and then they could append extra content around said word which would then be inserted into the list of referer terms on your site.
Therefore if you work with childlike colleagues (as I unfortunately do) you will need to handle this fact by adding in a basic rude word filter e.g
[CODE]$bs = "/\b(badword1|badword2|badword3)\b/iu";
if(preg_match($bs,$terms)){
return;
}[/CODE]
Also you may want to tighten it up as I had to do to prevent any referral content posted from certain IP's (maybe your office) from being added.
This is accomplished with a simple check for the IP address and a test for "unsafe" locations.
It would be nice if we lived in a world where this wasn't necessary but as I found out for myself we don'tso therefore we need to put in safeguards otherwise you could find your sites list of words contains more than you bargained for.
I would also suggest adding some more indexes to the tables you add with the plugin as I already have quite a large list of words and have increased the lookup performance considerably by some index tuning.
There are a lot of ways in implementing [URL="http://www.seozip.com/"]web marketing search engine optimization[/URL] for website owners. One of the techniques in implementing this strategy is by doing link building of your website. It is by getting your website linked from other website owners on the internet. But how are you going to get your website linked from other websites? Well, the first thing that a website owner will do is by hiring SEO (Search Engine Optimization) services company like SEO ZIPto do link building or other techniques for the optimization of your site. Website owners can also hire freelance SEO expert to implement some techniques for their website optimizations or they can do this on their own by improving the content and providing relevant information on their site so other website owners will be attracted and won’t hesitate them to provide a link on their website back to your site. This scenario will get more visitors to your website and will give website owners significant edge on search engines.
[URL="http://www.reputationmanagements.com/"]
[/URL]