Dec

Quick & dirty: total visitors in Statpress by period

admin

Tips

What is bother me in Statpress is to find out a way to know the site’s traffic in a period.

This query does exactly, calculating unique visitors, rss and views:

Set @ini='20101108';
Set @fin='20101110';

Select @uniquevisitors:= count(distinct ip,date) as visitors from wp_statpress where feed='' and spider='' and
date between @ini and @fin;

Select @rss:=count(date) as feeds from wp_statpress where feed<>''
and spider='' and date between @ini and @fin;

Select @views:=count(ip) as visitors from wp_statpress where feed='' and spider='' and
date between @ini and @fin;

Select @uniquevisitors,@views,@rss;

This is a start to a nice addition a this plugin… a sub-plugin.

If you want to make queries against WP databases , you should try WP-phpMyAdmin.

Is there is a better plugin for queries? I hear you.

Instructions: rotate your head clockwise… :)

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.