Update the No Longer Contact flag...

[derekw42533281]

Is there a way to update the no longer contact flag when the email address gets updated?

We currently have a process where if a customer bounces we notify them to update their email address. When they do update their email address during the import the email address updates but the no longer contact does. Is there a way to update that flag when the email changes?

[ramon_bisswanger · Accepted solution]

Hm, how do you set the "do not contact" in the first place?

If there is a bounce, it normally creates a Quarantine record inside ACS and does not set the flag.

The Quarantine record tough is bound to the E-Mail address, i.e. with a changed address, they would be contacted again.

Else you may handle it in the import workflow:

• Reconcile with existing profile
• if existing profile + different email address => reset the flag

[derekw42533281]

Hey Ramon,

Would you be able to assist me on how to do this in the import workflow. I'm running into a wall.

I'm struggling getting the workflow to identify the different email. I might be going at this the wrong way.

[ramon_bisswanger]

sure, what you can do:

• Load file to process the input information
• Add reconciliation activity
  • Under relations add profile
  • add a join based on the ID to match the record (e.g. customer number, ...)
• in the next step you can access the profile and compare it with the data from the file

Those this indeed only will work if you do have some criteria on the profile which stays the same after the change (e.g. customer ID) or if the input file contains the old e-mail address

[derekw42533281]

So I can get that far, but I'm stuck with what activity to use to recognize it's different and change the flag... I might be going about this the wrong way. 

This is what I have so far when I'm testing this.

[derekw42533281]

Figured it out! I just need to have my segment activity set as a temporary DB and have it look at the reconciliation activity.