Note: The scenario below uses data from the DESelect Demo Data Package.
Scenario: You want to get the first and last name of all contacts in a data extension that are already Subscribers in Marketing Cloud.
Watch the video tutorial on how to implement this scenario or follow the steps below.
First off, you need to make sure at least a few of the Emails from the source data extension are added as subscribers. We are using DESELECT_DEMO_Contacts as a source data extension here. Look at the records in this data extension and add some of the emails as Subscribers in Marketing Cloud. Alternatively, you can add existing Subscribers to the DESELECT_DEMO_Contacts data extension.
1. Selection Criteria
On the selections overview screen, click on New to create a new selection.
Drag DESELECT_DEMO_Contacts to the Selected Data Extensions section.
Drag data view _Subscribers on top of DESELECT_DEMO_Contacts in the Selected Data Extensions section
Create the relationship:
- DESELECT_DEMO_Contacts field: Emails
- DESELECT_DEMO_Contacts WITH MATCHING _Subscribers
- _Subscribers field: Subscriberkey
2. Target Definition
Hit the Create Data Extension button, enter a name, eg. Known Subscribers, and press Save.
Select the following fields by either double-clicking on them or dragging them to the section on the right:
- First Name, Last Name from Contacts
- Email from _Subscribers
Click Save Data Extension.
Note: if you are not getting any results, make sure that you have emails in your _Subscribers list that are also in DESELECT_DEMO_Contacts.
When you click Run Preview on the Preview screen, a results table will be shown with fields First Name, Last Name, Email. The results table shows only Contacts that are also Subscribers.