Include Operator Support

When filtering on dimensions related to a single object, such as Page Browse or Products Purchased, use the INCLUDE operator. For example, Product Browse = Shoes INCLUDE Color = Red produces all contacts who browsed the red version of shoes in your catalog.

Note Time values are calculated based on the Marketing Cloud Engagement server time, not on your business unit or org’s time zone. The Engagement server uses United States Central Standard Time (CST). Using CST can affect the yesterday value and other values that are related to the recency of data.

The INCLUDE operator supports these use cases.

By Page Browse

• Page Browse Event Count (LTD) = n INCLUDE Page Browse By Name = "some page name"
• Page Browse Date = mm/dd/yyyy INCLUDE Page Browse By Name = "some page name"
• Page Browse Days = n INCLUDE Page Browse By Name = "some page name"

By Content Browse

• By Name
  • Browse Event Count: Number of Pages Browsed Yesterday (or last 7,14,30) = 1 INCLUDE Content Browse By Name = "some content name"
  • Browse Event Count: Content Browse Date = mm/dd/yyyy INCLUDE Content Browse By Name = "some content name"
  • Browse Event Count: Content Browse Days = n INCLUDE Content Browse By Name = "some content name"
• By Attribute Name
  • Browse Event Count: Content Browse Date = mm/dd/yyyy INCLUDE Content Browse By Attribute = "some attribute name"
  • Browse Event Count: Content Browse Days = n INCLUDE Content Browse By Attribute = "some attribute name"

By Search Browse

• Search Browse Event Count (LTD) = n INCLUDE Search Browse By Search Term = "some search term"
• Search Browse Date = mm/dd/yyyy INCLUDE Search Browse By Search Term = "some search term"
• Search Browse days = n INCLUDE Search Browse By Search Term = "some search term"

By Visit

• Days since last visit = n INCLUDE Average Days Between Visits = n
• Days since last visit = n INCLUDE Average Time On Site In Minutes = n
• Average Days Between Visits = n INCLUDE Average Time On Site In Minutes = n
• Days since last visit = n INCLUDE Behavioral User Affinity = "some affinity"
• Days since last visit = n INCLUDE Behavioral User Affinity = "some affinity"
• Average Days Between Visits = n INCLUDE Behavioral User Affinity = "some affinity"

By Products Purchased

• By Product Name
  • Products Purchased by Product Name (LTD, last 30, 60, 90, or other value) = "some product" INCLUDE Products Purchased by Date = mm/dd/yyyy
  • Products Purchased by Product Name (LTD, last 30, 60, 90, or other value) = "some product" INCLUDE Products Purchased by Days = n
• By Product SKU
  • Products Purchased by Product SKU (LTD) = "some product SKU" INCLUDE Products Purchased by Date = mm/dd/yyyy
  • Products Purchased by Product SKU (LTD) = "some product SKU" INCLUDE Products Purchased by Days = n
• By Product Attribute
  • Products Purchased By Attribute = "some attribute" INCLUDE Products Purchased by Date = mm/dd/yyyy
  • Products Purchased By Attribute = "some attribute" INCLUDE Products Purchased by Days = n
  • Products Purchased By Attribute = "some attribute" INCLUDE Products Purchased by Days = n

By Products Browsed

• Product Browse Event Count (LTD) = n INCLUDE Product Browsed By Name = "some prod name"
• Product Browse Event Count (LTD) = n INCLUDE Product Browsed By SKU = "some prod SKU"
• Product Browse Event Count (LTD) = n
• Product Browse Event Count (LTD) = n INCLUDE Product Browsed By Day = n
• Product Browse Event Count (LTD) = n INCLUDE Product Browsed By Date = mm/dd/yyyy
• Product Browse by Days = n INCLUDE Product Browsed By Name = "some prod name"
• Product Browse by Days = n INCLUDE Product Browsed By SKU = "some prod SKU"
• Product Browse by Days = n INCLUDE Product Browsed By Attribute = "some prod attribute"
• Product Browse by Date = mm/dd/yyyy INCLUDE Product Browsed By Name = "some prod name"
• Product Browse by Date = mm/dd/yyyy INCLUDE Product Browsed By SKU = "some prod SKU"
• Product Browse by Date = mm/dd/yyyy INCLUDE Product Browsed By Attribute = "some prod attribute"

By Category Browsed

• Category Browse Event Count (LTD) = n INCLUDE Category Browsed By Name = "some category name"
• Category Browse Event Count (LTD) = n INCLUDE Category Browse Days = n
• Category Browse Event Count (LTD) = n INCLUDE Category Browse Days = mm/dd/yyyy
• Category Browse Days = n INCLUDE Category Browsed By Name = "some category name"
• Category Browse Date = mm/dd/yyyy INCLUDE Category Browsed By Name = "some category name"

By Search

• Search Browse Event Count (LTD) = n INCLUDE Search Browsed By Search Term = "some search term"
• Search Browse Event Count (LTD) = n INCLUDE Search Browse Date = mm/dd/yyyy
• Search Browse Event Count (LTD) = n INCLUDE Search Browse Days = n
• Search Browsed By Search Term = "some search term" INCLUDE Search Browse Date = mm/dd/yyyy
• Search Browsed By Search Term = "some search term" INCLUDE Search Browse Days = n

By Visits and User Affinity

• Days Since Last Visit = n INCLUDE Average Days Between Visits = n
• Days Since Last Visit = n INCLUDE Average Time On Site (in minutes) = n
• Average Days Between Visits = n INCLUDE Average Time On Site (in minutes) = n
• Average Days Between Visits = n INCLUDE Days Since Last Visit = n