| Index: trunk/fundraiser-statistics/fundraiser-scripts/sql/report_banner_metrics_minutely.sql |
| — | — | @@ -4,14 +4,14 @@ |
| 5 | 5 | |
| 6 | 6 | 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, |
| 7 | 7 | lp.utm_source, |
| 8 | | -impressions * (views / total_views) as impressions, |
| | 8 | +floor(impressions * (views / total_views)) as impressions, |
| 9 | 9 | views, |
| 10 | | -total_clicks, |
| | 10 | +-- total_clicks, |
| 11 | 11 | donations, |
| 12 | 12 | amount, |
| 13 | 13 | amount50, |
| 14 | 14 | (views / impressions) * (total_views / views) as click_rate, |
| 15 | | -donations / total_clicks as completion_rate, |
| | 15 | +-- donations / total_clicks as completion_rate, |
| 16 | 16 | round((donations / impressions) * (total_views / views), 6) as don_per_imp, |
| 17 | 17 | (amount / impressions) * (total_views / views) as amt_per_imp, |
| 18 | 18 | (amount50 / impressions) * (total_views / views) as amt50_per_imp |