---
schema_version: "1"
id: a1aebdc86efc142d0d746f7474b779eebab9752bd7216ae0e6354dc44b7a9e92
title: MDP Calculated Measurements
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_measure.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_measure.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8281f13dcb45045c838ac9526a9665f6b927f6506272064828fff8c8afbd6888
description: A calculated measurement is a numerical custom calculation that you can create on top of your existing data. The calculated measurement doesn’t physically exist in the database. Rather, it represents a query that you can reference from any report, or pivot table.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# MDP Calculated Measurements

A calculated measurement is a numerical custom calculation that you can create on top of your existing data. The calculated measurement doesn’t physically exist in the database. Rather, it represents a query that you can reference from any report, or pivot table.

For example, you want to view your return on ad spend (ROAS) to better analyze your campaign performance. Instead of manually calculating the ROAS per campaign, create a calculated measurement to extract this information from your data and view it in your campaign’s report.

- **[MDP Create a Calculated Measurement](https://help.salesforce.com/s/articleView?id=mktg.mcidp_measure_create_from_tab.htm&release=264.0.0&type=5)**  
    Create a calculated measurement on top of existing data that you can refer to across your workspace.
- **[MDP Aggregation and Total Aggregation Functions](https://help.salesforce.com/s/articleView?id=mktg.mcidp_measure_aggreg.htm&release=264.0.0&type=5)**  
    An aggregation function computes numerical calculations on data, allowing the query to return summarized information about a given column or result set. You can use an aggregation function to calculate each row at the dimension level or the total value. In MDP, you define the aggregation function when creating a calculated measurement.
- **[MDP Granularity in Calculated Measurements](https://help.salesforce.com/s/articleView?id=mktg.mcidp_measure_gran.htm&release=264.0.0&type=5)**  
    Granularity is the level of detail considered and then represented in an analysis or query. The greater the granularity, the deeper the level of detail. With more detail, you can better understand the smaller components of your data and create a fuller picture.
- **[MDP System Calculated Measurement](https://help.salesforce.com/s/articleView?id=mktg.mcidp_measure_system.htm&release=264.0.0&type=5)**  
    Marketing Cloud Intelligence Data Pipelines calculates popular industry measurements that you can use as data in reports, and pivot tables. The measurements are calculated using fixed formulas using your workspace’s data. A measurement is available only if its formula’s components are mapped in an existing data stream. For example, if you uploaded Impressions and Media Cost data, CPM appears. This table describes the available system calculated measurements and their formulas.
- **[MDP Calculated Measurement Functions](https://help.salesforce.com/s/articleView?id=mktg.mcidp_measure_functions.htm&release=264.0.0&type=5)**  
    Use functions when creating a calculated measurement to make your functions more dynamic.