Build Metrics

The Calculated Metrics Builder provides a canvas to drag and drop Dimensions, Metrics, Segments, and Functions to create custom metrics based on container hierarchy logic, rules, and operators. This integrated development tool lets you build and save simple calculated metrics or complex advanced calculated metrics.

There are several ways to get to the Calculated Metric Builder:



UI Components

# Field Description
1 Title

Naming the metric is mandatory. You cannot save the metric unless it is named.

2 Description

Give it a user-friendly description to show what it's used for and to distinguish it from similar ones.

The description also appears within a report. It's best NOT to put the formula into the description - instead, describe what this metric should and should not be used for. (The formula is generated as you build the metric, underneath the Summary heading. As a result, there is no need to add the formula to the description.)

3 Format

Choices include Decimal, Time, Percent, and Currency.

4 Decimal Places

Shows how many decimal places will be shown in the report. The maximum number of decimal places you can specify is 10.

5 Show Upward Trend As...

This metric polarity setting shows whether Analytics should consider an upward trend in the metric as good (green) or bad (red). As a result, the report's graph will show as green or red when it's going up.

6 Tags
Tagging is a good way to organize metrics. All users can create tags and apply one or more tags to a metric. However, you can see tags only for those segments that you own or that have been shared with you. What kinds of tags should you create? Here are some suggestions for useful tags:
  • Tags based on team names, such as Social Marketing, Mobile Marketing.
  • Project tags (analysis tags), such as Entry-page analysis.
  • Category tags: Men's; geography.
  • Workflow tags: To be approved; Curated for (a specific business unit)
7 Summary

The Summary formula updates anytime you make a change to the metric definition. This formula also shows up in the metrics rail on the left when you hover over a metric and click the icon.

8 Definition

This is where you drag in metrics/calculated metrics, segments, and/or functions to build the calculated metric.

  • If you drag in a calculated metric, it will expand its metric definition automatically.
  • You can nest definitions with containers. However, unlike segment containers, these containers function like a math expression and determine the order of operations.
9 Operator

Divided by ( ) is the default operator, plus there are the +, -, and x operators.

10 Preview

Provides a quick read on any possible errors. The preview covers the last 90 days. This is a way of initially gauging whether you have selected the right components for your metric. An unexpected result would mean you need to take a second look at the metric definition.

11 Product Compatibility
Product compatibility shows you whether the metric is compatible with Current Data, with Fully Processed Data, or only with Marketing Channel reports (first-touch allocation).
Note: Current Data does not support all metrics. Metrics that contain segments or functions are not compatible with current data. More...
12 Add

For all types of calculated metrics, you can add containers and static numbers to the definition. For advanced calculated metrics, you can also add segments and functions.

  • Containers function like a math expression and determine the order of operations. So anything in a container will get processed before the next operation.
  • Dragging a segment onto a container segments everything in that container. (Advanced calculated metrics only)
  • You can stack multiple segments in a container.
13 Gear icon (Metric Type, Metric Allocation)

Selecting the gear icon next to a metric lets you specify the metric type and the metric allocation.

14 + New

Lets you create a new component, such as a new segment (which takes you to the Segment Builder.)

15

Search Components

This search bar lets you search for dimensions, metrics, segments (advanced calculated metrics only), and functions (advanced calculated metrics only).

16

List of Dimensions

Rather than leaving the Calculated Metric Builder in order to build a simple segment (in the Segment Builder), e.g. “Page = Homepage”, you can drag in Page and select Homepage directly from the Calculated Metric Builder.

This results in a much more streamlined workflow for creating segmented calculated metrics.

17

List of Metrics

Metrics come in 3 categories:

  • Standard metrics ()
  • Calculated metrics ()
  • Metrics templates () - at the bottom of the list.

When you hover over a metric, you can see the Info icon to the right of it: . Clicking this icon gives you the following information:

  • The formula of how it is calculated.
  • A preview trend of the metric.
  • An edit (pencil) icon at the top right that will take you to the Calculated Metrics Builder where you can edit this calculated metric.



18

List of Segments

(Advanced calculated metrics only) As an Admin, this list shows all segments created in your login company. If you are a non-Admin user, this list shows segments you own and those shared with you. More...

19

List of Functions

(Advanced calculated metrics only) Functions are divided into two lists: Basic (used most often) and Advanced.

20

Report Suite selector

Lets you switch to a different report suite.