Is there an overview of all sent e-mails? | Community
Skip to main content
New Participant
November 10, 2022
Solved

Is there an overview of all sent e-mails?

  • November 10, 2022
  • 2 replies
  • 1762 views

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! 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Avinash_Gupta_

@talithapa : 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.html?lang=en 

 

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!

2 replies

Anuhya-Y
New Participant
November 16, 2022

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

TalithaPaAuthor
New Participant
November 17, 2022

Thank you so much!! 

Avinash_Gupta_
Avinash_Gupta_Accepted solution
New Participant
November 11, 2022

@talithapa : 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.html?lang=en 

 

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!

TalithaPaAuthor
New Participant
November 17, 2022

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