You could use program to split up your group and then insert delays to send to the rest of your list days later, or exclude them all together. In the example below, I send immediately to 20%, take another 40% and wait 3 days before sending, and take another 40% and exclude them all together.
Although I have not heard this directly from Responsys, I believe you can execute any SELECT statements that can normally be executed on an ORACLE database. We run this SQL statement, where you can see nested select statements:
SELECT * FROM ( SELECT RANK() OVER (PARTITION BY A.EMAIL_ADDRESS_ ORDER BY A.CREATED_DATE_) RNK, A.* FROM $A$ A JOIN (SELECT EMAIL_ADDRESS_ FROM $A$ GROUP BY EMAIL_ADDRESS_ HAVING count(EMAIL_ADDRESS_) > 1) B ON (A.EMAIL_ADDRESS_ = B.EMAIL_ADDRESS_) ) WHERE RNK <> 1
It’s that time of year again – spring cleaning time. Why not apply the same vigor to cleaning your email list as you do with cleaning out that flower bed full of weeds?
Continue reading