Filtered metrics

Last update: 2024-09-04
  • Created for:
  • User
    Admin

In the Calculated metric builder, you can apply filters within your metric definition. Applying filters is helpful if you want to use metrics for a subset of your data in your analysis.

NOTE

Filter definitions are updated through the Filter builder. If you make a change to a filter, the filter is automatically updated everywhere the filter is used, including if the filter is part of a calculated metric definition.

You want to compare metrics for German people interacting with your brand versus people outside of Germany. So, you can answer questions like:

  1. How many German versus international people are visiting your most popular pages.
  2. How many German versus international people in total have interacted online with your brand this month.
  3. What are the percentages of Germans and international people that have visited your popular pages?

See the sections below to illustrate how filtered metrics can help you answer these questions. Where appropriate, references are made to more detailed documentation.

  1. Create a calculated metric from a Workspace project, named German people.

  2. From within the Calculated metric builder, create a filter, titled Germany, that is using the CRM Country field from your CRM data to determine where a person is coming from.

    TIP

    In the Calculated metric builder, you can create a filter directly using the Components panel.

    Your filter could look like.

    Filter Germany

  3. Back in the Calculated metric builder, use the filter to update the calculated metric.

    Calculated metric Germany

Repeat the steps above for the international version of your calculated metric.

  1. Create a calculated metric from your Workspace project, titled International people.

  2. From within the Calculated metric builder, create a filter, titled Not Germany, that is using the CRM Country field from your CRM data to determine where a person is coming from.

    Your filter should look like.

    Filter Germany

  3. Back in the Calculated metric builder, use the filter to update the calculated metric.

    Calculated metric Germany

  4. Create a project in Analysis Workspace, where you look at pages visited by German and International people.

    Workspace Freeform table visualization showing German vs. International people

Totals

  1. Create two new filters based on Grand Total. Open each of the filters created earlier, rename the filter, set the Metric type for People to Grand Total and use Save As to save the filter using the new name. For example:

    Total metric for Germany

  2. Add a new Freeform table visualization to your Workspace project, showing the total pages for this month.

    Workspace Freeform table visualization showing German vs. International total people

Percentages

  1. Create two new calculated metrics that calculate a percentage from the calculated metrics you created earlier.

    Workspace Freeform table visualization showing German vs. International total people percentage

  2. Update your Workspace project.

    Workspace Freeform table visualization showing German vs. International total people

 Here is a video illustrating how to use a filtered calculated metric as an implementionless metric.

This video demonstrates the functionality using Adobe Analytics. However, the functionality is similarly available in Customer Journey Analytics. Be aware of the following differences in terminlogy.

Adobe Analytics Customer Journey Analytics
Segments Filters
Visitor Person
Visit Session
Hit Event

On this page