Unrelated Measurements in Data Reports

When you query entities from different data types with different measurements that are unlinked in the platform, unrelated measurements appear in your report. For example, a report pulling Ads data— Impressions and a measurement that isn’t in the Ads data type—visits, results in unrelated measurements in your report.

Required Editions

User Permissions Needed
To create and manage data reports: Admin or Power User

There are two ways to show unrelated measurement data in your report:

  • Show unrelated measurements on default entity—shows the unrelated measurements’ total values in a default entity of the dimension.

    unrelated measurements on default entity

  • Duplicate unrelated measurements across rows—shows the unrelated measurements’ total values in each row of the report.

    duplicate unrelated measurements across rows

  1. On the Analyze & Act tab, in the left menu, select Reports.
  2. Select the report, and click edit.
  3. Scroll down, and expand Advanced Sheet "Sheet 1" Settings.
  4. Select the display methods from the Unrelated Measurement dropdown.
  5. Save your report.