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

Count Of Deliveries

Avatar

Avatar
Validate 1
Level 1
lcharlwood
Level 1

Like

1 like

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
lcharlwood
Level 1

Like

1 like

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile
lcharlwood
Level 1

15-09-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile
Jyoti_Y
MVP

15-09-2020

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.

 

 

 

Answers (0)