For our monthly newsletters, we get a new list every month.
Original send - We have 20 different newsletter every month.
Resend - Each newsletter also need to go out to contacts who did not open or clicked on the send email.
Problem: Current process is very manual because it depend on creating sql for each send after the deployment that joins audience data extension with open and click data view to pull contacts who did not open or clicked.
Question: Is there any way to completely automate the process there is no need to manually write sql with job id for resent?
I am thinking about journey builder engagement spit as I don't think there is another way to do this in marketing cloud. But in engagement spilt, we can only do either open or click (not together). Can anyone suggest if there is any way to automate the process without journey builder? I think creating journey for each newsletter 20 times and new versions every monthly will be a lot of work.