EN

NL
EN
Introduction Definitions Login User profile Chatbot Menu
Home Dashboard Newsletters & Lists Leads 360° customer view Clicks Web Recognition Campaigns Overview Create Manage Search Selections Overview Create Manage Search Open Lock Template Runs Overview Search Schedules Overview Search Monitor Overview
Operation Campaign Working with blocks Connecting blocks Grouping blocks Add Memo Signal Context menus Settings Coding information
Select & Segment Select Split Sample Switch Deduplication Communication pressure Combine & Exclude Combine Exclude Enrich & Edit Upload file Import file Snapshot Web service Enrichment Datamart Aggregations
Channels
Email Create Edit Personalization AI Assistant User content Hyperlinks Mapping RSS Settings Contacts Validation A/B testing Test Additional
Preview Export SMS App messages Webpush Landing page Website personalization Content Newsletter wizard Dynamic content HTML editor Data capture RSS Funnel
Key path
Execute Schedule Webhook Time zones
Email reports
General settings TID info Email info Templates Management dashboard Admin settings
Access & entitlement Repository Authorization Email Trackers Tags Statistics Inline CSS Web Embedded forms Integration AI Assistant Webhooks Web service Datamarts Datastores Datalayers System datamarts System E-mail servers Domains Authorization Themes Output blocks Tokens TP Leads Group definitions Leadtype definitions Property definitions Ezines Business Units Ezines Property
Entities XML Preference Center Processes Housekeeping Bot click filtering Mail processing and email address status Feedback loop Number of records in Ternair CDP datastores

Aggregations

Aggregations are available for numeric and date fields. Aggregations are available in select, snapshot and split blocks.

Aggregations can be used to select customers with a sales volume greater than a certain amount over a period of time. Furthermore, a selection can be made of customers who have visited a particular page on your Web site multiple times over a period of time.

Aggregation types

Aggregations can be selected by numeric and date fields in selection and split blocks. If no aggregation is selected, it is also not applied (default).

Numeric fields

For numeric fields, the following aggregation types are available:

  • Summation

  • Average

  • Highest

  • Low

  • Number




Date fields

For date fields, the following aggregation types are available:

  • Highest

  • Lowest



Key

Aggregations are applied based on the selected key. Therefore, it is important to select the correct (type of) key. For example, by using the key Company ID, revenue can be aggregated at the company level, rather than at the invoice level, for example. By using the key email records that have clicked a certain hyperlink (more than) X times can be selected.

Examples

Type

Example

Summation

  • Customers with sales higher than/lower than/equal to € XX.XXX over a given period (key = accountId or companyId; summation sales)

  • Customers who have visited a specific hyperlink more than X times (key = accountId, summation clickId)

Means

  • Customers with average sales (or invoice amount) higher than/lower than/equal to € XX.XXX over a given period

    (key= accountId or companyId; average sales)

Highest

  • Customers with the highest revenue higher than/lower than/equal to € XX.XXX over a given period (key = accountId or companyId; highest sales)

  • Customers with a highest (most recent) click/open date higher than/lower than/equal to a specific date (key= email or accountId; highest open-click date)

Lowest

  • Customers with lowest revenue higher than/lower than/equal to € XX.XXX over a specific time period (key= accountId or companyId; lowest sales)

  • Customers with a lowest (oldest) click/open date higher than/lower than/equal to a specific date (key= email or accountId; lower open-click date)

Number

  • Customers with a number of invoices higher than/lower than/equal to X over a specific period (key = accountId or companyId; number of invoiceId)

  • Number of clicks/opens per record higher than/lower than/equal to X over a specific period (key = email; number of clickId or openId)


Video


In this article

Aggregations Aggregation types Numeric fields Date fields Key Examples Video

Copyright © 2025 Ternair.