Need to Mark Large Quantity of Emails as DNC

Options
Eleonore Buet
Eleonore Buet
Eighth Anniversary 10 Comments Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion
We have always use Constant Contact, which captures our unsubscribed emails. We recently migrated to RE NXT and want to use that email tool, but first I need to mark the emails that have unsubscribed in Constant Contact. It's about 1k emails, so I need a large scale way to do it. 


I can export all the emails in the DB, then through a series of Vlookups, associate the particular email with the System Record ID or the Constituent ID for each email. However, I am not sure if I can then do a Global Change using the System Record ID for the email to mark as DNC, or Constituent ID to Request no email.


Any thoughts on this?
Tagged:

Comments

  • Aaron Rothberg
    Aaron Rothberg
    Eighth Anniversary 500 Likes 100 Comments Name Dropper
    Hi Eleonore-


    You'll be hard pressed to find a way to mark phones as DNC en masse. Your best options are to use Import and either mark them as Inactive or create a new Phone Type called Do Not Contact and update your emails with that Phone Type.
  • Eleonore Buet
    Eleonore Buet
    Eighth Anniversary 10 Comments Photogenic
    Thank you!


    Can you explain a little more about how I would update the emails with the Do Not Contact phone type? Are you saying I could change the Phone type on the specific email address? How would I go about that?
  • Alan French
    Alan French
    Tenth Anniversary 1,000 Likes 500 Comments Name Dropper
    If you've got ImportOmatic, you can use that to mark phones as DNC. You just need the constituent ID and the phone type (which might be a problem if your business rules permit a constituent to have more than one phone of the same type, since ImportOmatic then won't know which one to update)
  • Aaron Rothberg
    Aaron Rothberg
    Eighth Anniversary 500 Likes 100 Comments Name Dropper
    Yes, you could, as one option, change the Phone Type on the email addresses. You'll need two other pieces of data; the Constituent Id and the Phone Import Id. Export those two values for each email address you'd like to update and add a third column called PhoneType (screenshot below). Then use a Constituent Phone Update Import to update the Phone Types in Raiser's Edge.

    49e80bffc5da670220d44875b14798bb-huge-dn


    One advantage of this method is that you can filter by PhoneType in your exports to exclude your Do Not Contact addresses.


    Alan is correct. If you have ImportOmatic you can update the DNC checkbox en masse, but using Raiser's Edge Import or Global Change it's just not possible.
  • Eleonore Buet
    Eleonore Buet
    Eighth Anniversary 10 Comments Photogenic
    Ok, thanks to both of you. We do not have Importomatic.


    So just to clarify, I want the ImportID, not the System Record ID,even if the email was manually entered it will have an import ID? 


    Thank you again!
  • Aaron Rothberg
    Aaron Rothberg
    Eighth Anniversary 500 Likes 100 Comments Name Dropper
    Correct. All of your phones and emails have an Import Id and it's the Constituent Id and the Phone Import Id you'll need to change the Phone Type using Raiser's Edge Import.
  • Rick Franklin 2
    Rick Franklin 2
    Ninth Anniversary First Comment
    Any chance that Blackbaud engineers would put DNC as a field in import?

     
  • Alan French
    Alan French
    Tenth Anniversary 1,000 Likes 500 Comments Name Dropper
    There's been a few requests for this in the idea bank for some years but they haven't received that many votes, so it's probably unlikely :(

Categories