Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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
Level 10

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
Level 10

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