Expand my Community achievements bar.

Join us for the Adobe Journey Optimizer Community Q&A Coffee Break on 28th February at 8 am PT with Ariel Sultan, Daniel Wright, Josee Haeley and Rohit Basuri.
SOLVED

Is there an overview of all sent e-mails?

Avatar

Level 3

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! 

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@Taal : 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!

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

@Taal : 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!

Avatar

Level 3

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

Avatar

Community Advisor

@Taal 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