We have all subscribers in 1 main data extensions "Audience_DE"
within this data extension, we have one field, "Email_Sign_up" YES / NO
All our emails are based on this field, we only send email if "Email_Sign_up" is YES.
What should be the correct approach to get subscribers who did not open email in last 100 days and they have "Email_Sign_up" as YES in "Audience_DE"?
If I save "Open" data view data in one data extension,
Is this a correct approach?
Select all customers from "Audience_DE" where "Email_Sign_up" = 'YES' and Email in (select SubscriberKey from openDataView where EventDate > DateAdd(Day,-100,GetDate())
Is it necessary to join with sent data view? if yes, why?