Create Aggregation Based Segment

Target high-value customers to maximize engagement and retention.

Add Conditions Based on Aggregation Operations

This filter helps you target loyal users who have reacted well to past promotions. The marketer wants to segment users who have spent more than Rs. 1000 in the past 30 days and increased their spending compared to the previous month. Aggregator operators can help us do that.

Aggregation Operators

Aggregation operators, including sum and average, enable the grouping and filtering of users based on their purchasing behavior. By applying these operators, you can effectively identify customers with increasing spending patterns. These high-value customers can be targeted for loyalty campaigns to maximize engagement and retention.

Create an Aggregation Based Segment

Follow the steps given below to create a new segment using aggregation.

Log in to the Netcore CE dashboard and navigate to Audience > Segments > Create Segment.
Select List(s)/Segment(s) or Contact Set as the source for your segment.
Define segmentation conditions and choose AND or OR based on your needs.
Click ADD BLOCK to include additional conditions.
Click on the filter icon to begin creating your aggregation-based filter.
Select the event you want to analyze, such as Category or Product purchase.
Select the property associated with the event that you want to aggregate. Refer to the table to learn the available properties.

Property	Description
Value	The total or individual spending amount of a customer within a specific time range.
Aggregation	The method used to compute values, such as sum, average, minimum, or maximum, to analyze spending trends.

Refer to the table to learn the available operators when you select the Aggregation Operator.

Aggregation Operator	Description
Sum	Calculates the total amount spent by a customer within the selected time range.
Average	Calculates the average amount spent by a customer within the selected time range.
Minimum	Identifies the lowest spending amount recorded in the selected time range.
Maximum	Identifies the highest spending amount recorded in the selected time range.

Use Case

Refer to the table below for the various use cases you can implement.

Use Case	Goal	Conditions	Application
Target Users Who Buy Discounted Items but Avoid Full Price	Identify users who prefer discounts and avoid full-price purchases.	- Sum of "Discount Applied" > $500. - Average "Discount Percentage" > 30%.	Create targeted campaigns with exclusive discounts to retain these users.
Identify Users with Large Orders but Low Average Order Values	Detect users who place large orders but have a low average order value.	- Sum of "Order Value" in the last 30 days > $500. - Average "Order Value" in the last 30 days < $100.	These may be new customers or bulk buyers. Target them with personalized product recommendations to encourage further purchases.

Updated 3 days ago