Create your customer segment

A Editor company would like to send out its weekly newsletter, and the marketing team requires create the customer list from their master customer, they wish to personalize their communication by using the first names and last names of their subscribers. As a member of the marketing team, you are responsible for creating the target data extension which will hold the data that will serve for personalization.

Create the target data extension

Data Extension Details: Master Customer

SQL query activity

SELECT

email, first_name, last_name

FROM [Master Customer]

Explanation

• SELECT: This clause point out which columns you’d like to see in your target data extension.
• FROM: This clause point out to the table from which you want to pull the data.

Outcomes gathered: Target DE is ready to be use to send emails.