| Index: trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_metrics_minutely.sql |
| — | — | @@ -79,6 +79,6 @@ |
| 80 | 80 | 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 |
| 81 | 81 | |
| 82 | 82 | where lp.utm_campaign REGEXP '%s' |
| 83 | | -group by 1,2 |
| | 83 | +group by 1,2,3 |
| 84 | 84 | -- having impressions > 100000 and donations > 10 |
| 85 | 85 | order by 1 asc; |
| Index: trunk/fundraiser-statistics/fundraiser-scripts/sql/report_bannerLP_confidence.sql |
| — | — | @@ -4,6 +4,7 @@ |
| 5 | 5 | select |
| 6 | 6 | |
| 7 | 7 | lp.utm_source, |
| | 8 | +lp.landing_page, |
| 8 | 9 | impressions as total_impressions, |
| 9 | 10 | impressions * (views / total_views) as impressions, |
| 10 | 11 | views as views, |