http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90641
Revision: 90641
Author: rfaulk
Date: 2011-06-23 00:54:24 +0000 (Thu, 23 Jun 2011)
Log Message:
-----------
fixed grouping
Modified Paths:
--------------
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_confidence.sql
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_metrics_minutely.sql
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_confidence.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_confidence.sql
2011-06-23 00:45:30 UTC (rev 90640)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_confidence.sql
2011-06-23 00:54:24 UTC (rev 90641)
@@ -4,6 +4,7 @@
select
lp.utm_source,
+lp.landing_page,
impressions as total_impressions,
impressions * (views / total_views) as impressions,
views as views,
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_metrics_minutely.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_metrics_minutely.sql
2011-06-23 00:45:30 UTC (rev 90640)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_metrics_minutely.sql
2011-06-23 00:54:24 UTC (rev 90641)
@@ -79,6 +79,6 @@
on ecomm.banner = lp.utm_source and ecomm.landing_page = lp.landing_page and
ecomm.hr = lp.dt_hr and ecomm.dt_min = lp.dt_min
where lp.utm_campaign REGEXP '%s'
-group by 1,2
+group by 1,2,3
-- having impressions > 100000 and donations > 10
order by 1 asc;
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
