How to suppress specific value from array field in DM campaign from AJO

[chrisyan]

Hi Team,

I need assistance in removing a specific value from an array field in a DM (Direct Marketing) campaign. In Audience Builder, there's no functionality to suppress a value directly, and using the "does not contain value" condition is too broad, which presents a risk.

In Journey, I can use the "in/not in" function in a conditional node's advanced query to remove any matched value from an array field, but I am unsure how to replicate this process in a DM campaign. I have been trying to tackle it in export template of DM that it's only giving me Boolean result by "in" function not removing the profile.

Could you please advise on how to handle this in a DM campaign?

Thank you!

[SatheeskannaK]

@chrisyan An optimal approach to address this at the audience level considering DM is currently supported only in Campaigns. Another audience approach to consider is having a data distiller audience, and based on the documentation I hope that works in the DM campaign.

[chrisyan]

I’m thinking of applying the approach above to precisely remove individuals who have already received specific touchpoints. The touchpoints will be stored in an array field, with values distributed and populated for those who received them and separated by commas. I plan to remove any previously received touchpoint values, which should help reduce broad matches adding comma in value position. Please advise if this method will work as intended.

[SatheeskannaK]

Yes, it should work. Small correction touchpoint values should look like this when you add them,

[RiteshY18]

@chrisyan  if possible, I would suggest to suppress at using AJO via express or helper function rather doing at audience level  

[chrisyan]

I could suppress it using in/notin function from the journey but for DM channel, to exclude it only option I have is the audience level where is no helper function or advance query to use and because DM is not able to extract file in the journey. 

[RiteshY18]

I am not sure and clear on the DM channel you are referring to, even if it comes as an array, you can use code to remove the value? the point here is not to update the source as it can be used for multiple use cases but rather do it at the implementation. If you have only one use case then can go ahead and update the audience  and even to actual source system before injecting it into the AEP data