1. Select Contacts that have not received any emails in the last 14 days

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get the details of all contacts that have not received any emails in the last 14 days watch the video tutorial on how to implement this scenario or follow the steps below note this scenario uses feature formula's in subqueries, which is available in deselect plus and advanced 1\ input on the selections overview screen, click on new to create a new selection drag the deselect demo contacts data extension to the selected data extensions section drag field email to the filters section choose criteria not in results in the not in results dropdown, select data view sent the sent data view contains the details of all emails that are sent from marketing cloud choose field subscriberkey as the matching column for the data view now we have indicated we want to get the contacts whose email does not appear in the sent data view however, we want to filter on only the emails from the last 2 weeks, so we'll limit the results of the sent data view click on the funnel icon on the newly created filter in the modal that opens up drag field eventdate to the filters section choose criteria is after or on choose date filter type relative choose 14 , days , before today 2\ output hit the create data extension button, enter a name, eg contacts without recent 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 from deselect demo contacts the results table shows only contact that have not received any emails in the last 14 days note we did not enter an exact date; whenever we run this selection, we'll always get contacts without an email in the last 14 days as the date comparison is dynamic and based on the time of execution of the query