http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90627
Revision: 90627
Author: rfaulk
Date: 2011-06-22 23:05:37 +0000 (Wed, 22 Jun 2011)
Log Message:
-----------
Returns all lps and banners for a campaign
Modified Paths:
--------------
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_banners.sql
Added Paths:
-----------
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_lps.sql
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_banners.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_banners.sql
2011-06-22 23:03:12 UTC (rev 90626)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_banners.sql
2011-06-22 23:05:37 UTC (rev 90627)
@@ -7,7 +7,7 @@
from drupal.contribution_tracking left join civicrm.civicrm_contribution ON
(drupal.contribution_tracking.contribution_id = civicrm.civicrm_contribution.id)
-where receive_date >= %s and receive_date < %s and utm_campaign REGEXP '%s'
+where ts >= '%s' and ts < '%s' and utm_campaign REGEXP '%s'
group by 1;
Added:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_lps.sql
===================================================================
--- trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_lps.sql
(rev 0)
+++ trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_lps.sql
2011-06-22 23:05:37 UTC (rev 90627)
@@ -0,0 +1,13 @@
+
+
+
+select
+
+SUBSTRING_index(substring_index(utm_source, '.', 2),'.',-1) as lp
+
+from drupal.contribution_tracking left join civicrm.civicrm_contribution ON
(drupal.contribution_tracking.contribution_id = civicrm.civicrm_contribution.id)
+
+where ts >= '%s' and ts < '%s' and utm_campaign REGEXP '%s'
+
+group by 1;
+
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
