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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
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.