Considerations

dots 2.png
+.png
-.png

Query Activity

+.png
-.png

Wait Activity

OAuth API Integration

+.png
-.png

SMS/MMS Content

+.png
-.png

AMPscript

+.png
-.png
  • Nested functions are calculated from the inside out.

  • Commas are not permitted in numeric constants.

  • Alternative quote characters, such as smart quotes, are not permitted in string constants.

  • Be careful using null. An empty string (for example "") or a zero value (0) is not the same as null.

  • Review spacing. The system views spaces as two different attributes. For example, First Name would search for a data field named "First" instead of "First Name."

  • The lookup function only returns a single value. If the criteria used in the lookup function matches multiple records, the function returns the first found value, regardless if more values exist.

  • Certain functions are not intended for send time use with high volume. These include EncryptSymmetric,CreateSalesforceObject, and InsertDE functions.