Return to Question

For clarity (hopefully!) I added an alternative query suggestion that amounts to the same outcome

Source Link

edited Nov 26, 2019 at 0:12

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)?

Thanks

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?

Thanks

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)?

Thanks

Source Link

asked Nov 25, 2019 at 23:51

Ben

Query to get ContactKey and SubscriberKey in results?

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?

Thanks