Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Is there an overview of all sent e-mails?

Avatar

Level 2

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
Level 5

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

View solution in original post

4 Replies

Avatar

Correct answer by
Level 5

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

Avatar

Level 4

@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