Acoustic Campaign skips invalid data and continues to process a record that references date or numeric typed fields that contain invalid data.

This functionality works when performing the following actions:

• Sending to the query.
• Using the Search tab.
• Calculating the count (unless universal behavior criteria are present).
• Exporting the results.
• Leveraging the query (or criteria like this) on a program action.
• Leveraging the query (or criteria like this) in dynamic content rule sets.

Here's how it works

Your database contains a field called Jersey number, the value type is set to numeric, and the field contains the following data.

The following query looks for jersey numbers that are numerical values between 1 and 20.

• Jersey Number is between 1 and 20, with is between being the operator.

This process returns the Brian Johnson and B.J. jones records. The Kris Martin record is excluded because his jersey number is outside the specified range. Acoustic Campaign also does not process the Justin Smith record because the query is looking for a numeric value and does not recognize Eight, the text value in that field.