Advanced Dynamic Content Cheatsheet

This section details the variables used for advanced dynamic messages.

Things that count as items:

• Products
• Articles
• Blogs
• Catalog Objects
• Categories

Must have intended item query selected in message settings

Ensure that you either iterate over every product in an array

You can further refine results from query functions by passing them a set of item options, as shown in the following example.

1$tools.user.products.viewCount(${itemOptions...})

You can specify item options by calling multiple functions on the itemOptions object, as shown in the following example.

1${itemOptions.optionOne().optionTwo().optionThree()}

By default, a message containing advanced dynamic queries renders only if there’s at least 1 result.

To increase the minimum number of items returned, use ${itemOptions.minItems(<Integer>)}.

To increase the maximum number of items returned, use ${itemOptions.maxItems(<Integer>)}.

You can further filter query results using the following filters.

To specify a lookback period apart from the default lookback period of the past week, use:

1${itemOptions.time(<TimeObject>)}

The following functions are provided by the $time singleton object:

The itemOptions object provides several conditional options or methods that you can call to filter or manipulate its properties based on certain conditions.

You can use conditionals with conditional options to further refine the data being filtered.

1${itemOptions.whereName().exists()}

The following conditionals are available for use.

To sort the results for display, use the displaySort function.

1${itemOptions.displaySort(<SortOptions>)}

To sort results for display in the descending order, use the descending function.

1${itemOptions.descending()}

The displaySort function provides the following sort options.

To sort results for display in the descending order, use the descending function.

1${itemOptions.descending()}

To include items a visitor is currently viewing in query results, use:

1${itemOptions.includeItemsBeingViewed()}

To include items in a visitor’s cart in query results, use:

1${itemOptions.includeItemsInCart()}

To exclude items a visitor has already purchased from query results, use:

1${itemOptions.excludePurchasedItems()}

To exclude items a visitor has already viewed from query results, use:

1${itemOptions.excludeViewedItems()}

1<!-- #if ($user.attributes.firstName) -->
2<div>Hello $user.attributes.firstName</div>
3<!-- #else -->
4<div>You don't have a first name at all</div>
5<!-- #end -->

1#set (${variableName} = $...)

1#foreach (${variableName} in <Array>)
2...
3#end

There are two ways to format prices.

• By passing the price as a floating-point number to the formatPrice method. The formatPrice method formats the given number as a price, with the default dataset currency symbol and appropriate decimal formatting, and returns the formatted string.

  1$tools.formatPrice(<Float>)

  In Open Time Email Templates, only the $currencyTools.formatPrice(<Float>) method is available. This method is used instead of is used instead of the $tools.formatPrice(<Float>) and $tools.formatNumber(<Float>, <Int Number of Fractional Digits>) methods.

  Important

• By passing the price as a floating-point number and a fixed number of digits after the decimal point to the formatNumber method.

  1$tools.formatNumber(<Float>, <Int Number of Fractional Digits>)

The #field utility enables you to provide a fallback value for an attribute.

1<div>#field($item.attributes.testString, "Item does not have a testString attribute")</div>

j

Get Started

Data Modeling

Web Integration

Event API

Mobile Integrations

Ingesting Data into Marketing Cloud Personalization

Campaign Development

Personalization Template System

Web Campaigns and Templates

Server-Side Campaigns and Templates

Open Time Email Campaigns and Templates

Advanced Use-Case APIs

Campaign Template APIs

Sending Campaign Statistics to Third Parties

Advanced Dynamic Message Content

Use Advanced Dynamic Message Content

Advanced Dynamic Message Content Cheatsheet

Data Analytics

Custom Interface and Template Configuration

Additional APIs