Custom Segment Syntax
The definition is written as a condition that will be passed to a WHERE clause. The condition should be based only on fields within your model version schema.
The following SQL operators are supported:
Categorical fields are ingested as strings. If your segment includes a comparison of a categorical field and a constant value, remember to quote the constant value.
Examples
Assume we have a numeric field "age" and a boolean field "is_customer" in our schema, we can create a segment based on these fields as follows:
Assume we have a categorical field "partner_type" and categorical field "deal_step" in our schema, we can create a segment based on these fields as follows:
Assume we have a categorical field "region_code" in our schema, we can create a segment based on this field as follows:
Last updated