Report on Bounced Marketing Emails (Mailings)

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.

20150502 Oracle Service Cloud - Bounced Emails by Mailing

Report Definition: Oracle Service Cloud – Bounced Emails by Mailing

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s