What is "!=" used for as a selector in email amarketing?

May 27, 2014 1:25 pm

what is the choice "!-" for when using as a conditional selector in email campaign drop down list for a directory

May 27, 2014 1:56 pm

Hi Paul,

The != sign means "Is not equal to."

For instance, if you had a membership field for relationship status, and you wanted to send a campaign to members listed as "Single", "Divorced", or "In a Relationship" but you didn't want to send to users listed as "Married" you could use != Married rather than creating an equals option for all of the other choices.

May 27, 2014 2:04 pm

thanks stephanie

I was setting up a campaign to send to all people who's email address started with
"b"

I decided on
exclude <=a
include >=b
exclude >=c

Is there any other clever way to select a field with a specific starting letter?
Can a "*" wildcard in the selection string?

May 27, 2014 3:36 pm

Hello Paul,

Can you please provide some more information on this topic to help us better understand your goal with Email Marketing Conditions? Are you using Membership to dictate the conditions? Or are you using a Custom Directory?

Currently, when adding a condition you will see the following drop down menus:

(#1) Include (or Exclude) | (#2) Membership: Field Selection(s) | (#3) Operator | (#4) Values from Drop Down Menu (#2)

The field, `membership:contact_email` (which produces the values for drop down #4) is derived from the Email field in the Contact Information section in:

Membership > Users > edit a User > Info > Contact Information > Email:

If this field is left blank for all users within Membership then instead of getting a drop down menu for (#4) it would then produce a blank textbox. When there are no values to create a condition, adding a single character (or anything else) will not produce any results because there is not a value that can drive the condition.

What is your overall goal so that we may be able to provide a different solution?

May 27, 2014 3:40 pm

hi blake

I think you meant this reply to go under the thread
Using Custom Directories for enhanced Email Marketing subscriber lists.

If you can repost it there, Ill reply to it so the threads are not crossed over

May 27, 2014 4:02 pm

In this thread

what i was trying to accomplish here is to send out a message to take a survey monkey survey to about 4000 people in a custom directory (not a membership directory) The organization thought that if the request to take the survey went out as emails from about 20 of the organization leaders, and making it look like a personal email from them, each sending to only a portion of the database, they would get a better yield.

So, to accomplish that I suggested they just create 20 different campaigns and one person sends to the email addresses starting with a, then next to b and so on.

I was just curious about other qualifiers and how they work

May 27, 2014 4:40 pm

Hello Paul,

I apologize for any confusion, however this is the topic I meant this reply to go to. I am trying to determine where and how you are setting up your filters to get them to best work for your needed situation.

When adding a condition you should be presented with the following options (drop downs):

(#1) Include (or Exclude) | (#2) Membership: Field Selection(s) | (#3) Operator | (#4) Values from Drop Down Menu (#2)

The field, (#2) `membership:contact_email` (which produces the values for drop down (#4) is derived from the Email field in the Contact Information section in:

Membership > Users > edit a User > Info > Contact Information > Email:

If this field is left blank for all users within Membership then instead of getting a drop down menu for (#4) it would then produce a blank textbox. When there are no values to create a condition, adding a single character (or anything else) will not produce any results because there is not a value that can drive the condition.

The filter is not made to filter via the Email Marketing Email. It is made to filter based on Membership > Information sub-tab or Custom Directory information such as 'where company = "google"' or 'where number_of_children > 3' etc.  If you have the same email set up for the Membership Contact Email as you do the Email Marketing email, you can send an email out to all users who have an email starting with 'B' However it will take a little bit different logic.  

Because fields which contain values give you a dropdown you will have to do the following:  

Include >= (First B email in the dropdown ) Exclude > (Last B email in the drop down)

NOTE: Once you have your conditions set you can then test your condition by clicking on the "Calculate Total" button:

This will produce the results of your current Query set. Please make sure that you calculate the total and view the included emails to verify that your includes and excludes are outputting the expected emails.