We have sent adoc sms via mobile connect to Service Cloud Contact. we want to sync the record back to service cloud. We have checked Below data views but unable to find SubscriberKey 1)_smsmessagetracking 2)_MobileAddress

Please let us know which data view has subscriberKey(Salesforce ContactId) or what is the best way to sync records to Service Cloud

Note- We don't have unique Mobile number in service cloud.

3 Answers 3


If these subscribers also exist on the email channel (All Subs list) you can join subscriberid from the smsmessagetracking data view to the _subscriber data view to get subscriberkey


Since _subscribersms doesn't available in Mobileconnect, so not able to combine it with _smsmessagetracking.

I have done a workaround by combining _MobileAddress and _smsmessagetracking to get SFDC 18 digit ContactId known as subscriber key in SFMC and it worked fine.


You should combine Dataviews _smsmessagetracking and _subscribersms and create a relationship based on Mobile & MobileNumber or on SubscriberId.

You should be able to retrieve the SubscriberKey like this.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .