Is there an overview of all sent e-mails?

[icostan2]

Hi,

I know the global and live reports for journeys, but my marketers want to see an overview of all e-mails sent in a sandbox. Is there any way to see all the e-mails sent with some stats? Or are global and live reports the only reports available for e-mails? Thanks! 

[Avinash_Gupta_ · Accepted solution]

@icostan2 : As of now, you can only get the report of the emails through live reports section present on each journey. There is no way to generate the global report of all the emails sent across all the journeys.

https://experienceleague.adobe.com/docs/journey-optimizer/using/reporting/live-report/live-report.ht... 

Although, you can access the detailed list of excluded email addresses, go to Administration > Channels > Email configuration, and select Suppression list and filter on the Suppression category, Address type, or Reason. 

Hope this helps!

[icostan2]

Ah alright, thanks. Hope it will be possible in the future! 

[anuhya-tad]

@icostan2 try this query to find all emails who received emails. change messageexecutionid accordingly.

SELECT _experience.customerjourneymanagement.emailchannelcontext.address AS emailid,
_experience.customerjourneymanagement.messagedeliveryfeedback.feedbackstatus AS status,
_experience.customerjourneymanagement.messagedeliveryfeedback.messagefailure.reason AS failurereason,
_experience.customerjourneymanagement.messagedeliveryfeedback.messagefailure.type AS bouncetype
FROM cjm_message_feedback_event_dataset WHERE _experience.customerjourneymanagement.messageprofile.channel._id = 'https://ns.adobe.com/xdm/channels/email'
AND _experience.customerjourneymanagement.messagedeliveryfeedback.feedbackstatus = 'sent'
AND _experience.customerjourneymanagement.messageexecution.messageexecutionid = 'XXXXXXX' ORDER BY emailid

[icostan2]

Thank you so much!!