Oracle Service Cloud comes with several reports that allow the analysis of the emails sent to customers by the use of the Outreach facilities of the platform. Those out-of-the-box reports track the accuracy of email delivery and show activity and performance for both broadcast and transactional mailings.
They display the number of marketing emails that have been sent and delivered. The number of emails open, links clicked and unsubscriptions requested. The number and percentage of emails that could not be delivered. As well as the types of email bounces that prevented them from being delivered.
This information is grouped by Mailing. i.e. the user can select a particular Mailing and the report shows the above information for that specific Mailing.
This was not enough on one of the projects my team was working on. The requirement was not only to see the number of bounces, but actually be able to identify the name and email address of the person to whom the Mailing was not delivered.
By using a simple join between the Marketing Activities (ma_trans) and the Contacts (contacts) tables, we were able to deliver the report that showed the intended information. See report and definition below.
Report Definition: Oracle Service Cloud – Bounced Emails by Mailing