Expand my Community achievements bar.

SOLVED

Count Of Deliveries

Avatar

Level 2

Hello.

 

I'm looking to run a workflow that will output all of our deliveries over a specific time period with metrics such as opens/clicks etc. However, the deliveries I want to look at are sent out every day and create a separate record on the deliveries table as we normally append a date to the delivery label. For example, for each brands welcome email, in a week it will appear 7 times for each brand.

 

How do I build a workflow that will aggregate the sends to one line while bringing in opens/clicks for that set period? For each delivery, the delivery code remains constant so I could group by that.

 

I have tried using counts/group by but not having any luck so far.

 

Thanks.

 

Luke

1 Accepted Solution

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

2 Replies

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.

 

 

 

Avatar

Level 2
Thank you very much - this is perfect, exactly what I needed.