Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Count Of Deliveries

lcharlwood
Level 2
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
Jyoti_Y
Correct answer by
Community Advisor
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
Jyoti_Y
Correct answer by
Community Advisor
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

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