Sometimes metrics don’t provide the type of information you’re looking for. Creating calculated PowerMetrics can help you get the accurate, relevant data you need.
For example, in Google Analytics, the metrics “Page Views” and “Sessions” provide valuable data but don’t tell you the number of pages views for each session. Using calculated PowerMetrics, you can get this information by combining these two metrics using a formula
(Number of Page Views / Number of Sessions) to create a “Page Views per Session” PowerMetric.
This article contains the following sections:
- What are calculated PowerMetrics?
- What do I need to know about calculated PowerMetrics?
- Creating a calculated PowerMetric
- Editing a calculated PowerMetric
What are calculated PowerMetrics?
Calculated PowerMetrics combine PowerMetrics using an equation (with simple math - addition, subtraction, multiplication, and division) to create a PowerMetric that can be expressed as a number, a percentage, or a ratio.
Here are some examples of calculated PowerMetric formulas:
- Lifetime Value to Cost Of Acquisition Ratio:
ƒ((Customer Lifetime Value)/(Customer Acquisition Cost))
- True Trials:
ƒ(count(Trial Users that have signed in twice within the first 7 days) / Count(All Trial Users))
What do I need to know about Klipfolio calculated PowerMetrics?
Here are a few things to note about calculated PowerMetrics:
- When creating a calculated PowerMetric, dimensions are selected for you, based on shared, common dimensions from your referenced PowerMetrics.
- The aggregation type for a calculated PowerMetric is based on the formula and is not configurable.
- If a referenced PowerMetric is deleted or no longer shared with you, any calculated PowerMetrics derived from it will not be able to calculate accurately. You will need to modify the calculated PowerMetric’s formula to update it.
- Functions in calculated PowerMetric formulas are not currently supported.
Creating a calculated PowerMetric
As a first step, ensure you have access to the PowerMetrics you will reference when creating your calculated PowerMetric. It’s important to give your referenced PowerMetrics relevant, recognizable names as you will be entering them into your calculated PowerMetric formula. Note that you can also use calculated PowerMetrics as referenced PowerMetrics.
Within the calculated PowerMetric configuration wizard, you have the option of moving forward and back, so it’s easy to play with your formula and settings until you get the end result you’re looking for. For additional clarity, as you create your calculated PowerMetric, the Preview pane displays the results of your choices. (Note that the PowerMetric value in the Preview pane uses the “all time range” setting, which is the overlap of time from the referenced PowerMetrics.)
During the calculated PowerMetric creation process, you:
- Enter a formula: The formula structure enables you to perform calculations by inserting operators, grouping with parentheses, and entering constant numerical values, if applicable, for example: (Revenue - Expenses) *2.14. The following operators are supported: +, -, /, *, and ().
- Apply filters: As you’re entering your formula, you can optionally apply filters to referenced metrics to include or exclude members for each dimension.
- Choose options: This is where you give your calculated PowerMetric a name and set options. We recommend choosing a relevant, descriptive name, ideally including the typical terminology for the PowerMetric you want to create, for example, “Page Views per Session”. In the Options window, you can also set a favourable trend, choose a format type (numeric, currency, or percentage), and choose whether or not to show your data cumulatively.
To create a calculated PowerMetric:
- In the left navigation sidebar, click PowerMetrics to open the PowerMetric List page.
- Click + Add PowerMetrics.
- Click Calculate a new PowerMetric.
- On the Create a calculated PowerMetric page, in the Formula window, write your formula by entering the names of your referenced PowerMetrics, separated by the appropriate operator(s) (+, -, /, *) and including parentheses and constant numerical values, as needed. Continue adding formula components as required.
Tip: To see a list of all of your PowerMetrics and to quickly select and enter them into your formula, click the + button (as shown below).
You can also copy and paste entire or partial formulas. Note that the right-hand Preview pane updates as you build your formula.
There are limits to the number of PowerMetrics and nested PowerMetrics allowed in a calculated PowerMetric formula. If your formula exceeds the maximum number of PowerMetrics, you must reassess your formula to reduce them. If your formula exceeds the maximum number of nested PowerMetrics, we will indicate which PowerMetric(s) needs to be reconfigured.
- Click on the referenced PowerMetric to see its aggregation type. The aggregation type is chosen for you based on the referenced PowerMetric’s aggregation type, but you can modify this setting if required.
- If you want to apply filters, click on the referenced PowerMetric and, under Filters, select the members to filter for each dimension. Next, select either Include or Exclude, and click Filter.
- When you’re done building your formula, click Next.
- In the Options window, under PowerMetric Name, type a name for your calculated PowerMetric.
You can also name your PowerMetric in the Preview pane.
- Under Format, choose a format type from the drop-down menu.
- Optionally, set your data to Show as cumulative.
- Optionally, set a Favourable trend for your calculated PowerMetric.
Choose whether you want ascending or descending values to indicate a positive trend. For example, if your PowerMetric includes sales totals, a higher (ascending) number demonstrates a positive trend but, if your PowerMetric includes cost to acquire customers, a lower (descending) number indicates a positive trend. This option only applies to scorecard (single value) visualizations. Favourable trends are indicated by a green arrow.
- Click Save.
The calculated PowerMetric is added to your PowerMetrics List page.
Editing a calculated PowerMetric
After creating a calculated PowerMetric, you can edit it to modify its formula, name, format type, and other optional settings.
To edit a calculated PowerMetric:
- In the left navigation sidebar, click PowerMetrics.
- Choose the calculated PowerMetric you want to edit from the PowerMetrics List page.
The PowerMetric opens in its Explore View.
- Click the 3-dot menu beside the PowerMetric’s name and click Edit.
The Edit <name of PowerMetric> page opens.
- Modify your calculated PowerMetric.
- Click Save.
Note that the Save option is only available after you navigate to the Options step in the edit wizard.