http://www.mediawiki.org/wiki/Special:Code/MediaWiki/89238
Revision: 89238
Author: rfaulk
Date: 2011-05-31 22:54:30 +0000 (Tue, 31 May 2011)
Log Message:
-----------
removed 'completion_rate' and 'total_clicks' from query result columns
Modified Paths:
--------------
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_metrics_minutely.sql
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_metrics_minutely.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_metrics_minutely.sql
2011-05-31 22:52:10 UTC (rev 89237)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_metrics_minutely.sql
2011-05-31 22:54:30 UTC (rev 89238)
@@ -4,14 +4,14 @@
if(imp.dt_min < 10, concat(imp.dt_hr, '0', imp.dt_min,'00'), concat(imp.dt_hr,
imp.dt_min,'00')) as day_hr,
lp.utm_source,
-impressions * (views / total_views) as impressions,
+floor(impressions * (views / total_views)) as impressions,
views,
-total_clicks,
+-- total_clicks,
donations,
amount,
amount50,
(views / impressions) * (total_views / views) as click_rate,
-donations / total_clicks as completion_rate,
+-- donations / total_clicks as completion_rate,
round((donations / impressions) * (total_views / views), 6) as don_per_imp,
(amount / impressions) * (total_views / views) as amt_per_imp,
(amount50 / impressions) * (total_views / views) as amt50_per_imp
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
