Solved

How to calculate average number of deliveries

1 reply
976 views
Translate All

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Level 10

One way would be: query broadlogrcp count by @1716897 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)

https://www.linkedin.com/in/david-garcia-uk/ | https://martech.network

david--garciaAccepted solution

Level 10

One way would be: query broadlogrcp count by @1716897 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)

Translate

https://www.linkedin.com/in/david-garcia-uk/ | https://martech.network

Sign up

Login with SSO

Login to the community

Login with SSO