[Piwik-svn] r351 - trunk/plugins/Actions

[svnmaster at piwik.org]

Author: matt
Date: 2008-03-10 18:11:13 +0100 (Mon, 10 Mar 2008)
New Revision: 351

Modified:
   trunk/plugins/Actions/Actions.php
   trunk/plugins/Actions/Controller.php
Log:
- adding new columns for every page: nb of unique visitors that visited a given page
useful for marketing guys

Modified: trunk/plugins/Actions/Actions.php
===================================================================
--- trunk/plugins/Actions/Actions.php	2008-03-10 15:17:51 UTC (rev 350)
+++ trunk/plugins/Actions/Actions.php	2008-03-10 17:11:13 UTC (rev 351)
@@ -98,6 +98,7 @@
 		$query = "SELECT 	name,
 							type,
 							count(distinct t1.idvisit) as nb_visits, 
+							count(distinct visitor_idcookie) as nb_uniq_visitors,
 							count(*) as nb_hits							
 				 	FROM (".$archiveProcessing->logTable." as t1
 						LEFT JOIN ".$archiveProcessing->logVisitActionTable." as t2 USING (idvisit))

Modified: trunk/plugins/Actions/Controller.php
===================================================================
--- trunk/plugins/Actions/Controller.php	2008-03-10 15:17:51 UTC (rev 350)
+++ trunk/plugins/Actions/Controller.php	2008-03-10 17:11:13 UTC (rev 351)
@@ -101,7 +101,7 @@
 		
 		$view->disableOffsetInformation();
 		
-		$view->setColumnsToDisplay( array(0,1,2) );
+		$view->setColumnsToDisplay( array(0,2,3) );
 		$view->setLimit( 100 );
 		// computing minimum value to exclude
 		$visitsInfo = Piwik_VisitsSummary_Controller::getVisitsSummary();