unique key identifier in SFMC whatsapp send tracking using a journey

yonatan — Thu, 16 Mar 2023 12:06:02 GMT

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?

Re: unique key identifier in SFMC whatsapp send tracking using a journey

Bipin_Patel — Tue, 20 Sep 2022 23:58:22 GMT

Hi Yonatan,
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

topic unique key identifier in SFMC whatsapp send tracking using a journey in Discussion Forum

unique key identifier in SFMC whatsapp send tracking using a journey

Re: unique key identifier in SFMC whatsapp send tracking using a journey