Create a resend campaign

Scenario: Let's assume you created an Email Campaign through Email Studio. You used one of your Data Extensions as the target audience. A couple of days after sending the original email, you want to resend the email with another subject to trigger the people who have not opened the email yet, in the hope they will open it the second time. You want to create a resend campaign for all the people that received the email from the first campaign but never opened it. Therefore, you need to find all the people from your target audience that received the email but did not open it.

DESelect provides all the required features to make it easy for you to find all these subscribers and store them inside a Data Extension. Let's see how we can make this happen!

We created a User-Initiated send through Email Studio. After sending the email we can get some information regarding the send through the Tracking tab:

Inside SFMC, each send relates to one Job. Information regarding Jobs is stored inside the _Job Data View. Since DESelect fully supports Data Views we can use Job information, such as the Job ID or the subject line, to only extract information for a specific send. We will start by creating a new selection inside DESelect:

1. Click on the New Selection button.
2. Provide the name Resend campaign.

For our resend campaign we would like all the information we had in our original target audience. Therefore we will add this Data Extension to our Selected Data Extensions and filter out all the people that received the first email but did not open it. Information regarding which people opened specific emails exist inside the _Open Data View:

1. Drag and drop your original Data Extension to your Selected Data Extensions.
2. Drag and drop your Email field from the Available Fields section to your Filters section, in order to filter out the people that did not open the email.
3. Select the Not in Results filter type from the dropdown and match it with the SubscriberKey field of your _Open Data View.
   
4. Click on the funnel icon to apply further filtering.
5. Drag and drop JobID to your Filters section.
6. Select Equals operator and set the value to the JobID you want to filter on, in our case, as shown from the screenshot above, 445498.

We now excluded the people that did not open the email, but we also want to make sure that they received it in the first place. Information regarding people that received specific emails exist inside the _Sent Data View:

1. Drag and drop your Email field from the Available Fields section to your Filters section.
2. Select the In Results filter type from the dropdown and match it with the SubscriberKey field of your _Sent Data View.
   
3. Click on the funnel icon to apply further filtering.
4. Drag and drop JobID to your Filters section.
5. Select Equals operator and set the value to 445498.
   
   

Your selection criteria should now look as follows:

The next step is to create the Data Extension we are planning to use for our resend campaign:

1. Click on Target Definition.
2. Click on Create Data Extension.
3. Fill in the name Resend Campaign Audience.
4. Click Is Sendable checkbox.
5. Click Save.
6. Click on the Add all Fields button.
7. Set the Send Relationship.
8. Click Save Data Extension.
9. Click Create.

Now it is time to hit on the Run button! The generated values should only contain the SubscriberKeys that received the previous email but not opened it:

As you can see from the tracking information inside Email Studio we successfully managed to get only the needed Subscriber: