Custom Values
This feature is available in Unaric Segment Plus and Unaric Segment Advanced.
Custom Values fields allow you to enrich your data by creating fields or columns that do not come from any Data Extension. They allow you to add various types of generated data to your results, such as fixed static values, dynamic values based on specific conditions, timestamps, date calculations, or aggregated metrics like sums and averages.
Add Custom Values
- Inside a Selection, go to the Output step.
- On the left panel, select the Custom Values tab.
- Click Add new value to create new Custom Values.
When a Custom Value is deleted, it is permanently removed from Unaric Segment and cannot be recovered. To prevent this issue from happening we recommend:
- Creating a copy of the Selection, the Custom Value will also be created and serve as a reference if you choose to recreate it.
- Create a Shared Custom Value (only available in Unaric Segment Advanced). See Shared Custom Values.
Custom Values types
Type | Description | Related Article | Available on |
|---|---|---|---|
Fixed Custom ValueFixed | A fixed value is added to all rows | Fixed Custom Value | Plus, Advanced |
Dynamic Custom ValueDynamic | A custom value that varies based on a set of conditions | Dynamic Custom Value | Plus, Advanced |
Transform Date Custom ValueTransform Date | Transform a date field in a Data Extension or Data View | Transform Date Custom Value | Plus, Advanced |
Timestamp Custom ValueTimestamp | Add the timestamp of when the Selection runs | Timestamp Custom Value | Plus, Advanced |
Date Difference Custom ValueDate Difference | Calculate the difference between 2 date fields | Date Difference Custom Value | Plus, Advanced |
Row Number Custom ValueRow Number | Create a new subsequent row number | Row Number Custom Value | Plus, Advanced |
Apply any function (SQL) Custom ValueApply any function (SQL) | Use as many SQL functions as needed | Apply any function (SQL) Custom Value | Advanced |
Aggregation Custom ValueAggregation | Calculate an aggregated value using Count, Sum, Average, Minimum, or Maximum | Aggregation Custom Value | Plus, Advanced |