cancel
Showing results for 
Search instead for 
Did you mean: 

unique key identifier in SFMC whatsapp send tracking using a journey

yonatan
New Contributor

Hello,

We are using Sinch for our Salesforce Marketing Cloud WhatsApp sending.

SFMC installed package

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?

1 REPLY 1

Bipin_Patel
Employee
Employee

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