Bulk update bounced contacts to non-bounced

Product Support
1

Your software
My Mautic version is: 4.4.10

Your problem
My problem is: How can I bulk update 50,000 bounced contacts to non-bounced contacts? Sparkpost mistakenly tagged emails as bounced that are in fact not bounced (independently verified with neverbounce.com). No I want to remove the bounce tag from these contacts. Is there a way to do this in bulk? Thank you.

2

I think you should take two steps:

  1. Set a separate segment for 50000 contacts
  2. Set a campaign with Action “Remove Do Not Contact”

I think this way it should be able to work for you. Good luck to you.

3

Thank you very much for your suggestion.
How do you do this: Set a campaign with Action “Remove Do Not Contact”.

4

image
image696×511 15.5 KB

Set the action of the segment for 50000 contacts to “Remove Do Not Contact”, please refer to the screenshot. Hope to solve your problem.

5

Thank you very much for this - much appreciated.

6

Will this have the effect of removing ‘Do Not Contact’ designation, ‘Bounced: EMAIL’ designation, or both?

I am asking as I would like to execute this type campaign but only want to affect those with ‘Bounced: EMAIL’ and not ‘Do Not Contact’

7

Alternatively you can delete bounced contacts like this:

DELETE FROM lead_donotcontact WHERE reason = 2;

Values for query can be found here: mautic/app/bundles/LeadBundle/Entity/DoNotContact.php at 8959f6dbdccda152170b642c018a7047cf51e32e · mautic/mautic · GitHub