Which AJO system dataset provides me From address?

[AvinashNa1]

Our AJO instance has 3 marketing subdomains, wanted to know which subdomain sent the email? 
Message feedback dataset --> I don't see any sender from address.

Thanks

Avinash

[SatheeskannaK]

@AvinashNa1 I don't see that exposed anywhere in the message feedback/AJO entity dataset.

https://data-distiller.all-stuff-data.com/unit-2-data-distiller-data-exploration/explore-300-explori...

I think we should open an Adobe support ticket to get more details unless someone has a better idea.

[Pulkit_Jain_ · Accepted solution]

@AvinashNa1 

A similar query was raised by another customer a few months back.

In the AJO Message Feedback Event dataset, you can query the recipient address via "_experience.customerJourneyManagement.emailChannelContext.address" but the dataset does not store the sender (“from”) address.  

If you need to verify which sender address was used for a given email, the only available sources today are:
• the email/channel configuration inside the Journey UI, or
• the rendered message stored in your ESP logs.

[Mayank_Gandhi]

@AvinashNa1 You cannot see the sender “From” address / subdomain in the AJO Message Feedback Event dataset; it is simply not captured there today.

That’s why you don’t see any “sender” field in your feedback dataset. You can see: The recipient address: _experience.customerJourneyManagement.emailChannelContext.address The recipient domain (for reporting): _experience.customerJourneyManagement.emailChannelContext.domain (or by splitting the address)

[FilipeFreitas]

Hi Avinash,

I faced the same need here, and like Mayank_Gandhi mentioned, this data isn't stored in any AEP dataset.

We developed a workaround: tags. When setting up a campaign or journey, the team adds a tag to reference the sender being used. This data is stored in the ajo_entity_dataset and can be used in queries or CJA.

I hope this helps.

Best regards,

Filipe Freitas