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

Is there an overview of all sent e-mails?

  • November 10, 2022
  • 2 replies
  • 1763 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

Avinash_Gupta_
Community Advisor and Adobe Champion
Avinash_Gupta_Community Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
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
Level 3
November 17, 2022

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

Anuhya-Y
Community Advisor
Community Advisor
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
Level 3
November 17, 2022

Thank you so much!!