I have a requirement where in I need to show the percentages of emails clicks and open rate of emails delivered through a program (AO Analytics object) and this is useful when representing them in Dashboard as the percentages speaks more than numbers.
Even though we show them under Program analytics tab, but needs to report using report builder.
Could you please advise.
Percentage of click rate and open rate of the email delivered through Program.
Userlevel 3
Is there any update on this request? How can we build a report with percentage value rather than numbers?
Userlevel 7
+1
To add more context, the customer is creating dashboards to present campaign results to csm, sellers, management... using various AO tables. Percentages are often more meaningful than total number of emails to present such information. She wants to produce a report that shows a percentage of emails opened for instance.
When looking at the AO dataspaces available for reporting. There is no numeric field she can use in the AO Emails table so all she can do is count instances (total or unique).
AO Analytics dataspace has numerics but for some unknown reason the Open Rate field is not populated! This has now been recognized as a bug on which we are working on.
Other numeric fields such as total opens, total participants do exist, but Report has no calculation capability to come up with a percentage.
The idea of this enhancement request is to help prioritize the fixing of the Open Rate field not getting populated and to improve Report to be able to produce a single percentage metric that we can then use to present in a widget in a Dashboard.
Ideally that would be what she would like.
When looking at the AO dataspaces available for reporting. There is no numeric field she can use in the AO Emails table so all she can do is count instances (total or unique).
AO Analytics dataspace has numerics but for some unknown reason the Open Rate field is not populated! This has now been recognized as a bug on which we are working on.
Other numeric fields such as total opens, total participants do exist, but Report has no calculation capability to come up with a percentage.
The idea of this enhancement request is to help prioritize the fixing of the Open Rate field not getting populated and to improve Report to be able to produce a single percentage metric that we can then use to present in a widget in a Dashboard.
Ideally that would be what she would like.
Userlevel 6
+1
After working with Support, I've learned that formula fields do not currently work with Email Logs, Email Raw Events and Unsubscribed Emails even though they are MDA objects...
Hopefully this functionality will be rolled out in a future release?
Hopefully this functionality will be rolled out in a future release?
Userlevel 7
Or just providing standard email rates as percentages out of the box, without requiring the use of formula fields would be even better.
Userlevel 1
Is there any update on this request? How can we build a report with percentage value rather than numbers? The rate is available, but it’s a number and could easily be moved into a percentage field, but I am unable to add a field on the AO analytic object.
Userlevel 7
Has anyone figured out how to create a report that will display engagement rates yet, even if it’s with bionic?
Userlevel 7
Would this be possible with formulas in Report Builder releasing this month?
Userlevel 7
+2
@All, chaning this to an idea post and redirecting to our product team.
Thanks for posting!
Thanks for posting!
Userlevel 7
+1
Reply
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.