AJO Campaigns emails sent to a profile | Community
Skip to main content
M
Melvinr
Level 1
March 11, 2026
Question

AJO Campaigns emails sent to a profile

  • March 11, 2026
  • 1 reply
  • 13 views

 

I’m using the Profile-based sample queries on the documentation to retrieve all successfully executed message actions for a specific profile but looks like it only return journey message.

 

How can I get all emails sent to a profile from AJO Campaigns?

 

Documentation link:

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/reporting/reports/query-examples

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity Advisor
Community Advisor
March 11, 2026

​@Melvinr Start with this initial query, and feel free to expand upon it if more details are needed. Replace the campaignID.

SELECT identityMap['email'][0]['id'] from
    ajo_message_feedback_event_dataset
WHERE
    _experience.customerJourneyManagement.messageDeliveryfeedback.feedbackStatus = 'sent'
    AND _experience.customerJourneyManagement.messageExecution.campaignID IN ('abc894e-bcef-4195-b680-3f3a42df1233')
 

Thanks, Sathees
    M
    MelvinrAuthor
    Level 1
    March 12, 2026

    Awesome, thank you ​@SatheeskannaK 

      Terms & ConditionsAccessibility statement

      Loading footer...