7. Select the Contacts with an email from a given domain

Note: The scenario below uses data from the DESelect Demo Data Package.

Scenario: You want to get all Contacts that have an email address from domain superrito.com from a Data Extension.

Watch the video tutorial on how to implement this scenario or follow the steps below. 

1. Input

On the Selections Overview screen, click on New to create a new Selection. 

Drag Data Extension DESELECT_DEMO_Contacts to the Selected Data Extensions section.

Drag field Email to the Selected Filters section:

• Criteria: Ends With
• Value: @superrito.com

2. Output

Hit the Create Data Extension button, enter a name, eg. Supperrito emails, 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 and Email from DESELECT_DEMO_Contacts

Click Save Data Extension.

3. Preview

When you click Run Preview on the Preview screen, a results table will be shown with fields First Name, Last Name, and Email. The results table shows only Contacts with an email ending in @superrito.com.