A2oz

How to Create a Calculated Metric in Adobe Analytics?

Published in Adobe Analytics 3 mins read

Creating a calculated metric in Adobe Analytics is a straightforward process that allows you to derive new insights from your data. You can combine existing metrics, apply mathematical operations, and customize your analysis.

Here's a step-by-step guide:

1. Navigate to the Calculated Metrics Section

  • Log in to your Adobe Analytics account.
  • Go to the Admin tab.
  • Click on Report Suites.
  • Select the report suite for which you want to create a calculated metric.
  • Click on Calculated Metrics under the Data Management section.

2. Create a New Calculated Metric

  • Click on the New Calculated Metric button.
  • Give your calculated metric a name and a description.
  • Choose the data type for the metric. You can select from several options, including:
    • Number: Used for numerical values like revenue, page views, or conversions.
    • Percentage: Used for representing proportions or ratios.
    • Currency: Used for displaying monetary values.
    • Text: Used for non-numerical values like strings or labels.
  • Select the calculation method. You can use basic mathematical operations like addition, subtraction, multiplication, and division. You can also use functions like SUM, AVG, MIN, MAX, and more.
  • Specify the metrics you want to use in your calculation.
  • Preview the calculated metric to see how it will be displayed in reports.
  • Save the calculated metric.

3. Use the Calculated Metric in Reports

Once you have created a calculated metric, you can use it in your reports just like any other metric. This allows you to analyze your data from a new perspective and derive valuable insights.

Example:

Let's say you want to create a calculated metric called "Conversion Rate" to track the percentage of visitors who complete a purchase on your website. You can create this metric by dividing the number of "Transactions" by the number of "Visits".

Calculated Metric Name: Conversion Rate

Data Type: Percentage

Calculation Method: Transactions / Visits

Metrics: Transactions, Visits

Practical Insights:

  • Calculated metrics can be highly customized to meet specific business needs.
  • You can use them to track key performance indicators (KPIs) like customer lifetime value (CLTV), average order value (AOV), and return on investment (ROI).
  • Combining existing metrics can reveal hidden patterns and insights that may not be apparent with individual metrics alone.

By creating calculated metrics, you can gain a deeper understanding of your data and improve your decision-making process.

Related Articles