Aggregations

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

Using aggregations a selection can be made of customers with a sales volume larger than a certain amount over a period. Furthermore a selection can be made of customers that have visited a certain page on your website multiple times over a period.

 

1. Aggregation types

For numeric and date fields in selection and split blocks aggregations can be selected. When no aggregation is selected, no aggregation is applied (default setting).

Nummeric fields

For numeric fields the following aggregation types are available:

• Sum
• Average
• Highest
• Lowest
• Count

Date fields

For date fields the following aggregation types are available:

• Highest
• Lowest

2. Key

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

 

Examples

Type	Example
Sum	— Customers having a revenue higher than/smaller than/equal to € XX.XXX over a certain period (key = accountId or companyId; sum revenue) — Customers who have visited a specific hyperlink more than X times (key = accountId; sum clickId)
Average	— Customers having an average revenue (or invoice amount) higher than/smaller than/equal to € XX.XXX over a certain period (key = accountId or companyId; average revenue)
Highest	— Customers having a highest revenue higher than/smaller than/equal to € XX.XXX over a certain period (key= accountId or companyId; highest revenue) — Customers having a highest (most recent) click/open date higher than/smaller than/equal to a specific date (key = email or accountId; highest open-/click date)
Lowest	— Customers having a lowest revenue higher than/smaller than/equal to € XX.XXX over a certain period (key = accountId or companyId; lowest revenue) — Customers having a lowest (oldest) click/open date higher than/smaller than/equal to a specific date (key = email or accountId; lowest open-/click date)
Count	— Customers having a number of invoices higher than/smaller than/equal to X over a specific time (key = accountId or companyId; count invoiceId) — Number of clicks/opens per record higher than/smaller than/equal to X over a specific time (key = email; count clickId or openId)