ÃÛ¶¹ÊÓƵ

Build calculated metrics build-metrics

The Calculated metric builder dialog is used to create new or edit existing calculated metrics. The dialog is titled New calculated metric or Edit calculated metric for metrics that you create or manage from the Calculated metrics manager.

Calculated metric builder
Calculated metric details window showing fields and options described in the next section.
Create or Edit calculated metric
Calculated metric details window showing fields and options described in the next section.
  1. Specify the following details ( Required is required):

    table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 9-row-2 10-row-2 11-row-2 12-row-2 13-row-2
    Element Description
    Data view You can select the data view for the calculated metric. The calculated metric you define is available in Workspace projects based on the selected data view.
    Project-only metric An info box to explain that the metric is only visible in the project where it is created and that the metric will not be added to your component list. Enable Make this metric available to all your projects and add it to your component list to change that setting. This info box is only visible when you create a metric in Workspace using Create metric from selection and have selected a function (like Mean or Median). And later use the Component info to edit that created metric.
    Title Required Name the calculated metric, for example, Conversion Rate.
    External ID Required The name of the calculated metric when using an external BI tool and the BI extension. The value is automatically defined as undefined_xxx unless you override the value.
    Description Provide a description for the filter, for example, Calculated metric to define the conversion rate. There is no need to describe the formula for the calculated metric as the formula is already automatically available in Summary.
    Format Select a format for the calculated metric: You can select between Decimal, Time, Percent, and Currency.
    Decimal places Specify the number of decimal places for the format selected. Only enabled when the format selected is Decimal, Currency, and Percent.
    Show upward trend as Specify whether an upward trend of the calculated metric displays as â–² Good (Green) or as â–¼ Bad (Red).
    Currency Specify the currency of the calculated metric. Only enabled when format selected is Currency.
    Tags Organize the calculated metric by creating or applying one or more tags. Start typing to find existing tags you can select. Or press ENTER to add a new tag. Select CrossSize75 to remove a tag.
    Preview The preview covers the last 90 days and is a way to gauge whether you have defined your metric correctly.
    Summary Displays a summary of the definition of the calculated metric.
    For example: Event Total Orders Divide Event Sessions.
    Definition Required Define your filter using the Definition builder.
  2. To verify whether your calculated metric definition is correct, use the constantly updated Preview of the results of the calculated metric. The Preview covers the last 90 days and evaluates the definition of your calculated metric continuously.

    The Product compatibility indicates whether the calculated metric can be used in experimentation. Possible values are:

    • Everywhere in Customer Journey Analytics: The calculated metric can be used throughout all of Customer Journey Analytics.
    • Everywhere in Customer Journey Analytics (excluding experimentation): The calculated metric can be used throughout all of Customer Journey Analytics, except in the Experimentation panel.
  3. Select:

    • Save to save the calculated metric.
    • Save As to save a copy of the calculated metric.
    • Cancel to cancel any changes you made to the calculated metric or cancel the creation of a new calculated metric.

Definition builder

You use the Definition builder to drag and drop dimensions, metrics, filters, and functions to create custom metrics based on container hierarchy logic, rules, and operators. In that construction, you can use standard metrics, ÃÛ¶¹ÊÓƵ defined metrics, calculated metrics, filters, dimensions and functions. All these components are available from the component panel in the Calculated metric builder. Furthermore, you can use operators and containers in the definition.

Create calculated metric

Only metrics are defined as singular components in the Definition area. All other components are defined as a container, wrapping metrics or other containers. See Containers for more information.

Metrics

To add a metric:

  • Drag and drop an Events Metrics component from the components panel onto Drag and drop metrics, dimensions, dimension items, filters, and/or functions here. You can use the Search in the components bar to search for specific components.

When you use a calculated metric as part of your definition, the calculated metric is expanded.

To modify a metric:

  1. Select Setting in a metric component in the Definition area.
  2. In the popup dialog you can define the type of metric and an attribution model. See Metric type and Attribution.

To delete a metric:

  • Select Close in the metric.

Operators

Operators let you specify the operator between components or containers. Operators appear automatically between

  • two or more metrics in a container,
  • two or more containers in a container,
  • one or more metrics and one or more containers in a container.

You can select:

Symbol
Operator
Divide
Divide (default)
Close
Multiply
Remove
Subtract
Add
Add

Static number

You can add a static number to your calculated metric definition. To add a static number:

  • Select AddCircle Add from within a container.
  • Select Static number. A static number container appears.
  • Select Click to add a value and type a value.

Containers

You add dimensions, filters and functions as containers to a calculated metric definition. You can also add a generic container. Containers function like a math expression and determine the order of operations. Anything within a container gets processed before the next component or container.

Filter container

You use the concept of a filter container to create a filtered metric. You can construct a filter container using a filter, or using a filter you create from a dimension.

  • To add a filter container from a dimension:

    1. Drag and drop a Dimensions Dimensions component from the components panel onto Drag and drop metrics, dimensions, dimension items, filters, and/or functions here. You can use the Search in the components bar to search for specific components.
    2. In the Create Filter from Dimension popup, define the condition for the filter. Select from the list of operators and select a value or enter a value. For example, Month equals ChevronDown Sep 2024.
    3. Select Done. A filter container is added to the Definition.
  • To add a filter container from a filter, you can use:

    • Drag and drop a Segmentation Filters component from the components panel onto Drag and drop metrics, dimensions, dimension items, filters, and/or functions here. You can use the Search in the components bar to search for specific filters.
      Automatically a filter container is added to the Definition, using the name of the filter.

    • Drag and drop a Segmentation Filters component from the components panel onto a generic container. The container is modified into a filter container.

    • Select AddCircle Add from within a container:

      1. Select Filter. A filter container is added to the Definition.
      2. In the new filter container, select a filter from the ³§±ð±ô±ð³¦³Ù… dropdown menu.
    note tip
    TIP
    You can add more than one filter to a container.

    The filters in the container are named after the filter component. For example, Segmentation Web sessions. Select InfoOutline to display a popup with details on the filter. In the popup, select Edit to edit the filter definition.

To remove a filter from a container:

  • Select Close next to the filter name.

See Filtered metrics for more details and examples.

Function container

To add a function container, you can use:

  • Drag and drop:

    1. Drag and drop a Function Functions component from the components panel onto Drag and drop metrics, dimensions, dimension items, filters, and/or functions here. You can use the Search in the components bar to search for specific functions.
    2. Automatically a function container is added to the Definition using the name of the function.
  • Select AddCircle Add from within a container:

    1. Select Function.
    2. In the container, select a function from the ³§±ð±ô±ð³¦³Ù… dropdown menu.

The function container is named after the function component. For example, Function SQUARE ROOT (metric). Select InfoOutline to display a popup with details on the function. Select Learn more for more information on the function.

See Use functions for details on how to use functions and what functions are available to create a calculated metric.

Generic container

To add a generic container:

  • Select AddCircle Add from within a container
  • Select Container. A new empty generic container is added to the Definition. You can use a generic container to nest or create a hierarchy in the definition of your calculated metric.

Delete a container

To delete a container, select Close at the container level.

recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79