Behavior Aggregation Rules

Copy

• Copy for LLM

  Copy page as Markdown for LLMs
• View as Markdown

  Open this page as Markdown
• Open in ChatGPT

  Get insights from ChatGPT
• Open in Claude

  Get insights from Claude
• Connect to Cursor

  Install MCP server on Cursor
• Connect to VS Code

  Install MCP server on VS Code

Depending on your behavior segment rules, you can apply the additional following aggregation functions filters to the number of behaviors per profile based on the rules you set.

This article contains information on the following topics:

• Count
• Average
• Count Distinct
• First
• Last
• Sum
• Min
• Max
• Related Documentation

Count

Returns only the profiles based on the number of behavior records set in COUNT.

Example

• Behavior Rule:
  • Item = Ping Pong Table COUNT >= 5

Average

Only selects the profiles that contain the average of a function of a selected a behavior column.

Example

• Behavior Rule (From ping pong table purchases, only select profiles where the total price averages to more than $5)
  • Item = Ping Pong Table
  • Average total_price > greater than 5

Count Distinct

The unique count of the selected behavior column fulfills the chosen function.

Example

• Count distinct by item >= 3

First

Takes the first value of a selected column when you put it in order of another column.

Example

• Item = Ping Pong Table
• FIRST item = Ping Pong Table, order by total_price`

Last

Takes the first value of a selected column when you put it in order of another column.

Example

• Item = Ping Pong Table
• LAST item = Ping Pong Table, order by total_price`

Sum

Only selects the profiles that contain the sum of a function of a selected behavior column.

Example

• Item = Ping Pong Table
• sum total_price > greater than 20

Min

Example

Only selects the profiles where the lowest value of a chosen behavior column fulfills the selected function.

• Item = Ping Pong Table
• MIN total_price > greater than 12

Max

Only selects the profiles where the highest value of a chosen behavior column fulfills the selected function.

Example

• Item = Ping Pong Table
• MAX total_price > greater than 12

Related Documentation

Customizing Behavior and Attribute Columns for Segment Rules