Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

How to calculate average number of deliveries

Avatar

Level 1

what’s the best way to calculate the average number of email deliveries to customers on a weekly basis?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

One way would be: query broadlogrcp count by @ID group by DateOnly(@eventDate), refine query by @eventDate on or after DaysAgo(7), add enrichment then use avg() expression on the @count ( such as avg(@count)

 

David__Garcia_1-1638945254194.png

David__Garcia_2-1638945268384.png

David__Garcia_3-1638945302244.png

David__Garcia_4-1638945519630.png

 

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

One way would be: query broadlogrcp count by @ID group by DateOnly(@eventDate), refine query by @eventDate on or after DaysAgo(7), add enrichment then use avg() expression on the @count ( such as avg(@count)

 

David__Garcia_1-1638945254194.png

David__Garcia_2-1638945268384.png

David__Garcia_3-1638945302244.png

David__Garcia_4-1638945519630.png