Average email received per profile | Community
Skip to main content
Level 3
July 23, 2024
Solved

Average email received per profile

  • July 23, 2024
  • 1 reply
  • 797 views

Hi all,

 

What's the best way to get the average number of emails received per profile within a timeframe in ACS? Thanks in advance

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

@michellelowsl Take a look at this thread and you can update the workflow based on your needs.

1 reply

Craig_Thonis
Adobe Employee
Adobe Employee
July 23, 2024

Hi Michelle,

 

You will want to use a workflow and include the average aggregate Avg(<value>) to return the average of a column.

 

Function documentation:

https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/filtering-data/list-of-functions

 

Regards,

Craig

Level 3
July 23, 2024

Hi @craig_thonis Thanks for the reply. Do you know what log should I use in the workflow and what column should I use the aggregate function for?

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
July 23, 2024

@michellelowsl Take a look at this thread and you can update the workflow based on your needs.

Thanks, Sathees