Hello,
We are using Sinch for our Salesforce Marketing Cloud WhatsApp sending.
We would like to create a report for journeys with WhatsApp sends.
So far I found an option to generate sends report, using Chat Messaging Data Extract: https://help.salesforce.com/s/articleView?id=sf.mc_jb_whatsapp_data_extract.htm&type=5
In order to align it with a specific journey I we need Join the Journey DataExtention with the Chat Messaging report.
But I could not find a unique key to connect both tables, the report has a filed called "SendIdentifier" which is a unique identifier per send. But I was not able to find any way to update the DE with this value for a later Join. If it was an email I could use something like this:
%%[
var @Contact_Key, @SendIdentifier
set @Contact_Key = [Contact_Key]
set @ SendIdentifier = AttributeValue(SendIdentifier)
set @insertCount = insertData("JourneyReportDE","Contact_Key", @Contact_Key," SendIdentifier ", @ SendIdentifier)
]%%
Using the "jobid" personalization string: https://help.salesforce.com/s/articleView?id=sf.mc_es_available_personalization_strings.htm&type=5
Is there a similar personalization string for "SendIdentifier" or some similar unique key identifier?
... View more
