cf6PQgCn

1select top 100
2d.domain,
3c.id as 'campaignid',
4c.run_dt,
5c.name,
6d.targetcount as 'targetcount',
7format(d.deliverycount * 1.0 / d.targetcount, 'p') as 'deliveryrate',
8format(d.uviewcount * 1.0 / d.deliverycount, 'p') as 'uviewrate',
9format(d.uclickcount * 1.0 / d.deliverycount, 'p') as 'uclickrate',
10format(d.bouncecount * 1.0 / d.targetcount, 'p') as 'bouncerate'
11
12from campaigns c with (nolock)
13inner join sim_reporting_flowmetrics s with (nolock)
14on c.id = s.campaignid
15inner join sim_reporting_domainmetrics d with (nolock)
16on c.id = d.campaignid
17
18where d.deliverycount > 0 and s.singleshot = 1 and d.domain = 'gmail.com' and (c.name like ('%GOOD_NEWS%') or c.name like ('%Price Guarantee%'))
19
20group by d.domain, c.id, c.run_dt, c.name, d.targetcount, d.deliverycount, d.uviewcount, d.uclickcount, d.bouncecount
21order by run_dt desc