- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Luke,
You can do Group By : 'Delivery Code' and find Count of 'Messages to deliver', 'sent','open','click'. You can use below parameters for Count:
1) Count of Total Sent: sum([indicators/@success])
2) Count of Total messages to deliver: sum([properties/@toDeliver])
3) Count of Open: sum([indicators/@estimatedRecipientOpen])
4) Count of Click: sum([indicators/@personClick])
5) Count of total Deliveries: Count(@deliveryCode)
Query to take only one week deliveries and get the aggregate. It should look like below:
Thanks.