Aggregation Custom Value
This feature is available on Unaric Segment Plus and Advanced.
The Aggregation Custom Value allows you to aggregate multiple values of a Data Extension/Data View that include:
- Sum also known as SUM in SQL
- Average also known as AVG in SQL
- Count also known as COUNT in SQL
- Minimum also known as MIN in SQL
- Maximum also known as MAX in SQL
Aggregation is supported in two modes:
- Basic Mode: You can use the Basic aggregation when you have a Predefined Relation between Data Extensions. See Predefined Relations.
- Advanced Mode: You need to use Advanced Aggregation when you don’t have a Predefined Relation? See Advanced Mode of Aggregation Custom Values.
Video overview
Create an Aggregation Custom Value
- Under Custom Values, click the Add new value button.
- Provide a name for the Custom Value, select Aggregation as Type, and click Next.
- Under Aggregation, choose the type of aggregation you want to use.
- On Field, select the field that you want to aggregate on.
- If you have additional filters on this specific aggregation, click Edit Filters. A modal will pop up where you can create the conditions that you want to apply.
- Save and drag-and-drop the new Custom Value to the Target Data Extension fields.