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?
Thanks for your question. We have reviewed and this issue must be submitted to the Salesforce Marketing Cloud team as Sinch has no insights of the JourneyBuilder Data Extension and is not involved in this part of the WhatsApp messaging process.
Thanks and kind regards,
Bipin Patel, WhatsApp Product Manager