Segmentation
When segmented, a metric monitor will look for anomalies within each distinct segment of data, instead of the table as a whole. This helps to isolate and "louden" segment-specific anomalies that could otherwise be diluted and missed. Common fields to segment by include products, regions, event types, versions, sources, and merchants.
There are two options for how to segment a metric monitor:
- By field(s): up to two fields can be selected.
- When one field is chosen, the monitor will be segmented by each distinct value present in that field.
- When two are chosen, the monitor will be segmented by all combinations of the distinct values from each respective field. For example, if
field1
has 25 distinct values andfield2
has 6 distinct values, the monitor will track 150 segments (25 * 6 = 150).
- By SQL Expression: write a SQL expression to segment the table. For example,
CONCAT(TYPE, ' ', STATUS, ' ', TYPE)
.
Limits
One metric monitor can track up to 10,000 combinations of metrics, fields, and segments. Usually, this limit is only encountered when segmenting the monitor by a very high cardinality field.
This is calculated by counting the metric-field pairs, and multiplying by the number of segments. For example, a monitor tracking 2 metrics, on 5 fields, for 500 segments would total 5,000 combinations (2 x 5 x 500).
When adding a segmentation field, the user is required to click Test. This will check how many segments are present in recent data.
If an already configured monitor exceeds the maximum number of allowable combinations, the monitor will fail to execute, and the appropriate audiences will be sent a notification about the failure.
Updated 11 days ago