Oracle Analytics and AI

saravananv

Hi all,

We would like to see the email frequency with engagement like below,

Number of emails sent 1, 2, 3, 4, 5, 6-10, 10+, 15+ and 20+ in a month

AND

Open rates/CTR

AND

Split that, or show the view for different BUs(campaign field).

Please let me know if this custom report is possible in insight or do we have any other workarounds?

Regards,

Saravanan

Robert Angel

Hi,

if I understand you correctly then you can use bin functionality on count(emails by whatever your fields are) or filter based equivalent to solve your 20+, 15-19, 10 - 14 etc requirement

You can also use a column selector to allow users to add various optional fields, but this may make the logic of the above requirement more complex.

Alternatively you could use a view selector in place of a column selector to keep the logic for your first requirement simple.