Solved

Testing for Customer Properties Existence

  • 25 October 2023
  • 2 replies
  • 37 views

Userlevel 1
Badge +2

As we have learned more about custom properties in Profiles, we have been adding new fields to our customers profiles, but we’d like to pull a list of customers who haven’t had these new fields added yet.

In Lists and Segments there is nothing that I can find to allow us to filter based on CustomFieldXYZ IS NULL or DOES NOT EXIST or even EQUALS BLANK.

How can we pull a list of customers who do not yet have a specific custom profile property?

icon

Best answer by bluesnapper 26 October 2023, 11:18

View original

2 replies

Userlevel 7
Badge +36

Hi @rlscsi 

If you create a segment similar to mine below with your custom property (ce_order_id in my example), you will create a segment of contacts with no value in that custom property, or the custom property does not exist for them. 

Let me know if that’s what you are after.

Regards

Andy

 

 

Userlevel 1
Badge +2

Thank you, BlueSnapper -- yes, I found that setting after I originally posted this. Changed the number to text and found that “is not set” and it worked perfectly.

This will suffice, but it sure would be nice to have a “NOT ISDEFINED” type of control.

Appreciate the input!

Reply