Related data and Data Inclusions
Look up where a result column comes from and what each setting of a related value does.
How related values work is explained in How related data works. How to add a column is in Work with audience results.
Sources in Select Fields to Display
Section titled “Sources in Select Fields to Display”| Source | What it offers | Saved |
|---|---|---|
| Record Fields | Fields of the result record and of its parent records, up to five relationship levels | In your browser, per audience object |
| Preconfigured Data Graph Fields | Data Inclusions already saved for this audience that aren’t shown yet | The definition with the audience; the column in your browser |
| Audience Data Graph | The audience’s paths and aggregates, to set up another Data Inclusion | The definition with the audience; the column in your browser |
Name and parent name columns open the record. Data Inclusion columns can’t be sorted.
Settings of a Data Inclusion
Section titled “Settings of a Data Inclusion”Configure Data Inclusion shows the path from the result to the chosen node, then one card per step that leads to many records. The audience object and parent lookups need no card.
| Setting | Values | Default |
|---|---|---|
| Sort By | A sortable field of the step’s records | Created Date |
| Sort Order | Ascending, Descending | Descending |
| Field to Include | A field of the last step’s record, up to three relationship levels | None; required |
At each step, the first record in the sort order continues along the path.
Settings of an aggregate value
Section titled “Settings of an aggregate value”For an aggregate, the window shows the calculation instead of a field choice:
| Part | Meaning |
|---|---|
| Steps to many records | Sort By and Sort Order as above, when the path from the result to the aggregated records leads to many records |
| No selection needed | Shown instead when the path only follows lookups to parent records |
| Calculation path | Each object on the path with its conditions; the objects in Aggregate chain contribute all matching records, the last one is marked Contributing records |
| Result type | Currency, Number, Date or Date/Time, with the currency and the decimal places |
Conditions on the result object itself decide membership only; they aren’t part of the calculation.
Messages
Section titled “Messages”| Message | Where | Meaning |
|---|---|---|
| Aggregate value unavailable | In an aggregate column | The value couldn’t be calculated for this result, for example because the contributing records aren’t accessible. |
| The fields of … could not be loaded. You may not have access to this object. | In Configure Data Inclusion | You can’t read the object of the last step. |
| Data Inclusion Warning | After an export | Some values of Data Inclusion columns couldn’t be read; the export leaves them empty. |

