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 the DEs. 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
To learn how to use the Aggregation Custom Value to get all customer information, along with the number of orders they placed, see 29. Find how many orders each customer placed.
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.