Skip to content
Browse documentation

Custom metrics

Define your own formula columns such as net EPC or approval rate and use them in any network report, its totals and saved views.

Last updated 2 min read

On this page

Custom metrics are named formulas over the built-in counters, for example (revenue - payout) / clicks. The report engine computes them from the aggregated numbers of each row — and of the totals row — so they are always consistent with the other columns.

Create a custom metric#

  1. Open Reporting → Custom metrics (/app/reports/metrics; search "Custom metrics" with Cmd-K).

  2. Click New metric.

  3. Fill in:

    FieldRules
    NameRequired, up to 60 characters. The key is derived from it, e.g. "Net EPC" → cm_net_epc (a suffix is added if taken).
    FormulaUp to 300 characters. See the grammar below.
    FormatNumber, Money (report currency) or Percent (fraction × 100).
    Decimals0–6, default 2.
  4. While typing, the form shows an Example value computed for 1,000 clicks, 40 conversions, 600 revenue and 400 payout, or the parse error.

  5. Save. The metric appears in the Metrics picker of the report builder under Custom formulas.

A workspace can have up to 50 custom metrics. Any staff member can create, edit and delete them (permission to save reports). Deleting a metric is safe: saved views that use it simply stop showing it.

Formula grammar#

  • Numbers: 100, 0.5, .25

  • Operators: +, -, *, /, unary minus, and parentheses ( )

  • Metrics (the base counters only):

    impressions, clicks, unique_clicks, bot_clicks, conversions, pending_conversions, rejected_conversions, revenue, payout, profit, sale_amount

Ratios such as cvr, epc or margin cannot be referenced; write them out instead (for example conversions / unique_clicks). Anything else — other names, functions, commas — is refused.

Division by zero gives an empty cell (—) for that row instead of an error.

Examples#

NameFormulaFormat
Net EPC(revenue - payout) / clicksMoney
Approval rateconversions / (conversions + pending_conversions + rejected_conversions)Percent
Rejection raterejected_conversions / (conversions + rejected_conversions)Percent
Revenue per 1,000 clicksrevenue / clicks * 1000Money
Bot sharebot_clicks / clicksPercent
Margin (own copy)profit / revenuePercent

Percent format multiplies the result by 100 for display, so a ratio formula (a / b) is what you want — do not multiply by 100 yourself.

Use custom metrics in reports#

  1. In Reporting → Reports, open Metrics.
  2. Tick the custom metrics under Custom formulas (up to 10 per view).
  3. They are computed for every row and the totals row, sort like other columns and are saved with saved views.

Money custom metrics use the report's money currency, like revenue and payout.

Limits#

  • Network reports only. Partner and advertiser portals and partner/advertiser API keys do not see custom metrics.
  • Not compared in period comparison and not usable as metric filters (Rows) or in KPI alerts.
  • Not part of the call shown under API request.
  • Changing a formula changes every view that uses it from then on; there is no version history beyond the audit log.
Something unclear or missing in this article?Tell us