Our team is looking for a custom dashboard to view & download stats from JO Programs. The out of the box does not allow people to filter by Account names/CSMs/download who opened what etc so we need to build a custom dashboard.
My understanding is that AO Email and AO Participants are the two objects to use but I am not able to get few key fields like Open/Delivery rates. Even tried to create a custom formula in AO Emails but this did not seem possible.
Another issue I found is that whilst EMAIL LOGS object has the actual links a person clicked on, I cannot find this in the two mentioned objects. And we cannot use Email Logs in reporting.
Has anyone managed to achieve this? Is there a way other than via Data Designer / creating a new object were I feed multiple AO objects?
Below is a quick draft of what we’re trying to build.