Skip to content

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.

SourceWhat it offersSaved
Record FieldsFields of the result record and of its parent records, up to five relationship levelsIn your browser, per audience object
Preconfigured Data Graph FieldsData Inclusions already saved for this audience that aren’t shown yetThe definition with the audience; the column in your browser
Audience Data GraphThe audience’s paths and aggregates, to set up another Data InclusionThe definition with the audience; the column in your browser

Name and parent name columns open the record. Data Inclusion columns can’t be sorted.

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.

SettingValuesDefault
Sort ByA sortable field of the step’s recordsCreated Date
Sort OrderAscending, DescendingDescending
Field to IncludeA field of the last step’s record, up to three relationship levelsNone; required

At each step, the first record in the sort order continues along the path.

For an aggregate, the window shows the calculation instead of a field choice:

PartMeaning
Steps to many recordsSort By and Sort Order as above, when the path from the result to the aggregated records leads to many records
No selection neededShown instead when the path only follows lookups to parent records
Calculation pathEach object on the path with its conditions; the objects in Aggregate chain contribute all matching records, the last one is marked Contributing records
Result typeCurrency, 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.

MessageWhereMeaning
Aggregate value unavailableIn an aggregate columnThe 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 InclusionYou can’t read the object of the last step.
Data Inclusion WarningAfter an exportSome values of Data Inclusion columns couldn’t be read; the export leaves them empty.