Custom Metrics
Formula
A computed metric that calculates values from other metrics and channel data
A computed metric that calculates its value automatically from other metrics and channel data. Formula values are not entered manually — they update in real time based on the clipping's data.
Writing a formula#
Type @ in the formula editor to insert references:
- Metrics — reference other custom metrics (Number, Slider, Dropdown, or other Formula metrics). For dropdowns, the arithmetic value is used in calculations.
- Channel fields — reference built-in channel data such as Media Value, Views, Likes, Reach, or Print Run. Only fields available across all channels assigned to the formula metric are shown.
- Functions — use built-in math functions for rounding, absolute values, and more.
Available operators#
| Operator | Description |
|---|---|
+ | Addition |
- | Subtraction |
* | Multiplication |
/ | Division |
% | Modulo (remainder) |
^ | Exponentiation |
( ) | Grouping |
Available functions#
| Function | Description | Example |
|---|---|---|
round() | Round to nearest integer | round(3.7) → 4 |
roundTo() | Round to N decimal places | roundTo(3.756, 2) → 3.76 |
floor() | Round down | floor(3.7) → 3 |
ceil() | Round up | ceil(3.2) → 4 |
abs() | Absolute value | abs(-5) → 5 |
sqrt() | Square root | sqrt(16) → 4 |
min() | Smaller of two values | min(3, 7) → 3 |
max() | Larger of two values | max(3, 7) → 7 |
Example formulas#
@Media Value * 2— double the media valueround(@Views / 1000)— views in thousands, rounded(@Sentiment Score + @Visibility Score) / 2— average of two metricsroundTo(@Media Value / @Print Run, 2)— cost per copy, rounded to 2 decimals
Channel compatibility#
A formula metric's referenced fields must be available for all channels the formula is assigned to. For example, if your formula uses Views and is assigned to both YouTube and Print, it will show an error because Print does not have a Views field. Either narrow the formula's channels or use only fields that all assigned channels share (such as Media Value).