Skip to content

Custom metrics ​

Use custom metrics to calculate derived values or use a numeric service field that is not available as a standard metric. Open Data → Custom metrics in a project.

Create a formula ​

  1. Select Add metric and choose Formula.
  2. Under Applies to, choose a source or the whole project. This determines the available metrics.
  3. Enter a descriptive name.
  4. Build the formula by choosing metrics from the suggestions. For example, cost divided by clicks gives cost per click.
  5. Choose what counts as an improvement: an increase, a decrease or no assessment.
  6. If needed, check the additional options under Advanced, then select Add metric.

Create a formula: scope, metrics and settings

Choose metrics by name and source: the same name can mean different data in different services. Operation and function buttons help you build the expression. Correct any formula error before saving.

Use a service field ​

  1. Choose Service field and the source.
  2. Select Load service fields, then Choose a numeric field.
  3. Check the name, source field, type and how totals are calculated. If Report or export is offered, select the appropriate option.
  4. Save the metric and check it after refreshing the data.

If the field list is unavailable, enter the source field name manually. It must match the field in the service; an arbitrary name is not a substitute. If requests are limited, wait until the indicated time before loading again.

For CRM, a warning that the field cannot be checked does not prevent saving. Check the result after the first data refresh.

Choose standard Keitaro metrics in source metrics. Custom fields are useful for custom conversions, rather than duplicating standard columns.

Discovered fields ​

Switch to Discovered during refresh to view detected fields. Review the name, type and settings of a metric you need, then approve it. Dismiss fields you do not need. Before approval, a field is not used as a regular active metric.

Project custom metrics and access to discovered fields

Do not approve fields containing contacts or other third-party personal data. Read the data notice beside the form.

If a field describes an object rather than a number, an owner or administrator can select Use as dimension. Then select the dimension in the source and refresh the data.

Check the scope

Connection fields are used by other projects sharing the connection. Before editing, approving or dismissing one, check the consequences for those projects.

View the result ​

For an active metric, select Open in statistics or add it through Columns in Statistics. If values are missing, check the input metrics and data refresh status.

Currency and missing values ​

For a monetary metric, set Currency in the additional options. Currency specifies the unit: changing it does not convert amounts or recalculate history.

A missing value differs from zero:

  • A formula with a missing input or division by zero produces no value. Replacing missing values with zero is not available for formulas.
  • For a summable service field, an empty total defaults to zero. Other metrics may have no value; you can change an available rule in the additional settings.
  • The round() function rounds halves away from zero: 2.5 → 3.

Edit, restore or delete ​

Open the metric's row menu. If editing or deleting it affects formulas, automations, observations or reports, resolve the dependencies listed in the warning first. Ask an administrator about objects you cannot access.

If an automation compares Improved/Worsened, change its condition to Changed before making the metric's direction neutral, or keep the previous direction.

Restoring a dismissed metric uses the limit again. If the limit is reached, free up space first. After a save error, correct the marked fields; see request failures.