Bulk update bounced contacts to non-bounced

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.

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.

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

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

Thank you very much for this - much appreciated.

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’

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

Where and how do you execute DELETE FROM lead_donotcontact WHERE reason = 2; ?

In your mautic database. You can access via terminal or web ui like PHP my admin