在此頁面上：瞭解如何使用運算式編輯器以手動方式建立規則，包含資料庫欄位、變數和協助程式函式，以操控協調行銷活動中的日期、字串和數值。
使用運算式編輯器 edit
編輯運算式需要手動輸入條件以形成規則。 此模式可讓您使用進階函式，這些函式可讓您操作用於執行特定查詢的值，例如操作日期、字串、數值欄位和排序。
設定自訂條件時，可按下規則產生器的「編輯運算式」按鈕打開運算式編輯器，適用於「屬性」和「值」欄位。
運算式編輯器提供：
-
定義運算式的輸入欄位 (1)。
-
可用欄位 (2) 清單，可用於運算式中，並對應至查詢的目標維度。
-
可用於運算式中的可用 變數(3) 清單。 此功能表適用於 值 欄位。 瞭解如何在協調的行銷活動中使用變數
-
協助程式函式(4)，依類別排序。
直接在輸入欄位中輸入運算式以編輯運算式。 若要新增欄位、變數或協助程式函式，請將游標置於要新增的運算式中，然後按一下+按鈕。
協助程式功能
查詢編輯工具可讓您使用進階功能，根據所需結果和操作資料的類型執行複雜的篩選。 可使用下列函式：
彙總
彙總函式會針對一組值執行計算。
日期
日期函數可操控日期或時間值。
地理行銷
地理行銷函式用於處理地理值。
數值
數值函數可用來將文轉換為數字。
其他
此表包含剩餘的可用函式。
字串
字串函式可用來處理字串集合。
視窗
This section contains structured knowledge intended to support interpretation, retrieval, and question answering related to this topic.
For complete understanding, this information should be combined with the documentation on this page. Neither source is intended to stand alone; the page describes the feature, while this section provides additional context that helps disambiguate terminology, intent, applicability, and constraints.
- TL;DR: This page explains how to use the expression editor to manually build rule conditions with fields, variables, and helper functions for manipulating dates, strings, numbers, and other values in Orchestrated campaigns.
Intents:
- Open the expression editor from the Attribute or Value field when configuring a custom condition in the rule builder.
- Enter an expression directly in the input field, or insert a field, variable, or helper function using the + button.
- Use helper functions (Aggregate, Date, Geomarketing, Numeric, Others, String, Window) to manipulate dates, strings, numeric values, and sorting.
- Insert variables into an expression from the Value field.
Glossary:
- Expression editor: a mode accessed from the rule builder Edit expression button that lets you manually enter conditions to form a rule, using advanced functions (product-specific)
- Helper functions: functions sorted by category (Aggregate, Date, Geomarketing, Numeric, Others, String, Window) available in the expression editor to manipulate values (product-specific)
- Fields: items available in the expression editor that correspond to the targeting dimension of the query (product-specific)
- Variables: items available in the expression editor, from the Value field menu, that can be used in an expression (product-specific)
Guardrails:
- The expression editor is available from the rule builder Edit expression button, for the Attribute and Value fields, when configuring a custom condition.
- The variables menu in the expression editor is available only for the Value field, not for the Attribute field.
- The DateOnly function takes into account the server’s timezone, not the operator’s.
Terminology:
- Canonical name: expression editor — variants: Edit expression
- Do not confuse: “fields” (correspond to the targeting dimension of the query) ≠ “variables” (listed in a separate menu, available from the Value field)
FAQ:
- Q: Where is the expression editor available from? — The rule builder Edit expression button, for the Attribute and Value fields, when configuring a custom condition.
- Q: How do I add a field, variable, or helper function to an expression? — Place your cursor in the expression where you want to add it and click the + button.
- Q: What categories of helper functions are available? — Aggregate, Date, Geomarketing, Numeric, Others, String, and Window.
- Q: Does the DateOnly function use my local timezone? — No, it takes into account the server’s timezone, not the operator’s.
- Q: Can I use variables from the Attribute field? — No, the variables menu is available only for the Value field.
Related pages:
- For using variables in an expression from the Value field: Learn how to use variables in Orchestrated campaigns (orchestrated/variables-orchestrated-campaigns.md)
Personas:
- marketer: Can open the expression editor from the Attribute or Value field when configuring a custom condition, and enter an expression directly in the input field. Can place the cursor and select the + button to add a field, variable, or helper function. Can use helper functions sorted by category, such as Aggregate, Date, Geomarketing, Numeric, Others, String, and Window, to manipulate dates, strings, numeric values, and sorting. The page states that the variables menu is available only for the Value field. Where: “Work with the expression editor”.
Onboarding:
- Level: Experienced
- First minimal step: Select the Edit expression button for the Attribute or Value field when configuring a custom condition.
- Next: Learn how to use variables in the expression editor: Use variables in Orchestrated campaigns (orchestrated/variables-orchestrated-campaigns.md)