Unique ID to be picked up from the system schemas for sending SMS via AJO journey messages using contextual attributes

[vikramcl]

Dear Community,

Greetings!

I am trying to send an uniqueID to the 3rd party system for sending the metadata. 

I need one attribute that is to be uniquely generated for each SMS sent via AJO journeys. 
Kindly suggest one attribute from the system schemas / datasets that would help me stitch this ID back to the message feedback event dataset to have a single view of the journey via queries or data distiller jobs. 

Sequence of events: 
1. SMS received from 3rd party system to AJO (This contains the SMS information) (Dataset 1) 
2. SMS delivered to the user and metadata (this contains the uniqueID) sent to 3rd party via AJO. (Message Feedback Dataset / Step Event Dataset stores the journey details) 
3. 3rd party sends the metadata back to AJO (Dataset 3) 

I would need one unique ID to be used in the metadata within the SMS content to stitch back the information to the profile. 
Constraints:
The only identity I am using is loyaltyID and can't use any other identity. 

Need your help. Thanks! 🙂 
Vikram C L 

[Mayank_Gandhi]

@vikramcl 

Use messageProfileID from the AJO Message Feedback Event Dataset

• messageProfileID is a unique GUID generated for each message sent to a recipient via a journey (including SMS).
• It exists in the AJO Message Feedback Event dataset and is specifically designed to identify each delivery to a profile.
• You can embed this messageProfileID in your SMS metadata sent to the third-party system.
• When the third-party system returns data to AJO, ensure it includes this messageProfileID, enabling you to stitch together the original send, delivery event, and feedback data even if only the loyaltyID identity is available in the identityMap.

[vikramcl]

Thanks @Mayank_Gandhi I did try this approach. However, I am unable to see the messageProfileID pass through in the message content. 

Any idea why this is not been popping up? 

[Mohan_Dugganab · Accepted solution]

@vikramcl You can use the following attribute

{{context.journey.technicalProperties.instanceUID}}

 and gets recorded in

(_experience.customerJourneyManagement.messageExecution.journeyVersionInstanceID)

 in message feedback dataset

[vikramcl]

Let me try this method right away 🙂 Thanks for your input. 

[vikramcl]

@Mohan_Dugganab by any chance do you know where can we pull this journey properties to message feedback schema one to one mapping? 

As I was thinking to use messageProfileID for this use-case. Thanks in advance. 

[Mohan_Dugganab]

You can use the following to reconcile 

SELECT  to_json(identityMap)  FROM ajo_message_feedback_event_dataset WHERE _experience.customerJourneyManagement.messageExecution.journeyVersionInstanceID = <InstanceIdReturnedBackFromThirdPartySystem>

[vikramcl]

Yup! Join I am aware. I am using multiple datasets so I can pull required attributes and join them. 

But wanted to know more about this Journey Properties and one to one mapping with system datasets like Step Event and Message Feedback. Any reference link or resources would be much appreciated. Thanks! 🙂 

[Mohan_Dugganab]

Here are the reference links for data dictionary and journey properties https://experienceleague.adobe.com/tools/ajo-schemas/schema-dictionary.html?lang=en 

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/orchestrate-journeys/building-adv... 

Whatever is exposed in journey properties gets stored in step events (once the journey is executed) - instanceUID in step events and _experience.customerJourneyManagement.messageExecution.journeyVersionInstanceID in message feedback dataset (wrt. your case)

[vikramcl]

Thank you so much and gratitude. 🙂