How to suppress specific value from array field in DM campaign from AJO | Community
Skip to main content
C
chrisyan
Level 4
March 2, 2025
Solved

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

  • March 2, 2025
  • 2 replies
  • 740 views

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!

Best answer by 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.

2 replies

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
March 2, 2025

@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.

Thanks, Sathees
    C
    chrisyanAuthor
    Level 4
    March 2, 2025

    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
    Community Advisor
    SatheeskannaKCommunity Advisor
    Community Advisor
    March 3, 2025

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

    Thanks, Sathees
      RiteshY18
      Community Advisor
      RiteshY18Community Advisor
      Community Advisor
      March 5, 2025

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

      C
      chrisyanAuthor
      Level 4
      March 5, 2025

      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
      Community Advisor
      RiteshY18Community Advisor
      Community Advisor
      March 5, 2025

      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 

        Terms & ConditionsAccessibility statement

        Loading footer...