Tagging rules — conditions

A rule’s conditions is a logical group of one or more conditions:

"conditions": {
  "operator": "AND",
  "rules": [ { "type": "METRIC", … }, { "type": "COLUMN", … } ]
}

operator — AND (all must match) or OR (any).
rules — a list of metric or column conditions.

Metric conditions

Compare an analytics metric against a threshold.

{
  "type": "METRIC",
  "metricId": "<uuid>",
  "conditionOperator": "LOWER_OR_EQUAL",
  "thresholdValue": 7,
  "periodFilter": { "type": "LAST_30_DAYS" }
}

Field	Meaning
`metricId`	A metric from the catalog (e.g. days of stock, inventory turnover, gross sales, risk score, sales trend %).
`conditionOperator`	See operators below.
`thresholdValue`	The comparison value.
`periodFilter`	Optional time window (e.g. `LAST_7_DAYS`, `LAST_30_DAYS`, `THIS_MONTH`, `ALL_TIME`).

Operators: LOWER_THAN, LOWER_OR_EQUAL, GREATER_THAN, GREATER_OR_EQUAL, EQUAL, NOT_EQUAL, TOP_PERCENT, BOTTOM_PERCENT.

For TOP_PERCENT / BOTTOM_PERCENT, thresholdValue is a percentile cutoff in (0, 100] evaluated across the entities in scope (e.g. “top 10% by sales”).

Column conditions

Test a gold/silver column value directly.

{
  "type": "COLUMN",
  "columnId": "dim_products.gender_full_path_1",
  "columnOperator": "STARTS_WITH",
  "value": "M",
  "secondaryValue": null
}

Field	Meaning
`columnId`	`"<table>.<column>"` (e.g. `dim_products.name`).
`columnOperator`	Depends on the column’s data type — see below.
`value`	The comparison value (string / number / boolean).
`secondaryValue`	Upper bound for `BETWEEN`; ignored otherwise.

Operators by data type

String
Date
Boolean
Numeric

EQUALS, NOT_EQUALS, CONTAINS, NOT_CONTAINS, STARTS_WITH, ENDS_WITH, MATCHES_REGEX, IS_EMPTY, IS_NOT_EMPTY.

BEFORE, AFTER, BETWEEN, ON_DATE, IS_EMPTY, IS_NOT_EMPTY.

IS_TRUE, IS_FALSE.

LOWER_THAN, LOWER_OR_EQUAL, GREATER_THAN, GREATER_OR_EQUAL, EQUAL, NOT_EQUAL.

Value-less operators

IS_EMPTY, IS_NOT_EMPTY, IS_TRUE, IS_FALSE take no value — the builder hides the value input for them. BETWEEN is the only operator that uses secondaryValue.

Metric and column conditions can be mixed in the same rule under one operator (AND/OR), e.g. “days of stock ≤ 7 AND gender starts with M”.

API integration

API recipes

Platform & data model

Decision layer (reference)

Operations & infrastructure

Ingestion specs (reference)

Workflows (reference)

Tagging rules (reference)

Alerts (reference)

Tagging rules — conditions

Metric conditions

Column conditions

Operators by data type

Value-less operators

​Metric conditions

​Column conditions

​Operators by data type

​Value-less operators

Metric conditions

Column conditions

Operators by data type

Value-less operators