As described T223935, for the last few years, contacts that were created during the first almost two hours of the silverpop export were added to the unsubscribes export on their first day. They would be exported to the regular mailing list on their second day, but according to @CCogdill_WMF their addresses stay on the opt out list on IBM's side.
- Figure out when we deployed the tools (silverpop_export) update that started calculating all the opt outs from the log tables.
- Check on timing of export job and look at logs to determine general timing of window between start and select to set up the 'excluded' table.
- Select all email addresses created between those hours, and delete those that have any opt-out status