New Column (VARCHAR)
I added a new column to the pm1_users table named UserCompany, but am unable to use it in an audience filter. Adding a WHERE clause such as below in the Custom SQL Query box, yields Invalid JSON syntax errors.
WHERE UserCompany LIKE 'Widget Corp'
WHERE UserCompany CONTAINS 'Widget Corp'
WHERE UserCompany = 'Widget Corp'
I tried double quotes ("") and escaping the single quotes with slashes (\').