Avatar

Correct answer by
Community Advisor

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:

 

Jyoti_Y_1-1600237392260.png

 

Thanks.

 

 

 

View solution in original post