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:
- In Analysis Workspace, open a project and click + New > Create Metric .
- In Analytics, go to Components > Calculated Metrics.
- Click + Add at the top of the Calculated Metric Manager, or
- Go to Analytics > Reports, open any report and click the Metrics icon to bring up the Metrics rail, then click Add.
Naming the metric is mandatory. You cannot save the metric unless it is named.
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.)
Choices include Decimal, Time, Percent, and Currency.
Shows how many decimal places will be shown in the report. The maximum number of decimal places you can specify is 10.
|Show Upward Trend As...|
This metric polarity setting shows whether [!DNL 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.
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:
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.
This is where you drag in metrics/calculated metrics, segments, and/or functions to build the calculated metric.
Divided by ( ) is the default operator, plus there are the +, -, and x operators.
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.
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...
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.
|Gear icon ( Metric Type , Attribution )|
Selecting the gear icon next to a metric lets you specify the metric type and attribution models .
Lets you create a new component, such as a new segment (which takes you to the Segment Builder .)
This search bar lets you search for dimensions, metrics, segments (advanced calculated metrics only), and functions (advanced calculated metrics only).
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.
List of Metrics
Metrics come in 3 categories:
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:
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...
List of Functions
Report Suite selector
Lets you switch to a different report suite.