MDP Related Measurements in Calculated Dimensions

A related measurement is linked to a calculated dimension and used to populate the dimension values in a list. You can add a related measurement when creating a calculated dimension, in the Advanced section.

When a calculated dimension is added to a list, such as to populate a pivot table, the dimension values from the relevant data stream type are pulled from the database.

For example, you have a calculated dimension that uses Campaign Name, and you want to include the calculated dimension in an interactive filter. However, you have mutually exclusive campaigns in your Ads and Conversion data. In this case, you can use a calculated measurement that includes Impressions and Total Conversions as the related measurement. The calculated dimension applies to both the ads and conversion types to produce the results you want.

Calculated dimensions can generate values from different data stream types, as long as the related measurements pull measurements from other data stream types.

To use a calculated dimension that includes an entity that exists in multiple data stream types while including all the values of the calculated dimension, create a new calculated measurement. Then use the new calculated measurement as the related measurement. The calculated dimension applies to both data tables and unifies the values into one list.

Selecting a related measurement with no values doesn’t affect the results of the calculated dimension.