Understanding the Challenge

The Contact ID in the _Subscribers view is actually the SubscriberID, which only includes Email subscribers. To get Contact IDs for all channels, including Mobile Push and Connect contacts, you need to extract all contacts and then query the resulting data.

Solution Overview

To extract all contacts, you can create a Mobile List, which includes all contacts across all channels. You can then use a SQL query to extract the Contact IDs from this list.

Step-by-Step Solution

Here are the steps to extract all contacts and query Contact IDs:

SQL Query

SELECT ContactID FROM _MobileList

The root cause of this issue is that the _Subscribers view only includes Email subscribers, and does not include contacts from other channels.

Best Practices

When extracting all contacts, make sure to follow best practices for data management and security.

Heads up: Be sure to check the documentation for any updates on querying Contact IDs across all channels.

Checklist

Extracting All Contacts

• Create a Mobile List to extract all contacts across all channels
• Use a SQL query to extract Contact IDs from the Mobile List
• Make sure to follow best practices for data management and security
• Check the documentation for any updates on querying Contact IDs
• Test your query to ensure it is working as expected

Frequently Asked Questions

What is the difference between SubscriberID and ContactID?

SubscriberID is the ID for Email subscribers, while ContactID is the ID for all contacts across all channels.

Can I use the _Subscribers view to query Contact IDs?

No, the _Subscribers view only includes Email subscribers, and does not include contacts from other channels.

How do I create a Mobile List in Marketing Cloud?

You can create a Mobile List by following the instructions in the Marketing Cloud documentation.

What are the best practices for data management and security when extracting all contacts?

Make sure to follow best practices for data management and security, such as encrypting sensitive data and limiting access to authorized personnel.