http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90639
Revision: 90639
Author: rfaulk
Date: 2011-06-23 00:44:55 +0000 (Thu, 23 Jun 2011)
Log Message:
-----------
Updated confidence queries to use latest banner and landing page tables from
the Fundraiser db on grosley
Modified Paths:
--------------
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_LP_confidence.sql
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_confidence.sql
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_LP_confidence.sql
===================================================================
--- trunk/fundraiser-statistics/fundraiser-scripts/sql/report_LP_confidence.sql
2011-06-23 00:39:48 UTC (rev 90638)
+++ trunk/fundraiser-statistics/fundraiser-scripts/sql/report_LP_confidence.sql
2011-06-23 00:44:55 UTC (rev 90639)
@@ -20,13 +20,13 @@
landing_page,
utm_campaign,
count(*) as views
-from landing_page
+from landing_page_requests
where request_time >= '%s' and request_time < '%s'
and utm_campaign REGEXP '%s'
and landing_page REGEXP '%s'
group by 1,2) as lp
-join
+left join
(select
SUBSTRING_index(substring_index(utm_source, '.', 2),'.',-1) as landing_page,
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_confidence.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_confidence.sql
2011-06-23 00:39:48 UTC (rev 90638)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_confidence.sql
2011-06-23 00:44:55 UTC (rev 90639)
@@ -25,7 +25,7 @@
(select
utm_source,
sum(counts) as impressions
-from impression
+from banner_impressions
where on_minute > '%s' and on_minute < '%s'
and utm_source REGEXP '%s'
group by 1) as imp
@@ -35,7 +35,7 @@
(select
utm_source,
count(*) as views
-from landing_page
+from landing_page_requests
where request_time >= '%s' and request_time < '%s'
and utm_campaign REGEXP '%s'
group by 1) as lp
@@ -47,14 +47,14 @@
(select
utm_source,
count(*) as total_views
-from landing_page
+from landing_page_requests
where request_time >= '%s' and request_time < '%s'
and utm_source REGEXP '%s'
group by 1) as lp_tot
on imp.utm_source = lp_tot.utm_source
-join
+left join
(select
SUBSTRING_index(substring_index(utm_source, '.', 2),'.',1) as banner,
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
