I am trying to create a query in marketing cloud that will give me both ContactKey and SubscriberKey in the results.
The background: we are setting up MobileConnect. It seems that between MobileConnect and Email Studio there are 4 IDs in play:
- SubscriberKey (email - user specified)
- SubscriberID (email - system generated)
- ContactKey (mobile - user specified)
- ContactID (mobile - system generated)
I have used this question as a reference to run queries to get a list of MobileConnect contacts. However, the issue is that these data views only have the ContactID.
It is also apparently not possible to query the _AllContacts data view (as per this article).
So how can I run a query that will result in a DE that shows contacts from both Email Studio and MobileConnect, along with their SubscriberKey and ContactKey, mobile number, email address, etc?
An alternative way of putting it: is there a query that will return all my MobileConnect contacts with their ContactKey (which will be the same as their SubscriberKey)?