When to use a custom metric
- Blended metrics — combine metrics from multiple ad platforms into one calculation.
- Business-specific ratios — margins, ROI, or LTV-to-CAC that no single data source provides natively.
- Reused calculations — a formula used on many widgets is easier to define once.
Create a custom metric
Custom metrics are created from a widget’s settings panel:1
Open the widget's settings panel
Pick any widget on the dashboard, and open its settings panel.
2
Open the metric panel
Open the metric picker inside the settings panel and click the + Custom metric button at the top.
3
Build the formula
In the custom metric editor, pick base metrics from the metric picker and combine them using math operators (
+, -, *, /, parentheses). Base metrics from every connected data source are available.4
Set the type and precision
Pick the metric type and precision:
- Type — one of Number, Percentage, Currency, or Duration.
- Precision — the number of decimal places, from 0 to 4.
5
Name and save
Give the custom metric a name and save. It becomes available in the metric picker on every widget that supports custom metrics.
Edit or delete a custom metric
From the same metric panel where the custom metric was created, hover over an existing custom metric to reveal edit and delete actions. Deleting a custom metric that’s referenced by dashboard widgets triggers a warning — widgets currently using it will render the value as- once deleted.
Formula basics
Custom metrics use base metrics, constants, and standard math operators. Examples:- Blended CPA —
(Meta Spend + Google Spend) / (Meta Conversions + Google Conversions). - Gross margin —
(Revenue - Spend) / Revenue. - Cost per session —
Ad Spend / GA4 Sessions.
Null handling
The formula evaluates row by row. Two rules apply when values are missing:- All referenced metrics are null on a row — the row’s custom metric value is also null (renders as
-). The row genuinely has no data. - Some referenced metrics are null — nulls are treated as
0before the formula runs, and the formula evaluates. The result is a real number, or-if the formula produces division-by-zero or an invalid result.
Conditional formulas
A custom metric can carry multiple formulas — each with its own condition. Adriel evaluates conditions top to bottom and uses the first formula whose condition matches the row. Common use cases:- Apply one formula for one channel and a different formula for another.
- Use a fallback formula for rows that don’t match any specific condition.
Scope
Custom metrics can be created at three scopes:- Workspace-scoped — available across every teamspace and dashboard.
- Teamspace-scoped — available only in the teamspace where it was created.
- Dashboard-scoped — available only on the dashboard where it was created.
Referencing custom metrics in other custom metrics
A custom metric can reference another custom metric. Chains resolve in dependency order:- Cycles are forbidden — a custom metric can’t reference itself directly or transitively.
- Missing references — a custom metric that references a base metric no longer present in the workspace evaluates to
nullfor every row.
Troubleshooting
For common problems — formula scoping, deleted-metric behavior, cache refresh, decimal precision on tooltips, and why the total row doesn’t equal the sum of the breakdown rows — see the Breakdowns & metrics FAQs.Related
Metrics
The base metrics custom calculations build on.
Custom breakdowns
The breakdown-side counterpart.
Multi-currency reporting
How currency conversion interacts with currency-typed metrics.
