Quick & dirty: total visitors in Statpress by periodRápido & sucio: totales de visitas en un período (para Statpresss)

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…  :)

Lo que me molesta a veces de Statpress es encontrar una manera de calcular el tráfico del sitio en un período determinado.

Esta consulta hace exactamente eso, calculando visitantes únicos, rss y páginas visitadas:

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;

Est es el comienco de un un lindo agregado a este plugin … un sub-plugin.

Si desea hacer consultas en una base de datos WordPress, debería probar el plugin  WP-phpMyAdmin.

¿Hay un plugin mejor para hacer consultas?. Te escucho

Instrucciones: gire la cabez en el sentido de las agujas del reloj… :)

No Comments


Leave a Reply

Your email address will not be published Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*