Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

Adding a New Profile Filter

The process of adding a new Profile filter consists of defining one or more conditions that will be used when the filter is applied.

  • In a Profile filter, set conditions based on Recipient data or Groups
  • You can connect multiple conditions using the Boolean operators AND & OR (e.g. "Age" field must be a number that is more then "35" AND equal to or less than "50")
  • The "Test" drop-down changes depending on the selection made in the "Type" drop-down. Fox example, the tests that can be done when the "Type" is "Text" are clearly different from the ones that are performed when the "Type" is "Date" or "Number".

Learn more about how to set the conditions in a filter.

In the example below, a business that is using MailUp in connection with an ecommerce store is setting up a filter that looks for customers whose latest order amount was a number between 100 and 500. Two conditions were created using the "Decimal" type and connected using the AND operator. This filter is based on the assumption that the a field containing the latest order amount exists in the Recipients Fields.

Dynamically populating recipient fields

You can populate fields in the recipients database by using one of the available ready-to-go integrations (e.g. ecommerce integrations) or by developing your own integration between your application and MailUp using the MailUp API.

Subscription date

Among the fields that you can use to create Profile filters is the subscription date. This field is filled automatically with the date of when the subscriber is added to the List, and can be used for a number of useful filters and triggered messages.

If you are doing a comparison on that date (e.g. a filter that looks at everyone that subscribed 60 days ago) select the MM/DD/YYYY field format from the Type drop-down, as shown in the picture below.

 

 

Date format

When filling a date field, you can input date format as following: 05/12/2014 or 5/12/2014 in the month and date (the year has to be always in 4 digits) the system will accept both

Decimals

When you select Decimals from the Type menu:

  • MailUp expects a number in that field
  • The number should not contain a thousands separator
  • The number can use either the comma or period as a decimal separator

Keep this in mind when you import recipients data via the Import Wizard or the API.

Handling arrays of values

If you save an array of values into a recipient field, you can match an element of the array by combining multiple conditions into your filters.

For example, let's say that in a recipient field called "Product_Purchased" you are saving IDs of recently purchased products (the data has been saved there via a data import, by leveraging an integration with another application, or by executing an API call).

Assume that you want to see if a product whose ID is "101" has been purchased. You would create a filter that contains the following conditions:

  • Product_Purchased equals to "101" OR
  • Product_Purchased starts with "101," OR
  • Product_Purchased contains (like) ",101," OR
  • Product_Purchased ends with ",101"

You can adjust the conditions above if you want to create a filter that looks to ensure that this product has not be purchased, or to cover other scenarios.

Related Topics

 

  • No labels