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
Create a calculated measurement on top of existing data that you can refer to across your workspace. - MDP Aggregation and Total Aggregation Functions
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
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
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
Use functions when creating a calculated measurement to make your functions more dynamic.